Standard AQ - Comprehensive Assignment AQ

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.
Worksite State	Multi-list dropdown for all US States	Filters the worksite states for the Order

Report Fields

Field Name	Description
Date of Birth	Date of Birth Pulls employee’s date of birth. This field only appears if you have the User permission to view the Employee EEO details
Gender	Pulls employee’s gender This field only appears if you have the User permission to view the Employee EEO details
EmployeeBranch	Pulls the branch name of the Employee
EmployeeID	The unique ID assigned to the employee.
BoldTalentID	An identifier for a Talent in AviontéBOLD (Front Office)
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.
BoldCompanyID	An identifier for a Company in AviontéBOLD (Front Office)
CustomerID	Pulls Customer ID
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.
BoldJobID	An identifier for a Job in AviontéBOLD (Front Office)
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.
AssignmentBranch	Pulls Branch name from assignment
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.
Extra Value	Pulls a specific Extra value as selected in the Extra Value Parameter.
User: <User Type>	Pulls name of the User associating with the Assignment (<User Type> displays the dynamic value for user type) For e.g.: User: Account Manager, User: Staffing Rep etc.
Dates: <Date Type>	Pulls date value associating with the Assignment (<Date Type>) displays the dynamic value for Date Type For e.g.: Dates: Entered Date, Dates: Start Date etc.
Total Count	(Listed at the bottom of the AQ)

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