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
UPDATED BY
PA372 PA590 PA90.1 PA90.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSH-COMPANY Numeric 4 PA372 PA590
Company Contains the company number that PA90.1
represents an established company.
OSH-EMPLOYEE Numeric 9 PA372 PA590
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
Sequence Number Sequence number. PA90.1
OSH-DATE Numeric 8 (yyyymmdd) PA372 PA590
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
Description This field contains the description of PA90.1
the illness or injury.
OSH-JOB-CODE Alpha 9 PA372 PA590
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
Process Level This field contains the employee's PA90.1
process level or the process level where
the incident occurred.
OSH-DEPARTMENT Alpha 5 PA372 PA590
Department This field contains the employee's PA90.1
department or the department where the
incident occurred.
OSH-AGE Numeric 2 PA372 PA590
Age This field contains the employee's age PA90.1
when the incident occurred.
OSH-SEX Alpha 1 PA372 PA590
Gender Employee's gender when incident PA90.1
occurred.
F = Female
M = Male
OSH-PHY-LST-NAME Alpha 15 (Lower Case) PA372 PA590
Physician Last Name This field contains the physician's PA90.1
last name.
OSH-PHY-FST-NAME Alpha 14 (Lower Case) PA372 PA590
Physician First Name This 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
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
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
Location This field contains the location of the PA90.1
incident. The location must be valid
in PCODES.
OSH-SHIFT Numeric 1 PA372 PA590
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
Affected Body Part 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
Days Out This field contains the number of days PA90.1
away from work.
OSH-DAYS-REST Numeric 3 PA372 PA590
Days Restricted This field contains the number of days PA90.1
restricted from certain types of work.
OSH-ILLNESS-TYPE Alpha 2 PA372 PA590
Illness Type This field contains the type of illness. PA90.1
DU = Dust Disease of the Lungs
O = All Other Occupational Illness
P = Poisoning
PA = Disorder From Physical Agent
RE = Respiratory Due to Toxins
SK = Skin Disease or Disorder
TR = Disorder from Repeated Trauma
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
Osha Flag Reserved for future development.
N = No
Y = Yes
OSH-INCIDENT Alpha 10 PA372 PA590
Incident Contains user-defined incident PA90.1
information.
OSH-ILLNESS Alpha 10 PA372 PA590
Illness Contains user-defined illness PA90.1
information.
OSH-FULL-NAME Derived
Full Name Reserved for future development.
OSH-ESTABLISHMENT Alpha 10 PA372 PA590
Establishment Contains the establishment where PA90.1
incident occurred.
OSH-INCID-STATUS Alpha 10 PA372 PA590
Incid Status Contains the user-defined incident PA90.1
status.
OSH-OUTCOME Alpha 10 PA372 PA590
Outcome Contains the user-defined incident PA90.1
outcome.
OSH-COST Signed 11.2 PA372 PA590
Cost Contains the incident cost. PA90.1 PA90.3
OSH-INCID-CAT Alpha 10 PA372 PA590
Incid Cat Contains the user-defined incident PA90.1
category.
OSH-WC-CLAIM Alpha 15 PA372 PA590
Wc Claim Contains the workers compensation claim PA90.1
number.
OSH-GOVT-FLAG Alpha 1 PA372 PA590
Govt Flag Indicates whether case must be reported PA90.1
to the government.
Y = Yes
N = No
OSH-GOVT-CASE Numeric 8 PA372 PA590
Govt Case Contains the government case number. PA90.1
OSH-PRIOR-ESTAB Alpha 10 PA372 PA590
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
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
Body Part Cd Contains the user-defined body part PA90.1
that was injured by the incident.
OSH-REPORTS-TO Numeric 9 PA372 PA590
Reports To Contains the employee to whom the PA90.1
incident was reported.
OSH-REPORT-TO-NAME Alpha 30 (Lower Case) PA372 PA590
Report To Name Contains the employee or individual to PA90.1
whom the incident was reported.
OSH-REPORTS-BY Numeric 9 PA372 PA590
Reports By Contains the employee who reported the PA90.1
incident.
OSH-REPORT-BY-NAME Alpha 30 (Lower Case) PA372 PA590
Report By Name Contains the employee or individual who PA90.1
reported the incident.
OSH-WITNESS Numeric 9 PA372 PA590
Witness Contains the employee who witnessed the PA90.1
incident.
OSH-WIT-NAME Alpha 30 (Lower Case) PA372 PA590
Wit Name Contains the employee or individual who PA90.1
witnessed the incident.
OSH-WIT-ADDR1 Alpha 30 (Lower Case) PA372 PA590
Wit Addr1 Contains the first line of the PA90.1
witness's address.
OSH-WIT-CITY Alpha 18 (Lower Case) PA372 PA590
Wit City Contains the witness's city. PA90.1
OSH-WIT-STATE Alpha 2 PA372 PA590
Wit State Contains the witness's state. PA90.1
OSH-WIT-ZIP Alpha 10 PA372 PA590
Wit Zip Contains the witness's postal code. PA90.1
OSH-WIT-CNTRY-CD Alpha 2 PA372 PA590
Wit Cntry Cd PA90.1
OSH-WIT-PHN-CNTRY Alpha 6 PA372 PA590
Wit Phn Cntry Contains the witness's telephone PA90.1
country code.
OSH-WIT-PHONE-NBR Alpha 15 PA372 PA590
Wit Phone Nbr Contains the witness's telephone number. PA90.1
OSH-WIT-PHONE-EXT Alpha 5 PA372 PA590
Wit Phone Ext Contains the witness's telephone PA90.1
extension.
OSH-EMP-STATUS Alpha 2 PA372 PA590
Employee Status Contains 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
Supervisor Emp Contains the supervisor to whom the PA90.1
employee reported when the incident
occurred.
OSH-SUP-NAME Alpha 30 (Lower Case) PA372 PA590
Supervisor's Name Contains the name of the supervisor to PA90.1
whom the employee reported when the
incident occurred.
OSH-ADDR1 Alpha 30 (Lower Case) PA372 PA590
Address 1 Contains the address where the incident PA90.1
took place.
OSH-CITY Alpha 18 (Lower Case) PA372 PA590
City Contains the city where the incident PA90.1
took place.
OSH-STATE Alpha 2 PA372 PA590
State or Province Contains the state where the incident PA90.1
took place.
OSH-ZIP Alpha 10 PA372 PA590
Postal Code Contains the postal code where the PA90.1
incident took place.
OSH-FIRST-AID-BY Numeric 9 PA372 PA590
First Aid By Contains the employee who provided PA90.1
first aid.
OSH-FIRST-AID-NAME Alpha 30 (Lower Case) PA372 PA590
First Aid Name Contains the employee or individual who PA90.1
provided first aid.
OSH-PHYSICIAN Alpha 10 PA372 PA590
Physician Contains the physician who treated the PA90.1
employee.
OSH-PATIENT-FLAG Alpha 1 PA372 PA590
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
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
Time Start Wk Contains the employee's normal work PA90.1
start time.
OSH-TIME-END-WK Numeric 6 (hhmmss) PA372 PA590
Time End Wk Contains the employee's normal work PA90.1
stop time.
OSH-DATE-INJURY Numeric 8 (yyyymmdd) PA372 PA590
Date Injury Contains the date the incident took PA90.1
place.
OSH-TIME-INJURY Numeric 6 (hhmmss) PA372 PA590
Time Injury Contains the time the incident took PA90.1
place.
OSH-DATE-LAST-WORK Numeric 8 (yyyymmdd) PA372 PA590
Date Last Work Contains the last date the employee PA90.1
worked after the incident.
OSH-TIME-LAST-WORK Numeric 6 (hhmmss) PA372 PA590
Time Last Work Contains the last time the employee PA90.1
worked after the incident.
OSH-DATE-OUT Numeric 8 (yyyymmdd) PA372 PA590
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
Date Notified1 Contains the date the employer was PA90.1
notified of the incident.
OSH-TIME-NOTIFIED1 Numeric 6 (hhmmss) PA372 PA590
Time Notified1 Contains the time the employer was PA90.1
notified of the incident.
OSH-DATE-NOTIFIED2 Numeric 8 (yyyymmdd) PA372 PA590
Date Notified2 Contains the date the employer was PA90.1
notified of lost time.
OSH-TIME-NOTIFIED2 Numeric 6 (hhmmss) PA372 PA590
Time Notified2 Contains the time the employer was PA90.1
notified of lost time.
OSH-DATE-1 Numeric 8 (yyyymmdd) PA372 PA590
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
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
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
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
Date Returned Contains the date the employee returned PA90.1
to work after the incident.
OSH-TIME-RETURNED Numeric 6 (hhmmss) PA372 PA590
Time Returned Contains the time the employee returned PA90.1
to work after the incident.
OSH-HOURS-FLAG Alpha 1 PA372 PA590
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
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
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
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
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
User ID Name Contains the user ID of the person who PA90.1 PA90.3
last changed this record.
OSH-SEVERITY Alpha 10 PA372 PA590
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
User2 Contains the second field of PA90.1
user-defined information.
OSH-USER3 Alpha 10 PA372 PA590
User3 Contains the third field of PA90.1
user-defined information.
OSH-CURRENCY-CODE Alpha 5 PA372 PA590
Currency Code Contains the currency in which the PA90.1 PA90.3
incident costs are recorded.
OSH-CURR-ND Numeric 1 PA372 PA590
Currency Number of Represents the number of decimals PA90.1 PA90.3
Decimals defined for the currency of the object.
OSH-COUNTRY-CODE Alpha 2 PA372 PA590
Country Code Contains the country where the incident PA90.1
took place.
OSH-BASE-CURRENCY Alpha 5 PA372 PA590
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
Base Amount Contains the incident costs in the PA90.1 PA90.3
company's base currency.
OSHA FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSHSET1 COMPANY HOSH.1 HR90.1
EMPLOYEE PA149 PA248
ESTABLISHMENT PA249 PA290
SEQ-NBR 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
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 PCODES Required
When (OSH-ESTABLISHMENT != Spaces )
"ET" -> PCO-TYPE
OSH-ESTABLISHMENT -> PCO-CODE
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
Spaces -> 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
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
|
