HDTDIM

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
HCDL.1 HCCE.1


UPDATED BY
HC01.1 HC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HCA-DATA-MART-NAME
Element: Data Mart Name
Alpha 20 (Lower Case)
This field contains the name of the data mart.
HC01.1 HC10.1
HCA-EMP-DIMENSION
Element: Emp Dimension
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.1 HC10.1
HCA-MEAS-DIMENSION
Element: Meas Dimension
Alpha 50 (Lower Case)
The Measures Dimension Name field contains the user-defined name for the Measures dimension. This name can contain up to 50 characters of any kind.
HC01.1 HC10.1
HCA-ORG-DIMENSION
Element: Org Dimension
Alpha 50 (Lower Case)
The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 50 characters of any kind.
HC01.1 HC10.1
HCA-GL-DIMENSION
Element: Gl Dimension
Alpha 50 (Lower Case)
HC01.1 HC10.1
HCA-TIME-DIMENSION
Element: Time Dimension
Alpha 50 (Lower Case)
The Time Dimension Name field contains the user-defined name of the Time dimension. This name can contain up to 50 characters of any kind.
HC01.1 HC10.1
HCA-POS-DIMENSION
Element: Pos Dimension
Alpha 50 (Lower Case)
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.
HC01.1 HC10.1
HCA-JOB-DIMENSION
Element: Job Dimension
Alpha 50 (Lower Case)
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.
HC01.1 HC10.1
HCA-SUP-DIMENSION
Element: Sup Dimension
Alpha 50 (Lower Case)
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.
HC01.1 HC10.1
HCA-SCH-DIMENSION
Element: Sch Dimension
Alpha 50 (Lower Case)
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.
HC01.1 HC10.1
HCA-YRS-DIMENSION
Element: Yrs Dimension
Alpha 50 (Lower Case)
HC01.1 HC10.1
HCA-AGE-DIMENSION
Element: Age Dimension
Alpha 50 (Lower Case)
HC01.1 HC10.1
HCA-PRF-DIMENSION
Element: Prf Dimension
Alpha 50 (Lower Case)
HC01.1 HC10.1
HCA-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
HC01.1 HC10.1
HCA-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
HC01.1 HC10.1
HCA-TIME-INDICATOR
Element: Time Indicator
Alpha 1
HC01.1 HC10.1
HCA-FIXED-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
HC01.1 HC10.1


HDTDIM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HCASET1 DATA-MART-NAME
HC01.1 HCCE.1
HCDL.1


File created: Thu Jun 09 11:14:26 2016

Home
Contact Us



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