Standard AQ - Active Assignment

Report Description

The Assignment AQ displays all employees that are assigned to an active assignment.

The report includes any assignment that was active at any point during the date range you enter. An assignment appears in results if:

• Its Start Date falls on or before the end of your date range
• Its End Date falls on or after the start of your date range, or it has no end date (meaning the assignment is still open)

For example, if you run the report for 01/01/2026 through 03/30/2026: an assignment that started 12/01/2025 and ended 01/15/2026 would appear, as it was active during part of that range. An assignment that ended 12/31/2025 would not.

Parameters

Parameter Name	Options	Description
Branch (Assignment)	All available branches
Start Date (Assignment)		Start of the date range.
End Date (Assignment)		End of the date range.
Customer Name		Filters results by Customer Name.
Employee Type	All available Employee Type

Report Fields

Field Name	Description
StaffingCompany	Assignment Supplier.
Branch	Assignment Branch.
CustomerID	Customer ID from Order.
BoldCustomerID	Customer ID from the front end (BOLD).
CustomerName	Customer Name from Order.
DepartmentName	Customer Department Name.
WorkSite Street 1	Order Work Site Street 1
WorkSite Street 2	Order Work Site Street 2
WorkSite City	Order Work Site City
WorkSite State	Order Work Site State
WorkSite ZipCode	Order Work Site Zip Code
EmployeeID	Employee ID from Assignment.
EmployeeName	Employee Name.
BoldTalentID	Employee ID from AviontéBOLD (Front Office).
SSN	Employee SSN.
Street1	Street1 from Employee Primary Address.
Street2	Street2 from Employee Primary Address.
City	City from Employee Primary Address.
State	State from Employee Primary Address.
Zipcode	Zip Code from Employee Primary Address.
PrimaryContactMethod	Contact Method Value from Employee Primary Contact Method.
Email	Employee Email address.
AssignmentType	Assignment Type of Assignment.
AssignmentID	Assignment ID of Assignment.
JobTitle	Job Title of Order.
JobDescription	Job Description of Order.
OrderType	Order Type of Order.
PerformanceCode	Assignment Performance.
OriginalStartDate	Assignments first start date.
StartDate	Assignment Start Date.
EndDate	Assignment End Date.
EndReason	Assignment End Reason.
PayRate	Reg paycode Pay Rate from active assignment schedule.
BillRate	Reg paycode Bill Rate from active assignment schedule.
OTPayRate	OT paycode Pay Rate from active assignment schedule.
OTBillRate	OT paycode Bill Rate from active assignment schedule.
SalaryPayRate	Salary paycode Pay Rate from active assignment schedule.
SalaryBillRate	Salary paycode Bill Rate from active assignment schedule.
DHFee	Assignment DH Order Fee. The column value will pull if the Assignment’s Order is DH Order.
Last Paid Date	Assignment last check date. Find the List of checks which are linked with transaction related to the Assignment. The Last Paid Date is the maximum check date value among the checks related to the assignment.
BoldCompanyID	Company ID from AviontéBOLD (Front Office).