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