OSHESTDTL

REFERENCED BY
PA292 PA490


UPDATED BY
PA92.2 PA92.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ODT-COMPANY
Element: Company Hr		Numeric 4
PA92.2
ODT-ESTABLISHMENT
Element: Establishment		Alpha 10
PA92.2
ODT-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
PA92.2
ODT-DEPARTMENT
Element: Department		Alpha 5
Contains the department.
PA92.2
ODT-LOCAT-CODE
Element: Locat Code		Alpha 10
PA92.2


OSHESTDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ODTSET1 COMPANY
ESTABLISHMENT
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
PA292 PA490
PA92.1 PA92.2
ODTSET2 COMPANY
ESTABLISHMENT
LOCAT-CODE
DEPARTMENT
PROCESS-LEVEL
PA92.2
ODTSET3 COMPANY
ESTABLISHMENT
LOCAT-CODE
PROCESS-LEVEL
DEPARTMENT
PA92.2
ODTSET4 COMPANY
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
ESTABLISHMENT
PA92.2


OSHESTDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Osha OSHA
ODT-COMPANY->OSH-COMPANY
ODT-ESTABLISHMENT->OSH-ESTABLISHMENT
  OSH-SEQ-NBR
  OSH-EMPLOYEE

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

Home
Contact Us



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