HRIAAGE – No description in the Lawson data dictionary

System
Compensation D Mart (HC)
Prefix
HRA
Primary key
DIMENSION-NAME
Fields
9
Updated by
2 programs
Referenced by
6 programs

HRIAAGE is a Lawson Compensation D Mart table (prefix HRA); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME (HRASET1). It is updated by HC03.4 and HC10.1 and referenced by HC01.1, HC02.1, HCAG.1, HCCE.1, HCDL.1 and HCHP.1. The table has 9 fields, 1 index and 0 documented relations.

About HRIAAGE

No description in the Lawson data dictionary.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
HRA-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name field contains the dimension name that is used by the OLAP database. Valid values are: Year Period Measures Scenario Compton Territory Customer ItemsHC03.4, HC10.1
HRA-MEMBER-PREFIX
MEMBER_PREFIX		Alpha 5 (Lower Case)The Member Prefix field contains a unique prefix to differentiate the dimension name from other like-named dimensions. This user-defined name can contain up to five characters of any kind.HC03.4, HC10.1
HRA-ALIAS-OPT
ALIAS_OPT		Alpha 1—HC03.4, HC10.1
HRA-BUILD-TO-LEVEL
BUILD_TO_LEVEL		Numeric 1—HC03.4, HC10.1
HRA-FOLLOWING-TEXT
FOLLOWING_TEXT		Alpha 45 (Lower Case)—HC03.4, HC10.1
HRA-STARTING-AGE
STARTING_AGE		Numeric 3—HC03.4, HC10.1
HRA-ENDING-AGE
ENDING_AGE		Numeric 3—HC03.4, HC10.1
HRA-ROLL-UP-RANGE
ROLL_UP_RANGE		Numeric 2—HC03.4, HC10.1
HRA-RANGE-START
RANGE_START		Numeric 2—HC03.4, HC10.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
HRASET1DIMENSION-NAMEPrimaryHC01.1, HC02.1, HC03.4, HCAG.1, HCCE.1, HCDL.1, HCHP.1

Programs

Updated by (2)

Referenced by (6)