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. |
Comments
0 commentsPlease sign in to leave a comment.