HRIASCH – No description in the Lawson data dictionary

System
Compensation D Mart (HC)
Prefix
HRD
Primary key
DIMENSION-NAME
Fields
7
Updated by
2 programs
Referenced by
7 programs

HRIASCH is a Lawson Compensation D Mart table (prefix HRD); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME (HRDSET1). It is updated by HC03.1 and HC10.1 and referenced by HC01.1, HC02.1, HCCE.1, HCDL.1, HCHE.1, HCHP.1 and HCSC.1. The table has 7 fields, 1 index and 0 documented relations.

About HRIASCH

No description in the Lawson data dictionary.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
HRD-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name field contains the name of the Schedule dimension. This user-defined name can contain up to 50 characters of any kind.HC03.1, HC10.1
HRD-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.1, HC10.1
HRD-ALIAS-OPTION
ALIAS_OPTION		Alpha 1The Alias Option field contains the alias option for the dimension. Valid values are:
  • 1 Description
  • 2 Code;Desc
  • 3 Company;Code;Desc
HC03.1, HC10.1
HRD-BUILD-TO-LEVEL
BUILD_TO_LEVEL		Numeric 1The Build To field specifies the build to level for the dimension. Valid values are:
  • 1 Schedule
  • 2 Grade
  • 3 Step
HC03.1, HC10.1
HRD-COMPANY
COMPANY		Numeric 4The Company field contains the company number used to build the Schedule dimension.HC03.1, HC10.1
HRD-USE-CURRENT
USE_CURRENT		Alpha 1—HC03.1, HC10.1
HRD-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date a vendor's prices will be in effect.HC03.1, HC10.1, HCSC.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
HRDSET1DIMENSION-NAMEPrimaryHC01.1, HC02.1, HC03.1, HCCE.1, HCDL.1, HCHE.1, HCHP.1, HCSC.1

Programs

Updated by (2)

Referenced by (7)