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 |
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
HCA-GL-DIMENSION Element: Gl Dimension | Alpha 50 (Lower Case) |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
HCA-YRS-DIMENSION Element: Yrs Dimension | Alpha 50 (Lower Case) |
|
||
HCA-AGE-DIMENSION Element: Age Dimension | Alpha 50 (Lower Case) |
|
||
HCA-PRF-DIMENSION Element: Prf Dimension | Alpha 50 (Lower Case) |
|
||
HCA-MAINT-DATE Element: Maint Date | Numeric 8 (yyyymmdd) The date last changed. |
|
||
HCA-MAINT-TIME Element: Sys Time | Numeric 6 (hhmmss) |
|
||
HCA-TIME-INDICATOR Element: Time Indicator | Alpha 1 |
|
||
HCA-FIXED-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HCASET1 |
DATA-MART-NAME |
|
|
All trademarks and registered trademarks are the property of their
respective owners.