CU*BASE Query: Q-LOC (MEMBER6)

This Query is used to view information in the CU*BASE “MEMBER6” file. This file stores financial information used in the tracking of open-credit loan account types. This file represents the OC application where loans have the ability for automated disbursement.

Specifications

File(s) used by this Query: MEMBER6

Access: Tool #481: LOC Accounts (MEMBER6)

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 GL Account #
Branch Number Variable Interest Rate Code
Loan Category Payment Amount
Processing Type Payment Frequency
Account Number Next Payment Month, Day, and Year
Account Suffix Write Off
Current Balance YTD Interest Paid
Interest Due Partial Payments
Unpaid Fines Delinquent Months, Delinquent Days
Payoff Balance Opened Month, Day, and Year
Credit Limit Security Code
Available Credit (contingent liability) Purpose Code
Interest Rate Loan Officer ID

Sample Conditions

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

Description	Field	Test	Value
List all accounts with a contingent liability (disbursement limit minus current balance) of $1,000 or more. NOTE: This field is a special “result field” created specifically for this Query. See “Define Result Fields” for details on how this field type is created for a Query.	AVAIL	GE	1000.00
Show accounts more than 90 days delinquent.	DLQMTH	GT	90
List all open-credit loans which were authorized by a specific loan officer (employee ID “45”).	EMPLID	EQ	'45'