AUMXVALDT

This file is used to store the effective date values for attribute unit attributes.

REFERENCED BY
GL146 GL197 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL70.1 GL70.2 GL70.3
GL70.6 GL14.1 GL14.5 GL14.7 GL14.8 GL16.1
GL16.2 GL16.3 GL16.4 MX00.1 MX00.2 MX00.3
MX05.1 MX05.2 MX06.1 MX06.2 MX10.1 MX10.2
MX135 MX20.1 MX20.2 MX20.4 MX20.5 MX202
SL40.1 RW100


UPDATED 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.
GL162 GL20.7
GL20.8 GL20.9
AVD-MATRIX-CAT
Element: Matrix Cat
Alpha 12
This is the accounting unit attribute to which a value is assigned.
GL162 GL20.7
GL20.8 GL20.9
AVD-MX-VALUE
Element: Mx Value
Alpha 32
This is the value of the attribute.
GL162 GL20.7
GL20.8 GL20.9
AVD-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
This is the date the value takes effect.
GL162 GL20.7
GL20.8 GL20.9
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.
GL162 GL20.7
GL20.8 GL20.9


AUMXVALDT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AVDSET1 OBJ-ID
MATRIX-CAT
EFFECTIVE-DATE
...
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6 GL14.1
GL14.5 GL14.7
GL14.8 GL16.1
GL16.2 GL16.3
GL16.4 GL162
GL20.7 GL20.8
GL20.9 MX00.1
MX00.2 MX00.3
MX05.1 MX05.2
AVDSET2 MATRIX-CAT
EFFECTIVE-DATE
OBJ-ID
MX202
AVDSET4 COMPANY
OBJ-ID
MATRIX-CAT
EFFECTIVE-DATE*
RW100 MX135


AUMXVALDT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Aumxvldtau AUMXVLDTAU
AVD-OBJ-ID->UDU-OBJ-ID
AVD-MATRIX-CAT->UDU-MATRIX-CAT
AVD-EFFECTIVE-DATE->UDU-EFFECTIVE-DATE
  UDU-ACTION
  UDU-DATE
  UDU-TIME
  UDU-UNIQUE-I-D


File created: Thu Jun 09 02:20:21 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.