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.