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