Asset Verification System: Generate a Report

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.PCG User activity 1. 
  • 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.PCG user login logs.  
  • 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.Login screen showing registry number.
  • 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?

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.