This report is produced when Loan Advances is selected from the Reports drop-down list. The report is a listing of all loan advances that were made during the specified date period. A loan advance can be any of the following:
A new loan for a new borrower
A new loan for an existing borrower
A disbursement for an existing borrower loan
A grand total of the loan advances is also provided.
When Loan Advances 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:
The following is a sample Loan Advances report:
The data elements which comprise the Loan Advances report are described in the following table:
|
Column Name |
Description |
|
Borrower Detail Lines |
|
|
SSN |
Borrower's social security number. |
|
Borrower Name |
Borrower's name, formatted as "Last Name", "First Name". |
|
Loan Name |
The Loan Name and Sub Name (if any). |
|
Advance Date |
The date of the payment (transaction date). |
|
Advance Type |
Indicates if the advance represented a new loan, or a disbursement to an existing loan. |
|
Advance Amount |
The amount of the loan advance. |
This report retrieves all Ledger records (and associated Loan and Customer information) from the CLM database that meets the following conditions:
The ledger record transaction date occurs within the specified time range
The transaction type and subtypes indicate a loan advance transaction.
A separate report detail line is created for each loan advance. The detail lines are sorted by borrower SSN, loan name, and loan advance (transaction) date.