HRIAJOB – No description in the Lawson data dictionary

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

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

About HRIAJOB

No description in the Lawson data dictionary.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
HRJ-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name fields contains the name of the Job dimension. This user-defined field can contain up to 50 characters of any kind. Territory Customer ItemsHC01.6, HC10.1
HRJ-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.6, HC10.1
HRJ-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
HC01.6, HC10.1
HRJ-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 All Job Codes
  • 2 Active Job Codes Only
HC01.6, HC10.1
HRJ-CLASS-PREFIX
CLASS_PREFIX		Alpha 5The Position Class Prefix field contains a user-defined, unique prefix to differentiate the job class. This prefix can contain up to five alpha characters.HC01.6, HC10.1
HRJ-COMPANY
COMPANY		Numeric 4The Company field contains the company number used to build the Job dimension.HC01.6, HC10.1
HRJ-LOAD-MEMBERS
LOAD_MEMBERS		Numeric 2The Load field contains the value that represents the job codes that will be loaded. Value values are:
  • 1 All Job Codes
  • 2 Active Job Codes Only
HC01.6, 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
HRJSET1DIMENSION-NAMEPrimaryHC01.1, HC01.6, HC02.1, HC03.2, HCCE.1, HCDL.1, HCHE.1, HCHP.1 +1 more

Programs

Updated by (2)

Referenced by (7)