Standard Report - OSHA 300A

Overview

Updated 08/18/2022

Summarizes work-related injuries and illnesses.

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

CHAPTERS Required Setup Report Description Filters Report Fields

Required Setup

Pulls only those WcCaims which has date type as Injury Date in date section.  The Year ID filter pulls the date from the Injury Date/Time field.

Example

In the Administration Menu > Wc Claim

Report Description

Summarizes work-related injuries and illnesses.

Filters

Filter Name	Options	Explanation
Year
Branch (Assignment)
Claim Type	All Available WcClaim Type
Report Based On	Supplier, Branch, Customer
Root Customer Name		Filters result by root customer name
Root Customer ID		Filters result by root customer ID
Change_Reason
Roll Up To Root Customer	True and False

Report Fields

Field Name	Explanation
Year	Pulls the year of the parameter.
Establishment Name	If the parameter Report Based On is selected as "Supplier," the Establishment Name pulls the staffing supplier description. If the parameter Report Based On is selected as "Branch," the Establishment Name pulls site description. If the parameter Report Based On is selected as "Customer": If Roll Up To Root Customer is "True", Establishment Name pulls "root customer name". If Roll Up To Root Customer is "False", Establishment Name pulls "root customer name - customer department name".
Street	Address: Displays the addresses based on the parameter Report Based On (Supplier’s, Branch’s, Customer’s): Pulls Street 1
City	Address: Displays the addresses based on the parameter Report Based On (Supplier’s, Branch’s, Customer’s): Pulls City
State	Address: Displays the addresses based on the parameter Report Based On (Supplier’s, Branch’s, Customer’s): Pulls State
Zip	Address: Displays the addresses based on the parameter Report Based On (Supplier’s, Branch’s, Customer’s): Pulls Zip Code
Total number of deaths	Counts the number of WCClaims that have an 'Extra' value of "Death" with system name MostSeriousOutcome.
Total number of cases with days away from work	Counts the number of WCClaims that have an Extra with system name ‘No.oflostdays’. The Value must be numeric and cannot be 0.
Total number of cases with job transfer or restriction	Counts the number of WCClaims that have an 'Extra' value of "Job transfer or restriction" with system name ‘MostSeriousOutcome’.
Total number of other recordable cases	Counts the number of WCClaims that have an 'Extra' value of "Other Recordable Cases" with system name ‘MostSeriousOutcome’.
Total number of days away from work	SUM of Extra Value with Extra Label with system name ‘No.oflostdays’. The value of must be numeric.
Total number of days of job transfer or restriction	SUM of Extra Value with Extra Label with system name ‘No.ofonjobtransfer’. The value must be numeric.
NAICSCode	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’.
Injuries	Counts the number of WCClaims that have an 'Extra' value of "Injury" with system name ‘InjuryType’.
Skin disorders	Counts the number of WCClaims that have an 'Extra' value of "Skin Disorder" with system name ‘InjuryType’.
Respiratory conditions	Counts the number of WCClaims that have an 'Extra' value of "Respiratory Condition" with system name ‘InjuryType’.
Poisonings	Counts the number of WCClaims that have an 'Extra' value of "Poisoning" with system name ‘InjuryType’.
Hearing loss	Counts the number of WCClaims that have an 'Extra' value of "Hearing Loss" with system name ‘InjuryType’.
All other illnesses	Counts the number of WCClaims that have an 'Extra' value of "All Other Illnesses" with system name ‘InjuryType’.