CBX Query: Q-LOC (MEMBER6)

This Query is used to view information in the CBX “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. 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'

 

For complete instructions on navigating the “Display Report” screen and using the available buttons, see Displaying a Custom Report as an Online Inquiry.