Standard AQ - Comprehensive Agency

Overview

Updated 07/27/2021

Report Description

This report provides a summary of an agency or agencies by pulling basic information and pay history for the previous three years.

Parameters

Parameter Name	Options	Explanation
Branch	All available branches	Branch of Agency.
Date Type	Date Entered, First Paycheck Date, Last Paycheck Date, Paycheck Date
Start Date
End Date
Agency Status	All available Agency Status
Agency Type	All available Agency Type.
Agency Name	Filter the agency name
Extra Value		Value list of all Agency Extra. If Selected, the AQ will display the value of that particular extra.

Report Fields

Field Name	Explanation
StaffingSupplier	Agency’s Supplier
Branch	Agency’s Branch
AgencyID	Agency’s ID
AgencyName	Agency’s FullName
ShortName	Agency’s Short Name
DepartmentName	Agency’s Department Name
Status	Agency’s Status
AgencyType	Agency’s Type
ReferenceID	Agency’s ReferenceID
StreetAddress1	Agency’s Main Address Street 1
StreetAddress2	Agency’s Main Address Street 2
City	Agency’s Main Address City
State	Agency’s Main Address State
ZipCode	Agency’s Main Address Zipcode
Geocode	Geocode calculated from Agency's Main Address
Country	Agency’s Main Address Country
FEIN	Agency’s FEIN
FirstPaycheckDate	Agency’s First Paycheck Date
LastPaycheckDate	Agency’s Last Paycheck Date
OutstandingTransactions	Shows Checked if there are transactions which has AgencyCost and Paycheck has not be issued. Only if Agency iis setup with PayNotRequired  = False.
ActiveDirectDeposit	Shows checked the agency has anctive bank.
InvoicePayRequired	Indicates the payment option for indicating invoice pay required.
PaymentDelayInDays	Indicates the no. of days delay during the payment.
PayBeginningDate	Indicates the beginning date of the payment.
PayNotRequired	Indicates the payment option for indicating pay not required.
Net Pay (Current Year)	Total net pay of an agency in current year
Net Pay (Current Year – 1)	Total net pay of an agency in last year
Net Pay (Current Year – 2)	Total net pay of an agency in year before last year
Agency Contact Method	Show multiple columns for Agency’s contact methods dynamically.
Agency User	Show multiple columns for Agency’s User types dynamically.
Agency Date	Show multiple columns for Agency’s Date types dynamically.
Extra Value	Pulls a specific Extra value as selected in the Extra Value Parameter.

Back to Top