Cancellation History Report

This report is produced when Cancellation History is selected from the Reports drop-down list. The report is a listing of all Cancellation benefit transactions that were made during the specified date period.

A separate detail line is produced for each transaction. Each detail line identifies the transaction date, SSN, principal, interest, late charge, collection cost and total transaction amounts. The report detail lines are grouped/sorted by:

Loan Name
Cancellation Type
Borrower SSN
Benefit Begins date.

Sub-totals of the amount fields are provided for each loan and cancellation type; grand totals are also provided.

Parameter Entry

When Cancellation History 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 Cancellation History report:

Report Composition

The data elements which comprise the Cancellation History report are described in the following table:

Column Name

Description

Loan Group Line

Loan Name

Name of the loans represented by this group.

Cancellation Type Group

Cancellation Type Code

The type of cancellation represented by this group.

Transaction Detail Lines

Date

This is the Benefit Begin Date of the Cancellation transaction.

SSN

Borrower's social security number.

Borrower Name

Borrower's name, formatted as "Last Name", "First Name".

Principal

The amount of the loan's principal balance that was cancelled.

Interest

The amount of the loan's interest balance that was cancelled.

Late Charge

The amount of the loan's late charge balance that was cancelled.

Collection Cost

The amount of the loan's collection cost balance that was cancelled.

Amount

The total amount of the cancellation transaction. This is the sum of the principal, interest, late charge and collection cost amounts.

Record Selection Criteria

This report retrieves all Loan Benefit history records (and associated Ledger, Loan, and Customer information) from the CLM database that meets the following conditions:

The transaction type and subtypes indicate a loan cancellation transaction.
The cancellation transaction Benefit Begins date occurs within the specified time range

A separate report detail line is created for each cancellation transaction. The detail lines are grouped by loan name and transaction type. The detail lines are also sorted by borrower SSN and benefit begins date.

Column Name	Description
Loan Group Line
Loan Name	Name of the loans represented by this group.
Cancellation Type Group
Cancellation Type Code	The type of cancellation represented by this group.
Transaction Detail Lines
Date	This is the Benefit Begin Date of the Cancellation transaction.
SSN	Borrower's social security number.
Borrower Name	Borrower's name, formatted as "Last Name", "First Name".
Principal	The amount of the loan's principal balance that was cancelled.
Interest	The amount of the loan's interest balance that was cancelled.
Late Charge	The amount of the loan's late charge balance that was cancelled.
Collection Cost	The amount of the loan's collection cost balance that was cancelled.
Amount	The total amount of the cancellation transaction. This is the sum of the principal, interest, late charge and collection cost amounts.