HDCNTMART FILE
REFERENCED BY
HCHP.1
UPDATED BY
HC02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HHH-DATA-MART-NAME Alpha 20 (Lower Case) HC02.1
Element: Data Mart NameThis field contains the name of the data
mart.
HHH-EMP-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name The Employee Dimension Name field
contains the user-defined name for the
Employee dimension. This name can
contain up to 30 characters of any
kind.
HHH-MEAS-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name The Measures Dimension Name field
contains the user-defined name for the
Measures dimension. This name can
contain up to 30 characters of any kind.
HHH-ORG-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name The Organization Dimension Name field
contains the user-defined name for the
Organization dimension. This name can
contain up to 30 characters of any kind.
HHH-GL-ORG-DIM Alpha 50 (Lower Case) HC02.1
Element: User Dim Name
HHH-TIME-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name The Time Dimension Name field contains
the user-defined name of the Time
dimension. This name can contain up to
30 characters of any kind.
HHH-POS-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name The Position Dimension Name field
contains the user-defined name for the
Position dimension. This name can
contain up to 30 characters of any kind.
HHH-JOB-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name The Job Dimension Name field contains
the user-defined name for the Job
dimension. This name can contain up to
30 characters of any kind.
HHH-SCH-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name The Schedule Dimension Name field
contains the user-defined name of the
Schedule dimension. The name can contain
up to 30 characters of any kind.
HHH-ACV-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name
HHH-SUP-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name The Supervisor Dimension Name field
contains the user-defined name for the
Supervisor dimension. This name can
contain up to 30 characters of any kind.
HHH-YRS-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name
HHH-PRF-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name
HHH-AGE-DIMENSION Alpha 50 (Lower Case) HC02.1
Element: User Dim Name
HHH-TIME-INDICATOR Alpha 1 HC02.1
Element: Time Indicator
HHH-FIXED-DATE Numeric 8 (yyyymmdd) HC02.1
Element: Date
HHH-MAINT-DATE Numeric 8 (yyyymmdd) HC02.1
Element: Date The date last changed.
HHH-MAINT-TIME Numeric 8 HC02.1
Element: Time The time last changed.
HHH-NULL-GL-MBR Alpha 50 (Lower Case) HC02.1
Element: Member Name
HHH-NULL-POS-MBR Alpha 50 (Lower Case)
Element: Member Name
HHH-NULL-JOB-MBR Alpha 50 (Lower Case)
Element: Member Name
HHH-NULL-SCHD-MBR Alpha 50 (Lower Case)
Element: Member Name
HHH-NULL-ACV-MBR Alpha 50 (Lower Case) HC02.1
Element: Member Name
HHH-ALL-POS-LEVEL Alpha 1
Element: All Pos Level
HHH-EXC-HDCT-OPT Numeric 1
Element: Exc Hdct Opt
HDCNTMART FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HHHSET1 DATA-MART-NAME HC02.1 HCHP.1
|
