Loan Quality Connect Job Aids

 

  • Contents

My web page

Dashboard Overview

Loan Quality Connect's Dashboard provides self-service reporting tools to manage loan quality. Logging in as a Manager, Document Technician, Lender Remediation Specialist, or a Lender DVC Specialist, you have the ability to access the Dashboard feature.

Note: See the Logging In and Out job aids for instructions on logging into Loan Quality Connect to access the Dashboard.

Team leads, managers, QC professionals, and executives want data on their review process and pipeline for many reasons. For day-to-day activities, data assists with analyzing team performance and highlights process challenges. For longer-term business decisions, quality and remediation metrics as well as the ability to analyze trends are necessary. The Dashboard is designed to meet these needs using the Daily Pipeline and Daily Status reports. You can also create custom reports, see loan level details, and save to Excel.

Composed of info graphic widgets, Daily Pipeline and Daily Status reports provide actionable data that is easy to understand. For example, the following Outstanding Requests widgets communicate the degree to which loan file and document requests are meeting their completion timelines.

Outstand Requests Widgeets

Outstanding Requests Widgets: Loan Files and Documents

Dashboard widgets were created in responses to lender-specific data needs. For example, lenders attending focus groups asked for the capability to measure metrics performance. In response, the Top 10 Document Types, Loan Review Defects, and Top 5 Defects widgets, shown below, provide the ability to track relevant patterns across an entire review population.

Top Ten Documents Requested Widgete

Top 10 Document Type Widget

 

Drill Down into Loan Details

Loan Level Detail for Income Not Documented Defect

Note:  Many of the widgets allow you to hover over a data point to produce loan level details that can be exported to Excel.

 

Loan Review Defects (by Type) and Top 5 Defects Widgets

Loan Defect Levels

As shown above, three defect levels (i.e., Findings, PAL (Price Adjusted Loan), and Significant Defect) are assigned to loans in the Daily Status report. Each defect is represented with colored bars as mapped in the legend at the bottom of the report. Each defect is explained below.

Findings Defect

A finding is one or more defects that, when considered with other loan features, does not necessitate a change in the price of the loan or result in the loan being unacceptable even if the true and accurate facts about the loan had been known at the time Fannie Mae purchased or securitized the loan.

PAL Defect

A price-adjusted loan (PAL) has one or more defects that, when considered with other loan features and based on the facts of the loan as purchased or securitized by Fannie Mae, result in a loan that was otherwise eligible for delivery had the correct data been delivered and LLPA been paid to Fannie Mae by the lender.

Significant Defect

A Significant Defect is one or more defects that either necessitates a change to the price on which the loan was acquired or result in the loan being unacceptable for purchase had the true and accurate information about the loan been known at time of purchase. Loans with findings and PALS are not loans with significant defects.

Daily Report Widgets

The Daily Pipeline and Daily Status reports are displayed by selecting Dashboards on the left navigation menu. The following table lists the widgets in each daily report and links to an image of the widget.

Note: Refer to the Customizing Dashboard Reports for instructions on creating custom reports.

Daily Pipeline Report

Daily Status Report

 

 

Daily Pipeline Report Widgets


The Total Outstanding Requests widget shows the number of pending requests for both full loan files and individual missing documents.

Total Outstanding Requests


Loan File and Document Requested: The Loan File widget on the left shows the number of loan files requested and delivered over a one-week (5 business days) period. The Documents widget reflects the timing of individual document requests based on the timing of the request. Documents Requested (Before Review), reflect requests for documents from a pre-underwriting review. Documents Requested (During Review), reflect requests for documents during the underwriting review process.

 
The Outstanding Requests: Loan Files widget shows the number of initial loan file requests or follow-up requests (if the original submission was rejected by Fannie Mae for some reason) that are outstanding along with the service level agreement (SLA) bucket that the requests fall into (i.e., In SLA, Near SLA or Outside SLA). The bar graphs to the right display the count of loans file requests that are expiring on particular days within a week.  

The Outstanding Requests: Documents widget shows the number of Loan File requests that are outstanding (i.e., Missing or Defective) along with the SLA bucket they fall into (i.e., In, Near or Outside SLA). The bar graphs to the right display the count of document requests that are expiring on particular days within a week. 

Refer to the Service Level Agreements job aid for details on the number of days you have to respond to or complete a request in Loan Quality Connect.

Outstand Requests: Loan Files and Documents


The Documents Requested widget displays both the Top 10 individual documents requests as well as the number of missing documents based on category. The Documents Requested widget provides detail on both missing documents and defective documents that were delivered.  

Top 10 Document Types


The Loan Status widget provides the status of all open full file or data only reviews. Statuses circled in red indicate that some Lender action is required. You may see the number of loans impacted by a status by clicking on the number in the circle. The loan numbers can be exported to an Excel spreadsheet.

Note: The Loan Status report does not separately list a count for loan quality defect notices, instead they are included in the Resolution Requested Significant Defect(s) count under the Remediation in Progress grouping.

 
The Reviews widget shows the number of loan reviews closed within a 30-day period and the defect results during that period.

 

Daily Status Report Widgets

On the left below, the Selection Activity widget displays BI cards with Lender Self Report or Voluntary Repurchase activity, indicating how many requests have an activity status of Submitted, Proceed, Defer and how many require Additional Information.

To the right below, the Outstanding Remediation Activity widget displays BI cards with the count of loan reviews in each indicated state of the remediation process.

The Loan Review Defects widget displays loan counts for Findings, PAL, and Significant Defects. The right side displays the Top 5 Defects assigned along with the loan count. This also includes Findings, PAL and Significant Defects.

Loan Review DefectsTop 5 Defects

Clicking a number card within a widget displays all of the loan numbers impacted. The loans numbers can be exported to an Excel spreadsheet.

Back to Top

© 2018 Fannie Mae. Trademarks of Fannie Mae.