PCG’s AVS Web Portal features a reporting dashboard which allows authorized users to generate standard or customized reports. Reports are as follows:
- Case Error Report (Standard): identifies all cases that have had a Will Not Respond message return from a bank within the selected date range. Case errors only applicable to batch file cases, not manually entered through Ad Hoc Request.
- Site Access Audit Report (Standard): identify users who log in and out of AVS and when.
- Case Access Audit Report (Standard): capture the cases users access and when.
- Ad hoc Request Audit Report (Standard): log all Ad Hoc AVS requests submitted and by whom.
- AVS Review Report (Standard): This report is broken into four sections; Summary, Current Status, Financial Results, and Property Results. The report offers a review of AVS activity such as; number of cases, requests, identified accounts, and cases over assets etc. for the selected time period.
- Invoice Balance Report (Standard): identify all current account balances discovered within a user-selected time period.
- Invoice Transaction Report (Standard): identify all AVS transactions submitted through the AVS within a user-selected time period.
- The Results After Decision Queue Report (Standard): This report only required a date range in the search parameters and will indicated all cases that had results (accounts) return after an eligibility decision was made. The request date, case number, case name, case status, application date and any worker information associated with the case will be shown in the report.
- Summary/Detail Report (Custom): Both summary and details reports can be run using any of the criteria detailed on the next page. These reports run at the case level and can show how many cases have been ingested, processed, decided, etc.
NOTE: Each of the above reports can only be assigned to state designated users as add-on roles by PCG. If users are not assigned any reporting add on roles by PCG then access to the reports will be blocked.
NOTE: Required data entry points for all reports will be denoted with a red asterisk in the AVS Portal.
Standard Report Selection Criteria and Output Elements | ||
---|---|---|
Report | Criteria Selection Options | Output Elements |
Case Error ReportStart/End Date Range*County | ||
County | Office | |
Office | Unit | |
Unit | Worker | |
Worker | Registry Number | |
Record Status (i.e. Error Type) | Case Number | |
Case Name | ||
Request Date | ||
Description | ||
Financial Institution | ||
Site Access Audit Report | Start/End Date Range* | County |
County | Office | |
Office | Unit | |
Unit | Worker | |
Worker | Login Time | |
Logout Time | ||
Session Time | ||
Case Access Audit ReportStart/End Date Range*Case Number | ||
County | County | |
Office | Office | |
Unit | Unit | |
Worker | Worker | |
Case Number | Case Access Time | |
Ad Hoc Access Audit Report | Start/End Date Range* | County |
County | Office | |
Office | Unit | |
Unit | Worker ID | |
Worker | Case Number | |
Ad Hoc Request Type* | Request Date/Time | |
Status | ||
Applicant Type | ||
Request Type | ||
Full Name | ||
Last 4 SSN | ||
Case Number | ||
Invoice Balance Report | Start Date* | Request Date |
End Date* | Request ID | |
Name | ||
Financial Institution Name | ||
Account Number | ||
Current Account Balance | ||
Invoice Transaction Report | Start Date* | Request Date |
End Date* | Request ID | |
Case Name | ||
First | ||
Middle | ||
Last | ||
Results After Decision Queue Report | Start Date* | Request Date |
End Date* | Case # / Registry # | |
Case Name | ||
Case Status | ||
Application Date | ||
AVS Review Report | Start/End Date* | See next page |
AVS Review Report | |
---|---|
Summary | Results |
# Requests | |
# Cases | |
# Identified Accounts | |
$ Current Account Balances Identified | |
# Cases Over Program Limits | |
% Cases Over Program Limits | |
$ Market Value Currently Owned Properties Identified | |
% Cases with Owned Property | |
Current Status | Results |
Current # Open Cases | |
Current # Closed Cases | |
Current # Results After Decision Alerts | |
Current # Open Cases Over Program Limits | |
Financial Results | Results |
# Cases Total Balance $0 to $50K | |
# Cases Total Balance $50k to $100K | |
# Cases Total Balance $100k to $250K | |
# Cases Total Balance $250k to $500K | |
# Cases Total Balance $500k to $1MM | |
# Cases Total Balance over $1MM | |
# Identified Undisclosed Accounts | |
# Potentially Disqualifying Account Transfer Flags | |
Property Results | Results |
# Properties identified | |
# Properties > $100K Market Value | |
Total $ Market Value Identified Properties | |
# Quit Claim Deeds Identified | |
# Identified Undisclosed Properties | |
# Potentially Disqualifying Property Transfer Flags |
Custom Report Criteria and Output elements | |
---|---|
Report Criteria | Drop-Down Options |
Start/End Date Range | Calendar Start and End Date Selection* |
Case Status | New |
Error | |
Processing | |
Pending Review | |
Review in Progress | |
Ineligible | |
Eligible | |
Transfer Penalty | |
Ineligibility Reason | Over Resources – Financial Accounts *note instances of spouse IRA |
Over Resources – Real Property | |
Over Resources – Real Property and Financial Accounts | |
Other | |
Decision Date Range | Calendar Start and End Date Selection |
Request Type | Agency-specific program and/or category designations |
County | 01 Kent |
03 New Castle | |
05 Sussex | |
Office | (Values dependent on County) |
Unit | (Values dependent on Office) |
Worker ID | (Values dependent on Unit) |
Undisclosed Accounts | Yes |
No | |
Undisclosed Properties | Yes |
No | |
Historical Case Errors | Yes |
No | |
AVS Summary | 1 – Under Resources |
2 – Over Resources | |
Transfer Flag | Yes |
No | |
Property Flag (in development) | Yes |
No | |
Excluded Account Flag | Yes |
No | |
Case Entry Type | Batch |
Ad-Hoc | |
Case Type | Application |
Renewal |
- Enter report parameters, as shown above in the table, combination, and select ‘Run Report’;
- The default report is ‘Summary Report’;
- To generate a ‘Detail Report, click ‘Detail Report’ from the toggle and click ‘Run Request’;
- To Export a report, select ‘Export Drop-down Menu’ to select an export format.
- To generate other standard reports, select either ‘Case Error Report, Site Access Audit Report or Ad Hoc Request Report’ from ‘Reports’ drop-down and complete requested fields before selecting ‘Run Request’; See descriptions below:
- PCG tracks and monitors all user activity within the AVS Web Portal and provides standard Site Access Audit Reports and Case Access Audit Reports, each of which can be generated by authorized user roles at the push of a button.
- The Site Access Audit Report includes a log of each user’s login and logout dates and times and can be customized by the user to include specific date ranges, counties, offices, units, and/or workers.
- The Case Access Audit Report date and time stamps of a user’s access to specific cases based on worker ID. Either the worker ID, or case/registry number are required fields. For the example below, and start/ end date were selected as well as a district (county), and a user’s worker ID. The results then show which exact cases that user has accessed in the selected timeframe.
- Users could choose to simply select the case or registry number along with the desired timeframe and see the list of users that have accessed the specific case being searched.
- Each of these user management reports can be exported and/or printed in commonly used formats; including Excel, Word, PDF, and more.
- User actions that modify data and visits in “view only” context to the Portal defined by the user’s role are recorded by the PCG application. Audit records include information to identify the user performing the action, date/time of change, fields modified, change type, system area of occurrence, and any users associated with the modification. All non-authenticated access attempts to the application as well as all HTTP requests for authenticated users are logged and archived. Information exchange with the database is stored within transaction logs. Authorized user access and changes to secure PCG resources, such as FTP, are recorded.
Was this article helpful?
0
Thanks for your feedback!
Please complete the Comments or Suggestions form below
Comments or Suggestions?
We want Quest to be your source for important information that you need to succeed at in your work but we need your help:
Was this article helpful? Was it missing something you needed to get the job done?
Tell us what you think, what you know about this article. What are we doing well, and what we could do better.
All fields are required.