HREMPDIM

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HRESET1 EMP-DIMENSION
HC01.1 HC01.2
HC01.3 HC02.1
HCCE.1 HCDL.1
HCEM.1 HCHE.1
HCHP.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.