The HREMPDIM file contains the information used when building the Employee dimension.

REFERENCED BY

HC02.1

HCCE.1

HCDL.1

HCEM.1

HCHE.1

HCHP.1

UPDATED BY

HC01.2

HC10.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
HRE-EMP-DIMENSION Element: User Dim Name	Alpha 50 (Lower Case) The Employee Dimension Name field contains the user-defined name for the Employee dimension. This name can contain up to 50 characters of any kind.	HC01.2 HC10.1
HRE-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.	HC01.2 HC10.1
HRE-ALIAS-OPTION Element: Account Flag	Alpha 1 The Alias Option field contains the alias name option that has been specified for the Employee dimension. Valid values are: 1 = Name 2 = Number;Name 3 = Company;Number;Name	HC01.2 HC10.1
HRE-COMPANY Element: Company Hr	Numeric 4 The Company field contains the company number.	HC01.2 HC10.1
HRE-GROUP-NAME Element: Group Name	Alpha 10 The Group Name field contains the name of the company group.	HC01.2 HC10.1
HRE-PROC-LEVEL Element: Process Lev Hr	Alpha 5 Occurs 5 Times The Process Level field contains the process level name. Process level is one reporting level below company. This field can contain up to five process levels.	HC01.2 HC10.1
HRE-EMP-STATUS Element: Emp Status	Alpha 2 Occurs 9 Times The Employee Status field contains a valid employee status value. This field can contain up to nine valid employee status values.	HC01.2 HC10.1
HRE-EMP-DATE1 Element: Emp Date1	Numeric 8 (yyyymmdd) The Employment Date1 field contains the first date in the termination date range, if employees with a terminated status are included in the data mart.	HC01.2 HC10.1
HRE-EMP-DATE2 Element: Emp Date2	Numeric 8 (yyyymmdd) The Employment Date2 field contains the final date in the termination date range if employees with a terminated status are included in the data mart.	HC01.2 HC10.1
HRE-ALL-POS-LEVEL Element: All Pos Level	Alpha 1 The All Positions and Job Levels field specifies whether all positions and jobs are included for the employee. Valid values are: Y = Yes N = N	HC01.2 HC10.1
HRE-CHECK-HISTORY Element: Check History	Alpha 1 The Check History field specifies whether the Headcount and Turnover data mart should also include historical data. Valid values are: Y = Yes N = No	HC01.2 HC10.1
HRE-AS-OF-DATE Element: As Of Date	Numeric 8 (yyyymmdd)	HC01.2 HC10.1
HRE-YRS-JOB-CODE Element: Yrs Job Code	Numeric 1	HC01.2 HC10.1
HRE-YRS-GRADE Element: Yrs Grade	Numeric 1	HC01.2 HC10.1
HRE-YRS-COMPANY Element: Yrs Company	Numeric 1	HC01.2 HC10.1
HRE-HIERARCHY Element: Hierarchy	Alpha 1	HC01.2

HREMPDIM FILE INDEX

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