Submit a ticket

Standard AQ - Comprehensive Order

Updated on Follow
0 out of 0 found this helpful

 

Report Description

Shows a comprehensive list of information associated with a Customer.

Comprehensive_Order_AQ.PNG

 

 

 

Parameters

Parameter Name

Options

Description

Branch (Order)

All available branches

Branch of Orders.

Date Type

Date Entered,First Invoice Date,Last Invoice Date,Invoice Date

 

Start Date

 

 

End Date

 

 

Order Status

All available Order Status for both Temp and DH Orders

 

Order Type

All available Order Status for both Temp and DH Orders

 

Customer Name

 

Filters results by Customer name

Extra Value

 

Value list of all Order Extra. If Selected, the AQ will display the value of that particular extra.

 

 

 

Report Fields

Field Name

Description

OrderID

Unique number assigned to the order

OrderEnteredDate

The date the order was entered into the application

Customer Name

The name of the customer requesting the order

Department Name 

The specific department in which the order was placed

Main Address

The customer's main address

OrderType

The type of order (Clerical Temp Order(Temp), Direct(Temp), etc.)

OrderStatus

The status of the order (Completed (Temp), Deleted (Temp), etc.)

OrderScheduleStatus

The status of the order's schedule.

JobTitle

The position title for the order.

PositionDescription

A description of the order's position.

Branch

Order's Branch

WCCode

The worker's comp code for the position.

RegPayRate

The regular hourly pay rate for the position. 

RegBillRate

The regular hourly Bill rate for the position. 

OTPayRate

The overtime pay rate for the position. 

OTBillRate

The overtime bill rate for the position.

DTPayRate

The double-time pay rate for the position.

DTBillRate

The double-time bill rate for the position.

SalaryPayRate

The pay rate measured annually.
SalaryBillRate The Bill rate measured annually.

MarkUp

The profit increase on the order.

PayPeriod

The pay period associated with the order.

OTPlan

The overtime plan selected for the order.

StartDate

The start date of the order.

EndDate

The end date of the order.

Required

The number of employees required to fulfill the order.

Placed

The current number of employees assigned to the order.

FillRatio

The number of positions filled (placed vs. required) expressed in a ratio.

FillRatioPercent

The number of positions filled (placed vs. required) expressed in a percentage.

Fill Rate (Hours)

The number of hours needed to fill the order. 

IsPostedToWeb

Indicates whether the job is posted on a job board.

Posted To Avionte Job Board

Indicates whether the job is posted to Avionte job board.

Posted To CareerBuilder

Indicates if the Order is posted to Career Builder

Posted To DataFrenzy

Indicates if the Order is posted to Data Frenzy

ShiftName

The name of the work shift (first, second, etc.)

WorkSiteAddress

The address of the order's work site.

Worksite County

County associated with the Worksite Address

ReferralSource

The source of the order referral.

ReferralDetail

A description about the order's referral.

PONumber

The purchase order number assigned to the order.

RecordOrigin

The origin where the order record was created. 

RecordType

The type of record associated with the order.

Discount

Identifies any payment discounts applied to the order.

SalaryRange

Salary range for the order.

SalaryRangeMin

The minimum of the order's salary range. 

SalaryRangeMax

The maximum of the order's salary range.

FeeType

The type of fee collected by the staffing agency for the order (percentage, flat, etc.)

Fee

The dollar amount collected by the staffing agency for the order.

FeeMin

The minimum dollar amount that will be paid for the order.

FeeMax

The maximum dollar amount that will be paid for the order.

FeePercent

The percentage of the total order that goes to the fee.

InvoicedAmount

The dollar amount invoiced to the customer.

YetToBeBilledAmount

The dollar amount yet to be billed to the customer.

Career Builder Candidate Total

Number of Candidates from Career Builder

Career Builder Candidate Parsed

Number of Candidates added/parsed as an Order Candidate from Career Builder

Career Builder Candidate Removed

Number of Candidates removed from Career Builder

Data Frenzy Candidate Total

Number of Candidates from Data Frenzy

Data Frenzy Candidate Parsed

Number of Candidates added/parsed as an Order Candidate from Data Frenzy
Data Frenzy Candidate Removed Number of Candidates removed from Data Frenzy
Order Candidates Shows multiple columns for each Order Candidate Status with Count of Employee for each Status dynamically.
Order Dates Shows multiple columns for each Order Dates Type dynamically.
Order Users Shows multiple columns for each Order User types dynamically.
Extra Value Pulls a specific Extra value as selected in the Extra Value Parameter. 

 

** Need to set up following Config ChoiceCodes: MainCategory = CustomerOrderExtra, SystemName = Source

 

** Need to set up following Config ChoiceCodes: MainCategory = CustomerOrderExtra, SystemName = SourceDetail


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.