Active Consultants Report

Overview

Updated 09/29/2022

• Click here to go to the Operational Category (list of Standard Reports)

Click on the links below for more information: List of Standard Reports List of BOLD Analyze Reports List of INSIGHTS Dashboards List of Business Intelligence (BI) Reports

CHAPTERS Legend Locating the Report Logic Filter Options Field Details Using the Data     Screenshot

Legend

Locating the Report

1. Click on Analyze Tab
   The Reports Sub Tab will automatically be selected
2. In the Search Reports field, type ACTIVE CONSULTANTS
3. Click on the Active Consultants Report

Logic

The Active Contractor report provides users with an overview of all active contractor placements.  To see a report of all placements, including permanent positions, view the “Hiring Stats” report within the “Operational” folder.

View consultants that are actively working on jobs along with details such as: Job, company, manager, bill/pay rate and time approver.

• Click here to go to the Operational Category (list of Standard Reports)

Filter Options

	Filter Name	Options	Explanation
	Division	All available Employers	Filters Job's Employers Note: not every account will have divisions enabled
	Region	All available Regions	Filters Job's Regions
	Office	All available Branches	Filters Job's Branches
	Company	All available Companies	Filters Job's Companies
	Client Rep	All available Sales Reps	Filters Job's Sales Rep
	Contractor Rep	All available Recruiter Reps	Filters Placement's Recruiter Rep
	Extensions	All, Active	Include extensions or only show Active
	Date From		Start Date of Placement's Extensions falling under the date range
	Date To		End Date of Placement's Extensions falling under the date range
	Date Range	Yesterday, Today, Tomorrow, ...	When 'Date Range' is selected, 'Date From' and 'Date To' will be automatically disabled. The user will need to select either 'Date Range' or enter 'Date From' and 'Date To'.

Field Details

• Click here to go to the Operational Category (list of Standard Reports)

Field Name	Description	Notes
Office	Job's Branch
Requisition ID	Job ID (ID in the URL)
Requisition	Job/Requisition ID
Job Title	Job's Internal Title
Contract Type	System Job's Type (Contract, Permanent, Contract to Perm, ...)
Division	Job's Division Name Note: not every account will have divisions enabled
Department	Hiring Manager's Department Name
Applicant	Talent's Name
Email	Talent's primary email
Email2	Talent's 2nd email
Phone Number	Talent's phone number
Manager	Hiring Manager's Name
Company	Company's Name
Start Date	Placement Extension's Start Date
End Date	Placement Extension's End Date
Bill Rate	Placement Extension's Reg Bill Rate
Pay Rate	Placement Extension's Reg Pay Rate
Client Rep	Job's Sales Rep
Contractor Rep	Placement Extension's Recruiter Rep (Hired Details)
Job Owner
Talent Source
Company ID	Company's ID
Applicant ID	Talent's ID
Employment Type	Placement Extension's Employment Type (W-2, 1099, ...)
Tax Type	Job's Tax type (W-2, 1099, ...)
Time Approver 1	Name of Time Approver from Placement Extension
Approver Email 1	Email Address of Time Approver
Time Approver 2	Name of 2nd Time Approver from Placement Extension
Approver Email 2	Email Address of 2nd Time Approver
Time Approver 3	Name of 3rd Time Approver from Placement Extension
Approver Email 3	Email Address of 3rd Time Approver
Nomination Source	The Nomination Source when they are nominated
Bill Name	Company's Billing Name
Bill Addr1	Company's Billing Address 1
Bill Addr2	Company's Billing Address 2
Bill City	Company's Billing City
Bill State	Company's Billing State
Bill Zip	Company's Billing Zip Code
Bill Phone	Company's Billing Phone number
App Addr1	Talent's Address 1
App Addr2	Talent's Address 2
App City	Talent's City
App State	Talent's State
App Zip	Talent's Zip code
WC Code	Job's Worker's Comp Code
Job State	Job's State
Rate Type	Job's Rate Type (Hourly, Daily, ...)
OT Type	Placement Extension's Overtime (Paid and Billed, Paid and Not Billed, ...)
VMS Fee	Placement Extension's VMS Fee %
Mark up (%)	Placement Extension's Mark-Up % (Hired Details)
Commission User 1	Commission User from Placement Extension
Commission Type 1	Commission User Type from Placement Extension
Commission Percent 1	Commission % from Placement Extension
Commission User Office 1	Commission User's Office for the Job
Commission User 2	2nd Commission User from Placement Extension
Commission Type 2	2nd Commission User Type from Placement Extension
Commission Percent 2	2nd Commission % from Placement Extension
Commission User Office 2	2nd Commission User's Office for the Job
Commission User 3	3rd Commission User from Placement Extension
Commission Type 3	3rd Commission User Type from Placement Extension
Commission Percent 3	3rd Commission % from Placement Extension
Commission User Office 3	3rd Commission User's Office for the Job
Commission User 4	4th Commission User from Placement Extension
Commission Type 4	4th Commission User Type from Placement Extension
Commission Percent 4	4th Commission % from Placement Extension
Commission User Office 4	4th Commission User's Office for the Job
Corp Name	Company Name (Corp or 1099)
Corp Addr1	Company Address1 (Corp or 1099)
Corp Addr2	Company Address2 (Corp or 1099)
Corp City	Company City (Corp or 1099)
Corp State	Company State (Corp or 1099)
Corp Zip	Company Zip (Corp or 1099)
Corp Phone	Company Phone # (Corp or 1099)
Notes	Placement Extension's Notes (Hired Details)
OT Bill Rate	Placement Extension's Overtime Bill
OT Pay Rate	Placement Extension's Overtime Pay
DT Bill Rate	Placement Extension's Doubletime Bill
DT Pay Rate	Placement Extension's Doubletime Pay
Hourly Margin	Placement Extension's Hourly Margin (Hired Details)
Entered Placement	Hiring Authority (User who entered the Placement)
End Reason	Placement Extension's End Reason
Talent Status	Talent's Status
Hired Date	Placement Extension's Hired Date Note: this is just for internal use and does not apply to the candidate’s “Start Date”
Placement Branch	Placement Extension's Branch
Applicant Tags	Talent's Tags
OT Rule	Job's Overtime Rule (Federal OT, Lower Bill OT, ...)
Custom Job Details	Name and Value from Job's Custom Job Details
File Number/Payroll ID	File Number from Applicant's users
Bill Email	Company's Billing email
Company Office	Job's Company Office
Adjusted Bill Rate	Calculation: Bill Rate - (Bill Rate * (VMS Deduct/100))
Job Office

Using the Data

To get deeper insights into this report, you can narrow down the list of companies with active placements.  This can come in handy when you want to see how many placements your larger clients have.

Conversely, you can deselect companies from the “Company” filter.  This can be helpful if you use Avionte for your internal recruiting as you can hide hires to your company and eliminate any false positives.

Screenshot

(right-click and select "Open Image in New Tab" to view a larger image)