Standard AQ - Comprehensive Assignment AQ

Overview

Updated 12/06/2022

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

Report Description
Parameters
Report Fields

Report Description

Shows a comprehensive list of information associated with an Assignment.

Parameters

Parameter Name	Options	Description
Branch (Assignment)	All available branches
Branch (Employee)	All available branches
Date Type	Assignment Date Entered, Assignment Start Date, Assignment End Date, Active	A description of the date entered.
Start Date
End Date
Customer name		Filters results by customer name.
Extra Value		Value list of all Assignment Extra. If Selected, the AQ will display the value of that particular extra.

Report Fields

Field Name	Description
EmployeeID	The unique ID assigned to the employee.
EmployeeName	Pulls employee name from the employee.
SSN	Pulls employee’s social security number from the employee.
EmployeeStatus	Pulls employee status from the employee.
PrimaryContact	Pulls employee’s primary contact info.
Employee Email	Pulls employee's email address [Contact method with SystemName='email']
IsW2	Indicates whether the assignment is a W2 or Non-W2 assignment.
Date of Birth	Pulls employee’s date of birth.
Gender	Pulls employee’s gender
CustomerName	Pulls Order/Assignments Customer Name.
DepartmentName	Pulls Order/Assignments Customer's Department Name
JobTitle	Pulls Order's Job Title
WCCode	Pulls Order's WC Code
OrderID	Pulls order ID from staffing order.
OrderType	Pulls order type from staffingorder.
OTPlan	Pulls OT Plan from Assignment.
AssignmentID	Pulls assignment ID from the assignment.
AssignmentType	A description of the assignment
MarkUp	Pulls markup name from the Order if Order has a markup.
Shift	Pulls shift name from assignment schedule.
PerformanceCode	The performance choice code associated with the assignment.
EndReason	The reason the assignment ended.
Original StartDate	Pulls min start date from assignment schedule.
EndDate	Pulls end date from most recent assignment schedule.
OrderStartDate	Pulls start date from the Order.
OrderEndDate	Pulls end date from the Order.
# Days on Assignment	Pulls Number of days the Assignment is/was Open.
RegPayRate	Pulls pay rate from assignment rate with pay code Reg.
RegBillRate	Pulls bill rate from assignment rate with pay code Reg.
Reg Hours	Pulls Reg hours associated with the assignment.
OTPayRate	Pulls pay rate from assignment rate with pay code OT.
OTBillRate	Pulls bill rate from assignment rate with pay code OT.
OT Hours	Pulls OT hours associated with the assignment.
DTPayRate	Pulls pay rate from assignment rate with pay code DT.
DTBillRate	Pulls bill rate from assignment rate with pay code DT.
DT Hours	Pulls DT hours associated with the assignment.
SalaryPayRate	Pulls pay rate from assignment rate with pay code Salary.
SalaryBillRate	Pulls pay rate from assignment rate with pay code Salary.
Salary Hours	Pulls Salary hours associated with the assignment.
RecruitingCall	Pulls most recent original start date time from staffing action which has action type Recruiting Call.
ReferenceCall	Pulls most recent original start date time from staffing action which has action type Reference Call.
ArrivalCall	Pulls most recent original start date time from staffing action which has action type Arrival Call.
SecondDayCall	Pulls most recent original start date time from staffing action which has action type SecondDay Call.
EndingCall	Pulls most recent original start date time from staffing action which has action type Ending Call.
EmployeeLastPaid	Pulls most recent check date received by the employee.
AssignmentLastPaidDate	Pulls the last check date associated with the assignment.
TotalBill	Pulls Total Bill amount of the Assignment.
TotalPay	Pulls Total Pay amount of the Assignment.
BillAmount	Total Bill Amount
GrossWages	Total Gross Wages
BillTotalHours	Bill Total Hours
PayTotalHours	Pay Total Hours
GrossProfit	Gross Profit
Referral Source	Pull Referral source from Interview section or extra section. (Interview section takes precedence over extra.
ResidentStreet1	Pulls Employee's home address Street1.
ResidentStreet2	Pulls Employee's home address Street2.
ResidentCity	Pulls Employee's home address City.
ResidentState	Pulls Employee's home address State.
ResidentZipCode	Pulls Employee's home address Zip Code.
WorksiteStreet1	Pulls staffing order’s work site address Street1.
WorksiteStreet2	Pulls staffing order’s work site address Street2.
WorksiteCity	Pulls staffing order’s work site address City.
WorksiteCounty	Pulls staffing order’s work site address County.
WorksiteState	Pulls staffing order’s work site address State.
WorksiteZipCode	Pulls staffing order’s work site address Zip Code.
Agency	Pulls agency name if Employee on the assignment is an Agency Employee.
Assignment Dates	Shows multiple columns for each Date types used on Assignments dynamically.
Assignment Users	Shows multiple columns for each User types used on Assignments dynamically.
Extra Value	Pulls a specific Extra value as selected in the Extra Value Parameter.
Assignment Branch
Bold Job ID
Bold Talent ID
Employee Branch
User: Account Manager
User: Entered By
User: Filled By
User: Sales Rep
User: Sourcer
User: Staffing Rep
Total Count	(Listed at the bottom of the AQ)