HRIAORG – No description in the Lawson data dictionary

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

HRIAORG is a Lawson Compensation D Mart table (prefix HRO); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME (HROSET1). It is updated by HC01.8 and HC10.1 and referenced by HC02.1, HCCE.1, HCCP.1, HCDL.1, HCHE.1 and HCHP.1. The table has 5 fields, 1 index and 0 documented relations.

About HRIAORG

No description in the Lawson data dictionary.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
HRO-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name field contains the name of the Organization dimension. This user-defined field can contain 50 characters of any kind.HC01.8, HC10.1
HRO-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.HC01.8, HC10.1
HRO-ALIAS-OPTION
ALIAS_OPTION		Alpha 1The Alias Option field contains the value for the alias option. Valid values are:
  • 1 Company
  • 2 Process Level
  • 3 Department
HC01.8, HC10.1
HRO-COMPANY
COMPANY		Numeric 4The Company field contains the company number used to build the Organization dimension.HC01.8, HC10.1
HRO-BUILD-TO-LEVEL
BUILD_TO_LEVEL		Numeric 1The Build To field contains the value that represents the build to level for the dimension. Valid values are:
  • 1 Company
  • 2 Process Level
  • 3 Department
HC01.8, HC10.1, HCCP.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
HROSET1DIMENSION-NAMEPrimaryHC01.1, HC01.8, HC02.1, HCCE.1, HCCP.1, HCDL.1, HCHE.1, HCHP.1

Programs

Updated by (2)

Referenced by (6)