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 HR700 HR704 PA372 PA590 PA90.1 PA90.3 PA115 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. 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 reprot 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-COUNTRY Alpha 30 Wit Country Contains the witness's country. OSH-WIT-CNTRY-CD Alpha 2 HR704 PA372 Wit Cntry Cd PA590 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 the address where the PA90.1 incident 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-COUNTRY Alpha 30 (Lower Case) Country or Other Contains the country where the 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 hosptitalized 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 retured 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 Contains the server date (month, date, PA90.1 PA90.3 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 HR700 PA372 Currency Code Contains the currency in which the PA590 PA90.1 incident costs are recorded. PA90.3 OSH-CURR-ND Numeric 1 HR700 PA372 Currency Number of Represents the number of decimals PA590 PA90.1 Decimals defined for the currency of the object. PA90.3 OSH-COUNTRY-CODE Alpha 2 HR704 PA372 Country Code Contains the country where the incident PA590 PA90.1 took place. OSH-BASE-CURRENCY Alpha 5 HR700 PA372 Base Currency Contains the company base currency. PA590 PA90.1 PA90.3 OSH-BASE-ND Numeric 1 HR700 PA372 Base Number Of The number of decimal positions defined PA590 PA90.1 Decimals for the company base currency. PA90.3 OSH-BASE-AMOUNT Signed 15.2 HR700 PA372 Base Amount Contains the incident costs in the PA590 PA90.1 company's base currency. PA90.3 OSHA FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN OSHSET1 COMPANY HOSH.1 HR700 EMPLOYEE HR704 HR90.1 ESTABLISHMENT PA115 PA149 SEQ-NBR PA248 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 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 |