HDCNTGRP – No description in the Lawson data dictionary

System
Compensation D Mart (HC)
Prefix
HDG
Primary key
MEAS-OBJ-ID, GROUP-NAME
Fields
7
Updated by
3 programs
Referenced by
2 programs

HDCNTGRP is a Lawson Compensation D Mart table (prefix HDG); no description in the lawson data dictionary. It is indexed by MEAS-OBJ-ID, GROUP-NAME (HDGSET1). It is updated by HC02.2, HC02.4 and HC10.1 and referenced by HCHM.1 and HCHP.1. The table has 7 fields, 1 index and 0 documented relations.

About HDCNTGRP

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the HDG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#HDG-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.4, HC10.1
#HDG-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.4, HC10.1
#HDG-ALIAS-NAME
ALIAS_NAME		Alpha 80 (Lower Case)The Alias Name field contains an alias name for the dimension.HC02.4, HC10.1
#HDG-AGGR-OPTION
AGGR_OPTION		Alpha 1—HC02.4, HC10.1
#HDG-INCLUDE-ALL
INCLUDE_ALL		Alpha 1—HC02.4, HC10.1
#HDG-TIME-BALANCE
TIME_BALANCE		Alpha 1—
  • 1 Average
  • 2 First Value
  • 3 Last Value
HC02.4, HC10.1
#HDG-GROUP-VALUE
GROUP_VALUE		Alpha 1—HC02.4, HC10.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HDGSET1
  1. MEAS-OBJ-ID
  2. GROUP-NAME
PrimaryHC02.2, HC02.3, HC02.4, HCHM.1, HCHP.1

Programs

Updated by (3)

Referenced by (2)