Participation Loan Delinquency Analysis

Screen ID:  LPLDEQSC-01
Screen Title:

Participation Loan Delinquency Analysis Report
Panel ID: 5667
Tool Number: 578
Report Name: LPLDEQ Click here to magnify

Access this screen by selecting Tool #578 Particip. Loan Delinquency Analysis Rpt.

Helpful Resources

Visit Show Me the Steps for easy instructions on using Automated Reports to create, change, and delete report settings.

Screen Overview

This report identifies delinquent participation loans by investor. The investor owned portion of delinquent balance is listed in the appropriate day range. It is modeled after the Loan Delinquency Analysis which lists the CU owned portion of the delinquency.

This report can be run anytime that you want to review the delinquency position of your participation loans. The report will page break by investor.

The loan delinquency analysis is broken down by to 60-89 days and 90-179 days to match the delinquency day ranges required by the NCUA for the 5300 Call Report.

Check the box next to Export to file to create a file for use in CU*BASE Report Builder (Query) or Member Connect.

How Do I Save/Retrieve My Report Settings?

For more details on setting up this feature, refer to the Automating Reports and Queries booklet, available on the CU*BASE Reference page. 

This report can be used with the “Report Scheduler,” a time-saving automation feature that allows you to select and save the filters you use to run several commonly used reports and then set these reports to be run automatically by our operations staff on the first of the month.  Or you can save the settings and run them manually by yourself at any time.

To save your report settings, first select your filters, including printer (can be a physical printer or the HOLDxx or MONTHxx OUTQs).  Then select Save Settings (F24).  On the next screen name your settings (we recommend adding your name!), and designate whether you wish to run this manually or if you wish for operations to run the report.  At a later time, use Retrieve Settings (F23) to populate the screen with the settings you have saved.  You can also edit your settings using Retrieve Settings (F23).  All saved settings can be viewed on the Report Automation: Standard Reports screen.

Field Descriptions

Field Name

Description

Process Date

Specify the month and year to process the participation loan delinquency analysis.

PL Investors

This is a select button that allows you to print a trial balance for a single or multiple investors. Select the button to reveal a screen to select one or more loan investors.

The number that displays next to the select button is the number of investors selected. If you want all investors, leave the field blank and all investors will print. Default is all.  

Report type

Select to view either a summary report or a detail and summary report.

Include 30 to 59 day call report term

Check this box to include the 30-59 delinquency day range on the report.

Export report to file

Check this box to create a file for use in CU*BASE Report Builder (Query) or Member Connect.

Pull by Account or Reference

Use this to specify whether the loans should be listed on the report by loan account number or by the PL reference number.

Report Sample

For complete details on the PL system, including configuring the necessary codes, creating participation loan records, processing investor settlement and using various reports, refer to the appropriate booklet.