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
|
