Standard AQ - Comprehensive Assignment AQ

Report Description

Shows a comprehensive list of information associated with an Assignment.

Comprehensive_Assignment_AQ.PNG

 

 

Parameters

mceclip0.png

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

mceclip1.png

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)

 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.