Standard AQ - Active Assignment

Overview

Updated 11/17/2022

• Click here for information on Advanced Queries
• Click here for information on Standard Reports

Report Description
Parameters
Report Fields

Report Description

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

Parameters

Parameter Name	Options	Description
Branch (Assignment)	All available branches
Start Date (Assignment)
End Date (Assignment)
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).