|
|
HDTDIM FILE
The HDTDIM data file contains the data mart, dimension, and Years of Service
member names for the Compensation and Headcount and Turnover data marts.
REFERENCED BY
HCCE.1 HCDL.1 HCHE.1
UPDATED BY
HC01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HCA-DATA-MART-NAME Alpha 20 (Lower Case) HC01.1
Element: Data Mart NameThis field contains the name of the data
mart.
HCA-EMP-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Emp Dimension 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.
HCA-MEAS-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Meas DimensionThe Measures Dimension Name field
contains the user-defined name for the
Measures dimension. This name can
contain up to 50 characters of any kind.
HCA-ORG-DIMENSION Alpha 50 (Lower Case) HC01.1
Organization The Organization Dimension Name field
Dimensioin Name contains the user-defined name for the
Organization dimension. This name can
contain up to 50 characters of any kind.
HCA-GL-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Gl Dimension
HCA-TIME-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Time DimensionThe Time Dimension Name field contains
the user-defined name of the Time
dimension. This name can contain up to
50 characters of any kind.
HCA-POS-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Pos Dimension The Position Dimension Name field
contains the user-defined name for the
Position dimension. This name can
contain up to 50 characters of any kind.
HCA-JOB-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Job Dimension The Job Dimension Name field contains
the user-defined name for the Job
dimension. This name can contain up to
50 characters of any kind.
HCA-SUP-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Sup Dimension The Supervisor Dimension Name field
contains the user-defined name for the
Supervisor dimension. This name can
contain up to 50 characters of any kind.
HCA-SCH-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Sch Dimension The Schedule Dimension Name field
contains the user-defined name of the
Schedule dimension. The name can contain
up to 50 characters of any kind.
HCA-YRS-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Yrs Dimension
HCA-AGE-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Age Dimension
HCA-PRF-DIMENSION Alpha 50 (Lower Case) HC01.1
Element: Prf Dimension
HCA-MAINT-DATE Numeric 8 (yyyymmdd) HC01.1
Element: Maintenance DaThe date last changed.
HCA-MAINT-TIME Numeric 6 (hhmmss) HC01.1
Element: Sys Time The time last changed.
HCA-TIME-INDICATOR Alpha 1 HC01.1
Element: Time Indicator
HCA-FIXED-DATE Numeric 8 (yyyymmdd) HC01.1
Element: Date
HDTDIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HCASET1 DATA-MART-NAME HC01.1 HCCE.1
HCDL.1 HCHE.1
|
