Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HDTDIM


                              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