Detailed Loan Inquiry
Contents
- 1 Overview of IL407VIEW
- 2 View Button
- 2.1 Transaction Inquiry
- 2.2 Loan Documentation
- 2.3 Loan Payment History
- 2.4 Loan Payment Requests
- 2.5 Loan Tax Maintenance
- 2.6 Loan Change History
- 2.7 Loan Support Inquiry
- 2.8 Loan Insurance Maintenance
- 2.9 Loan Tickler
- 2.10 Loan Memos
- 2.11 Loan Calculator
- 2.12 Conversion History
- 2.13 Payoff Calculations
- 2.14 Loan Relief Maintenance
- 2.15 Transaction Reasoning
- 2.16 Risk Rating Details
- 3 Account Button
- 4 Processes Button
Overview of IL407VIEW
Under varied circumstances following the creation of a loan record, you will need to use the Financial Inquiry to access loan data. The Financial Inquiry is a flexible tool providing access to information about investments, loans, portfolios, and lines of credit. All of the functions described in this section are available only by using the Financial Inquiry to select a loan record.
The Financial Inquiry is usually accessible under the Financial Services folder in the DDI-Connect main menu. Launching it enables you to use the Loan field to enter the number of the loan you want to display. If unsure of this number, you can also click the adjacent button to search for the loan. To view detailed loan information:
- From the DDI Connect main menu, double-click Financial Services
- Double-click Financial Inquiry. You will see this screen:
In the Loan field, type the loan number you wish to view. As noted above, you can also click the list icon to view a list of all loans in the system. When you have entered the loan number, you can either click Find on the toolbar or press Enter to bring up the Detailed Loan Inquiry screen:
You have multiple tabs on this screen, along with other options via the View button on the toolbar. Those screens are detailed below.
Summary Tab
The loan summary tab looks like this:
The following information is displayed on this screen:
| Field | Description |
|---|---|
| Loan Type | Displays the code associated with this particular loan's Type |
| Regular payment amount | Displays the amount the borrower is expected to pay with each payment |
| Interest rate | Shows the current interest rate assigned to the loan |
| Last payment amount | Displays the total amount of the last payment made against the loan |
| Commitment date | The date that your organization committed to the loan |
| Last payment date | The date that the last payment was received in the system |
| Commitment amount | Amount that your organization has committed to loan to the borrower |
| Payment due date | Displays the date that the next loan payment is due |
| Commitment expiration | Date that the commitment expires. After this date, no loan advances can be made |
| Current investment support | If this loan is supported by investments, displays the total value of the supporting investments |
| Principal balance | Current principal balance of the loan |
| Close date | Date that the loan closed |
| Principal paid YTD | Total amount paid toward the loan's principal current year to date |
| Actual interest due | Accrued interest currently due on the loan |
| -Prepaid/+past due | Displays the amount, if any, that the loan is prepaid (displays as a negative number) or past due (displays as a positive number) |
| Last interest post date | Date that interest was last accrued and posted to the loan |
| Maturity date | Date that the loan will be paid off, assuming that all payments are made on time |
| Interest now posted | Interest now posted to the loan |
| First payment due | Date that the first payment was due for the loan |
| Interest paid YTD | Total interest paid year to date for the loan |
| Estimated payoff | Estimated amount required to pay off the loan |
| Status | Displays the code associated with the loan's current status |
| Amortization term | Displays the loan's amortization term (in months) |
| Total advanced | Total amount advanced to the borrower to date |
| Monitor/Processor | If applicable, displays the loan monitor and the loan processor codes |
| Original risk rating | Displays the loan's original risk rating, if applicable |
| Adjustment date | Displays the date of the last loan adjustment, if applicable |
| Current risk rating | Adjusted risk rating, if applicable |
| Current risk rating date | The date that the loan's risk rating was adjusted, if applicable |
Payments Tab
If you click the Payments tab, you will see the following screen:
These fields are displayed:
| Field | Description |
|---|---|
| Regular Payment | Amount to be paid for the regular loan payment |
| Special Payment | If a special payment is due, the amount of the payment |
| Payment Due Date | The date that the next regular loan payment is due |
| Special Payment Due | Date that the special payment is due, if applicable |
| Regular Payment Code | Code indicating the regular payment frequency for this loan |
| Special Payment Code | Code indicating the special payment frequency, if applicable |
| Actual Interest Due | Actual amount of interest currently due on the loan |
| Autopay Participant | Displays whether or not the borrower has set up the loan to be automatically paid via ACH |
| Last Interest Posted | Date that interest was last accrued and posted to the loan |
| Autopay Amount | If applicable, the amount that is automatically withdrawn from the borrower's account |
| Interest Comp Code | The code representing the loan's interest computation method |
| Autopay ABA # | If applicable, the borrower's bank routing number for their autopay account |
| Reserve Payment | If applicable, the reserve payment due with each loan payment |
| Autopay Bank Account | If applicable, the bank account used for this loan's autopay withdrawal |
| Reserve Balance | Amount currently available for reserve payments, if applicable |
| Next autopay date | If applicable, the date that the autopayment will next be withdrawn from the account |
| Change in Terms? | If any changes have taken place on the loan, displays a Y for yes. N would represent no changes to the loan |
| Autopay frequency | Code representing the frequency of the autopay for this loan |
| Principal Paid Total | Total amount paid to date toward the principal of the loan |
| Autopay account type | Code representing the type of account used for the autopay payment |
| Interest Total | Total amount in interest paid to date on the loan |
| Extra Payments | If applicable, total amount of extra payments made to date |
| Payments Reversed | If applicable, total amount of payments reversed to date for this loan |
Adjustments Tab
If you click the Adjustments tab, you will see this screen:
The following information is displayed on this screen:
| Field | Description |
|---|---|
| Adjustment Date | Date that the most recent loan adjustment was performed on this loan |
| Adjustment Frequency | Frequency in months when the loan will be adjusted |
| Amortization Date | Date on which the loan is expected to reach maturity |
| Adjust Method | Code representing the method used for the loan adjustment |
| Per Adjustment Cap | Maximum percentage allowed per adjustment, as established in the Loan Add/Maintenance |
| Lifetime Adjustment Cap | Maximum percentage allowed in the life of the loan, as established in the Loan Add/Maintenance |
| Original Interest Rate | Original interest rate for the loan |
| First Advance | Date that the first loan advance was issued |
| Total Advanced | Total amount of loan advances to date |
| Last Advance | Date that the most recent loan advance was issued |
| Total Re-advanced | If applicable, total amount of advances re-issued |
| Last Re-advance | Date of the most recent re-advancement on the loan |
| Total Interest Capitalized | Total amount of interest that has been capitalized for the loan to date |
Fees Tab
When you click the Fees tab, you will see this screen:
The following information is displayed on this screen:
| Field | Description |
|---|---|
| Application Fee Due | Amount currently owed for application fee |
| Closing Fee Rate | Rate used to calculate closing fee for the loan |
| Application Fee Paid | Amount paid for application fees on the loan |
| Closing Fee Paid YTD | Total amount of closing fees paid on the loan year to date |
| Application Fee Balance | If applicable, application fee balance owed on the loan |
| Closing Fee Paid | Total amount of closing fees paid on the loan |
| Application Fee Paid YTD | Total amount of application fees paid on the loan year to date |
| Late Fee Due | If applicable, total amount of late fees due on the loan |
| Late Fee Paid | Total amount of late fees paid over the life of the loan |
| Misc Fee Due | If applicable, miscellaneous fee balance owed on the loan |
| Misc Fee Paid | Total amount of misc fees paid over the life of the loan |
LSP Tab
When you click the LSP tab, you will see this screen:
The following information is displayed on the screen:
| Field | Description |
|---|---|
| Line # | If applicable, the line of credit # supporting the loan |
| Weighted Inv. Rate | If applicable, weighted investment rate for the loan's supporting investments |
| Block Out Code | Example |
| % Inv / Loan Balance | Calculated percentage of supporting investments to balance of the loan |
| Block Out Amount | Example |
| Required Inv. Support | Total amount of investments required for the support of this loan |
| Base Rate | Base interest rate for the loan |
| Inv. Support | Total amount of investments supporting the loan |
| Last LSP Review | Date that the LSP for this loan was last reviewed |
| Next LSP Review Date | Date that the next LSP review is scheduled for this loan |
| Rebate Amount | If applicable, the available rebate amount for the loan |
| Rebate Paid | Total amount of rebates paid for this loan over the life of the loan |
| Pool # | If applicable, the investment pool # supporting this loan |
| Pool Support % | Percentage of the investment pool supporting this loan |
Disbursement Tab
When you click the Disbursement tab, you will see this screen:
On the right side of your screen, you will see the Disbursements window. The lines display the date, type of disbursement and total amount of funds disbursed for the transaction. If you click on a line item in that window, the following information is available:
| Field | Description |
|---|---|
| Disbursement Code | Displays the code associated with the disbursement type |
| Disbursement ABA# | If applicable, the bank routing number associated with the account receiving the transferred disbursement funds |
| Disbursement Account | If applicable, the bank account receiving the transferred disbursement funds |
| Disbursement acct type | The type of account receiving the transferred disbursement funds |
| Wire Reference Memo | If applicable, the memo associated with the wire transfer |
| Disbursement PIN | The PIN and associated constituent information for the individual/organization receiving the disbursed funds |
Detail Button
If you click a line item in the Disbursements window and click the Detail button, the Transaction Detail screen will display. When you have finished viewing the information on the screen, click Exit to return to the Disbursements tab.
Before/After Button
If you click a line item in the Disbursements window and click the Before/After button, the Edit History screen will appear. When you have finished viewing the screen, click Exit to return to the Disbursements tab.
Miscellaneous Tab
When you click the Miscellaneous tab, you will see this screen:
The following information is available:
| Field | Description |
|---|---|
| Purpose Code | Code representing the loan's purpose |
| Extract # | Example |
| Cash Account | Code representing the loan's associated cash account |
| Last Transaction | The date that the last transaction was applied to the loan |
| Statement Code | Code representing the loan's statement preference setting on the Beneficiary/Remitter tab of the loan (Loan Add/Maintenance). You will see O (Original), C (Copy) or blank (None) |
| Denomination | Code representing the borrower's denomination, if known |
| Amortization Date | Date that the loan is expected to mature, assuming all payments are made on time |
| Interest Due Month | For interest only loans, this field displays the interest accrued and due this month |
| Delinquent | Displays whether or not the loan is delinquent (yes or no) |
| Security | Displays the code associated with the type of security provided for the loan |
| General Ledger | Displays the general ledger account assigned to the loan |
| Times Delinquent | Displays the number of times that the loan has been delinquent |
| Amount to be refinanced | The loan dollar amount to be refinanced through your organization. This field displays a positive amount while the loan has a setup status, and is automatically reduced to 0.00 when the first loan advance is made |
| Collateral Value | Value of the loan's collateral |
| Amount requested | Total amount requested by the borrower |
| Collateral value date | Date that the loan's collateral value was confirmed |
| Collateral value type | Displays the code associated with the loan's collateral value type |
Remitter Tab
When you click the Remitter tab, you will see a screen similar to this one:
If the loan has a remitter configured in the Loan Add/Maintenance, the remitter information will display on this screen.
View Button
The View button allows you to view multiple screens of information related to the loan. Select one of the options below to view the related screen
Transaction Inquiry
To view transaction history for this particular loan, click View and select Transaction Inquiry. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Loan Documentation
To view all documentation associated with a loan, click View and select Loan Documentation. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Loan Payment History
To view loan payment history, click View and select Loan Payment History. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Loan Payment Requests
To view loan payment requests from the Online-CEF product, click View and select Loan Payment Requests. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Loan Tax Maintenance
To view the loan's Tax Maintenance information, click View and select Loan Tax Maintenance. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Loan Change History
To view a loan's change history, click View and select Loan Change History. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Loan Support Inquiry
To view the loan's support information, click View and select Loan Support Inquiry. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Loan Insurance Maintenance
To view a loan's insurance information, click View and select Loan Insurance Maintenance. When you have finished viewing the information, click the Exit button to return to the Detailed Loan Inquiry screen.
Loan Tickler
To view loan tickler information, click View and select Loan Tickler. When you have finished viewing the information, click the Exit button to return to the Detailed Loan Inquiry screen.
Loan Memos
To view existing memos or add memos to the loan, click View and select Loan Memos. When finished, click the Exit button to return to the Detailed Loan Inquiry screen.
Loan Calculator
To view the loan calculator, click View and select Loan Calculator. When you have finished with the screen, click Exit to return to the Detailed Loan Inquiry screen.
Conversion History
To view the conversion history of a loan, click View and select Conversion History. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Payoff Calculations
To calculate a loan's payoff estimates, click View and select Payoff Calculations. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Loan Relief Maintenance
To view a loan's Relief Maintenance information, click View and select Loan Relief Maintenance. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry screen.
Transaction Reasoning
To view a loan's transaction reasoning, click View and select Transaction Reasoning. When you have finished viewing the screen, click Exit to return to the Detailed Loan Inquiry screen.
Risk Rating Details
To view a loan's risk rating details, click View and select Risk Rating Details. When you have finished viewing the information, click Exit to return to the Detailed Loan Inquiry.
Account Button
If you click the Account button on the toolbar, you will be taken to the borrower's Account Entry screen.
Processes Button
If you click the Processes button, you will be taken to the Process Maintenance screen. When you have finished viewing this screen, click Exit to return to the Detailed Loan Inquiry screen.
