Standard AQ - Comprehensive Order

Report Description

Shows a comprehensive list of information associated with a Customer.

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.
AutoUpdateOrderStatus	Auto Update Order Status (from Order>Detail>More Info screen)
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.
Extra Value	Pulls a specific Extra value as selected in the Extra Value Parameter.
BoldJobID	An identifier for a Job in AviontéBOLD (Front Office)
CustomerID	Pulls Customer ID from the order
BoldCompanyID	An identifier for a Company in AviontéBOLD (Front Office)
Sales Tax	Name of the Tax based on the Customer's Address
User <User Type>	Pulls name of the User associating with the Order (<User Type> displays the dynamic value for user type) For e.g.: User: Account Manager, User: Staffing Rep etc.
Date <Date Type>	Pulls date value associating with the Order (<Date Type>) displays the dynamic value for Date Type For e.g.: Dates: Entered Date, Dates: Start Date etc.

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