CU*BASE Query: Q-Master (MASTER)

The Q-Master Query is used to view information contained in the CU*BASE “MASTER” file. This file contains non-financial information used in tracking a membership.

Specifications

File(s) used by this Query: MASTER

Access: Tool 524: Membership Records (MASTER)

Records will be sorted in ascending order by Date Opened. The following fields will be displayed in this Query:

Individual/Organization (indicates whether individual or organization account)

Branch Number
Account Base
Name ID
First Name, Middle Initial, Last Name
Social Security/TIN
Address Lines 1 and 2
City, State, ZIP Code
birthdate
Birth Year
Area Code, Phone Number
Sex
Date Opened

Sample Conditions

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

Description	Field	Test	Value
List all members with a 49505 ZIP code.	ZIPCD	EQ	49505
List all members which were born between 1960 and 1970. AND	BRTHYR BRTHYR	GE LE	1960 1970
Show all members which have been flagged as having a “wrong address.”	WRADD	EQ	1