HRYEARS – No description in the Lawson data dictionary

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

HRYEARS is a Lawson Compensation D Mart table (prefix HRY); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME (HRYSET1). It is updated by HC03.3 and HC10.1 and referenced by HC01.1, HC02.1, HCCE.1, HCDL.1, HCHP.1 and HCYR.1. The table has 9 fields, 1 index and 0 documented relations.

About HRYEARS

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the HRY- 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 / column	Type	Description & values	Updated by
#`HRY-DIMENSION-NAME` PK 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	HC03.3, HC10.1
#`HRY-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.3, HC10.1
#`HRY-ALIAS-OPT` ALIAS_OPT	Alpha 1	—	HC03.3, HC10.1
#`HRY-BUILD-TO-LEVEL` BUILD_TO_LEVEL	Numeric 1	—	HC03.3, HC10.1
#`HRY-MAX-YEAR` MAX_YEAR	Numeric 3	—	HC03.3, HC10.1
#`HRY-FOLLOWING-TEXT` FOLLOWING_TEXT	Alpha 45 (Lower Case)	—	HC03.3, HC10.1
#`HRY-ROLL-UP-RANGE` ROLL_UP_RANGE	Numeric 2	—	HC03.3, HC10.1
#`HRY-RANGE-START` RANGE_START	Numeric 2	—	HC03.3, HC10.1
#`HRY-DATE-SELECTION` DATE_SELECTION	Numeric 1	— `1` Employee Hire Date `2` Employee Adjusted Hire Date `3` Employee Seniority Date `4` Job Code Start Date `5` Schedule Start Date	HC03.3, HC10.1

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.

Index	Keys	Flags	Condition	Used in
`HRYSET1`	`DIMENSION-NAME`	Primary		HC01.1, HC02.1, HC03.3, HCCE.1, HCDL.1, HCHP.1, HCYR.1

Programs

Updated by (2)

HC03.3 Years of Service Dimension
HC10.1 Compensation Data Mart Upgrade

Referenced by (6)

HC01.1 Compensation Data Mart Setup
HC02.1 Headcount and Turnover Data Mart Setup
HCCE.1 Compensation Data Mart Edit
HCDL.1 Olap Data Load
HCHP.1 Olap Data Load
HCYR.1 Olap Dimension Retrieval Format

HRYEARS – No description in the Lawson data dictionary

About HRYEARS

Fields (9) Copy as SQL

Indexes (1)

Programs

Updated by (2)

Referenced by (6)

Fields (9)