CU*BASE Query: Q-Closed Loan (ACHIST5)

This Query is used to view information contained in the CU*BASE “ACHIST5” file. This file stores information about closed loan accounts.

Specifications

File(s) used by this Query: ACHIST5

Access: Tool #216: Closed Loan Accounts (ACHIST5)

Records will be grouped by loan category and branch. After each group, the system will show a total, average and count for all accounts within that group, with grand totals at the bottom of the report.

The following fields will be displayed in this Query:

Branch Number Total Payments
Loan Category Payments Left
Processing Type GL Account #
Account Base Write Off Indicator
Account Suffix YTD Interest Paid
Current Balance Last Pmt Month, Day, and Year
Interest Due Partial Payments
Unpaid Fine Delinquent Balance
Payoff Balance Purpose Code
Interest Rate Security Code
Payment Amount Open Month, Open Day, Open Year
Payment Frequency Closed Month, Closed Day, Closed Year
Variable Interest Rate Code

Sample Conditions

The following table lists a few sample conditions which can be used in the Closed Loan Query.

Description

Field

Test

Value

Show all car loans (purpose code “11”) which were paid off and closed in the past three months.

AND

LNTYPE

CLOSMO

CLOSYR

'11'

Show all accounts closed during the month of May, 1996.

AND

CLOSMO

CLOSYR