HRIASUP – No description in the Lawson data dictionary

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

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

About HRIASUP

No description in the Lawson data dictionary.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
HRS-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name fields contains the name of the Supervisor dimension. This user-defined field can contain up to 50 characters of any kind.HC01.9, HC10.1
HRS-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.9, HC10.1
HRS-ALIAS-OPTION
ALIAS_OPTION		Alpha 1The Alias Option field contains the value for the alias option. Valid values are:
  • 1 Description
  • 2 Code;Desc
  • 3 Company;Code;Desc
  • 4 Company;Code;Name
  • 5 Company;Code;Desc;Name
HC01.9, HC10.1
HRS-BUILD-TO-LEVEL
BUILD_TO_LEVEL		Numeric 1The Build To field specifies the build to option for the dimension. Valid values are:
  • 1 Reports to Hierarchy
  • 2 No Hierarchy
HC01.9, HC10.1
HRS-COMPANY
COMPANY		Numeric 4The Company field contains the company number used to build the Supervisor dimension.HC01.9, HC10.1
HRS-LOAD-MEMBERS
LOAD_MEMBERS		Numeric 2The Load field contains the value that represents how the Supervisors will be loaded. Valid values are:
  • 1 All Supervisors
  • 2 Active Supervisors Only
HC01.9, HC10.1
HRS-TOTAL-TEXT
TOTAL_TEXT		Alpha 50 (Lower Case)——
HRS-DIRECT-TEXT
DIRECT_TEXT		Alpha 50 (Lower Case)——

Indexes (1)

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

IndexKeysFlagsConditionUsed in
HRSSET1DIMENSION-NAMEPrimaryHC01.1, HC01.9, HC02.1, HCCE.1, HCDL.1, HCHE.1, HCHP.1, HCSU.1

Programs

Updated by (2)

Referenced by (6)