HRYEARS

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
Element: 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
Element: 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
Element: Alias Opt
Alpha 1
HC03.3 HC10.1
HRY-BUILD-TO-LEVEL
Element: Build To Level
Numeric 1
HC03.3 HC10.1
HRY-MAX-YEAR
Element: Max Year
Numeric 3
HC03.3 HC10.1
HRY-FOLLOWING-TEXT
Element: Following Text
Alpha 45 (Lower Case)
HC03.3 HC10.1
HRY-ROLL-UP-RANGE
Element: Roll Up Range
Numeric 2
HC03.3 HC10.1
HRY-RANGE-START
Element: Range Start
Numeric 2
HC03.3 HC10.1
HRY-DATE-SELECTION
Element: 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


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


File created: Wed Jun 08 20:49:01 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.