TRNOVERDTL – No description in the Lawson data dictionary
- System
- Compensation D Mart (HC)
- Prefix
TOD- Primary key
MEAS-OBJ-ID,GROUP-NAME,SEQ-NBR- Fields
- 8
- Updated by
- 4 programs
- Referenced by
- 1 program
TRNOVERDTL is a Lawson Compensation D Mart table (prefix TOD); no description in the lawson data dictionary. It is indexed by MEAS-OBJ-ID, GROUP-NAME, SEQ-NBR (TODSET1); alternate indexes: TODSET2 and TODSET3. It is updated by HC02.2, HC02.5, HC02.6 and HC10.1 and referenced by HCHP.1. The table has 8 fields, 3 indexes and 0 documented relations.
About TRNOVERDTL
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the TOD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
TOD-MEAS-OBJ-ID PKMEAS_OBJ_ID | Numeric 12 | 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. | HC02.5, HC10.1 |
TOD-GROUP-NAME PKGROUP_NAME | Alpha 50 (Lower Case) | This is an override member name for Data Mart dimensions with no association to a Budget dimension. | HC02.5, HC10.1 |
TOD-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | HC02.5, HC10.1 |
TOD-NBR-FIELD-KEYNBR_FIELD_KEY | Numeric 1 | — | HC02.5, HC10.1 |
TOD-INC-EXC-FLAGINC_EXC_FLAG | Alpha 1 | — | HC02.5, HC10.1 |
TOD-BEG-VALUEBEG_VALUE | Alpha 25 | — | HC02.5, HC10.1 |
TOD-END-VALUEEND_VALUE | Alpha 25 | — | HC02.5, HC10.1, HCHP.1 |
TOD-DTL-GROUPINGDTL_GROUPING | Alpha 2 | — | HC02.5, HC10.1 |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TODSET1 | MEAS-OBJ-ID, GROUP-NAME, SEQ-NBR | Primary | HC02.2, HC02.5, HC02.6 | |
TODSET2 | MEAS-OBJ-ID, GROUP-NAME, DTL-GROUPING, SEQ-NBR | HC02.5, HCHP.1 | ||
TODSET3 | MEAS-OBJ-ID, NBR-FIELD-KEY, GROUP-NAME, DTL-GROUPING, SEQ-NBR | — |
Programs
Updated by (4)
- HC02.2 Headcount and Turnover Measures
- HC02.5 Turnover Group Criteria
- HC02.6 Turnover Group Definition
- HC10.1 Compensation Data Mart Upgrade
Referenced by (1)
- HCHP.1 Olap Data Load