CBX Query: Q-Closed Certificate (ACHIST3)

This Query is used to view information contained in the core “ACHIST3” file. This file stores information about closed certificate (CD) type accounts.

Specifications

File(s) used by this Query: ACHIST3

Access: Tool #214: Closed Certificates (ACHIST3)

Records will be grouped by CD dividend application, CD type and branch. After each group, the system will show a total, average and count for all accounts within that group, with grand totals at the bottom of the report.

The following fields will be displayed in this Query:

CD Application
CD Type
IRA (indicates whether or not the account was an IRA)
Branch Number
Account Base
Account Suffix
Current Balance
Dividend Rate
Accrued Dividend
GL Account Number
Tax/Social Security Number
Maturity Month, Maturity Day, Maturity Year
Dividend Disbursement Code
Dividend Disbursement Frequency
Renewal Code
Issue Month, Issue Day, Issue Year
Open Month, Open Day, Open Year
Closed Month, Closed Day, Closed Year

Sample Conditions

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

Description

Field

Test

Value

Show all closed IRA certificate accounts.

IRAFLG

' I '

Show all accounts closed during the month of May, 1996.

AND

CLOSMO

CLOSYR