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       Contains the company number which
                       represents an established company.
EOD-ESTBLSH-NBR        Alpha 9                                   PA93.4
EEO Establishment      Contains the establishment number.
Number
                       Establishment numbers are setup in the
                       EEO Establishment file.
EOD-PROCESS-LEVEL      Alpha 5                                   PA93.4
Element: Process Level Contains the process level.
EOD-DEPARTMENT         Alpha 5                                   PA93.4
Element: Department    Contains the department.
EOD-LOCAT-CODE         Alpha 10                                  PA93.4
Element: Location      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
                            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
                            "LO"                 -> PCO-TYPE
                            EOD-LOCAT-CODE       -> PCO-CODE
Process Level  PRSYSTEM     Required
                            EOD-COMPANY          -> PRS-COMPANY
                            EOD-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL
 |