CBX Query: Q-Certificate (MEMBER3)

This Query is used to view information in the core “MEMBER3” file. This file stores financial information used in the tracking of certificate (CD) account types.

Specifications

File(s) used by this Query: MEMBER3

Access: Tool #193: Certificate Accounts (MEMBER3)

Records will be grouped according to CD Type, 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 Number
CD Application
Issue Month, Issue Day, Issue Year
CD Type
Tax Social Security/TIN
IRA* Maturity Month, Maturity Day, Maturity Year
(*Indicates whether or not the account is an IRA)
Branch Number
Dividend Disbursement Code
Account Number
Dividend Disbursement Frequency
Account Suffix
Renewal Code
CD Dividend Rate
Dividend Transfer Account Number
CD Variable Rate Code
Dividend Transfer Account Suffix
Current Balance Renewal Account Number
Accrued Dividend Renewal Account Suffix
Open Month, Open Day, Open Year

Sample Conditions

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

Description		Field	Test	Value
Show all certificate accounts which have a balance over $20,000 and are maturing in the months of September, October or November of 1996.	AND AND	CURBAL MATYR MATMTH	GT EQ RANGE	100000.00 96 09 11
List all CDs earning dividends at or over 4.500%.		CDDVRT	GE	4.500
List all CDs with a renewal code of “0” (do not auto renew).		CDRENW	EQ	0