Standard AQ - Employee Fair Workweek

Report Description

This AQ helps to track employees who have worked a specific amount of hours for specific industries located on a specific worksite, city, and state.

Parameters

Parameter Name	Options
Branch (Employee)	All available branches.
Date Type	Accounting Period Date, Check Date, Invoice Date, Week Worked
Start Date	Calendar drop-down picker
End Date	Calendar drop-down picker
Employee Status	ALL, Active, Applicant, Deleted, DNA, DNU, Inactive, Incomplete Applicant, On-line Applicant, Pending, Rejected, Resume Parsed
Employee ID	You can enter one to search for or return all
Customer Name	You can enter one to search for or return all
Customer ID	You can enter one to search for or return all
Worksite State	Any state in the US
Worksite City	You can enter one to search for or return all
Total hours >=	You can enter a value or leave as 0 You can enter a value or leave as 0. Used to filter the employees who has greater than or equals to the value passed.

Report Fields

Field Name	Description
EmployeeName	Name of the Employee
EmployeeID	Employee’s Identification Number
Branch	Branch’s Name
IndustryCode	Name of Industry (For e.g. Retail, Service etc.)
IsW2	If yes, Employee is an W2 type Employee
TotalHours	Total Sum of hours worked
RegHours	Total Sum of Reg hours
OTHours	Total Sum of OT hours
PayRate	Pay Rate
GrossPay	Total sum of Grosswages amount
NetPay	Total sum of Netpay amount (where NetPay is calculated as PayPercentageOfTransaction * NetAmount)