HRIAPOS – No description in the Lawson data dictionary

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

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

About HRIAPOS

No description in the Lawson data dictionary.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
HIP-DIMENSION-NAME PK
DIMENSION_NAME
Alpha 50 (Lower Case)The Dimension Name field contains the name of the Position dimension. This user-defined name can contain up to 50 characters of any kind. Scenario Compton Territory Customer ItemsHC01.5, HC10.1
HIP-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.5, HC10.1
HIP-ALIAS-OPTION
ALIAS_OPTION
Alpha 1The Alias Option field contains the value for the alias option. Valid values are:
  • 1 Description
  • 2 Code;Description
  • 3 Company;Code;Description
HC01.5, HC10.1
HIP-BUILD-TO-LEVEL
BUILD_TO_LEVEL
Numeric 1The Build to Level field contains the value that represents the build to level for the dimension. Valid values are:
  • 1 Position Class
  • 2 No Position Class
HC01.5, HC10.1
HIP-CLASS-PREFIX
CLASS_PREFIX
Alpha 5The Position Class Prefix field contains a user-defined unique prefix to differentiate the position class. This prefix can contain up to five alpha characters.HC01.5, HC10.1
HIP-COMPANY
COMPANY
Numeric 4The Company field contains the company number used to build the Position dimension.HC01.5, HC10.1
HIP-LOAD-MEMBERS
LOAD_MEMBERS
Numeric 2The Load field contains the value that represents the positions that will be loaded. Valid values are:
  • 1 All Positions
  • 2 Active Position Only
HC01.5, 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
HIPSET1DIMENSION-NAMEPrimaryHC01.1, HC01.5, HC02.1, HCCE.1, HCDL.1, HCHE.1, HCHP.1, HCPO.1

Programs

Updated by (2)

Referenced by (6)