This file is used to store the effective date values for attribute unit attributes.
REFERENCED BY
GL162 | GL20.7 | GL20.8 | GL20.9 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
AVD-OBJ-ID Element: Obj Id | Numeric 12 This is the unique object identifier. |
|
||||
AVD-MATRIX-CAT Element: Matrix Cat | Alpha 12 This is the accounting unit attribute to which a value is assigned. |
|
||||
AVD-MX-VALUE Element: Mx Value | Alpha 32 This is the value of the attribute. |
|
||||
AVD-EFFECTIVE-DATE Element: Effective Date | Numeric 8 (yyyymmdd) This is the date the value takes effect. |
|
||||
AVD-COMPANY Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
AVDSET1 |
OBJ-ID MATRIX-CAT EFFECTIVE-DATE |
|
|||||||||
AVDSET2 |
MATRIX-CAT EFFECTIVE-DATE OBJ-ID |
|
| ||||||||
AVDSET4 |
COMPANY OBJ-ID MATRIX-CAT EFFECTIVE-DATE* |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Aumxvldtau | AUMXVLDTAU |
|
All trademarks and registered trademarks are the property of their
respective owners.