Standard AQ - Job Order Metrics AQ

Report Description

This report is useful for tracking recruiter activity and determining the fill rate of active job orders.

 

Requirements

For dynamic columns, each client needs to set up different choice codes under Category = OrderTempCandidateStatus and Order_DHCandidateStatus

Parameters

Parameter Name	Options	Description
Branch (Order)	All available Suppliers	Filter for Staffing Order Branch
Start Date (Order Date Entered)		Filter for date entered at the beginning of the staffing order
End Date (Order Date Entered)		Filter for date entered at the end of the staffing order
Customer Name	All available branches.	Filter for customer's name
Order Type		Filter for Order Type

Report Fields

Field	Description
Branch Name	Staffing Order Branch
Customer Name	Customer Name from Staffing Order
Department Name	Department Name of Customer from Staffing Order
Order ID	Order ID
System Order Type	System Order Type (TE or DH)
Job Title	Job Title of Staffing Order
BoldJobID	An identifier for a Job in AviontéBOLD (Front Office)
Order Start Date	Order Start Date from Order Schedule
Order End Date	Order End Date from Order Schedule
Fee	Shows if DH fee is Flat Fee Type or Percent Type. If DH Fee Type = Percent Type, then Show a Value If DH Fee Type = Flat Type, then Show “Flat”
Fee Min	If DH Fee Type = Percent Type, then (Fee% / 100) * Minimum Pay Range from DH Order setup If DH Fee Type = Flat Type, then Show Flat Amount from DH Order setup
Fee Max	If DH Fee Type = Percent Type, then (Fee% / 100) * Maximum Pay Range from DH Order setup If DH Fee Type = Flat Type, then Show Flat Amount from DH Order setup
Pay Rate	Regular Pay Rate defined in Order
Bill Rate	Regular Bill Rate defined in Order
Contact	All contact persons related to the Order, shown in comma separated format
Required	Total number of employees required for Order
Placed	Total number of employees placed in the order
City	City of Work Site Address
State	State of Work Site Address
Order Status	Status of Order
Posted Date	Date on which order is posted to web
# Days Open	Report Run Date – Entered Date
# Candidates	Number of Candidates for Order
# Web Candidates	Number of Candidates for Order with Candidate Record Origin = Portal Entry
Order Entered Date	Entered Date from Staffing Order Date Type
Days Since Entered	Report Run Date – Entered Date
Customer Referral Source	Lead Source set in Customer Sales Info tab If there is number lead source setup in Customer Sales Info tab, then pull from Customer Extra Value, System Name = Source
Job Portal	List of all the Job Portals on which the Order is posted. Different Job portals are shown in comma separated format.
Except these fields, AQ returns many other dynamic columns that are based on the Candidate Status
	The column names will be as: #Applicant, #Assigned, #Client Interview, #Offered, #placed, etc. The data shown in these columns will be number, which represents the Number of candidates with respective Candidate Status
Except these fields, AQ returns many other dynamic columns that are based on the Order Users
	The column names will be as: Entered By, Staffing Rep, Sales Rep, etc.