EEODETAIL

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 PA392


UPDATED BY
PA93.4 PA93.2 PA93.6 PA93.1 PA93.5

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EOD-COMPANY
Element: Company Hr		Numeric 4
Contains the company number which represents an established company.
PA93.4
EOD-ESTBLSH-NBR
Element: Estblsh Nbr		Alpha 9
Contains the establishment number. Establishment numbers are setup in the EEO Establishment file.
PA93.4
EOD-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
Contains the process level.
PA93.4
EOD-DEPARTMENT
Element: Department		Alpha 5
Contains the department.
PA93.4
EOD-LOCAT-CODE
Element: Locat Code		Alpha 10
Location code defines locations that are valid within an establishment.
PA93.4


EEODETAIL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EODSET1 COMPANY
ESTBLSH-NBR
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
PA393 PA93.2
PA93.4 PA93.6
EODSET2 COMPANY
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
PA390 PA392
PA393 PA93.1
PA93.4 PA93.5
EODSET3 COMPANY
LOCAT-CODE
PROCESS-LEVEL
DEPARTMENT


EEODETAIL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:24:45 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.