OSHA 300A Injury & Illness
OSHA_300Afree10 data-quality rules for OSHA Form 300A injury and illness summary data submitted electronically to OSHA (ITA). Covers required establishment identification, valid NAICS, non-negative case and day counts, total-cases reconciliation, employee/hours plausibility, reporting year, and duplicate suppression. Use it to validate the 300A before ITA submission.
Checks included (10)
Case Counts Are Non-Negative(total_cases)
Total cases and case-type counts cannot be negative.
Day Counts Are Non-Negative(total_days_away)
Days away from work and days of restriction/transfer cannot be negative.
Total Hours Worked Is Positive(total_hours_worked)
Total hours worked by all employees must be greater than zero; it is the denominator for incidence rates.
Average Employees Is Non-Negative(average_employees)
Annual average number of employees cannot be negative.
Required Establishment Fields Present
Each summary must identify the establishment name, EIN, NAICS, and reporting year.
Reporting Year Present(reporting_year)
The summary must specify the calendar reporting year.
Total Cases Equals Sum of Case Types
Total cases must equal the sum of deaths, days-away cases, job-transfer/ restriction cases, and other recordable cases.
Days-Away Days Require Days-Away Cases
If days away from work are reported, there must be at least one days-away case.
NAICS Code Is Valid
The establishment NAICS code must be a valid 6-digit NAICS industry code.
One Summary per Establishment per Year(establishment_year_key)
Each establishment should submit one 300A summary per reporting year.