OSHESTDTL FILE
REFERENCED BY
PA292 PA490
UPDATED BY
PA92.2 PA92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ODT-COMPANY Numeric 4 PA92.2
Element: Company Hr
ODT-ESTABLISHMENT Alpha 10 PA92.2
Element: Establishment
ODT-PROCESS-LEVEL Alpha 5 PA92.2
Element: Process Lev Hr
ODT-DEPARTMENT Alpha 5 PA92.2
Element: Department Contains the department.
ODT-LOCAT-CODE Alpha 10 PA92.2
Element: Locat Code
OSHESTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ODTSET1 COMPANY PA292 PA490
ESTABLISHMENT PA92.1 PA92.2
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
ODTSET2 COMPANY PA92.2
ESTABLISHMENT
LOCAT-CODE
DEPARTMENT
PROCESS-LEVEL
ODTSET3 COMPANY PA92.2
ESTABLISHMENT
LOCAT-CODE
PROCESS-LEVEL
DEPARTMENT
ODTSET4 COMPANY PA92.2
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
ESTABLISHMENT
OSHESTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
ODT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When ODT-DEPARTMENT != Spaces
ODT-COMPANY -> DPT-COMPANY
ODT-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
ODT-DEPARTMENT -> DPT-DEPARTMENT
Establishment OSHESTAB Required
ODT-COMPANY -> OTB-COMPANY
ODT-ESTABLISHMENT -> OTB-ESTABLISHMENT
Pcodes PCODES Required
When ODT-LOCAT-CODE != Spaces
"LO" -> PCO-TYPE
ODT-LOCAT-CODE -> PCO-CODE
Process Level PRSYSTEM Required
When ODT-PROCESS-LEVEL != Spaces
ODT-COMPANY -> PRS-COMPANY
ODT-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
OSHESTDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Osha OSHA
ODT-COMPANY -> OSH-COMPANY
ODT-ESTABLISHMENT -> OSH-ESTABLISHMENT
OSH-SEQ-NBR
OSH-EMPLOYEE
|
