Standard AQ - Turnover AQ

Required Setup

This report requires mapping: Mapping Reports and Advanced Queries

• All end reasons should be inserted into mapping. Client must designate which of their End Reasons are Negative and which are positive.

Report Description

Details turnover rates for both positive and negative end reasons. (This report shows turnover rates broken out into rates of positive and negative turnover as mapped to the assignment end reasons to give you a better sense of how your employees are performing on assignments)

Parameters

Parameter Name	Options	Description
Start Date ( Order Entered Date )
End Date (Order Entered Date )
Customer Name		Filters results by Customer name.
Order Type	All Choice codes present for category of Temp and DH Orders

Report Fields

Field Name	Description
Branch	Customer’s Branch
CustomerID	Customer ID from Staffing Order.
CustomerName	Customer Name from Staffing Order.
DepartmentName	Department Name from Staffing Order.
StaffingOrderID	StaffingOrder ID
OrderType	Order Type of Staffing Order.
OrderStatus	Status of Staffing Order.
OrderScheduleStatus	OrderSchedule’s Status.
Jobtitle	Skill Code from Staffing Order.(For Temp orders) Job Title from StaffingOrderDH.(For DH Orders)
BoldJobID	An identifier for a Job in AviontéBOLD (Front Office)
ShiftName	Shift Name from staffing order’s schedule.
RegPayRate	Pay Rate of “Reg” Pay Code from Staffing Order
RegBillRate	Bill Rate of “Reg” Pay Code from Staffing Order
Required	Number of Required from Staffing Order
Placed	Number of Placed from Staffing Order
AssignmentsEnded	Total count of Ended Assignment associated with Staffing Order.
EndReasonNegative	Count of all employees who ended an assignment on the particular staffing order for a "Negative End Reason"
EndReasonPositive	Count of all employees who ended an assignment on the particular staffing order for a "Positive End Reason"
TurnoverPercent	Ratio of AssignmentEnded to the Required of the staffing order. Formula = (AssignmentEnded / Required ) * 100
NegativeTurnoverPercent	Ratio of EndReasonNegative to the AssignmentEnded of the staffing order. Formula = (EndReasonNegative / AssignmentEnded ) * 100
PositiveTurnoverPercent	Ratio of EndReasonPositive to the AssignmentEnded of the staffing order. Formula = (EndReasonPositive / AssignmentEnded ) * 100
AverageAssignmentLength(Days)	Average days worked in multiple assignments of a particular Staffing order. Formula: Total No. of Days Worked in all assignments of a staffing order /Count of all assignments present in a staffing order.
UserType	User Types present in staffing order is displayed as columns which displays the username. For Example:  If in a particular staffing order, John Doe is an Account Manager, then the column “Account Manager” is displayed after the column  “AverageAssignmentLength(Days)” which shows username John Doe. *This column displays only when there are user types present in the staffing order. If none of the orders have any user type present, then in such case no specific user type is displayed.
BoldCompanyID	An identifier for the Company in AviontéBOLD (Front Office)