TRNOVERCAT FILE
REFERENCED BY
HCHM.1 HCHP.1
UPDATED BY
HC02.5 HC02.6 HC02.2 HC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRT-MEAS-OBJ-ID Numeric 12 HC02.6 HC10.1
Element: Obj Id This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
TRT-TURNOVER-TYPE Alpha 1 HC02.6 HC10.1
Element: Turnover Type
TRT-GROUP-NAME Alpha 50 (Lower Case) HC02.6 HC10.1
Element: Member Name This is an override member name for
Data Mart dimensions with no association
to a Budget dimension.
TRT-GRP-ALIAS-NAME Alpha 80 (Lower Case) HC02.6 HC10.1
Element: Alias Name The Alias Name field contains an alias
name for the dimension.
TRT-GROUP-VALUE Alpha 1 HC02.6 HC10.1
Element: Group Value
TRT-GROUP-DATE Alpha 1 HC02.6 HC10.1
Element: Group Date
TRT-AGGR-OPTION Alpha 1 HC02.6 HC10.1
Element: Aggr Option
TRT-FIELD-NAME Alpha 20 (Lower Case) HC02.5 HC10.1
Element: Field Name Occurs 9 Times
TRNOVERCAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRTSET1 MEAS-OBJ-ID HC02.2 HC02.5
TURNOVER-TYPE HC02.6 HCHM.1
GROUP-NAME HCHP.1
TRTSET2 MEAS-OBJ-ID HC02.6
GROUP-NAME
TRTSET3 MEAS-OBJ-ID
GROUP-DATE
GROUP-NAME
|
