This report is produced when Account Totals is selected from the Reports drop-down list. The report is a listing of all borrowers that have one or more loans. A separate detail line is produced for each borrower. Each detail line identifies the borrower, the total number of loans the borrower has, and total principal balances for those loans. The report detail lines are grouped/sorted by:
Borrower Last Name
Borrower First Name
Social Security Number
Summary report totals are also provided.
The following is a sample Account Totals report:
The data elements which comprise the Account Totals report are described in the following table:
|
Column Name |
Description |
|
Detail Lines |
|
|
Borrower Name |
Borrower's name, formatted as Last, First MI |
|
Social Security Number |
Borrower's social security number. |
|
Borrower Loan Count |
Total number of loans (not deleted) for this borrower. |
|
Borrower Principal Total |
The total principal amount for all of the borrower's loans. |
|
Borrower Principal Paid Total |
The total principal paid amount for all of the borrower's loans. |
|
Borrower Principal Cancelled Total |
The total principal amount cancelled for all of the borrower's loans. |
|
Borrower Principal Defaulted Total |
The total principal amount defaulted for all of the borrower's loans. |
|
Borrower Principal Balance Total |
The total principal balance amount for all of the borrower's loans. |
|
Totals Line |
|
|
Loans Count |
The total number of loans (undeleted) for all borrowers. |
|
Borrowers Count |
The total number of borrowers in the system/school. |
|
Principal Amount |
The total principal amount of all loans in the system/school. |
|
Principal Paid |
The total principal paid amount of all loans in the system/school. |
|
Principal Cancelled |
The total principal cancelled amount of all loans in the system/school. |
|
Principal Defaulted |
The total principal defaulted amount of all loans in the system/school. |
|
Principal Balance |
The total principal balance of all loans in the system/school. |
This report retrieves all Loan data (and associated Customer information) from the CLM database that meets the following conditions:
The loan is not deleted
A separate report detail line is created for each borrower that is retrieved from the database.