Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EEODETAIL


                             EEODETAIL FILE

                        EEO Establishment Detail

The EEO Establishment Detail file contains EEO establishment structures where
the company reports multi-establishments. An EEO establishment consists of one
or more combinations of process levels and departments.

REFERENCED BY

PA393     PA390

UPDATED BY

PA93.4    PA93.2    PA93.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EOD-COMPANY            Numeric 4                                 PA93.4
Element: Company Hr    Contains the company number which
                       represents an established company.

EOD-ESTBLSH-NBR        Alpha 9                                   PA93.4
Element: Estblsh Nbr   Contains the establishment number.

                       Establishment numbers are setup in the
                       EEO Establishment file.

EOD-PROCESS-LEVEL      Alpha 5                                   PA93.4
Element: Process Lev HrContains the process level.

EOD-DEPARTMENT         Alpha 5                                   PA93.4
Element: Department    Contains the department.

EOD-LOCAT-CODE         Alpha 10                                  PA93.4
Element: Locat Code    Location code defines locations that
                       are valid within an establishment.

                         EEODETAIL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EODSET1   COMPANY                                                PA393   PA93.2
          ESTBLSH-NBR                                            PA93.4
          PROCESS-LEVEL
          DEPARTMENT
          LOCAT-CODE

EODSET2   COMPANY                                                PA390   PA393
          PROCESS-LEVEL                                          PA93.1  PA93.4
          DEPARTMENT
          LOCAT-CODE

EODSET3   COMPANY
          LOCAT-CODE
          PROCESS-LEVEL
          DEPARTMENT

                         EEODETAIL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            EOD-COMPANY          -> PRS-COMPANY  (PRSSET1)
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When (EOD-DEPARTMENT != Spaces )
                            And  (EOD-DEPARTMENT != "ALL" )

                            EOD-COMPANY          -> DPT-COMPANY
                            EOD-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            EOD-DEPARTMENT       -> DPT-DEPARTMENT

Establishment  EEOUNIT      Required

                            EOD-COMPANY          -> EEO-COMPANY
                            EOD-ESTBLSH-NBR      -> EEO-ESTBLSH-NBR

Pcodes         PCODES       Required
                            When (EOD-LOCAT-CODE != Spaces )
                            And  (EOD-LOCAT-CODE != "ALL" )

                            "LO"                 -> PCO-TYPE
                            EOD-LOCAT-CODE       -> PCO-CODE

Process Level  PRSYSTEM     Required
                            When EOD-PROCESS-LEVEL != Spaces

                            EOD-COMPANY          -> PRS-COMPANY
                            EOD-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL