CU*BASE Query: Q-Collections - Loans (COLL)

This Query is used to view information contained in the CU*BASE “COLL” file. This file stores collections information, and this Query is designed to show all delinquent loan accounts.

Specifications

File(s) used by this Query: COLL

Access: Tool #226: Collections (COLL) - Delinquent Accounts

Records will be sorted first by delinquency category, then by number of months and days delinquent. A grand total and count will be shown at the bottom of the report.

The following fields will be displayed in this Query:

Delinquency Category
Delinquent Months
Delinquent Days
Member Name
Account Base
Account Suffix
Current Balance
Branch Number
Last Contact Date
Last Transaction Date
Corporate ID
Status

Sample Conditions

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

· IMPORTANT: Notice the default condition that is already entered for this Query. Because this condition is important to perform the Query properly, be sure to leave it as is and add any other conditions below it.

Description

Field

Test

Value

Show all loans that are at least 3 months delinquent with a balance over $100.00.

AND

CMRTYP

CMDQMO

CMCBAL

'D'

100.00