OSHA 300A Feed

Overview

Updated 10/17/2022

Click on the links below for more information: OSHA 300 Standard Report OSHA 300 A Standard Report List of Standard Reports List of Advanced Queries (AQs) Add a new Worker Comp Claim

CHAPTERS Report Description Filters Report Fields

Report Description

This is a Feed that gets exported to a CSV file.

The Feed will be exported to a CSV file:

Filters

	Filter Name	Options	Explanation
	Year
	Branch (Assignment)	List of all available Branches
	Claims Type	All, Incident, and Reportable
	Based on	Supplier, Branch, and Customer
	Root Customer Name		Filters result by root customer name
	Root Customer ID		Filters result by root customer ID
	Change Reason (Optional)
	Roll Up to Root Customer	Yes or No

Report Fields

Field Name	Explanation
establishment_name	If the parameterReport Based Onis selected as "Supplier," theEstablishment Namepulls the staffing supplier description. If the parameterReport Based Onis selected as "Branch," theEstablishmentNamepulls site description. If the parameterReport Based On is selected as "Customer": If Roll Up To Root Customer is "True",Establishment Namepulls "root customer name". If Roll Up To Root Customer is "False",Establishment Namepulls "root customer name - customer department name".
ein
company_name
street_address	Address: Displays the addresses based on the parameterReport Based On(Supplier’s, Branch’s, Customer’s): Pulls Street 1
city	Address: Displays the addresses based on the parameterReport Based On(Supplier’s, Branch’s, Customer’s): Pulls City
state	Address: Displays the addresses based on the parameterReport Based On(Supplier’s, Branch’s, Customer’s): Pulls State
zip	Address: Displays the addresses based on the parameterReport Based On(Supplier’s, Branch’s, Customer’s): Pulls Zip Code
naics_code	If parameter Report Based On is selected as Supplier, NAICSCode pulls value of staffing supplier property 'OSHA NAICS Code' If parameter Report Based On is selected as Branch, NAICSCode pulls value of staffing supplier site property 'OSHA NAICS Code' If parameter Report Based On is selected as Customer, NAICSCode pulls customer extra value for system name ‘NAICSCode’.
industry_description
size
establishment_type
year_filing_for	Pulls the year of the parameter.
annual_average_employees
total_hours_worked
no_injuries_illnesses
total_deaths	Counts the number of WCClaims that have an 'Extra' value of "Death" with system nameMostSeriousOutcome.
total_dafw_cases	Counts the number of WCClaims that have an Extra with system name ‘No.oflostdays’. The Value must be numeric and cannot be 0.
total_djtr_cases	Counts the number of WCClaims that have an 'Extra' value of "Job transfer or restriction" with system name ‘MostSeriousOutcome’.
total_other_cases	Counts the number of WCClaims that have an 'Extra' value of "Other Recordable Cases" with system name ‘MostSeriousOutcome’.
total_dafw_days	SUM of Extra Value with Extra Label with system name ‘No.oflostdays’. The value of must be numeric.
total_djtr_days	SUM of Extra Value with Extra Label with system name ‘No.ofonjobtransfer’. The value must be numeric.
total_injuries	Counts the number of WCClaims that have an 'Extra' value of "Injury" with system name ‘InjuryType’.
total_skin_disorders	Counts the number of WCClaims that have an 'Extra' value of "Skin Disorder" with system name ‘InjuryType’.
total_respiratory_conditions	Counts the number of WCClaims that have an 'Extra' value of "Respiratory Condition" with system name ‘InjuryType’.
total_poisonings	Counts the number of WCClaims that have an 'Extra' value of "Poisoning" with system name ‘InjuryType’.
total_hearing_loss	Counts the number of WCClaims that have an 'Extra' value of "Hearing Loss" with system name ‘InjuryType’.
total_other_illnesses	Counts the number of WCClaims that have an 'Extra' value of "All Other Illnesses" with system name ‘InjuryType’.
change_reason