Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HREMPDIM


                             HREMPDIM FILE

The HREMPDIM file contains the information used when building the Employee
dimension.

REFERENCED BY

HC02.1    HCCE.1    HCDL.1    HCEM.1    HCHE.1    HCHP.1

UPDATED BY

HC01.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HRE-EMP-DIMENSION      Alpha 50  (Lower Case)                    HC01.2
Element: User Dim Name 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.

HRE-MEMBER-PREFIX      Alpha 5  (Lower Case)                     HC01.2
Element: Member Prefix The Member Prefix field contains a
                       unique prefix to differentiate the
                       dimension name from other like-named
                       dimensions.  This user-defined name can
                       contain up to five characters of any
                       kind.

HRE-ALIAS-OPTION       Alpha 1                                   HC01.2
Element: Account Flag  The Alias Option field contains the
                       alias name option that has been
                       specified for the Employee dimension.

                       Valid values are:
                       1 = Name
                       2 = Number;Name
                       3 = Company;Number;Name

HRE-COMPANY            Numeric 4                                 HC01.2
Element: Company Hr    The Company field contains the company
                       number.

HRE-GROUP-NAME         Alpha 10                                  HC01.2
Element: Group Name    The Group Name field contains the name
                       of the company group.

HRE-PROC-LEVEL         Alpha 5 Occurs 5 Times                    HC01.2
Element: Process Lev HrThe Process Level field contains the
                       process level name. Process level is one
                       reporting level below company. This
                       field can contain up to five process
                       levels.

HRE-EMP-STATUS         Alpha 2 Occurs 9 Times                    HC01.2
Element: Employee StatuThe Employee Status field contains a
                       valid employee status value. This field
                       can contain up to nine valid employee
                       status values.

HRE-EMP-DATE1          Numeric 8  (yyyymmdd)                     HC01.2
Element: Emp Date1     The Employment Date1 field contains the
                       first date in the termination date
                       range, if employees with a terminated
                       status are included in the data mart.

HRE-EMP-DATE2          Numeric 8  (yyyymmdd)                     HC01.2
Element: Emp Date2     The Employment Date2 field contains the
                       final date in the termination date range
                       if employees with a terminated status
                       are included in the data mart.

HRE-ALL-POS-LEVEL      Alpha 1                                   HC01.2
Element: All Pos Level The All Positions and Job Levels field
                       specifies whether all positions and jobs
                       are included for the employee.

                       Valid values are:

                       Y = Yes
                       N = N

HRE-CHECK-HISTORY      Alpha 1                                   HC01.2
Element: Check History The Check History field specifies
                       whether the Headcount and Turnover data
                       mart should also include historical
                       data.

                       Valid values are:

                       Y = Yes
                       N = No

HRE-AS-OF-DATE         Numeric 8  (yyyymmdd)                     HC01.2
Element: As of Date

HRE-YRS-JOB-CODE       Numeric 1                                 HC01.2
Element: Yrs Job Code

HRE-YRS-GRADE          Numeric 1                                 HC01.2
Element: Yrs Grade

HRE-YRS-COMPANY        Numeric 1                                 HC01.2
Element: Yrs Company

HRE-HIERARCHY          Alpha 1                                   HC01.2
Element: Hierarchy

                         HREMPDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HRESET1   EMP-DIMENSION                                          HC01.1  HC01.2
                                                                 HC01.3  HC02.1
                                                                 HCCE.1  HCDL.1
                                                                 HCEM.1  HCHE.1
                                                                 HCHP.1