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
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
Process Level        Contains the process level.

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

EOD-LOCAT-CODE       Alpha 10                                    PA93.4
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