|
|
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 PA49.1
PA49.3 PA549 HR170 HR70.1 PA91.1 PA92.1
UPDATED BY
PA290 PA372 PA490 PA590 PA90.1 PA90.3
HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSH-COMPANY Numeric 4 PA290 PA372
Element: Company Hr Contains the company number that PA490 PA590
represents an established company. PA90.1
OSH-EMPLOYEE Numeric 9 PA290 PA372
Element: Employee An employee number is assigned to each PA490 PA590
person employed by the company. It is PA90.1
used to correlate all information
related to the employee.
OSH-SEQ-NBR Numeric 4 PA290 PA372
Element: Seq Nbr Sequence number. PA490 PA590
PA90.1
OSH-DATE Numeric 8 (yyyymmdd) PA290 PA372
Element: Date This field contains the date of injury PA490 PA590
or illness. PA90.1
OSH-ILL-INJ Alpha 2 PA290 PA372
Element: Ill Inj This field contains the illness or PA490 PA590
injury indicator. PA90.1
IL = Illness
IN = Injury
OSH-DESCRIPTION Alpha 30 (Lower Case) PA290 PA372
Element: Description This field contains the description of PA490 PA590
the illness or injury. PA90.1
OSH-JOB-CODE Alpha 9 PA290 PA372
Element: Job Code This field contains the job code PA490 PA590
performed when the incident occurred. PA90.1
The job code must be valid in JOBCODE.
OSH-PROCESS-LEVEL Alpha 5 PA290 PA372
Element: Process Lev HrThis field contains the employee's PA490 PA590
process level or the process level where PA90.1
the incident occurred.
OSH-DEPARTMENT Alpha 5 PA290 PA372
Element: Department This field contains the employee's PA490 PA590
department or the department where the PA90.1
incident occurred.
OSH-AGE Numeric 2 PA290 PA372
Element: Age This field contains the employee's age PA490 PA590
when the incident occurred. PA90.1
OSH-SEX Alpha 1 PA290 PA372
Element: Sex Employee's gender when incident PA490 PA590
occurred. PA90.1
F = Female
M = Male
OSH-PHY-LST-NAME Alpha 15 (Lower Case) PA290 PA372
Element: Phy Lst Name This field contains the physician's PA490 PA590
last name. PA90.1
OSH-PHY-FST-NAME Alpha 14 (Lower Case) PA290 PA372
Element: Phy Fst Name This field contains the physician's PA490 PA590
first name. PA90.1
OSH-PHY-MID-INIT Alpha 1 PA290 PA372
Element: Phy Mid Init This field contains the physician's PA490 PA590
middle initial. PA90.1
OSH-HOSP-NAME Alpha 30 (Lower Case) PA290 PA372
Element: Hosp Name This field contains the hospital name. PA490 PA590
PA90.1
OSH-DEATH Alpha 1 PA290 PA372
Element: Death This field indicates if the incident PA490 PA590
resulted in death. PA90.1
N = No
Y = Yes
OSH-DEAD-DATE Numeric 8 (yyyymmdd) PA290 PA372
Element: Dead Date This field contains the date of death. PA490 PA590
PA90.1
OSH-CMP-PREM Alpha 1 PA290 PA372
Element: Cmp Prem This field indicates if the incident PA490 PA590
occurred on company premises. PA90.1
N = No
Y = Yes
OSH-LOCAT-CODE Alpha 10 PA290 PA372
Element: Locat Code This field contains the location of the PA490 PA590
incident. The location must be valid PA90.1
in PCODES.
OSH-SHIFT Numeric 1 PA290 PA372
Element: Shift This field contains the shift worked PA490 PA590
when the incident occurred. PA90.1
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) PA290 PA372
Element: How Occurs 2 Times PA490 PA590
This field contains the description of PA90.1
how the incident occurred.
OSH-BODY-PART Alpha 50 (Lower Case) PA290 PA372
Element: Body Part This field contains the description of PA490 PA590
the body part(s) affected by the PA90.1
incident.
OSH-OBJ-SUBS Alpha 50 (Lower Case) PA290 PA372
Element: Obj Subs This field contains the description of PA490 PA590
the object or substance. PA90.1
OSH-DAYS-OUT Numeric 3 PA290 PA372
Element: Days Out This field contains the number of days PA490 PA590
away from work. PA90.1
OSH-DAYS-REST Numeric 3 PA290 PA372
Element: Days Rest This field contains the number of days PA490 PA590
restricted from certain types of work. PA90.1
OSH-ILLNESS-TYPE Alpha 2 PA290 PA372
Element: Illness Type This field contains the type of illness. PA490 PA590
1 = Musculoskeletal disorder PA90.1
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 PA290 PA372
Element: Wc Flag This field indicates whether the PA490 PA590
incident was reportable with regard to PA90.1
workers compensation.
N = No
Y = Yes
OSH-OSHA-FLAG Alpha 1 PA290 PA372
Element: Osha Flag Reserved for future development. PA490 PA590
N = No PA90.1
Y = Yes
OSH-INCIDENT Alpha 10 PA290 PA372
Element: Incident Contains user-defined incident PA490 PA590
information. PA90.1
OSH-ILLNESS Alpha 10 PA290 PA372
Element: Illness Contains user-defined illness PA490 PA590
information. PA90.1
OSH-FULL-NAME Derived
Element: Full Name Reserved for future development.
OSH-ESTABLISHMENT Alpha 10 PA290 PA372
Element: Establishment Contains the establishment where PA490 PA590
incident occurred. PA90.1
OSH-INCID-STATUS Alpha 10 PA290 PA372
Element: Incid Status Contains the user-defined incident PA490 PA590
status. PA90.1
OSH-OUTCOME Alpha 10 PA290 PA372
Element: Outcome Contains the user-defined incident PA490 PA590
outcome. PA90.1
OSH-COST Signed 11.2 PA290 PA372
Element: Cost Contains the incident cost. PA490 PA590
PA90.1 PA90.3
OSH-INCID-CAT Alpha 10 PA290 PA372
Element: Incid Cat Contains the user-defined incident PA490 PA590
category. PA90.1
OSH-WC-CLAIM Alpha 15 PA290 PA372
Element: Wc Claim Contains the workers compensation claim PA490 PA590
number. PA90.1
OSH-GOVT-FLAG Alpha 1 PA290 PA372
Element: Govt Flag Indicates whether case must be reported PA490 PA590
to the government. PA90.1
Y = Yes
N = No
OSH-GOVT-CASE Numeric 8 PA290 PA372
Element: Govt Case Contains the government case number. PA490 PA590
PA90.1
OSH-PRIOR-ESTAB Alpha 10 PA290 PA372
Element: Prior Estab If the incident is related to a prior PA490 PA590
incident, this field contains the PA90.1
establishment where the prior incident
occurred.
OSH-PRIOR-SEQ-NBR Numeric 4 PA290 PA372
Element: Prior Seq Nbr If the incident is related to a prior PA490 PA590
incident, this field contains the prior PA90.1
report number.
OSH-BODY-PART-CD Alpha 10 PA290 PA372
Element: Body Part Cd Contains the user-defined body part PA490 PA590
that was injured by the incident. PA90.1
OSH-REPORTS-TO Numeric 9 PA290 PA372
Element: Reports To Contains the employee to whom the PA490 PA590
incident was reported. PA90.1
OSH-REPORT-TO-NAME Alpha 30 (Lower Case) PA290 PA372
Element: Report To NameContains the employee or individual to PA490 PA590
whom the incident was reported. PA90.1
OSH-REPORTS-BY Numeric 9 PA290 PA372
Element: Reports By Contains the employee who reported the PA490 PA590
incident. PA90.1
OSH-REPORT-BY-NAME Alpha 30 (Lower Case) PA290 PA372
Element: Report By NameContains the employee or individual who PA490 PA590
reported the incident. PA90.1
OSH-WITNESS Numeric 9 PA290 PA372
Element: Witness Contains the employee who witnessed the PA490 PA590
incident. PA90.1
OSH-WIT-NAME Alpha 30 (Lower Case) PA290 PA372
Element: Wit Name Contains the employee or individual who PA490 PA590
witnessed the incident. PA90.1
OSH-WIT-ADDR1 Alpha 30 (Lower Case) PA290 PA372
Element: Wit Addr1 Contains the first line of the PA490 PA590
witness's address. PA90.1
OSH-WIT-CITY Alpha 18 (Lower Case) PA290 PA372
Element: Wit City Contains the witness's city. PA490 PA590
PA90.1
OSH-WIT-STATE Alpha 2 PA290 PA372
Element: Wit State Contains the witness's state. PA490 PA590
PA90.1
OSH-WIT-ZIP Alpha 10 PA290 PA372
Element: Wit Zip Contains the witness's postal code. PA490 PA590
PA90.1
OSH-WIT-CNTRY-CD Alpha 2 PA290 PA372
Element: Wit Cntry Cd PA490 PA590
PA90.1
OSH-WIT-PHN-CNTRY Alpha 6 PA290 PA372
Element: Wit Phn Cntry Contains the witness's telephone PA490 PA590
country code. PA90.1
OSH-WIT-PHONE-NBR Alpha 15 PA290 PA372
Element: Wit Phone Nbr Contains the witness's telephone number. PA490 PA590
PA90.1
OSH-WIT-PHONE-EXT Alpha 5 PA290 PA372
Element: Wit Phone Ext Contains the witness's telephone PA490 PA590
extension. PA90.1
OSH-EMP-STATUS Alpha 2 PA290 PA372
Element: Emp Status Contains the employee's status when PA490 PA590
incident occurred. PA90.1
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 PA290 PA372
Element: Supervisor EmpContains the supervisor to whom the PA490 PA590
employee reported when the incident PA90.1
occurred.
OSH-SUP-NAME Alpha 30 (Lower Case) PA290 PA372
Element: Sup Name Contains the name of the supervisor to PA490 PA590
whom the employee reported when the PA90.1
incident occurred.
OSH-ADDR1 Alpha 30 (Lower Case) PA290 PA372
Element: Addr1 Contains the address where the incident PA490 PA590
took place. PA90.1
OSH-CITY Alpha 18 (Lower Case) PA290 PA372
Element: City Contains the city where the incident PA490 PA590
took place. PA90.1
OSH-STATE Alpha 2 PA290 PA372
Element: State Contains the state where the incident PA490 PA590
took place. PA90.1
OSH-ZIP Alpha 10 PA290 PA372
Element: Zip Contains the postal code where the PA490 PA590
incident took place. PA90.1
OSH-FIRST-AID-BY Numeric 9 PA290 PA372
Element: First Aid By Contains the employee who provided PA490 PA590
first aid. PA90.1
OSH-FIRST-AID-NAME Alpha 30 (Lower Case) PA290 PA372
Element: First Aid NameContains the employee or individual who PA490 PA590
provided first aid. PA90.1
OSH-PHYSICIAN Alpha 10 PA290 PA372
Element: Physician Contains the physician who treated the PA490 PA590
employee. PA90.1
OSH-PATIENT-FLAG Alpha 1 PA290 PA372
Element: Patient Flag Indicates whether the employee was PA490 PA590
hospitalized as a result of the PA90.1
incident.
N = No
Y = Yes
OSH-HOSPITAL Alpha 10 PA290 PA372
Element: Hospital Contains the user-defined hospital PA490 PA590
where the employee was treated after the PA90.1
incident.
OSH-TIME-START-WK Numeric 6 (hhmmss) PA290 PA372
Element: Time Start Wk Contains the employee's normal work PA490 PA590
start time. PA90.1
OSH-TIME-END-WK Numeric 6 (hhmmss) PA290 PA372
Element: Time End Wk Contains the employee's normal work PA490 PA590
stop time. PA90.1
OSH-DATE-INJURY Numeric 8 (yyyymmdd) PA290 PA372
Element: Date Injury Contains the date the incident took PA490 PA590
place. PA90.1
OSH-TIME-INJURY Numeric 6 (hhmmss) PA290 PA372
Element: Time Injury Contains the time the incident took PA490 PA590
place. PA90.1
OSH-DATE-LAST-WORK Numeric 8 (yyyymmdd) PA290 PA372
Element: Date Last WorkContains the last date the employee PA490 PA590
worked after the incident. PA90.1
OSH-TIME-LAST-WORK Numeric 6 (hhmmss) PA290 PA372
Element: Time Last WorkContains the last time the employee PA490 PA590
worked after the incident. PA90.1
OSH-DATE-OUT Numeric 8 (yyyymmdd) PA290 PA372
Element: Date Out Contains the first date the employee PA490 PA590
did not attend work due to the incident. PA90.1
OSH-DATE-NOTIFIED1 Numeric 8 (yyyymmdd) PA290 PA372
Element: Date Notified1Contains the date the employer was PA490 PA590
notified of the incident. PA90.1
OSH-TIME-NOTIFIED1 Numeric 6 (hhmmss) PA290 PA372
Element: Time Notified1Contains the time the employer was PA490 PA590
notified of the incident. PA90.1
OSH-DATE-NOTIFIED2 Numeric 8 (yyyymmdd) PA290 PA372
Element: Date Notified2Contains the date the employer was PA490 PA590
notified of lost time. PA90.1
OSH-TIME-NOTIFIED2 Numeric 6 (hhmmss) PA290 PA372
Element: Time Notified2Contains the time the employer was PA490 PA590
notified of lost time. PA90.1
OSH-DATE-1 Numeric 8 (yyyymmdd) PA290 PA372
Element: Date 1 If the employee returned to work after PA490 PA590
the incident, contains the first date of PA90.1
the date range.
OSH-TIME-1 Numeric 6 (hhmmss) PA290 PA372
Element: Time 1 If the employee returned to work after PA490 PA590
the incident, contains the start time. PA90.1
OSH-DATE-2 Numeric 8 (yyyymmdd) PA290 PA372
Element: Date 2 If the employee returned to work after PA490 PA590
the incident, contains the last date of PA90.1
the date range.
OSH-TIME-2 Numeric 6 (hhmmss) PA290 PA372
Element: Time 2 If the employee returned to work after PA490 PA590
the incident, contains the ending time. PA90.1
OSH-DATE-RETURNED Numeric 8 (yyyymmdd) PA290 PA372
Element: Date Returned Contains the date the employee returned PA490 PA590
to work after the incident. PA90.1
OSH-TIME-RETURNED Numeric 6 (hhmmss) PA290 PA372
Element: Time Returned Contains the time the employee returned PA490 PA590
to work after the incident. PA90.1
OSH-HOURS-FLAG Alpha 1 PA290 PA372
Element: Hours Flag Indicates whether the employee was PA490 PA590
absent from work due to the incident. PA90.1
N = No
Y = Yes
OSH-WORK-FLAG Alpha 1 PA290 PA372
Element: Work Flag Indicates whether the employee is able PA490 PA590
to perform other duties at work. PA90.1
N = No
Y = Yes
OSH-WAGES-FLAG Alpha 1 PA290 PA372
Element: Wages Flag Indicates whether the employee will PA490 PA590
earn reduced wages due to performing PA90.1
other work duties.
N = No
Y = Yes
OSH-DATE-STAMP Numeric 8 (yyyymmdd) PA290 PA372
Element: Date Stamp This field contains the server date PA490 PA590
(month, date, and year) of the last PA90.1 PA90.3
change to this record.
OSH-TIME-STAMP Numeric 6 (hhmmss) PA290 PA372
Element: Time Stamp Contains the server time (hour, minute, PA490 PA590
and second) when the record was last PA90.1 PA90.3
changed.
OSH-USER-ID Alpha 10 (Lower Case) PA290 PA372
Element: User PA490 PA590
PA90.1 PA90.3
OSH-SEVERITY Alpha 10 PA290 PA372
Element: Severity Contains the user-defined incident PA490 PA590
severity. PA90.1
OSH-USER-FIELD1 Alpha 30 PA290 PA372
Element: User Field1 This is the first user definable field. PA490 PA590
It can be used to capture any data that PA90.1
the user wants. The title of the field
is setup in IC00.
OSH-USER2 Alpha 10 PA290 PA372
Element: User2 Contains the second field of PA490 PA590
user-defined information. PA90.1
OSH-USER3 Alpha 10 PA290 PA372
Element: User3 Contains the third field of PA490 PA590
user-defined information. PA90.1
OSH-CURRENCY-CODE Alpha 5 PA290 PA372
Element: Currency Code Contains the currency in which the PA490 PA590
incident costs are recorded. PA90.1 PA90.3
OSH-CURR-ND Numeric 1 PA290 PA372
Element: Acct Nd The number of decimals assigned to a PA490 PA590
particular account as determined by the PA90.1 PA90.3
account currency.
OSH-COUNTRY-CODE Alpha 2 PA290 PA372
Element: Country Code Contains the country where the incident PA490 PA590
took place. PA90.1
OSH-BASE-CURRENCY Alpha 5 PA290 PA372
Element: Base Currency Contains the company base currency. PA490 PA590
PA90.1 PA90.3
OSH-BASE-ND Numeric 1 PA290 PA372
Element: Base Nd The number of decimal positions defined PA490 PA590
for the company base currency. PA90.1 PA90.3
OSH-BASE-AMOUNT Signed 15.2 PA290 PA372
Element: Base Amt Contains the incident costs in the PA490 PA590
company's base currency. PA90.1 PA90.3
OSH-INCIDENT-SITE Alpha 30 (Lower Case) PA290 PA372
Element: Incident Site PA490 PA590
PA90.1
OSH-REPORT-COMP-BY Numeric 9 PA290 PA372
Element: Report Comp By PA490 PA590
PA90.1
OSH-RPT-COMP-NAME Alpha 30 (Lower Case) PA290 PA372
Element: Rpt Comp Name PA490 PA590
PA90.1
OSH-RPT-COMP-DATE Numeric 8 (yyyymmdd) PA290 PA372
Element: Rpt Comp Date PA490 PA590
PA90.1
OSH-EMERGENCY-ROOM Alpha 1 PA290 PA372
Element: Emergency Room PA490 PA590
PA90.1
OSH-SHARP-DEVICE Alpha 10 PA290 PA372
Element: Sharp Device PA490 PA590
PA90.1
OSH-BRND-SHARP-DEV Alpha 10 PA290 PA372
Element: Brnd Sharp Dev PA490 PA590
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 PA290 PA372
ESTABLISHMENT PA490 PA590
SEQ-NBR* PA90.1 PA92.1
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
|
