Standard AQ - Sick Leave

This report provides a detailed overview of employee assignment and accrual plan information. It includes both general assignment data and accrual plan summaries, with the option to display results in two formats: detailed (Show Summary = No) or summarized (Show Summary = Yes).

Parameters

Parameter Name	Options
Accrual Plan	List of all active Accrual plans having descriptions starting with Sick Leave_
Customer Name	Free Text field (can be used to filter records per Employee name)
Employee Name	Free Text field (can be used to filter records per Customer name)
Show Summary	Yes or No

Report Fields

Show Summary = No

Field	Description
ActionItem	Action Description
EmployeeID	Employee's Identifier
EmployeeName	Employee's Name
CustomerName	Customer's Name
DepartmentName	Customer's Department Name
OrderID	Order Identifier
AssignmentID	Assigment's Identifier
AssignmentStartDate	Assignment's Start Date
AssignmentStillActive	Displays  1 if the assignment is still active
EmployeeOnAssignment	Displays 1 if the Employee is on an assignment
WorksiteCity	Worksite address (City) of the associated order
WorksiteState	Worksite address (State) of the associated order
WorksiteCounty	Worksite address (County) of the associated order
WorksiteGeoCode	Worksite address (Geocode) of the associated order
RegHours	Total Sum of Reg hours
OTHours	Total Sum of OT hours
DTHours	Total Sum of DT hours
OtherHours	Total Sum of Other hours  (except Reg, OT, DT)
TotalHours	Total Sum of  hours worked
CalcDaysWorked	Total Hours Worked / 8
DaysWorked	No of Days Worked (is calculated differently depending on if daily pay is used. If it does, the total number of days is entered. If it is weekly pay, it default to using 5 days instead)
TotalPay	Sum of Total Pay
TotalBill	Sum of Total Bill
GrossProfit	Gross Profit Amount
LastCheckDate	Date on which the employee received their last paycheck (Excludes the paycheck associated with an Order for which the city is Excluded)
DayGapSinceLastCheckDate	Days between the last check date and the current date. (If the employee has not yet received a check, it will show the days between the assignment start date and the current date.)
ActionItem	Action Description
AccrualPlan	Name of the Accrual Plan
HasActiveAccrualPlan	Shows 1 if the aacrual plan is currently active
AccrualPlanStartDate	Start Date of the Accrual Plan
AccrualPlanYearlyDate	Date the accrual plan is set to be renewed
AccrualCurrentBalance	Current Balance of the Accrual Plan
AccrualPlanTotalHours	Sum of Reg, OT, DT and Other Hours per Accrual Plan

Show Summary = Yes

Field	Description
EmployeeID	Employee's Identifier
EmployeeName	Employee's Name
EmployeeOnAssignment	Displays 1 if the Employee is on a assignment
WorksiteCity	Employee's Worksite address (City)
WorksiteState	Employee's Worksite address (State)
WorksiteCounty	Employee's Worksite address (County)
WorksiteGeoCode	Employee's Worksite address (Geocode)
ActionItem	Action Description
AccrualPlanTotalHours	Sum of Reg, OT, DT and Other plans per Accrual Plan
AccrualPlan	Name of the Accrual Plan
HasActiveAccrualPlan	Shows 1 if the aacrual plan is currently active
AccrualPlanStartDate	Start Date of the Accrual Plan
AccrualPlanYearlyDate	Date the accrual plan is set to be renewed
AccrualCurrentBalance	Current Balance of the Accrual Plan
AssignmentStartDate	First Assignment Start Date for Each Accrual Plan by Worksite Address
RegHours	Sum of Reg hours for Each Accrual Plan by Worksite Address
OTHours	Sum of OT hours for Each Accrual Plan by Worksite Address
DTHours	Sum of DT hours for Each Accrual Plan by Worksite Address
OtherHours	Sum of Other hours (except Reg, OT, DT) for Each Accrual Plan by Worksite Address
TotalHours	Total Sum of  hours worked for Each Accrual Plan by Worksite Address
CalcDaysWorked	Total Hours Worked / 8
DaysWorked	No of Days Worked (is calculated differently depending on if daily pay is used. If it does, the total number of days is entered. If it is weekly pay, it default to using 5 days instead)
TotalPay	Sum of Total Pay for Each Accrual Plan by Worksite Address
TotalBill	Sum of Total Bill for Each Accrual Plan by Worksite Address
GrossProfit	Gross Profit Amount for Each Accrual Plan by Worksite Address
LastCheckDate	Date on which the employee received their last paycheck for Each Accrual Plan by Worksite Address (Excludes the paycheck associated with an Order for which the city is Excluded)
DayGapSinceLastCheckDate	Days between the last check date and the current date. (If the employee has not yet received a check, it will show the days between the assignment start date and the current date.)