Collections Outflow Report

This report is produced when Collections Outflow is selected from the Reports drop-down list. The report is a listing of all borrowers/loans that have been removed from collections during a specified time period. The time period is indicated by supplied Begin and End Date parameters. The report information is organized by Collection Queue, Transaction Date, SSN, and Loan Name/Sub Name.

Parameter Entry

When Collections Outflow is selected, the top portion of the Reports screen is replaced with a parameter entry window as shown in the following example:

The user should enter the desired Begin and End Dates and then click the Submit button to generate the report. Both date values are required; the CLM system defaults these to the current date. If a date value is not entered, or an invalid date is entered, the following error message will be displayed:

Sample Report

The following is a sample Collections Outflow report:

Report Composition

The data elements which comprise the Collections Outflow report are described in the following table:

Column Name	Description
Collection Queue Group Heading
Queue Name	This is the Collection Queue name .
Detail Lines
SSN	Borrower's social security number.
Borrower Name	Comprised of "Last Name" , "First Name".
Loan Name	This is the loan name.
Loan Sub Name	This is the loan sub name.
Outflow Date	The date this loan was removed from the collections queue.
Collection Queue Totals Line
Borrower Count	The total number of distinct borrowers removed from this queue.
Loan Count	The total number of loans removed from this queue.
Report Totals Line
Borrower Count	The total number of distinct borrowers removed from Collections.
Loan Count	The total number of loans removed from Collections.

Record Selection Criteria

This report retrieves all Collections History records (and associated Loan and Customer information) from the CLM database that meets the following conditions:

• The history record reflects/references a "RCL" transaction

• The history record transaction date falls within the supplied Begin/Date parameters.

A separate report detail line is created for each history record that is retrieved from the database. The detail lines are grouped by Collection Queue, and then sorted by transaction (outflow) date, SSN, loan name and loan sub name.