|
|
HREMPDIM FILE
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRE-EMP-DIMENSION Alpha 50 (Lower Case) HC01.2
Element: User Dim Name 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.
HRE-MEMBER-PREFIX Alpha 5 (Lower Case) HC01.2
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.
HRE-ALIAS-OPTION Alpha 1 HC01.2
Element: Account Flag 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
HRE-COMPANY Numeric 4 HC01.2
Element: Company Hr The Company field contains the company
number.
HRE-GROUP-NAME Alpha 10 HC01.2
Element: Group Name The Group Name field contains the name
of the company group.
HRE-PROC-LEVEL Alpha 5 Occurs 5 Times HC01.2
Element: Process Lev HrThe 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.
HRE-EMP-STATUS Alpha 2 Occurs 9 Times HC01.2
Element: Employee StatuThe Employee Status field contains a
valid employee status value. This field
can contain up to nine valid employee
status values.
HRE-EMP-DATE1 Numeric 8 (yyyymmdd) HC01.2
Element: Emp Date1 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.
HRE-EMP-DATE2 Numeric 8 (yyyymmdd) HC01.2
Element: Emp Date2 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.
HRE-ALL-POS-LEVEL Alpha 1 HC01.2
Element: All Pos Level 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
HRE-CHECK-HISTORY Alpha 1 HC01.2
Element: Check History The Check History field specifies
whether the Headcount and Turnover data
mart should also include historical
data.
Valid values are:
Y = Yes
N = No
HRE-AS-OF-DATE Numeric 8 (yyyymmdd) HC01.2
Element: As of Date
HRE-YRS-JOB-CODE Numeric 1 HC01.2
Element: Yrs Job Code
HRE-YRS-GRADE Numeric 1 HC01.2
Element: Yrs Grade
HRE-YRS-COMPANY Numeric 1 HC01.2
Element: Yrs Company
HRE-HIERARCHY Alpha 1 HC01.2
Element: Hierarchy
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
|
