Submit a ticket

Standard AQ - Comprehensive Assignment

Updated on Follow
0 out of 0 found this helpful

Report Description

Shows a comprehensive list of information associated with an Assignment.

Comprehensive_Assignment_AQ.PNG

 

 

 

Parameters

Parameter Name

Options

Description

Branch

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.

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.

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.

Branch

Pulls site name from the 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.

OrderEndDate

Pulls end date from the Order.

# Days on Assignment

Pulls Number of days the Assignment is/was Open.

Reg Hours

Pulls Reg hours associated with the assignment.

RegPayRate

Pulls pay rate from assignment rate with pay code Reg.

RegBillRate

Pulls bill rate from assignment rate with pay code Reg.

OT Hours

Pulls OT 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.

DT Hours

Pulls DT 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.

Salary Hours

Pulls Salary 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.

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.

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.

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. 

 

 

 


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.