HRYEARS FILE
REFERENCED BY
HC01.1 HC02.1 HCCE.1 HCDL.1 HCHP.1 HCYR.1
UPDATED BY
HC03.3 HC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRY-DIMENSION-NAME Alpha 50 (Lower Case) HC03.3 HC10.1
Element: Dimension NameThe 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
HRY-MEMBER-PREFIX Alpha 5 (Lower Case) HC03.3 HC10.1
Element: Member Prefix 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.
HRY-ALIAS-OPT Alpha 1 HC03.3 HC10.1
Element: Alias Opt
HRY-BUILD-TO-LEVEL Numeric 1 HC03.3 HC10.1
Element: Build To Level
HRY-MAX-YEAR Numeric 3 HC03.3 HC10.1
Element: Max Year
HRY-FOLLOWING-TEXT Alpha 45 (Lower Case) HC03.3 HC10.1
Element: Following Text
HRY-ROLL-UP-RANGE Numeric 2 HC03.3 HC10.1
Element: Roll Up Range
HRY-RANGE-START Numeric 2 HC03.3 HC10.1
Element: Range Start
HRY-DATE-SELECTION Numeric 1 HC03.3 HC10.1
Element: Date Selection1 = Employee Hire Date
2 = Employee Adjusted Hire Date
3 = Employee Seniority Date
4 = Job Code Start Date
5 = Schedule Start Date
HRYEARS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HRYSET1 DIMENSION-NAME HC01.1 HC02.1
HC03.3 HCCE.1
HCDL.1 HCHP.1
HCYR.1
|
