CU*BASE Query: Q-Loan (MEMBER5)

This Query is used to view information in the CU*BASE “MEMBER5” file. This file stores financial information used in the tracking of loan account types. This file represents the LN application where all loans require manual disbursement.

Specifications

File(s) used by this Query: MEMBER5

Access: Tool #453: Loan Accounts (MEMBER5)

Records will be grouped according to Loan Category and Branch number, with each group sorted in ascending order by Account Base. After each group, the system will show a total, average, and count for all accounts in that group, with grand totals at the bottom of the report.

The following fields will be displayed in this Query:

Corporate ID
Variable Rate Code
Branch Number
Total Payments
Loan Category
Payments Left
Processing Type
GL Account #
Account Number
Write Off
Account Suffix
YTD Interest Paid
Current Balance
Last Payment Month, Day, and Year
Interest Due
Partial Payments
Unpaid Fines
Delinquent Balance
Payoff Balance
Loan Officer
Interest Rate
Purpose Code
Payment Amount
Security Code
Payment Frequency

Sample Conditions

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

Description		Field	Test	Value
Show all loan accounts with any unpaid delinquency fines.		FINAMT	GT	0.00
List all loans for new cars (purpose code “11”) with a current balance over $25,000.	AND	LNTYPE CURBAL	EQ GT	'11' 25000.00
List all loans with a delinquent balance of $1,000 or more.		DLQBAL	GE	1000.00