Standard Report - OSHA 300A – Avionte Classic

Overview

Updated 07/14/2021

Report Description

Summarizes work-related injuries and illnesses.

Parameters

Parameter 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, 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’.

Required Setup

Pulls only those WcCaims which has date type as “Injury Date” in date section.

Back to Top