Standard AQ - WC Cost by Claim Type

Report Description

Details how WC (Worker's Compensation) claims affect gross profit. This report is useful for determining the financial impact that a single or group of WC claims had on your company and is easy to sort as an advanced query.

Parameters

Parameter Name	Options	Description
Branch	All available branches.	WcClaim’s Branch.
As Of Date		Filters for the WcClaims till “As of Date” entered
Claim Status	ALL, Closed, Open	Choice codes present in WcClaim Claim Status
Claim Number		Filters results by Claim Number.
Customer Name		Filters results by Customer Name.
Employee Name		Filters results by Employee Name.

Report Fields

Field Name	Description
CustomerName	Customer Name associated with Worker Compensation Claim.
ClaimNumber	Claim Number of Worker Compensation Claim filed.
ClaimEnteredDate	Claim Entered Date of Worker Compensation Claim.
WcCode	Worker comp code associated with Worker Compensation Claim.
EmployeeName	Name of Employee associated with Worker Compensation Claim.
BoldTalentID	Identifier for employee in AvointéBOLD (Front Office)
ClaimStatus	Status of the Worker Compensation Claim filed.
StaffingCompany	Supplier associated with Worker Compensation Claim filed.
BoldCompanyID	The identifier for the related company in AviontéBOLD (Front Office)
BranchName	WcClaim Branch.
JobOrderID	Order ID associated with WcClaim.
Jobtitle	Job Tile associated with WcClaim.
TotalBillAmount	Life time to Date Bill Amount.
GrossProfitBeforeWCCost	Sum of Gross profit from transactions till As of Date parameter.
GrossProfitAfterWCCost	(Total Gross Profit Before Wc Cost) – (Total WcClaim Cost) , Where Total WcClaim cost = Total WcClaim Cost present in “NetIncurred” choicecode of  category “WcClaimCostType” for a particular WcClaim.
YTDCustomerBillAmount	Year To Date Bill Amount.
BodyParts	Name of the Body Parts affected.
	If the client has set up the choice codes for category “WcClaimCostType”, and if any of these choice codes are present in WcClaimCost  for a particular WcClaim then each of these choice codes are displayed after the “BodyParts” column along with the amounts associated with these choice codes. For e.g: Medical, Transportation, Wages etc.