|
|
OSHA FILE
OSHA Incident History
The OSHA Incident History file contains the history of OSHA incidents.
REFERENCED BY
HOSH.1 HR90.1 PA149 PA248 PA249 PA290
PA49.1 PA49.3 PA490 PA549 HR170 HR70.1
PA91.1 PA92.1
UPDATED BY
PA372 PA590 PA90.1 PA90.3 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSH-COMPANY Numeric 4 PA372 PA590
Element: Company Hr Contains the company number that PA90.1
represents an established company.
OSH-EMPLOYEE Numeric 9 PA372 PA590
Element: Employee An employee number is assigned to each PA90.1
person employed by the company. It is
used to correlate all information
related to the employee.
OSH-SEQ-NBR Numeric 4 PA372 PA590
Element: Sequence NumbeSequence number. PA90.1
OSH-DATE Numeric 8 (yyyymmdd) PA372 PA590
Element: Date This field contains the date of injury PA90.1
or illness.
OSH-ILL-INJ Alpha 2 PA372 PA590
Illness or Injury This field contains the illness or PA90.1
Indicator injury indicator.
IL = Illness
IN = Injury
OSH-DESCRIPTION Alpha 30 (Lower Case) PA372 PA590
Element: Description This field contains the description of PA90.1
the illness or injury.
OSH-JOB-CODE Alpha 9 PA372 PA590
Element: Job Code This field contains the job code PA90.1
performed when the incident occurred.
The job code must be valid in JOBCODE.
OSH-PROCESS-LEVEL Alpha 5 PA372 PA590
Element: Process Lev HrThis field contains the employee's PA90.1
process level or the process level where
the incident occurred.
OSH-DEPARTMENT Alpha 5 PA372 PA590
Element: Department This field contains the employee's PA90.1
department or the department where the
incident occurred.
OSH-AGE Numeric 2 PA372 PA590
Element: Age This field contains the employee's age PA90.1
when the incident occurred.
OSH-SEX Alpha 1 PA372 PA590
Element: Gender Employee's gender when incident PA90.1
occurred.
F = Female
M = Male
OSH-PHY-LST-NAME Alpha 15 (Lower Case) PA372 PA590
Element: Physician LastThis field contains the physician's PA90.1
last name.
OSH-PHY-FST-NAME Alpha 14 (Lower Case) PA372 PA590
Element: Physician FirsThis field contains the physician's PA90.1
first name.
OSH-PHY-MID-INIT Alpha 1 PA372 PA590
Physician Middle This field contains the physician's PA90.1
Initial middle initial.
OSH-HOSP-NAME Alpha 30 (Lower Case) PA372 PA590
Element: Hospital Name This field contains the hospital name. PA90.1
OSH-DEATH Alpha 1 PA372 PA590
Death Resulted This field indicates if the incident PA90.1
Indicator resulted in death.
N = No
Y = Yes
OSH-DEAD-DATE Numeric 8 (yyyymmdd) PA372 PA590
Element: Date of Death This field contains the date of death. PA90.1
OSH-CMP-PREM Alpha 1 PA372 PA590
Occurred on Company This field indicates if the incident PA90.1
Premises occurred on company premises.
N = No
Y = Yes
OSH-LOCAT-CODE Alpha 10 PA372 PA590
Element: Location This field contains the location of the PA90.1
incident. The location must be valid
in PCODES.
OSH-SHIFT Numeric 1 PA372 PA590
Element: Shift This field contains the shift worked PA90.1
when the incident occurred.
1 = Shift 1
2 = Shift 2
3 = Shift 3
4 = Shift 4
5 = Shift 5
6 = Shift 6
7 = Shift 7
8 = Shift 8
9 = Shift 9
OSH-HOW Alpha 50 (Lower Case) PA372 PA590
How Incident Occurs 2 Times PA90.1
Occurred This field contains the description of
how the incident occurred.
OSH-BODY-PART Alpha 50 (Lower Case) PA372 PA590
Element: Affected Body This field contains the description of PA90.1
the body part(s) affected by the
incident.
OSH-OBJ-SUBS Alpha 50 (Lower Case) PA372 PA590
Involved Object or This field contains the description of PA90.1
Substance the object or substance.
OSH-DAYS-OUT Numeric 3 PA372 PA590
Element: Days Out This field contains the number of days PA90.1
away from work.
OSH-DAYS-REST Numeric 3 PA372 PA590
Element: Days RestricteThis field contains the number of days PA90.1
restricted from certain types of work.
OSH-ILLNESS-TYPE Alpha 2 PA372 PA590
Element: Illness Type This field contains the type of illness. PA90.1
1 = Musculoskeletal disorder
2 = Skin disorder
3 = Respiratory condition
4 = Poisoning
5 = Hearing loss
6 = Disorder from physical agent
7 = Disorder from repeated trauma
8 = Dust disease of the lungs
9 = Other occupational illness
OSH-WC-FLAG Alpha 1 PA372 PA590
Workers Comp This field indicates whether the PA90.1
Reportable Flag incident was reportable with regard to
workers compensation.
N = No
Y = Yes
OSH-OSHA-FLAG Alpha 1 PA372 PA590
Element: Osha Flag Reserved for future development. PA90.1
N = No
Y = Yes
OSH-INCIDENT Alpha 10 PA372 PA590
Element: Incident Contains user-defined incident PA90.1
information.
OSH-ILLNESS Alpha 10 PA372 PA590
Element: Illness Contains user-defined illness PA90.1
information.
OSH-FULL-NAME Derived
Element: Full Name Reserved for future development.
OSH-ESTABLISHMENT Alpha 10 PA372 PA590
Element: Establishment Contains the establishment where PA90.1
incident occurred.
OSH-INCID-STATUS Alpha 10 PA372 PA590
Element: Incid Status Contains the user-defined incident PA90.1
status.
OSH-OUTCOME Alpha 10 PA372 PA590
Element: Outcome Contains the user-defined incident PA90.1
outcome.
OSH-COST Signed 11.2 PA372 PA590
Element: Cost Contains the incident cost. PA90.1 PA90.3
OSH-INCID-CAT Alpha 10 PA372 PA590
Element: Incid Cat Contains the user-defined incident PA90.1
category.
OSH-WC-CLAIM Alpha 15 PA372 PA590
Element: Wc Claim Contains the workers compensation claim PA90.1
number.
OSH-GOVT-FLAG Alpha 1 PA372 PA590
Element: Govt Flag Indicates whether case must be reported PA90.1
to the government.
Y = Yes
N = No
OSH-GOVT-CASE Numeric 8 PA372 PA590
Element: Govt Case Contains the government case number. PA90.1
OSH-PRIOR-ESTAB Alpha 10 PA372 PA590
Element: Prior Estab If the incident is related to a prior PA90.1
incident, this field contains the
establishment where the prior incident
occurred.
OSH-PRIOR-SEQ-NBR Numeric 4 PA372 PA590
Element: Prior Seq Nbr If the incident is related to a prior PA90.1
incident, this field contains the prior
report number.
OSH-BODY-PART-CD Alpha 10 PA372 PA590
Element: Body Part Cd Contains the user-defined body part PA90.1
that was injured by the incident.
OSH-REPORTS-TO Numeric 9 PA372 PA590
Element: Reports To Contains the employee to whom the PA90.1
incident was reported.
OSH-REPORT-TO-NAME Alpha 30 (Lower Case) PA372 PA590
Element: Report To NameContains the employee or individual to PA90.1
whom the incident was reported.
OSH-REPORTS-BY Numeric 9 PA372 PA590
Element: Reports By Contains the employee who reported the PA90.1
incident.
OSH-REPORT-BY-NAME Alpha 30 (Lower Case) PA372 PA590
Element: Report By NameContains the employee or individual who PA90.1
reported the incident.
OSH-WITNESS Numeric 9 PA372 PA590
Element: Witness Contains the employee who witnessed the PA90.1
incident.
OSH-WIT-NAME Alpha 30 (Lower Case) PA372 PA590
Element: Wit Name Contains the employee or individual who PA90.1
witnessed the incident.
OSH-WIT-ADDR1 Alpha 30 (Lower Case) PA372 PA590
Element: Wit Addr1 Contains the first line of the PA90.1
witness's address.
OSH-WIT-CITY Alpha 18 (Lower Case) PA372 PA590
Element: Wit City Contains the witness's city. PA90.1
OSH-WIT-STATE Alpha 2 PA372 PA590
Element: Wit State Contains the witness's state. PA90.1
OSH-WIT-ZIP Alpha 10 PA372 PA590
Element: Wit Zip Contains the witness's postal code. PA90.1
OSH-WIT-CNTRY-CD Alpha 2 PA372 PA590
Element: Wit Cntry Cd PA90.1
OSH-WIT-PHN-CNTRY Alpha 6 PA372 PA590
Element: Wit Phn Cntry Contains the witness's telephone PA90.1
country code.
OSH-WIT-PHONE-NBR Alpha 15 PA372 PA590
Element: Wit Phone Nbr Contains the witness's telephone number. PA90.1
OSH-WIT-PHONE-EXT Alpha 5 PA372 PA590
Element: Wit Phone Ext Contains the witness's telephone PA90.1
extension.
OSH-EMP-STATUS Alpha 2 PA372 PA590
Element: Employee StatuContains the employee's status when PA90.1
incident occurred.
1 = Full Time
2 = Part Time
3 = Casual
4 = Seasonal
5 = Apprentice
6 = Student
7 = Learner
8 = Volunteer
9 = Other
OSH-SUPERVISOR-EMP Numeric 9 PA372 PA590
Element: Supervisor EmpContains the supervisor to whom the PA90.1
employee reported when the incident
occurred.
OSH-SUP-NAME Alpha 30 (Lower Case) PA372 PA590
Element: Supervisor's NContains the name of the supervisor to PA90.1
whom the employee reported when the
incident occurred.
OSH-ADDR1 Alpha 30 (Lower Case) PA372 PA590
Element: Address 1 Contains the address where the incident PA90.1
took place.
OSH-CITY Alpha 18 (Lower Case) PA372 PA590
Element: City Contains the city where the incident PA90.1
took place.
OSH-STATE Alpha 2 PA372 PA590
Element: State or ProviContains the state where the incident PA90.1
took place.
OSH-ZIP Alpha 10 PA372 PA590
Element: Postal Code Contains the postal code where the PA90.1
incident took place.
OSH-FIRST-AID-BY Numeric 9 PA372 PA590
Element: First Aid By Contains the employee who provided PA90.1
first aid.
OSH-FIRST-AID-NAME Alpha 30 (Lower Case) PA372 PA590
Element: First Aid NameContains the employee or individual who PA90.1
provided first aid.
OSH-PHYSICIAN Alpha 10 PA372 PA590
Element: Physician Contains the physician who treated the PA90.1
employee.
OSH-PATIENT-FLAG Alpha 1 PA372 PA590
Element: Patient Flag Indicates whether the employee was PA90.1
hospitalized as a result of the
incident.
N = No
Y = Yes
OSH-HOSPITAL Alpha 10 PA372 PA590
Element: Hospital Contains the user-defined hospital PA90.1
where the employee was treated after the
incident.
OSH-TIME-START-WK Numeric 6 (hhmmss) PA372 PA590
Element: Time Start Wk Contains the employee's normal work PA90.1
start time.
OSH-TIME-END-WK Numeric 6 (hhmmss) PA372 PA590
Element: Time End Wk Contains the employee's normal work PA90.1
stop time.
OSH-DATE-INJURY Numeric 8 (yyyymmdd) PA372 PA590
Element: Date Injury Contains the date the incident took PA90.1
place.
OSH-TIME-INJURY Numeric 6 (hhmmss) PA372 PA590
Element: Time Injury Contains the time the incident took PA90.1
place.
OSH-DATE-LAST-WORK Numeric 8 (yyyymmdd) PA372 PA590
Element: Date Last WorkContains the last date the employee PA90.1
worked after the incident.
OSH-TIME-LAST-WORK Numeric 6 (hhmmss) PA372 PA590
Element: Time Last WorkContains the last time the employee PA90.1
worked after the incident.
OSH-DATE-OUT Numeric 8 (yyyymmdd) PA372 PA590
Element: Date Out Contains the first date the employee PA90.1
did not attend work due to the incident.
OSH-DATE-NOTIFIED1 Numeric 8 (yyyymmdd) PA372 PA590
Element: Date Notified1Contains the date the employer was PA90.1
notified of the incident.
OSH-TIME-NOTIFIED1 Numeric 6 (hhmmss) PA372 PA590
Element: Time Notified1Contains the time the employer was PA90.1
notified of the incident.
OSH-DATE-NOTIFIED2 Numeric 8 (yyyymmdd) PA372 PA590
Element: Date Notified2Contains the date the employer was PA90.1
notified of lost time.
OSH-TIME-NOTIFIED2 Numeric 6 (hhmmss) PA372 PA590
Element: Time Notified2Contains the time the employer was PA90.1
notified of lost time.
OSH-DATE-1 Numeric 8 (yyyymmdd) PA372 PA590
Element: Date 1 If the employee returned to work after PA90.1
the incident, contains the first date of
the date range.
OSH-TIME-1 Numeric 6 (hhmmss) PA372 PA590
Element: Time 1 If the employee returned to work after PA90.1
the incident, contains the start time.
OSH-DATE-2 Numeric 8 (yyyymmdd) PA372 PA590
Element: Date 2 If the employee returned to work after PA90.1
the incident, contains the last date of
the date range.
OSH-TIME-2 Numeric 6 (hhmmss) PA372 PA590
Element: Time 2 If the employee returned to work after PA90.1
the incident, contains the ending time.
OSH-DATE-RETURNED Numeric 8 (yyyymmdd) PA372 PA590
Element: Date Returned Contains the date the employee returned PA90.1
to work after the incident.
OSH-TIME-RETURNED Numeric 6 (hhmmss) PA372 PA590
Element: Time Returned Contains the time the employee returned PA90.1
to work after the incident.
OSH-HOURS-FLAG Alpha 1 PA372 PA590
Element: Hours Flag Indicates whether the employee was PA90.1
absent from work due to the incident.
N = No
Y = Yes
OSH-WORK-FLAG Alpha 1 PA372 PA590
Element: Work Flag Indicates whether the employee is able PA90.1
to perform other duties at work.
N = No
Y = Yes
OSH-WAGES-FLAG Alpha 1 PA372 PA590
Element: Wages Flag Indicates whether the employee will PA90.1
earn reduced wages due to performing
other work duties.
N = No
Y = Yes
OSH-DATE-STAMP Numeric 8 (yyyymmdd) PA372 PA590
Element: Date Stamp This field contains the server date PA90.1 PA90.3
(month, date, and year) of the last
change to this record.
OSH-TIME-STAMP Numeric 6 (hhmmss) PA372 PA590
Element: Time Stamp Contains the server time (hour, minute, PA90.1 PA90.3
and second) when the record was last
changed.
OSH-USER-ID Alpha 10 (Lower Case) PA372 PA590
Element: User Contains the user ID of the person who PA90.1 PA90.3
last changed this record.
OSH-SEVERITY Alpha 10 PA372 PA590
Element: Severity Contains the user-defined incident PA90.1
severity.
OSH-USER-FIELD1 Alpha 30 PA372 PA590
Item Mster User This is the first user definable field. PA90.1
Defined Field1 It can be used to capture any data that
the user wants. The title of the field
is setup in IC00.
OSH-USER2 Alpha 10 PA372 PA590
Element: User2 Contains the second field of PA90.1
user-defined information.
OSH-USER3 Alpha 10 PA372 PA590
Element: User3 Contains the third field of PA90.1
user-defined information.
OSH-CURRENCY-CODE Alpha 5 PA372 PA590
Element: Currency Code Contains the currency in which the PA90.1 PA90.3
incident costs are recorded.
OSH-CURR-ND Numeric 1 PA372 PA590
Account Currency Represents the number of decimals PA90.1 PA90.3
Code defined for the currency of the object.
OSH-COUNTRY-CODE Alpha 2 PA372 PA590
Element: Country Code Contains the country where the incident PA90.1
took place.
OSH-BASE-CURRENCY Alpha 5 PA372 PA590
Element: Base Currency Contains the company base currency. PA90.1 PA90.3
OSH-BASE-ND Numeric 1 PA372 PA590
Base Number Of The number of decimal positions defined PA90.1 PA90.3
Decimals for the company base currency.
OSH-BASE-AMOUNT Signed 15.2 PA372 PA590
Element: Base Amount Contains the incident costs in the PA90.1 PA90.3
company's base currency.
OSH-INCIDENT-SITE Alpha 30 (Lower Case) PA372 PA590
Element: Incident Site PA90.1
OSH-REPORT-COMP-BY Numeric 9 PA372 PA590
Element: Report Comp By PA90.1
OSH-RPT-COMP-NAME Alpha 30 (Lower Case) PA372 PA590
Element: Rpt Comp Name PA90.1
OSH-RPT-COMP-DATE Numeric 8 (yyyymmdd) PA372 PA590
Element: Rpt Comp Date PA90.1
OSH-EMERGENCY-ROOM Alpha 1 PA372 PA590
Element: Emergency Room PA90.1
OSH-SHARP-DEVICE Alpha 10 PA372 PA590
Element: Sharp Device PA90.1
OSH-BRND-SHARP-DEV Alpha 10 PA372 PA590
Element: Brnd Sharp Dev PA90.1
OSHA FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSHSET1 COMPANY HOSH.1 HR11.1
EMPLOYEE HR90.1 PA115
ESTABLISHMENT PA149 PA248
SEQ-NBR PA249 PA290
PA372 PA49.1
PA49.3 PA490
PA549 PA590
PA90.1 PA90.2
PA90.3
OSHSET2 COMPANY KeyChange HR170 HR70.1
EMPLOYEE PA91.1
DATE
ESTABLISHMENT
SEQ-NBR
OSHSET3 COMPANY PA372 PA590
ESTABLISHMENT PA90.1 PA92.1
SEQ-NBR*
EMPLOYEE
OSHA FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
When (OSH-CURRENCY-CODE != Spaces )
OSH-BASE-CURRENCY -> CUC-CURRENCY-CODE
Body Part PCODES Required
When (OSH-BODY-PART-CD != Spaces )
"BP" -> PCO-TYPE
OSH-BODY-PART-CD -> PCO-CODE
Company PRSYSTEM Required
OSH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (OSH-COUNTRY-CODE != Spaces )
OSH-COUNTRY-CODE -> INT-COUNTRY-CODE
Currency CUCODES Required
When (OSH-CURRENCY-CODE != Spaces )
OSH-CURRENCY-CODE -> CUC-CURRENCY-CODE
Department DEPTCODE Required
When OSH-DEPARTMENT != Spaces
OSH-COMPANY -> DPT-COMPANY
OSH-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
OSH-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
OSH-COMPANY -> EMP-COMPANY
OSH-EMPLOYEE -> EMP-EMPLOYEE
Establishment OSHESTAB Required
When (OSH-ESTABLISHMENT != Spaces )
OSH-COMPANY -> OTB-COMPANY
OSH-ESTABLISHMENT -> OTB-ESTABLISHMENT
First Aid By EMPLOYEE Required
When (OSH-FIRST-AID-BY != Zeroes )
OSH-COMPANY -> EMP-COMPANY
OSH-FIRST-AID-BY -> EMP-EMPLOYEE
Hospital PCODES Required
When (OSH-HOSPITAL != Spaces )
"HO" -> PCO-TYPE
OSH-HOSPITAL -> PCO-CODE
Illness PCODES Required
When OSH-ILL-INJ = "IL"
"IL" -> PCO-TYPE
OSH-ILLNESS -> PCO-CODE
Illness Type PCODES Required
When (OSH-ILLNESS != Spaces )
"IL" -> PCO-TYPE
OSH-ILLNESS -> PCO-CODE
Incident PCODES Required
When (OSH-INCIDENT != Spaces )
"IN" -> PCO-TYPE
OSH-INCIDENT -> PCO-CODE
Incident Cat PCODES Required
When (OSH-INCID-CAT != Spaces )
"IC" -> PCO-TYPE
OSH-INCID-CAT -> PCO-CODE
Incident Outcm PCODES Required
When (OSH-OUTCOME != Spaces )
"IO" -> PCO-TYPE
OSH-OUTCOME -> PCO-CODE
Incident Stat PCODES Required
When (OSH-INCID-STATUS != Spaces )
"IS" -> PCO-TYPE
OSH-INCID-STATUS -> PCO-CODE
Job Code JOBCODE Required
When OSH-JOB-CODE != Spaces
OSH-COMPANY -> JBC-COMPANY
OSH-JOB-CODE -> JBC-JOB-CODE
Location PCODES Required
When OSH-LOCAT-CODE != Spaces
"LO" -> PCO-TYPE
OSH-LOCAT-CODE -> PCO-CODE
Pa Employee PAEMPLOYEE Required
OSH-COMPANY -> PEM-COMPANY
OSH-EMPLOYEE -> PEM-EMPLOYEE
Physician PCODES Required
When OSH-PHYSICIAN != Spaces
"PY" -> PCO-TYPE
OSH-PHYSICIAN -> PCO-CODE
Prior Incident OSHA Required
When OSH-PRIOR-SEQ-NBR != Zeroes
OSH-COMPANY -> OSH-COMPANY
OSH-EMPLOYEE -> OSH-EMPLOYEE
OSH-PRIOR-ESTAB -> OSH-ESTABLISHMENT
OSH-PRIOR-SEQ-NBR -> OSH-SEQ-NBR
Process Level PRSYSTEM Required
When OSH-PROCESS-LEVEL != Spaces
OSH-COMPANY -> PRS-COMPANY
OSH-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Report By EMPLOYEE Required
When (OSH-REPORTS-BY != Zeroes )
OSH-COMPANY -> EMP-COMPANY
OSH-REPORTS-BY -> EMP-EMPLOYEE
Report To EMPLOYEE Required
When (OSH-REPORTS-TO != Zeroes )
OSH-COMPANY -> EMP-COMPANY
OSH-REPORTS-TO -> EMP-EMPLOYEE
Severity PCODES Required
When OSH-SEVERITY != Spaces
"IE" -> PCO-TYPE
OSH-SEVERITY -> PCO-CODE
Super Emp EMPLOYEE Required
When (OSH-SUPERVISOR-EMP != Zeroes )
OSH-COMPANY -> EMP-COMPANY
OSH-SUPERVISOR-EMP -> EMP-EMPLOYEE
User2 PCODES Required
When OSH-USER2 != Spaces
"I2" -> PCO-TYPE
OSH-USER2 -> PCO-CODE
User3 PCODES Required
When OSH-USER3 != Spaces
"I3" -> PCO-TYPE
OSH-USER3 -> PCO-CODE
Wit Country INSTCTRYCD Required
When (OSH-WIT-CNTRY-CD != Spaces )
OSH-WIT-CNTRY-CD -> INT-COUNTRY-CODE
Witness EMPLOYEE Required
When (OSH-WITNESS != Zeroes )
OSH-COMPANY -> EMP-COMPANY
OSH-WITNESS -> EMP-EMPLOYEE
OSHA FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Comments PACOMMENTS Delete Cascades
OSH-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"OS" -> PAC-CMT-TYPE
OSH-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
OSH-ESTABLISHMENT -> PAC-ACTION-CODE
OSH-SEQ-NBR -> PAC-LN-NBR
PAC-SEQ-NBR
Costs PAINCICOST Delete Cascades
OSH-COMPANY -> PAI-COMPANY
OSH-EMPLOYEE -> PAI-EMPLOYEE
OSH-ESTABLISHMENT -> PAI-ESTABLISHMENT
OSH-SEQ-NBR -> PAI-INCIDENT-NBR
PAI-EFFECT-DATE
PAI-SEQ-NBR
Establish Dtl OSHESTDTL
Valid When (OSH-ESTABLISHMENT != Spaces )
OSH-COMPANY -> ODT-COMPANY
OSH-ESTABLISHMENT -> ODT-ESTABLISHMENT
ODT-PROCESS-LEVEL
ODT-DEPARTMENT
ODT-LOCAT-CODE
Follow Up PAFOLLOWUP Delete Cascades
OSH-COMPANY -> PAF-COMPANY
OSH-EMPLOYEE -> PAF-EMPLOYEE
OSH-ESTABLISHMENT -> PAF-ESTABLISHMENT
OSH-SEQ-NBR -> PAF-INCIDENT-NBR
PAF-EFFECT-DATE
PAF-SEQ-NBR
|
