HRIADIM – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
HID
Primary key
DATA-MART-NAME, DIM-TYPE
Fields
19
Updated by
1 program
Referenced by
4 programs

HRIADIM is a Lawson Human Resources table (prefix HID); no description in the lawson data dictionary. It is indexed by DATA-MART-NAME, DIM-TYPE (HIDSET1). It is related 1:1 to PRSYSTEM, PERSGROUP and OLAPDBM and 1:M to HRIAMBR. It is updated by HC10.1 and referenced by HC01.1, HC02.1, HCCE.1 and HCHE.1. The table has 19 fields, 1 index and 4 documented relations.

About HRIADIM

No description in the Lawson data dictionary.

Fields (19)

Column = COBOL field name without the HID- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#HID-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.—
#HID-DIM-TYPE PK
DIM_TYPE		Numeric 3——
#HID-APPLIC-TYPE
APPLIC_TYPE		Alpha 3The Application Type file stores the names of the Lawson applications that can be requested to supply information to the OLAP database. The Lawson applications that are currently OLAP-ready are:
  • FIN Financial Analyzer
  • FND Daily Financial Analyzer
  • SA Sales Analyzer
  • CX Case Cart Analyzer
  • PO Purchasing Analyzer
  • WO Work Order Analyzer
  • CMP Compensation
  • HDT Headcount/Turnover
—
#HID-DIMENSION-USE
DIMENSION_USE		Alpha 1——
#HID-DIMENSION-NAME
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name field contains the dimension name that is used by the OLAP database. Valid values are: Year Period Measures Scenario Compton Territory Customer Items—
#HID-DIM-PREFIX-1
DIM_PREFIX_1		Alpha 5——
#HID-DIM-PREFIX-2
DIM_PREFIX_2		Alpha 5——
#HID-DIM-PREFIX-3
DIM_PREFIX_3		Alpha 5——
#HID-DIM-ALIAS-OPT
DIM_ALIAS_OPT		Alpha 1—HC10.1
#HID-DIM-BUILD-TO
DIM_BUILD_TO		Numeric 2——
#HID-COMPANY
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.—
#HID-GROUP-NAME
GROUP_NAME		Alpha 10——
#HID-DATE-1
DATE_1		Numeric 8 (yyyymmdd)——
#HID-DATE-2
DATE_2		Numeric 8 (yyyymmdd)——
#HID-FACTOR-1
FACTOR_1		Signed 7.2——
#HID-SELECTION
SELECTION		Alpha 100——
#HID-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.—
#HID-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.—
#HID-USER-ID
USER_ID		Alpha 10 (Lower Case)——

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HIDSET1
  1. DATA-MART-NAME
  2. DIM-TYPE
PrimaryHC01.1, HC02.1, HC10.1, HCCE.1, HCHE.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMPERSGROUPOLAPDBMHRIAMBRHRIADIM

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredWhen HID-COMPANY != Zeroes
HID-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Emp GroupPERSGROUPRequiredWhen HID-GROUP-NAME != Spaces
HID-COMPANY→PRG-COMPANY
HID-GROUP-NAME→PRG-GROUP-NAME
Olap DbOLAPDBMRequired
HID-DATA-MART-NAME→ODB-DATA-MART-NAME

One to many (1) — child tables

RelationTableRulesConditionField map
MembersHRIAMBR
HID-DATA-MART-NAME→HIM-DATA-MART-NAME
HID-DIM-TYPE→HIM-DIM-TYPE
—→HIM-MEMBER-TYPE
—→HIM-SEQ-NBR

Programs

Updated by (1)

Referenced by (4)