ACADDASSGN FILE
Activity Address Assignment
This file contains address assignment information from AC10.2 (Location
Assignment). It includes address codes, their descriptions, and the activities
they are assigned to. The addresses or locations that address codes refer to
can be defined in AC10.4 (Location).
UPDATED BY
AC10.2 AC10.1 AC300 AC310 AC500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAS-ACTIVITY Alpha 15 AC10.2 AC500
Activity Required key. This is the activity for
the address.
AAS-ADDRESS-CODE Alpha 9 AC10.2 AC500
Address Code Required key. This is the address code
used to assign a location to an
activity. Address codes are defined in
AC10.4 (Location).
AAS-DESCRIPTION Alpha 30 (Lower Case) AC10.2 AC500
Address Code This is the address code description.
Description
ACADDASSGN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AASSET1 ACTIVITY AC10.1 AC10.2
ADDRESS-CODE AC300 AC310
AC500
ACADDASSGN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Not Required
AAS-ACTIVITY -> ACV-ACTIVITY
Acaddress ACADDRESS Required
AAS-ADDRESS-CODE -> ADD-ADDRESS-CODE
|