Submit a ticket

Standard Report - OSHA Form 300

Updated on Follow
0 out of 0 found this helpful

Report Description

Log of work-related injuries and illnesses.

OSHA_300.png

 

 

 

Parameters

Parameter Name

Options

Explanation

Year

 

 

Branch (Assignment)

 

 

Claim Type

 All Available WcClaim Type

 

Report Based On

 Supplier, Branch, Customer

 

Root Customer Name

 

Filters results 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 parameter Report Based On is selected as Supplier, Establishment Name pulls staffing supplier description.

If parameter Report Based On is selected as Branch, Establishment Name pulls site description.

In case of parameter Report Based On 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".

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.

Case No.

Shows WCclaimID from WCClaim.

Employee Name

Pulls employee name from employee table.

Job Title

Pulls Assignments' Job Title.

 

Date of Injury

or Onset

of illness

 

Puls date from date type “Injury Date” with the category of “WcClaimDate”.

 

Where the event occurred

Pulls AccidentDescription from WCClaim.

 

Describe the injury or illness, parts of body affected, and object/substance that directly or made person ill

 

Pulls all body parts injuries + notes in comma separate from WcClaimBodyPartInjured.

Death

Shows as checked if the extra value for systemname “MostSeriousOutcome” has been set up in WcClaim extra section.

Days away from work

Shows as checked if the extra value for systemname  “MostSeriousOutcome” has been set up in WcClaim extra section and extra value is “Days Away from Work”.

Job Transfer or restriction

 

Shows as checked if extra  value for systemname  “MostSeriousOutcome” has been set up in WcClaim extra section and extra value is "Job Transfer or Restriction"

Other recordable cases

Show as checked if the extra value for systemname “MostSeriousOutcome” has been set up in WcClaim extra section and extra value is  "Other Recordable Cases".

Away from work

Shows extra value if the extra value for systemname  “No.oflostdays” has been set up in WcClaim extra section.

On job transfer or restriction

Shows extra value if the extra value for systemname  “No.ofOnJobTransfer” has been set up in WcClaim extra section.

Injury

 

Shows as checked if the extra value for systemname  “InjuryType” has been set up in WcClaim extra section and extra value is “Injury”.

Skin Disorder

Shows as checked if the extra value for systemname  “InjuryType” has been set up in WcClaim extra section and extra value is “Skin Disorder”.

Respiratory

condition

Shows as checked if the extra value for systemname  “InjuryType” has been set up in WcClaim extra section and extra value is “Respiratory Condition”.

Poisoning

Shows as checked if the extra value for systemname  “InjuryType” has been set up in WcClaim extra section and extra value is “Poisoning”.

Hearing Loss

Shows as checked if the extra value for systemname  “InjuryType” has been set up in WcClaim extra section and extra value is “Hearing Loss”.

All other illness

Shows as checked if the extra value for systemname  “InjuryType” has been set up in WcClaim extra section and extra value is “All Other Illnesses”.

 

 

 

 

 

Required Setup

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.