HDCNTDTL – No description in the Lawson data dictionary

System
Compensation D Mart (HC)
Prefix
HDL
Primary key
MEAS-OBJ-ID, GROUP-NAME, EMP-STATUS
Fields
4
Updated by
4 programs
Referenced by
1 program

HDCNTDTL is a Lawson Compensation D Mart table (prefix HDL); no description in the lawson data dictionary. It is indexed by MEAS-OBJ-ID, GROUP-NAME, EMP-STATUS (HDLSET1); alternate indexes: HDLSET2. It is updated by HC02.2, HC02.3, HC02.4 and HC10.1 and referenced by HCHP.1. The table has 4 fields, 2 indexes and 0 documented relations.

About HDCNTDTL

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the HDL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
HDL-MEAS-OBJ-ID PK
MEAS_OBJ_ID		Numeric 12This 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.3, HC10.1
HDL-GROUP-NAME PK
GROUP_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.HC02.3, HC10.1
HDL-COMPANY
COMPANY		Numeric 4—HC02.3, HC10.1
HDL-EMP-STATUS PK
EMP_STATUS		Alpha 2—HC02.3, HC10.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HDLSET1MEAS-OBJ-ID, GROUP-NAME, EMP-STATUSPrimaryHC02.2, HC02.3, HC02.4
HDLSET2MEAS-OBJ-ID, EMP-STATUS, GROUP-NAMEHCHP.1

Programs

Updated by (4)

Referenced by (1)