|
|
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 Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
ODT-ESTABLISHMENT Alpha 10 PA92.2
Element: Establishment
ODT-PROCESS-LEVEL Alpha 5 PA92.2
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
ODT-DEPARTMENT Alpha 5 PA92.2
Element: Department Contains the department.
ODT-LOCAT-CODE Alpha 10 PA92.2
Element: Location
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
|
