Avionté provides a set of standard advanced queries through Main Menu > Reports. To access an Advanced Query not displayed through the Reports menu, contact your company's Avionté Super User or Avionté Technical Services.
Note: Some reports may not be available with older versions of Avionté.
The Standard Advanced Queries in this article are grouped by the type of user (e.g., front office users, back office users, admin users) who may find that particular report most useful.
| On This Page | |
Report Tools and Exporting AQs Video
Front Office User Advanced Queries
| Name | Description | Parameters | Fields / Configuration Settings | Why is this AQ useful? |
|---|---|---|---|---|
| Active Assignment Missing Hours AQ | Displays all active assignments with missing hours. | Branch (Assignment), Accounting Period Date, Customer Name, Assignment ID, Time Entered/Unentered | Staffing Company, Branch Name, Assignment ID, Employee ID, Employee Name, Customer Name, Department Name, Employee Primary Contact, Employee Home Phone, Employee Cell, Employee Email, Week Worked, Start Date, End Date, Time Entered Method, Pay Unit, Bill Unit | Useful for rectifying assignments with missing hours; the user can take the data and make corrections if necessary. |
| Assignment AQ | Shows all employees assigned to an active assignment. | Branch (Assignment), Start Date, End Date, Customer Name, Employee Type | Staffing Company, Branch, Customer Name, Department Name, Employee ID, Employee Name, SSN, Street 1, Street 2, City, State, Zip Code, IsW2, Primary Contact Method, Email, Agency Name, Assignment Type, Assignment ID, Job Title, Job Description, Order Type, Performance Code, Original Start Date, Start Date, End Date, End Reason, Pay Rate, Bill Rate, OT Pay Rate, OT Bill Rate, Salary Pay Rate, Salary Bill Rate, DH Fee, Last Paid Date | Useful when auditing new placements, cross-checking assignment end dates, and reviewing current active assignments. |
| Audit AQ | Lists changes to specific tables within the application. | Start Date (Audit Date Modified), End Date (Audit Date Modified), User Name, Table Name, Column Name | Audit Type, Table Name, Column Name, Old Value, New Value, Date Modified, User Name, User Description | Lists all changes made to any table, including the prior value, change date, and the user who made the change. |
| Birthday AQ | Lists employee birthday information by month and branch. | Branch (Employee), Employee Month, Show Customer Detail (Yes, No) | Staffing Company, Branch, Employee ID, Employee Name, Employee Status, On Assignment (Checkbox), Birthday, Employee Address, Phone, Email, Customer Name, Department Name | Useful for verifying employee age for assignments or sending birthday cards. |
| Client Evaluation Results AQ | Lists results from client surveys. | Customer Name, Evaluation Name, Question, Start Date, End Date | Questions from client evaluation. | Compiles client evaluation information in an easy-to-read, compact format. |
| Config Choice AQ | Lists all property values for each branch for each choice code in the system. | Branch, Category, Active | Staffing Supplier Desc, Branch Name, Category Name, Choice Code, Choice Code Description, Property, Value, Is Active, Config Choice ID, Date Entered | Useful for quickly reviewing property values set for each branch. |
| Customer Attendance Roster AQ | Details weekly attendance of employees at assignments by customer. | Branch, Assignment, Attendance Code (All, A, NA), Customer Name, Start Date (Attendance Date), End Date (Attendance Date) | Staffing Company, Branch, Customer Name, Department Name, Employee Name, SSN, Date Worked, Day, Entry, Week End Day, Week End Date | Shows a brief snapshot of employee attendance and the customer they are assigned to. |
| Employee eDocument Info AQ | Details eDocument status for each employee. | Branch (Employee), Employee Status, eDocument, eDocument Status, Include Employee with Missing eDocs? (Yes, No) | Employee Branch, Employee ID, Employee Name, Employee Status, On Assignment, Primary Contact Method, Employee Date Entered, Employee Entered By, eDocument Type, eDocument Status, Active, Verified, eDocument Submitted Date, eDocument Completed Date, eDocument Expiration Date, eDocument Missing | Good summary of employees with missing and submitted eDocuments. |
| Employee Adobe e-Signature Document Info AQ | Lists all completed Adobe e-Signature documents. | Branch (Employee), Employee Status, e-Signature Document, Include Employee with Missing Document? (Yes, No) | Employee Branch, Employee ID, Employee Name, Employee Status, On Assignment, Primary Contact Method, Employee Date Entered, Employee Entered By, e-Signature Template Name, e-Signature Completed Date | Good summary of an employee's missing and completed Adobe e-Signature templates. |
| Employee Certification AQ | Lists all available assigned or missing certifications for the employee between a selected date, assignment, hire, or paycheck date. | Branch (Employee), Date Type, Start Date, End Date, Employee Status, Certification, Missing Certifications | Staffing Company, Branch, Employee ID, Employee Name, On Assignment, Primary Contact, Employee Status, Last Paycheck Date, First Paycheck Date, Certification Type, Certification Issuing Authority, Certification Number, Certification Issue Date, Certification Expiration Date, Certification Validation Date, Certification Note, Missing Certification | |
| Employee Document Info AQ | Details document status for each employee. | Branch (Employee), Date Type, Start Date, End Date, Employee Status, Document Type, Employee with Missing Docs | Employee Branch, Employee ID, Employee Name, Employee Status, On Assignment, Primary Contact Method, Employee Date Entered, Document Type, Note, File Name, Document Entered By, File Type, Expiration Date, Date Entered, Document Missing, Last Paycheck Date, User: Entered By, User: Interviewed By, User: Recruiter | Good summary of employees with missing and submitted documents. |
| Employee Overview AQ | Allows you to search for all employee education, skills, requirements, past jobs, certifications, documents, and eDocuments — including employees missing any of this information. | SSN, Search Type, Branch, Start Date/End Date, Employee Status, Employee Missing [must match exactly with the choice code] | Branch Name, Employee ID, SSN, Last Name, First Name, Employee Status, Primary Contact, Email, Full Address, On Assignment, and other fields depending on the Search Type selected. | Allows searching for employees missing certain information such as I-9 certification or specific requirements. |
| Employee Missing Certification AQ | Lists missing employee certifications. | Branch (Employee), Certification List, On Assignment? | Branch Name, Employee ID, Employee Name, SSN, On Assignment?, Address 1, Address 2, City, State, Zip Code | Shows all employees missing specific certifications. |
| Employee Missing Requirement AQ | Lists employees missing requirements. | Branch (Employee), Requirement List, On Assignment? | Staffing Company, Branch Name, Employee ID, Employee Name, SSN, On Assignment?, Address 1, Address 2, City, State, Zip Code | Shows all employees missing specific requirements. |
| Employee W2 Info | Displays all W2 fields in Excel format. | Supplier / Year, Branch (Employee), Employee Status, Address Type, Order By | Pulls all the fields that appear on the W2 form. | Shows all W2 information in Excel format for easier review and verification. |
| Ending Assignment List AQ | List of employees with ending assignments. | Branch (Assignment), Start Date (Assignment End Date), End Date (Assignment End Date) | Staffing Company, Site Name, Assignment ID, Employee ID, Employee Name, Customer Name, Department, Job Title, Start Date, End Date, Bill Rate, Pay Rate, Performance, End Reason, Employee Main Contact Method, Last Date Paid, Total Hours Worked, # Days on Assignment | Details ending assignments during a specified time period, including end reason and employee contact information. |
| Everify Case AQ | Details employees' E-Verify statuses. | Employee Branch, Everify Requested Date (From), Everify Requested Date (To) | Group Name, Group Description, Created by User Name, Created by User Description, Contact Branch, Last Name, First Name, Street 1, City, State, Zip Code, Authorized to Work, Sent By User | Allows searching for E-Verify completion status for all employees by submission date. |
| Job Order Metrics AQ | Shows all job order information. | Branch (Order), Start Date (Order Date Entered), End Date (Order Date Entered), Customer Name, Staffing Specialist, Order Type | Branch Name, Customer Name, Department Name, Order ID, Order Type, System Order Type, Job Title, Order Start Date, Order End Date, Fee, Fee Min, Fee Max, Pay Rate, Bill Rate, Contact, Required, Placed, City, State, Order Status | Useful for tracking recruiter activity and determining the fill rate of active job orders. |
| Message Activities AQ | Shows messages and activities for each employee, customer, and contact. | Date Type, Start Date, End Date, Entered By, Action Type, Customer Name | StaffingCompany, BranchName, ActionType, MessageType, Subject, Message, DATE, EnteredbyUser, EmployeeName, CustomerName, ContactName, LinkUsers, IsComplete, Order ID, Assignment ID, Agency Name, WCClaim ID, Unemployment ID, Is Aero Activities, Is System Generated | Shows messages and activities for employees, customers, or contacts in a specific date range. |
| Order Posted to Web AQ | Shows orders posted to the web. | Branch (Order), Order Type, Customer Name, Start Date (Date Posted), End Date (Date Posted), Show Active Only (Yes, No) | Staffing Company, Branch, Customer ID, Customer Name, Department Name, Staffing Order ID, Job Title, Order Type, Order Status, WC Code, Shift Name, Job Portal, Date Posted, Is Active?, Required, Placed, Start Date, End Date, Pay Rate, Bill Rate, Order Candidates | Useful for tracking online activity and the implications on job order postings. |
| Prove It! AQ | Tracks Prove It! tests sent, submitted, and expired. | Branch (Employee), Date Type (Date Sent, Date Completed, Date Expired), Start Date, End Date | Branch, Employee ID, Employee Name, Status, Email, Primary Contact Method, On Assignment, Test Name, Sent Date, Expire Date, Complete Date, Score, Score %, Percentile, Sent By | Useful for searching results of a specific Prove It test, determining completion status, or filtering by score cutoff. |
| Referral Source AQ | Lists referral information for customers and employees. | Start Date (Entered Date), End Date (Entered Date), Branch, Entity (Employee, Customer) | Employee: Employee Branch, Employee ID, Employee Name, Referral Source, Date Entered, Employee Origin, Assigned, Active Order Count, Customer Name, Department Name, Job Title; Customer: Customer ID, Customer Name, Department Name, Source, Source Detail, Customer Branch, Date Entered, Has Active Order, Active Order Count. Requires Extra label with SystemName = Source under EmployeeExtra and CustomerOrderExtra. Config ChoiceCodes: MainCategory = EmployeeExtra or EmployeeInterview, SystemName = Source. | Useful for determining referral source for later action (e.g., sourcing payment) or measuring referral success. |
| Skill Code AQ | Provides a list of skill codes and their status. | Branch, Category, Is Active, Is Job Position, Is Skill, Is Web Visible | StaffingSupplier, Branch, Category, Skill Code, Skill Code Description, IsActive, IsJobPosition, IsWebVisible, IsSkill | Lists skill codes along with their active, web-visible, job position, and skill status. |
| Staffing Action AQ | Staffing message search report. | Branch (User), Date Type (Entered Date, Start Date, End Date), Start Date, End Date, Entered By, Is Complete, Action Type, Customer Name | Staffing Company, Branch Name, Action Type, Message Type, Subject, Message, Date, Entered By User, Employee Name, Customer Name, Contact Name, Link Users, Is Complete, Order ID, Assignment ID, Agency Name, WC Claim ID, Unemployment ID | Useful for tracking recruiter activity and finding specific messages. |
| Staffing Action Archive AQ | Searches Staffing message records archived by the Aged Data Maintainer. | Branch (User), Date Type (Entered Date, Start Date, End Date), Start Date, End Date, Entered By, Is Complete, Action Type, Customer Name | Staffing Company, Branch Name, Action Type, Message Type, Subject, Message, Date, Entered By User, Employee Name, Customer Name, Contact Name, Link Users, Is Complete, Order ID, Assignment ID, Agency Name, WC Claim ID, Unemployment ID | Same as the Staffing Action AQ but references archive tables. The Aged Data Maintainer moves messages, tasks, and appointments older than 5 years to archive to prevent table bloat. |
Back Office User Advanced Queries
| Name | Description | Parameters | Fields / Configuration Settings | Why is this AQ useful? |
|---|---|---|---|---|
| 401K Census AQ | Gives details of 401K deduction and contribution for employees. | Branch (Employee), Start Date (Check Date), End Date, Show Summary, 401K Deductions List, 401K Contributions List | Staffing Supplier Desc, Branch, Employee ID, Last Name, First Name, Middle Name, SSN, Gender, Street1, Street2, City, State, Zip, Date of Birth, Date of Hire, Status, Date of Termination, Phone, Email, Check Number, Check Date, Accounting Period Date, Hours, Wages, Deduction Amount, Deduction Amount YTD, Deduction Amount LTD, Contribution Amount, Contribution Amount YTD, Contribution Amount LTD | Helpful for reviewing and reporting 401K deductions and contribution census. |
| AR Aging As Of AQ | Details AR days sales outstanding. | Branch Invoice, As of Date, Aging Date Type (Accounting Period Date, Due Date), Customer Name, Root Customer ID, Roll up to Parent Customer (True/False) | StaffingCompany, BranchName, CustomerID, CustomerName, DepartmentName, InvoiceNumber, InvoiceDate, DueDate, AccountingPeriodDate, InvoiceAmount, FinanceCharge, BalanceAmount, PaymentAmount, Current_Age, Age_1_30, Age_31_60, Age_61_90, Age_Over_90, PaymentTerms, DSO, PhoneNumber, CreditLimit, HighLimit, LastPaymentDate, LastCustomerPaymentDate, AccountManager, CreditHoldCode | Useful for reviewing accounts receivable and tracking AR status for a specific date. |
| AR Aging DSO AQ | Details AR days sales outstanding. | Branch, Customer Name, Date Type (Accounting Period Date, Invoice Date), Start Date, End Date | Branch, Customer Name, Department Name, Invoice Amount, Balance Amount, Total Payment Amount, DSO, No of Days (within a specified time period) | Useful for reviewing accounts receivable and tracking the AR status of customers. |
| AR Batch ID AQ | Lists AR by Batch ID. | Date Type (Accounting Period Date, Date Posted), Start Date, End Date, Branch (Invoice), Customer Name, AR Batch ID | Staffing Company, Branch Name, AR Batch ID, AR Batch Type, Customer Name, Invoice #, Check #, Payment Amount, Payment Applied, Reason Code, Posted By, Date Posted, Accounting Period Date | Useful for reviewing accounts receivable information by Batch ID. |
| Billing by Work State AQ | Shows billing totals by work state. | Date Type (Accounting Period, Invoice Date), Start Date, End Date, Branch (Invoice) | State, State Description, Total Bill | Breaks down billing totals by state. |
| California Labor Contractor Report | Provide this report to customers; they will determine if they need to submit the required information to California. | Supplier, Branch, Date Type, Start Date, End Date, Transaction Type, Ignore "Missing Info" Errors?, Customer ID, Show Employee Detail, Include Child Departments | Establishment Name, Address Line 1, Address Line 2, City, State, ZIP Code, NAICS Code, Major Activity, Employee ID, Employee First Name, Employee Middle Name, Employee Last Name, Total Number of Employees at Establishment, Was a California Pay Data Report filed last year?, Was an EEO-1 Report filed last year?, Is this the employer's headquarters?, Labor Contractor, Labor Contractor FEIN, Snapshot Start/End Date, Job Category, Race/Ethnicity/Sex, Pay Band, Number of Employees, Mean Hourly Rate, Median Hourly Rate, Total Hours, Row-Level Clarifying Remarks | |
| California Pay Data Report | Required for private employers of at least 100 employees to file a Payroll Employee Report for the prior calendar year. | Supplier, Branch, Date Type, Start Date, End Date, Transaction Type, Ignore "Missing Info" Errors?, Employee Detail | Establishment Name, Address, City, State, ZIP Code, NAICS Code, Major Activity, Employee ID, Employee First/Middle/Last Name, Total Number of Employees, Various EEO-1 fields, Job Category, Race/Ethnicity/Sex, Pay Band, Number of Employees, Mean/Median Hourly Rate, Total Hours, Row-Level Clarifying Remarks | |
| Check Register AQ | Shows information similar to that on paychecks. | Branch (Payment Check), Date Type (Check Date, Accounting Period Date, ACH Generated Date, Positive Pay Generated Date), Start Date, End Date, SSN Ends with, Show Earnings Details (Yes, No), Show Deductions Details (Yes, No), Show Benefits Details (Yes, No) | Staffing Company, Branch, Check Date, Accounting Period Date, ACH Generated Date and Time, Positive Pay Generated Date and Time, PrenoteSentDate, PrenoteApproveDate, Date Cleared, Check Number, Check Delivery, Employee ID, Agency ID, Payee Name, SSN, Gross Amount, Total EE Taxes, Total Deductions, Total Benefits, Net Amount, Is W2, Is Direct Deposit, Federal Tax, States, State WH, FICAEE, MEDEE, LOCALEE, SUIEE, SDIEE, FICAER, MEDER, SUIER, SDIER, FUTAER, and dynamic Earnings/Deductions/Benefits fields | Good resource to cross-check with payroll before submission. |
| Cincinnati Local Tax Details AQ | Details Cincinnati local tax information. | Supplier, Start Date (Check Date), End Date (Check Date), SSN, Result Type (Detail, Summary) | Employee ID, Last Name, First Name, Middle Name, SSN, Check Number, Check Date, Cinci Taxable, Cinci Tax Calc Full, Work Site Tax Withheld, Cinci Tax Calc Reduced, Cinci Tax Actual Withheld | Provides a detailed breakdown of all local Cincinnati taxes. |
| Cleared Paychecks by Date AQ | Lists cleared paychecks during a specific time period. | Start Date (Date Cleared), End Date (Date Cleared), Payment Date, Payment Bank, Branch (Paycheck) | Branch, Payee, SSN, Check #, Check Date, Net Amount, Date Cleared, Payment Bank ID, Bank Name, Description, Is Direct Deposit, Is W2, Gross Amount, Accounting Period Date | Useful for determining which disbursed paychecks have been deposited in the event of a payroll error. |
| Commission Split AQ | Shows a breakdown by employee with total pay and bill hours, amounts, commission %, and gross profit. | Branch, Date Type, Start Date, End Date, Order Type, Customer Name | BranchName, CustomerName, DepartmentName, OrderType, WcCode, EmployeeName, AccountingPeriodDate, WeekWorked, PayTotalHours, BillTotalHours, BillAmount, DHFee, GPAdjBill, DiscountAmount, GrossWages, NonAdjCost, GPAdjPay, AgencyCost, EmployerTaxes, WorkerComp, GPAdjCost, BurdenAmount, EmployerContributions, GrossProfit, GrossProfitPerBilledHour, GP%, User, UserType, CommissionPercent, CommissionGP | Displays financial details per employee and assignment. |
| Department of Labor AQ | Lists number of employees and their hours. | Date Type (Accounting Period Date, Week Worked), Start Date, End Date | Branch, Count of Employees, Gross Wages, Reg Hours, OT Hours, DT Hours, Total Hours | Good summary of the number of employees by branch and total hours worked. |
| Discount Usage AQ | Lists the dollar amounts associated with discount types. | Branch (Transaction), Date Type (Accounting Period Date, Week Worked), Start Date, End Date, Show Details (Yes, No) | Staffing Company, Branch Name, Accounting Period Date, Week Worked, Invoice Number, Customer Name, Transaction Type, Department Name, Discount Name, Bill Amount, Discount Amount | Shows transactions that have discount amounts associated with them. |
| Employee Direct Deposit AQ | Details employee direct deposit information. | Branch (Employee), Employee Name, Show Inactive (True, False) | Branch, Employee ID, First Name, Middle Name, Last Name, Status, On Assignment, Bank Name, Routing Number, Account Number, Amount Value, Amount Type, Bank Account Type, Sequence, Last Check Date, Is Active | Good summary of employee direct deposit information. |
| Employee Pay Detail per Pay Code AQ | Shows all pay details for each employee. | Branch (Employee), Date Type (Accounting Period Date, Check Date), Start Date, End Date, Tax Type | Show Type = Employee: Staffing Company, Employee Name, Employee ID, SSN, Employee Status, Primary Contact Method, On Assignment?, Employee Address, plus dynamic Pay Code fields; Show Type = Customer: adds Customer Name, Customer ID, Department Name | Breaks down an employee's pay by pay code in detail. |
| Employee Payroll Tax Detail with Pretax AQ | Shows all pay details for each employee. | Branch (Employee), Start Date, End Date, Tax Type, Date Type (Accounting Period Date, Check Date) | Staffing Supplier Description, Employee Branch, Employee ID, Employee Name, On Assignment, US Withholding Type, Tax Name, Gross Wages, Subject Gross, Taxable Gross, Tax Amount, 401k Deductions, Sect125 Deductions | Shows a detailed breakdown of employee taxes with pretax deduction types and amounts. |
| Employee Tax Info AQ | Lists all tax information for each employee. | Branch (Employee), Employee Status | Employee Branch, Employee ID, Employee Name, Employee Status, On Assignment?, US Withholding Type, Tax Type, Tax Name, Active, Tax Filing Status, Exemption, Dependent, Add WH, Is Tax Exempt?, NR_CERT, Fixed Percentage, Exemption Amount, Last Check Date | Breaks down each employee's tax withholding amounts and shows tax-exempt employees. Useful for detailed employee tax information and filing statuses. |
|
Federal EEO Reporting AQ Requires mapping |
Lists equal opportunity information for employees. | Supplier, Date Type (Week Worked, Accounting Period Date), Start Date, End Date, Show Employee Info (Yes, No), Branch (Employee), Exclude DH Orders (Yes, No) | Job Category, employee counts of Race and Gender by Job Category. Displays Disability and Veteran status when Show Employee Info = Yes. Requires mapping: Mapping Reports and Advanced Queries | Makes federal reporting of EEO information simple and easy. |
| Federal EEO Component 2 Reporting AQ | Lists equal opportunity information for employees, including wage and hour data. | Supplier, Branch, Date Type, Start Date, End Date, Status Code, Unit Number, User ID, Question B2C, Question D2, Show Employee Info, Transaction Types, Exclude DH Orders, Ignore Missing Info Errors | Same parameters as above. Requires mapping: Mapping Reports and Advanced Queries | Makes federal reporting of EEO information simple and easy. |
| Future Payroll/Billing AQ | Branch (Transaction), SSN, Customer Name, Future Type | StaffingSupplierDesc, TransactionBranch, AccountingPeriodDate, WeekWorked, TimeEntryBatchID, TransactionID, CustomerID, BillToName, DepartmentName, EmployeeID, SSN, EmployeeName, IsW2, StaffingOrderID, AssignmentID, AssignmentStartDate, AssignmentEndDate, CheckAccountingPeriodDate, CheckDate, CheckNumber, CheckBranch, IsDirectDeposit, InvoiceAccountingPeriodDate, InvoiceDate, InvoiceNumber, InvoiceBranch, PayCode, PayUnit, PayRate, ItemPay, BillUnit, BillRate, ItemBill, CostUnit, CostRate, ItemCost, AgencyName, EmployerContribution, RTPay, OTPay, DTPay, RTBill, OTBill, DTBill, OrderType, WcCode, WcCodeRate, JobPosition, PONumber | ||
| Get Employee Fed W2 AQ | Gives details of employee federal wages. | Supplier, Year, SSN, Data Source (Avionté, Compare, Greenshades), Return Type (Results, Summary), Sort By (Name, SSN) | SSN, Last Name, First Name, Middle Name, Full Name, Gross Wages, Fed Taxable Gross, Fed Tax Amount, FICA Taxable Gross, FICA Tax Amount, Med Taxable Gross, Med Tax Amount | Shows all federal W2 information for an employee. |
| Get Employee Local W2 AQ | Gives details of employee local wages. | Supplier, Year, State, Local Tax, SSN, Data Source (Avionté, Compare, Greenshades), Return Type (Results, Summary), Sort By (Name, SSN) | SSN, Last Name, First Name, Middle Name, Full Name, Street 1, Street 2, City, State, Zip Code, Gross Wages, Local Tax Name, Local Tax Code, Local Tax State, Avionté Taxable Gross, Avionté Tax Amount | Shows all local W2 information for an employee. |
| Get Employee State W2 AQ | Gives details of employee state wages. | Supplier, Year, State, SSN, Data Source (Avionté, Compare, Greenshades), Return Type (Results, Summary), Sort By (Name, SSN) | SSN, Last Name, First Name, Middle Name, Full Name, Gross Wages, Tax State, Avionté Taxable Gross, Avionté Tax Amount | Shows all state W2 information for an employee. |
| Get Employee SUI Wage Details AQ | Gives details of employee SUI wages. | Supplier, Start Date (Check Date), End Date (Check Date), State Code | SSN, Last Name, First Name, Middle Initial, Gross Wages, Taxable Wages, Subject Wages, Excess Wages | Shows all SUI wage details for an employee. |
| Get PA EIT Details AQ | PA EIT breakdown by employee and worksite. | Start Date (Check Date), End Date (Check Date), Tax Type(s) | Supplier Name, SSN, Employee Name, Employee Address, Gross Wages, Taxable Wages, Tax Amount, Resident PSD Code, Tax Name, Tax Type, Worksite, Worksite Address, Worksite PSD Code, Tax PSD Code, Tax Authority. Requires Employee Extra label with SystemName = PSDCode. | Shows a breakdown of PA Earned Income Tax details and amounts for each employee. |
| Get PA EIT Details - Tax Name | Start Date, End Date, Tax Type(s), Tax Name, Local Account Number | EIN, LocalAccountNumber, WorksitePSDCode, TaxYear, Period, SSN, LastName, FirstName, MiddleName, Address1, Address2, City, State, ZipCode, WorksiteAddress, WorksiteCity, WorksiteState, WorksiteZipCode, TaxableWages, EITTaxAmount, ResidentPSDCode, LSTTaxAmount | Gives details of EIT Tax Amount and LST Tax Amount for Worksite PSD Code and Resident PSD Code. | |
| Get PA Employees Missing Resident PSD Code AQ | Shows PA employees with missing Resident PSD Code. | Start Date (Check Date), End Date (Check Date), Show EE w/PSD Code (Yes, No) | Staffing Company, Employee ID, Last Name, First Name, Middle Name, SSN, Full Address, Gross Wages, Tax Amount, Resident PSD Code. Requires Employee Extra label with SystemName = PSDCode. | Helps find employees working in PA with missing PSD codes so their records can be updated. |
| IL Day and Temporary Labor Act Registration AQ | Provides information required for registering in Illinois for the Day and Temporary Labor Act. | Date Type (Accounting Period Date, Week Worked), Start Date, End Date, Show Employee Info (Yes, No), Branch (Employee) | Branch, Male Hispanic Or Latino, White, Black African American, Native Hawaiian Pacific Islander, Asian, American Indian Alaskan Native, Two or More Races, Unknown Race, Male, Female, Unknown Gender | IL Day & Temp Labor Act |
| IL Equal Pay Act | Supplier Name, Start Date, End Date (uses Check Dates) | FirstName, LastName, SSN, Gender, Race, Ethnicity, Wages, HireDate, TerminationDate, JobClassification, JobTitle, County | ||
| Invoice Finance Charge Details | Gives details of finance charges applied to invoices. | Branch (Invoice), Date Type, Start Date, End Date | Customer ID, Customer Name, Department Name, Invoice Date, Invoice Amount, Balance Amount, Finance Charge Date, Finance Charge Percent, Chargeable Amount, Finance Charge, Charge Type, Increase Balance Amount | Useful for reviewing the details of finance charges applied to invoices. |
| Local Tax Mappings AQ | View, edit, or add Greenshades local tax mapping. | Action Type (View, Map), Year, State(s), Tax Types, Map Tax ID, Map to Juris ID, Map to Juris Code, Map to Juris Name, Map to Muni Code, Map to Muni Name | Tax ID, Tax Name, Tax Type, Vertex Tax Type, State Code, Tax Code ID, Taxable Gross YTD, Tax Amount YTD, Jurisdiction ID, Jurisdiction Code, Jurisdiction Name, Municipality Code, Municipality Name | Useful for determining where an employee falls in the Greenshades tax mapping. |
| Local Tax Mappings - Greenshades Listing AQ | View Greenshades' local tax list for mapping. | State(s), Jurisdiction, Municipality | Jurisdiction ID, State Code, Jurisdiction Code, Jurisdiction Name, Municipality Code, Municipality Name | Useful for determining where an employee falls in the Greenshades tax mapping and their applicable tax rates. |
| Local Tax WH AQ | Totals local tax withholding. | Branch Payment Check, Date Type (Check Date, Accounting Period Date), Start Date, End Date | Staffing Company, Branch, Year ID, Quarter Name, State, Local Name, Num of Employees, Taxable Gross, Subject Gross, Gross Amount, Tax Amount | Useful for tracking local tax withholding amounts for all employees by branch. |
| Minimum Wage Rate AQ Report | Allows you to view and export all locality minimum wage rate records configured across your staffing suppliers. | Supplier, State(s), City, Active Records Only, Start Date, End Date | Staffing Supplier, State, City, Minimum Wage, Start Date, End Date, Locality Minimum Wage ID, Select | Use this report to audit wage rates by state, city, and date range — streamlining multi-state compliance management and reducing the time spent manually reviewing individual records. |
| Oregon Statewide Transit Tax AQ | Data required for reporting Oregon Statewide Transit Tax to the state of Oregon. | Supplier FEIN, Quarter, Year | Social Security Number, First Initial, Employee Last Name, Total Subject Wages, Statewide Transit Tax Withheld | Reporting OR Transit Tax |
| Paycheck/Invoice with a Gap AQ | Lists paychecks or invoices with time gaps in the sequence. | Entity Branch, Start Date, End Date, Entity Type (Paycheck, Invoice), No. of Days, Entity Name | Paycheck: Branch, Employee ID, Last Name, First Name, Middle Name, Last Check Date; Invoice: Branch, Customer ID, Customer Name, Department Name, Last Invoice Date | Identifies customers who haven't been billed and employees who haven't been paid for a gap period, due to inactivity or billing/payroll error. |
| Quarterly Payroll Numbers Detail AQ | Breakdown of quarterly payroll information by tax types. | Start Date (Accounting Period), End Date (Accounting Period Date) | Check Year, Quarter, Bank ID, Tax Name, Tax Type, Taxable Gross, Tax Amount, Payee, Check Number | Good summary of quarterly payroll totals broken down by tax type. |
| Quarterly Sales by Fiscal Year AQ | Breakdown of quarterly sales by fiscal year. | Branch (Transaction), Fiscal Year Start Date, Fiscal Year End Date, Line of Business | Branch Name, Year ID, Month_Quarter, Customer, Department, Total Bill, Bill Amount, GP Adj Bill, Total Sales, Total Hours, Gross Profit, Line of Business | Good summary of total sales, hours, and gross profit during a specific quarter in a fiscal year. |
| Split Transaction AQ | Shows all split transaction information. | Branch (Transaction), Date Type (Accounting Period Date, Week Worked), Check Number, Check Date, Check Status, Start Date, End Date | Staffing Supplier Desc, Site Name, Payee Name, Bill To Name, Department Name, Total Pay, Total Bill, Total Cost, Worker Comp Cost, Agency Cost, Payment Cost, Burden, Gross Profit Percent, Gross Profit, Gross Wages, Bill Amount, Employer Taxes, Credit Card Fee, Discount Amount, Total Adjustment Pay/Bill/Cost, Pay/Bill RT/OT/DT/Other Hours, SUTA/FUTA/FICA/MED Tax, Accounting Period Date, Week Worked | Shows all financial information about split transactions, including gross profit, tax, pay, and bill breakdowns. |
| State Saves_Employee Contribution File | Required employee contribution information for CA, IL, & OR state savings (Secure Choice) programs. | Branch (Employee), Start Date, End Date, Date Type (Accounting Period Date, Check Date), Deduction Type, State | Last Name, First Name, SSN, Contribution Amount, External Payroll ID, State | Used for IL, CA, OR Secure Choice Programs. |
| State Saves_Employee List | Required employee census information for CA, IL, & OR state savings (Secure Choice) programs. | Branch (Employee), State, Date Type, Start Date, End Date, Pay Cycle, Start Print From, Run Type | SSN/ITIN, Full Name, Birthdate, Address, State, ZIP Code, Phone, Email | Used for IL, CA, OR Secure Choice Programs. |
| State Tax WH AQ | Lists state tax withholding by employee. | Branch (Employee), Date Type (Accounting Period Date, Check Date), Start Date, End Date, State | Staffing Company, Branch, Year ID, Quarter Name, State, Num of Employees, Taxable Gross, Subject Gross, Tax Amount | Good summary of state tax withholding for all employees by branch. |
| SUI Amount AQ | Lists amounts paid for SUI tax. | Branch (Employee), Start Date (Check Date), End Date (Check Date) | Employee Name, Tax Name, Upper Limit, Subject Wages, Taxable Wages, Tax Amount | Shows wage and tax amounts for State Unemployment Insurance taxes. |
| Taxes Summary AQ | Summarizes company taxes. | Branch (Paycheck), Check Start Date, Check End Date, Show Summary (Yes, No) | Supplier Description, First Name, Last Name, Check Number, Check Date, State Description, Tax Type, Tax Name, Gross Amount, Subject Gross, Taxable Gross, Tax Amount, Summary | Shows a breakdown of amounts owed for each tax type, plus a summary. |
| Unemployment AQ | Lists all unemployment claim information by employee. | Branch (Employee), Date Type (All, Claim Date, Claim Received), Start Date, End Date, Unemployment Status, Unemployment Status Reason | Last Name, First Name, Claim Number, Claim Date, Claim Received Date, Status, Determination Status, Reason Status, Potential Charges, Total Benefit Charged, Terminated By Employer, Protestable, Separation Info Needed, Appeal Pending, Claim Not Chargeable, Max Benefit, Weekly Benefit, Appeal Pending 1, Avg Pay Per Week, Total Earnings. Requires Unemployment Date setup with SystemName = ClaimDate and SystemName = ClaimReceived. | Generates a detailed list of unemployment claims and statuses, useful for tracking or court presentation. |
| View Greenshades Errors AQ | View errors generated from Greenshades feed. | Supplier, Year, Quarter | Quarter, Last Feed Generated Date, Last Feed Generated By, Error Messages | Shows all Greenshades errors from running the last feed. |
| VMS Billing | Shows bill and pay for VMS orders. | Branch (Transaction), Date Type (Accounting Period Date, Week Worked), Start Date, End Date | Staffing Company, Branch Name, Agency Name, Customer Name, Department Name, Employee Name, Accounting Period Date, Week Worked, Total Bill, Total Pay, Total Cost | Useful for reviewing bill and pay data for orders associated with vendors. |
| W2 Manual Modifications Utility AQ | Lists changes and allows changes to be made to W2s. | Supplier, Year, Action (View Modifications, Add New Modification, Adjust Previous Modification, Remove Previous Modification), SSN, Box Number, Box Code, Modification Value, Modification Notes | SSN, Last Name, First Name, Box Number, Code, Value, Notes, Entered Date, Entered by User | Allows someone to easily view and make changes to W2s in the system. |
| WC Cost by Claim Type AQ | Details how workers comp claims affect gross profit. | Claim Status, Claim Number, Customer Name, Employee Name, Branch, As Of Date | Customer Name, Claim Number, Claim Entered Date, WC Code, Employee Name, Claim Status, Staffing Company, Branch Name, Job Order ID, Job Title, Total Bill Amount, Gross Profit Before WC Cost, Gross Profit After WC Cost, YTD Customer Bill Amount, Body Parts, Medical Transportation | Useful for determining the financial impact of a WC claim or group of claims. |
| Workers Comp Claim Detail AQ | Shows all non-cost related details associated with a Workers Comp Claim. | Branch (Claim) | Branch, Employee ID, Last Name, First Name, Middle Name, SSN, Address, Phone, Claim Number, Claim Type, Claim Status, Injury Date Time, WC Claim ID, Customer Name, Customer Address, Customer Phone, Job Title, Assignment ID, WC Code, Reg Pay Rate, Start Date, End Date, Body Part, Notes, Modified Duty Date, Insurance Notification, Count Date, Return to Work Date, Entered Date, Entered By, Body Part Injured 1, Note 1, Body Part Injured 2 | Useful resource for claim reporting to customers. |
| Worker Comp Cost AQ | Details on worker comp codes per employee, including wages, hours, and WC cost. | Branch, Date Type, Start Date, End Date, Include Burden Factor, Roll up To Parent Customer | Staffing Company, Branch Name, Customer Name, Department Name, State, Worker Comp Code, WC Code Description, EmployeeID, Employee Name, SSN, Order Type, Skill Code, Accounting Period Date, Check Date, Reg/OT/DT/Other/Gross Wages, Worker Comp Wage, Worker Comp Percent, Worker Comp Cost, Pay Total/Reg/OT/DT/Other Hours, Select | Provides details on hours, wages, and worker comp costs per employee and customer. |
Front and Back Office User Advanced Queries
| Name | Description | Parameters | Fields / Configuration Settings | Why is this AQ useful? |
|---|---|---|---|---|
| Accrued Hours AQ | Details total hours for employees within a specified time period. | Date Type (Accounting Period Date, Week Worked), Start Date, End Date, Branch, Pay Code, Total Hours | Staffing Company, Branch, Employee ID, Employee Name, SSN, Primary Contact Method, Status, On Assignment?, Street 1, Street 2, City, State, Zip Code, Total Hours, Reg Hours, OT Hours, Gross Wages | Can be used to report an employee's hours to a customer, calculate client discounts, or get general hours information for assignments. |
| Comprehensive Agency AQ | Shows a comprehensive list of information associated with an agency. | Branch, Date Type, Start Date, End Date, Agency Status, Agency Type, Agency Name, Extra Value | StaffingSupplier, Branch, AgencyID, AgencyName, ShortName, DepartmentName, Status, AgencyType, ReferenceID, StreetAddress1, StreetAddress2, City, State, ZipCode, Country, FEIN, FirstPaycheckDate, LastPaycheckDate, OutstandingTransactions, ActiveDirectDeposit, InvoicePayRequired, PaymentDelayInDays, PayBeginningDate, PayNotRequired, Net Pay (Current Year/Current Year–1/Current Year–2), Agency Contact Method, Agency User, Agency Date, Extra Value | Offers a very detailed summary of agency information. |
| Comprehensive Assignment AQ | Shows a comprehensive list of information associated with an assignment. | Branch (Assignment), Date Type (Date Entered, Hire Date, First Paycheck Date, Last Paycheck Date, Paycheck Date), Start Date, End Date, Customer Name, Extra Value | EmployeeID, EmployeeName, SSN, EmployeeStatus, PrimaryContact, IsW2, US Withholding Type, CustomerName, DepartmentName, JobTitle, WCCode, OrderID, OrderType, AssignmentID, AssignmentType, MarkUp, Branch, Shift, PerformanceCode, EndReason, Original StartDate, EndDate, OrderEndDate, # Days on Assignment, RegPayRate, RegBillRate, OTPayRate, OTBillRate, DTPayRate, DTBillRate, SalaryPayRate, SalaryBillRate, RecruitingCall, ReferenceCall, ArrivalCall, SecondDayCall, EndingCall, EmployeeLastPaid, AssignmentLastPaidDate, TotalBill, ResidentStreet1, ResidentStreet2, ResidentCity, ResidentState, ResidentZipCode, WorksiteStreet1, WorksiteStreet2, WorksiteCity, WorksiteState, WorksiteZipCode, WorksiteGeoCode, Agency, Extra Value | Offers a very detailed summary of assignment information. |
| Comprehensive Contact AQ | Shows a comprehensive list of information associated with a contact. | Branch, Start Date, End Date, Date Type, Extra Value | ContactID, Salutation, FirstName, MiddleName, LastName, Title, ContactStatus, Branch, CustomerAgencyName, DepartmentName, Street1, Street2, City, State, ZipCode, Sales Level, Sales Level Notes, Industry Code, Customer Type, Competition, Lead Source, Contact Contact Methods, Customer Contact Methods, Contact Users, Contact Dates, Customer User, Extra Value | Offers a very detailed display of contact information. |
| Comprehensive Customer AQ | Shows a comprehensive list of information associated with a customer. | Branch (Customer), Date Type (Date Entered, First Invoice Date, Last Invoice Date, Invoice Date), Start Date, End Date, Customer Name, Entered By, Extra Value | Customer ID, Customer Name, Department Name, Status, Branch, Street Address 1 & 2, City, State, Zip Code, Short Name, Phone #, Staffing Supplier, Account Manager, Date Entered, Entered By, Website, Sales Level, Industry Code, Customer Type, Competition, Lead Source, Credit Limit, Hold Code, Default Payment Option, Warning Value Type/Value, First/Last Invoice Date, Invoice to Department, Invoice Style, Email Invoice To, Print Invoice?, Statement Letter Day, Billing Period, Billing Cycle, Payment Terms, Max Invoice Amount, Annual Invoice Totals (3 years), LTD Total Invoice Amount, Total Sales Tax Amount, Total Discount Amount, Total Payment Amount, AR Invoice/Age breakdowns, Annual Hours (3 years), Total Expected Revenue, Referral Source, Agency, Agency Fee, Default WC Code, Default Mark Up | Offers a very detailed display of customer information, including historical invoices and total hours for annual comparison. |
| Comprehensive Employee AQ | Shows a comprehensive list of information associated with an employee. | Branch (Employee), Date Type (Date Entered, Hire Date, First Paycheck Date, Last Paycheck Date, Paycheck Date), Start Date, End Date, Employee Status, Extra Value | Branch, Employee ID, Last Name, First Name, Middle Name, Nickname, SSN, Employee Status, On Assignment, Street 1, Street 2, City, State, Zip Code, User_EEO Permission, Date of Birth, Gender, Check Delivery, Agency Name, Tax Credit Qualified?, First/Last Paycheck Date, First Assignment Start Date, Is W2?, Resume?, I9?, Direct Deposit?, ACA Eligible?, Referral Source, Referral Detail, E-Verify Status, Total Wages/Hours (3 years), Accrual Balance, Contact Method, Date Type, Entered By, Entered Date | Gives a great summary of an employee, pulling all basic information and work/pay history for the past 3 years. |
| Comprehensive Order AQ | Shows a comprehensive list of information associated with an order. | Branch (Order), Date Type (Date Entered, Order Start Date), Start Date, End Date, Order Status, Customer Name, Order Type, Extra Value | Order ID, Order Date Entered, Customer Name, Department Name, Main Address, Order Type, Order Status, Order Schedule Status, Job Title, Position Description, Branch, WC Code, Pay/Bill Rates (Reg/OT/DT/Salary), Mark Up, Pay Period, OT Plan, Start Date, End Date, Required, Placed, Fill Ratio, Fill Rate (Hours), Is Posted to Web, Shift Name, Worksite Address, Referral Source, PO Number, Record Origin/Type, Discount, Candidate Status Counts, SalaryRange, FeeType, InvoicedAmount, YetToBeBilledAmount, Candidate Totals, Order Candidates, Extra Value, BoldJobID, CustomerID, BoldCompanyID, Sales Tax | Offers a very detailed summary of order information, including fill ratio and fill rate data. |
| Customer Markup AQ | Shows the markup rates for customers. | Customer ID, Customer Name | CustomerID, CustomerName, DepartmentName, MarkUpName, Description, RTMarkUp, OTMarkUpOption, OTMarkUp, DTMarkUpOption, DTMarkUp, IsVisible, IsDefault, DateEntered, UserName | Displays all (or specific) customers and their respective Regular, OT, and DT markup rates and names. |
| Daily Hours AQ | Details daily hours for employees. | Branch (Transaction), Date Type (Accounting Period Date, Week Worked, Date Worked), Start Date, End Date | Staffing Supplier, Branch, Name, Accounting Period Date, Week Worked, Batch ID, Customer Name, Department Name, Order ID, Job Title, WC Code, Assignment ID, Start Date, End Date, Employee ID, Employee Name, SSN, Day Name, Date Worked, Type, Pay Unit, Pay Rate, Item Pay, Bill Unit, Bill Rate, Item Bill, Time In, Lunch Out, Lunch In, Time Out | Shows specific time clock information, as well as associated assignment, customer, pay, and bill information for each employee. |
| Employee Benefit AQ | Details benefits enrollment for each employee. | Date Type (Accounting Period Date, Check Date), Start Date, End Date, Branch (Employee), Deduction/Benefit List | Employee Branch, Employee ID, First Name, Middle Name, Last Name, SSN, Employee Status, Birth Date, Original/Recent Hire Date, First Check Date, Street 1, Street 2, City, State, Zip Code, Country, Gender, Total Hours, Total Wages, Deduction Amount, YTD/LTD Deduction Amount, Is ACA Eligible, Current Stability End Date, Measurement Start/End Date, Measured Type, Measurement Total Hours, Measured Eligibility, Benefit Plan Name, Benefit Plan Type | Similar to the ACA Census AQ. Useful for tracking healthcare eligibility and other benefit participation. |
| Employee Deduction/Contribution List AQ | Details deductions and contributions for each employee. | Branch, Date Type (Check Date, Date Entered, Start Date, None), Start Date, End Date, Deduction/Contribution Name | Employee Branch, Employee Status, Employee ID, First Name, Middle Name, Last Name, Deduction/Contribution Type, Deduction/Contribution Name, Amount, Is Fixed Amount, Is Levy, Is Per Hour, Sequence, Percent of Gross/Net, Agency Name, Agency Address, Agency Reference Number, Deduction DI Percent, Start Date, End Date, Pay Period/Monthly/Yearly/Lifetime Limit, Deduction Amount MTD/YTD/LTD, Deduction Balance, Note, Frequency, Deduction/Contribution Supplier, Flag During Payroll, Entered By, Date Entered, Last Check Date, Employee Last Assignment End Date, Deduction Max Percent of Net | Gives detailed deduction/contribution information; useful when checking employee payroll deductions. |
| Favorite Contacts AQ | Lists favorite contacts. | User Name(s) (Optional), Branch (Contact) | Group Name, Group Description, Created by User Name/Description, Contact Supplier, Contact Branch, Contact ID, Last Name, First Name, Title, Customer/Agency Name, Contact Primary Contact Method, Contact Email Address, Street 1, City, State, Zip Code | Makes it easy to pull up contact information for favorite contacts. |
| Favorite Customers AQ | Lists favorite customers. | User Name(s) (Optional), Branch (Customer) | Group Name, Group Description, Created by User Name/Description, Customer Supplier, Customer Branch, Customer ID, Customer Name, Customer Primary Contact Method, Customer Email Address, Street 1, City, State, Zip Code | Makes it easy to pull up contact information for favorite customers. |
| Favorite Employees AQ | Lists favorite employees. | User Name(s) (Optional), Branch (Employee) | Group Name, Group Description, Created by User Name/Description, Employee Supplier, Employee Branch, Employee ID, First Name, Last Name, Employee Primary Contact Method, Employee Email Address, Street 1, City, State, Zip Code | Makes it easy to pull up contact information for favorite employees. |
| Look Back Data Comparison AQ | Compares specific column totals for two different specified time periods (week, month, quarter, year). | Date Type (Accounting Period Date, Week Worked), Start Date, End Date, Column to Compare, Compare By (Week, Month, Quarter, Year), Include In Comparison (Transaction Branch, Order Type), Roll up to Root Customer | Staffing Company, Branch Name, Customer Name, Department Name, Order Type, Label, Year/Quarter/Month/Week (depending on time period), Sales Rep, Service Rep, Account Manager, Entered By. Config ChoiceCode: Main Category = "CustomerUser", SystemName = "SalesRep", "ServiceRep", "AccountManager", and "EnteredBy". | Great report for tracking company performance on various metrics over time. |
| PO Number Info AQ | Gives information associated with a PO number. | Customer Name, Start Date (Assignment), End Date (Assignment), Active (Active, Inactive) | Customer ID, Customer Name, Department Name, Staffing Order ID, PO Number, PO Limit, PO Start Date, Warning Value, Amount Used, PO Remaining, Assignment ID, Employee Name, Shift, Is Active? | Useful for getting a general snapshot of information associated with a PO number. |
| Processed Transaction Detail AQ | Gives detailed information of all processed transactions. | Branch (Transaction), Date Type (Accounting Period Date, Check Date, Invoice Date, Week Worked), Start Date, End Date, Customer Name, SSN | Staffing Supplier Desc, Transaction Branch, Accounting Period Date, Week Worked, Time Entry Batch ID, Transaction ID, Customer ID, Bill To Name, Department Name, Employee ID, SSN, Employee Name, Staffing Order ID, Assignment ID, Assignment Start/End Date, Check Date, Check Number, Check Branch, DD, Invoice Date, Invoice Number, Invoice Branch, Pay Code, Pay Unit, Pay Rate, Item Pay, Bill Unit, Bill Rate, Item Bill, Cost Unit, Cost Rate, Item Cost, NonAdjustmentCost, Employer Contribution, RT/OT/DT Pay and Bill, Order Type, WC Code, Job Position, PO Number, Customer User: Service Rep/Account Manager, Assignment User: Sales Rep/Staffing Rep | Shows a comprehensive view of all processed transactions during a specific time period. |
| Processed Transaction Summary AQ | Gives detailed information of all processed transactions. | Date Type (Accounting Period Date, Week Worked), Start Date, End Date, Branch (Transaction), Customer Name, SSN | All fields from the Detail AQ plus: Total Pay, Total Bill, Bill Amount, Gross Wages, Total Adjustment Pay/Bill, WC Cost, Agency Cost, Payment Cost, Burden, Gross Profit, Gross Profit Percent, Gross Margin, Employer Taxes, Employer Contribution, RT/OT/DT/Total Hours (Pay and Bill), RT/OT/DT Pay and Bill, Order Type, WC Code, Job Position, Total Adjustment Cost, GP Adjustment Pay/Bill/Cost, Sales Tax Amount, NonAdjustmentCost, WC Wage, CC Fee, Discount Amount, Rebate Amount, PO Number, Fed Income Tax, State Tax, FICAEE, MEDEE, Other Taxes | Shows an extremely comprehensive view of all processed transactions during a specific time period. |
| Turnover AQ | Details turnover rates for both positive and negative end reasons. | Start Date (Order Entered Date), End Date (Order Entered Date), Customer Name, Order Type | Branch, Customer ID, Customer Name, Department Name, Staffing Order ID, Order Type, Order Status, Order Schedule Status, Job Title, Shift Name, Reg Pay Rate, Reg Bill Rate, Required, Placed, Assignments Ended, End Reason Negative/Positive, Turnover Percent, Negative/Positive Turnover Percent, Average Assignment Length (Days), Account Manager, Entered By, Sales Rep, Staffing Rep. Requires mapping: Mapping Reports and Advanced Queries | Shows turnover rates broken out into positive and negative turnover as mapped to assignment end reasons. |
| Web Time AQ | Lists time entered by employees online. | Branch (Transaction), Start Date (Weekend Date), End Date (Weekend Date), Customer Name, Assignment ID | Staffing Company, Branch Name, Employee ID, Employee Name, Customer Name, Department Name, Submitted Date, Submitted Time, Approved Date, Approved Time, Approved By, Imported Date, Rejected By, Rejected Date, Week End Date, Transaction Type, Assignment ID, Date Worked, Day Label, Start Time, Break In, Break Out, End Time, Date Time Entered, Bill Unit, Pay Unit, Time Entry Batch ID, Rejection Reason 1, Rejection Reason 2, Rejection Reason 3 | Great resource for cross-checking an employee's entered time. |
Admin User Advanced Queries
| Name | Description | Parameters | Fields / Configuration Settings | Why is this AQ useful? |
|---|---|---|---|---|
| Audit AQ | See Audit AQ in the Front Office section for details. | |||
| Bureau of Labor Current Employment Statistics | Pulls information required for reporting Bureau of Labor Statistics Current Employment Statistics data. | Supplier, Month Code, Year, Pay Period (Daily, Weekly, Biweekly, Monthly, SemiMonthly, Yearly, Hourly) | Staffing Supplier Desc, Pay Period, Total EE Count, Total Non Sup. EE Count, Total Female EE Count, Wages for All EE without Comm., Wages for Non Sup. EE without Comm., Total Comm., Non Sup. EE Comm., Total Hours for All EE, Total Hours for Non Sup. EE. Requires mapping: Mapping Reports and Advanced Queries | Makes it easy to submit Current Employment Statistics data to the Bureau of Labor Statistics each month. |
| Bureau of Labor Multiple Worksite Report | Pulls information required for reporting Bureau of Labor Statistics quarterly wages data. | Quarter, Year | Branch Name, Street 1, Street 2, City, State, Zip Code, Month 1 EE Count, Month 2 EE Count, Month 3 EE Count, Quarterly Wages | Makes it easy to fill out State or Federal Labor Statistics quarterly wage structured reports. |
| eDocument Audit Log AQ | Logs changes made to eDocuments. | Start Date (Modified), End Date (Modified), User Name, Table List, Web User | FK ID, FK Name, Table Name, eDocument Type, Field, Old Value, New Value, Date Modified, Modified Time, Modified By | Allows tracking of employee progress on eDocuments and shows when and how specific eDocument fields were changed. |
| Get System Usage | Details system usage by user name. | User Description, Show Primary (Yes, No), Start Date, End Date | ID, User Description, Table Name, Count, Show Primary, Section | Details system usage by username, showing what each user is doing within the application. |
| Get W2 Details AQ | Shows totals for W2s and related taxes. | Supplier, Year, Return Type (Detail, EE Summary, ER Summary, W2 Count) | W2 Payee Count, W2 Page Count, SSN, SSN Count, Last Name, First Name, Middle Name, Full Name, Total Gross, Fed Taxable Gross, Fed Tax Amount, FICA Taxable Gross, FICA Tax Amount, Med Taxable Gross, Med Tax Amount, Tax States, State Taxable Gross, State Tax Amount, Local Tax Codes, Local Tax Names, Local Tax States, Local Taxable Gross, Local Tax Amount | Totals the number of W2 payees and W2 page count for a supplier and year. ER Summary also totals all tax types; EE Summary totals all tax types per employee. |
| Report AQ Possible Issue | Lists error reasons for issues with reports or AQs within the Reports feature. | Root Staffing Supplier | Title, Target Server URL, File Name, Error | Can be run to determine why a specific report will have issues running or with user access. |
| User Log | Tracks user activities in the application within a given date range. | Start Date, End Date | UserName, UserGroup, LastLoginDate, LaunchApplication, Score, Messages, EmployeeCreated, CustomerCreated, ContactCreated, OrderTempCreated, OrderDHCreated, AssignmentCreated, TimeEntryBatchesClosed, PaymentBatchesClosed, PostedPaymentBatches, PaymentChecksCreated, BillingBatchesCreated, PostedBillingBatches, InvoicesCreated, InvoiceCorrections, ARBatches, ARBatchPayments, ARBatchPaymentInvoices, PostedARBatches, ACHPaymentBatchesCreated, ClosedAccountingPeriods | Provides a great summary of activities by user. |
| User Login Stat | Log of user logins by date. | Start Date (User Log Date), End Date (User Log Date) | Group Name, User Name, User Description, User Log Count, Last Login Date, Is Active | Can help determine internal productivity. |
| VETS 4212 Reporting AQ | Contractors and subcontractors with federal contracts meeting the criteria under 38 U.S. Code, Section 4212 must report the data this report populates. | Supplier, Branch (Employee), Date Type (Week Worked, Accounting Period Date), Start Date, End Date, Show Employee Info | Show Employee Info = Yes: Employee ID, Employee Name, Veteran Status, Job Position, Mapping Job Category; Show Employee Info = No: Job Category, Protected Veterans (A), Total Employees (B), New Hire Protected Veterans (C), New Hire Total Employees (D) | Makes it easy to report VETS 4212 data. |
| View Greenshades Errors AQ | See View Greenshades Errors AQ in the Back Office section for details. | |||
| W2 Manual Modifications Utility AQ | See W2 Manual Modifications Utility AQ in the Back Office section for details. | |||
| WC Cost by Claim Type AQ | See WC Cost by Claim Type AQ in the Back Office section for details. | |||
| Workers Comp Claim Detail AQ | See Workers Comp Claim Detail AQ in the Back Office section for details. | |||
Management User Advanced Queries
| Name | Description | Parameters | Fields / Configuration Settings | Why is this AQ useful? |
|---|---|---|---|---|
| Bureau of Labor Current Employment Statistics | See Bureau of Labor Current Employment Statistics in the Admin section for details. | |||
| Bureau of Labor Multiple Worksite Report | Pulls information required for reporting Bureau of Labor Statistics quarterly wages data. | Quarter, Year | Branch Name, Street 1, Street 2, City, State, Zip Code, Month 1 EE Count, Month 2 EE Count, Month 3 EE Count, Quarterly Wages | Makes it easy to fill out State or Federal Labor Statistics quarterly wage structured reports. |
| Client Evaluation Results AQ | See Client Evaluation Results AQ in the Front Office section for details. | |||
| Comprehensive Assignment AQ | See Comprehensive Assignment AQ in the Front and Back Office section for details. | |||
| Comprehensive Customer AQ | See Comprehensive Customer AQ in the Front and Back Office section for details. | |||
| Comprehensive Employee AQ | See Comprehensive Employee AQ in the Front and Back Office section for details. | |||
| Comprehensive Order AQ | See Comprehensive Order AQ in the Front and Back Office section for details. | |||
|
Federal EEO Reporting AQ Requires mapping |
See Federal EEO Reporting AQ in the Back Office section for details. | |||
| Job Order Metrics AQ | See Job Order Metrics AQ in the Front Office section for details. | |||
| Look Back Data Comparison AQ | See Look Back Data Comparison AQ in the Front and Back Office section for details. | |||
| Referral Source AQ | See Referral Source AQ in the Front Office section for details. | |||
| Revenue Opportunity AQ | Shows revenue opportunities from potential sales. | Branch (Customer), Date Type (Expected Close Date, Revenue End Date), Start Date, End Date, Customer Name, User Name | Staffing Company, Branch Name, Opportunity Name, Description, Sales Status, Expected Revenue, Revenue Period, Revenue Competition, Sales Close Level, Expected Close Date, Revenue Start/End Date, Customer ID, Customer Name, Department Name, Customer Status, Lead Source, Contact Name, User Name, Staffing Order ID, Sales Level, Expected Sales, Weekly Amount, Last Message Date, Last Message Action, First Invoice Date. Requires Customer Contact Method with SystemName = Email and Customer Contact Role with SystemName = Sales. | Useful for forecasting future revenue and determining recent sales activity. |
| Staffing Action AQ | See Staffing Action AQ in the Front Office section for details. | |||
| Turnover AQ | See Turnover AQ in the Front and Back Office section for details. | |||
| VETS 4212 Reporting AQ | See VETS 4212 Reporting AQ in the Admin section for details. | |||
Sales User Advanced Queries
| Name | Details |
|---|---|
| Favorite Contacts AQ | See Favorite Contacts AQ in the Front and Back Office section for details. |
| Favorite Customers AQ | See Favorite Customers AQ in the Front and Back Office section for details. |
| Favorite Employees AQ | See Favorite Employees AQ in the Front and Back Office section for details. |
| Revenue Opportunity AQ | See Revenue Opportunity AQ in the Management section for details. |
Advanced Queries for All Users
| Name | Description | Parameters | Fields / Configuration Settings | Why is this AQ useful? |
|---|---|---|---|---|
| Accrual Balance as of Today AQ | Shows employee accrual information as of the day this report is run. | Branch (Employee), Accrual Plan, On Assignment, Show Balance > Than | Employee ID, SSN, First Name, Middle Name, Last Name, Branch, On Assignment, Is W2, Accrual Plan, Rate, Rate Based On, Balance Unit, Accrual Date Entered, Date Based On, Pay Period Limit, Yearly Limit, Accrual Start Date, Active, Last Pay Rate, Last Week Worked, Customer Name Lasted Worked | Easy way to pull up accrual balance information for employees as of today's date. |
| Accrual History AQ | Shows employee accrual history information. | Date Type (Check Date, Accounting Period Date), Branch (Check), Accrual Plan, Show Details, Start Date, End Date | Employee ID, SSN, First Name, Middle Name, Last Name, Check Number, Check Date, Gross Amount, Net Amount, Accrual Plan, Previous Balance, Accrued Unit, Deplete Unit, New Balance, Last Pay Rate, Week Worked | Useful for seeing an employee's accrual information over time from each pay period. |
| AQ_SMTP Email Issues AQ | Issues with emails. | Start Date (Date Created), End Date (Date Created) | User Name, To, From, CC, BCC, Subject, Body, Status, Date Created, Invoice Number | Can be used to check for errors when sending out important emails. |
ACA Queries
| Name | Description | Parameters | Fields / Configuration Settings | Why is this AQ useful? |
|---|---|---|---|---|
| ACA Census | Branch (Transaction), Start Week Worked, End Week Worked, HealthCare Code, Show Summary | EmployeeID, FirstName, MiddleName, LastName, SSN, EmployeeStatus, EmployeeBranch, BirthDate, OriginalHireDate, RecentHireDate, FirstCheckDate, RecentCheckDate, EffectiveInsuranceDate, AssignmentMaxEndDate, Street1, Street2, City, State, Zipcode, Country, Gender, PrimaryContactMethod, EmployeeCellPhone, EmployeeEmail, TotalWages, TotalHours, DeductionAmount, BenefitAmount, IsACAEligible, CurrentStabilityPeriodEndDate, MeasurementStartDate, MeasurementEndDate, MeasuredType, MeasurementTotalHours, MeasuredEligibility, ReasonForDeactivation, OnAssignment, Select | Useful for tracking healthcare eligibility and other benefit participation. Also a great resource for reporting data to insurance brokers. | |
| ACA Companion Census AQ | Start Date, End Date, Date Type, Employer, SSN end with, Show All Measurements, Exclude Non W2 Employees | EmployeeID, SSN, FirstName, MiddleName, LastName, Branch, ACAEligibility, EmployeeStatus, OnAssignment, LastCheckDate, DateOfBirth, Gender, Phone, Email, AddressStreet, AddressCity, AddressStateorProvinceCode, AddressCountryCode, AddressPostalCode, EmployerName, EmployerIdentificationNumber, FirstWorkedDate, TerminatedDate, MeasurementType, MeasurementPeriodStartDate, MeasurementPeriodEndDate, MeasurementPeriodTotalHours, MeasurementEligibility, StabilityPeriodStartDate, StabilityPeriodEndDate, MostRecentEligibilityStatusDeclaration, MostRecentOfferedDate, MostRecentOfferedBenefitPackage, MostRecentOfferedStatus | ||
| ACA Companion Declination Export | Form Batch, Branch | ReportingYear, EmployerCode, EmployeeSSN, MemberCode, MemberFirstName, MemberLastName, MemberSSN, MemberDOB, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec | ||
| ACA Companion Employee Offers | Displays a list of all offers made in the ACA Companion Application. | Start Date, End Date, Date Type, Branch, Benefit Package | EmployerName, SSN, FirstName, MiddleName, LastName, BenefitPackage, OfferedDate, AcceptOrDecline, InsurancePlanOrDeclinationReason, StartDate, EndDate, LastCheckDate, LastAssignmentEndDate, EmployeeIDs, Branches, EmployeeStatuses | Allows users to audit and review insurance offers entered into the ACA Companion Application for accuracy. |
| ACA Companion Employee Primary Address Error | N/A | Error, EmployeeID, FirstName, MiddleName, LastName, SiteName, StaffingSupplierCode, Status, SSN, Street1, Street2, City, State, ZipCode, GeoCode, CountryCode | ||
| ACA Companion Employee Sync Error | Displays a list of all duplicate employees (based on name, address, and SSN) so they can be located and merged prior to running the ACA companion. | Look Up Criteria (All Employees or only those with paychecks), Paycheck Year | Error, SSN, EmployeeGroupID, EmployeeID, FirstName, MiddleName, LastName, Street1, Street2, City, State, ZipCode, GeoCode, SiteName, StaffingSupplierCode, Status, LastCheckDate, Primary Record, Bold Talent ID | Duplicate employees can cause the ACA companion to malfunction; locating and fixing them before running the companion is imperative. |
| ACA Companion Employee Sync SSN Errors | Lookup Criteria, Paycheck Year | Error, SSN, EmployeeGroupID, EmployeeID, FirstName, MiddleName, LastName, Street1, Street2, City, State, ZipCode, GeoCode, SiteName, StaffingSupplierCode, Status, LastCheckDate, PrimaryRecord | ||
| ACA Companion Insurance Offers AQ | Displays a list of all offers made in the ACA Companion Application. | Start Date, End Date, Date Type, Employer, SSN end with, Show Dependents | EmployeeIDs, SSN, FirstName, MiddleName, LastName, AddressStreet, AddressCity, AddressStateOrProvinceCode, AddressCountryCode, AddressPostalCode, OnAssignment, LastCheckDate, MostRecentEligibilityStatusDeclaration, BenefitPackageName, OfferedByEmployerName, OfferedByEmployerIdentificationNumber, OfferedDate, HealthInsurancePlanName, HealthInsurancePlanProviderName, AcaOfferOfCoverageCode, SafeHarborCode, IsSelfInsured, IncludesSpouse, IncludesDependents, IsMinimumEssentialCoverage, IsMinimumValue, EnrollmentDate, CoverageStartDate, CoverageEndDate, DeclinationStartDate, DeclinationEndDate, DeclinationReason | Allows users to audit and review all insurance offers entered into the ACA Companion Application for accuracy. |
| ACA Employee Sync Error Import | ImportExportBatchGUID | |||
| Get ACA EOY Reporting Errors | Supplier Year | |||
| ACA Companion Finalize Initial Setup | ||||
| ACA Export - Nelco | ||||
| ACA Import | ||||
| ACA Import Employee Status Declarations | ||||
| ACA Insert Employee 1095-C Overrides | ||||
| Standard AQ - Get employee 1095-C info |
Canadian Advanced Queries
| Name | Description | Parameters | Fields / Configuration Settings |
|---|---|---|---|
| Get Employee T4 Details AQ | A T4 (akin to an American W2) provides employee tax information. The T4_CA offers a detailed look at the tax associated with a supplier's employees. | Branch (Employee), Year, SIN | YearID, Supplier Desc, First Name, Middle Name, Last Name, Street1, Street2, City, Province, Country, Postal Code, SIN, Email, CPP QPP Exempt (28), EI Exempt (28), PIP Exempt (28), Province of Employment (10), Employment Code (29), Employment Income (14), Income Tax (22), CPP Contribution (16), EI Insurable Earnings (24), Employee QPP Contribution (17), CPP/QPP Pensionable Earnings (26), EI Premium (18), Union Dues (44), RPP Contribution (20), Charitable Donation (46), Pension Adjustment (52), RPP DPSP Registration Number (50), Employee PPIP Premiums (55), PPIP Insurable Earnings (56), EmploymentIncome_Code57, EmploymentIncome_Code58, EmploymentIncome_Code59, EmploymentIncome_Code60, Box 1–6 (Name and Amount) |
3rd party link Disclaimer: These links are provided as a convenience and for informational purposes only; they do not constitute an endorsement or approval by Avionté of any products, services, or opinions of any corporation, organization, or individual. Avionté bears no responsibility for the accuracy, legality, or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.
Comments
0 commentsPlease sign in to leave a comment.