THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set

PROCEDURE 44: MMTFCATEGORYLIST

The query returns a list of abbreviation codes and related descriptors for Taliesin Fellows membership, event registrations and donations, as well as subscriptions to the Journal of the Taliesin Fellows.

Note: The column labels shown within the query structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

PROCEDURE NOTES

Procedure TFCATEGORYLISTING calls on Table MMTFCATEGORY to return a list of 39 tracking abbreviations and descriptions for events, membership  and Journal of the Taliesin Fellows subscription status, and fundraising between 1991 and 2000 for the Taliesin Fellows organization. The procedure did not function in later versions of the database.

The query was intended to produce the following report:

CATEGORY ID   DESCRIPTION
     
S   RENEWAL MEMBERSHIP
D DONATION
9202   FEBRUARY MEETING AT BOWLER HOUSE (LLOYD WRIGH[T)]
9106   JUNE MEETING AT LAUTNER SILVERTOP HOUSE
9109   OCTOBER MEETING AT JOHN BENTON'S HOUSE
P   PURCHASE OF JOURNAL NOT PART OF SUBSCRIPTION
G   Gift Membership
26T   JUNE '92 SATURDAY TOUR OF 4 BLOCK HOUSES
26P   JUNE '92 SUNDAY PICNIC AT ERIC & MARY WRIGHT
26L   JUNE '92 MONDAY OPEN HOUSE AT JOHN LAUTNER OF [--]
9210   STEWART HOUSE MEETING
9206   WRIGHT BIRTHDAY EVENTS 1992, SAT/SUN/MON
9304   1993 WRIGHT WEEKEND/GREEN/DUKE/QUINAN
9306   In The Cause of Architecture 1993
9312   General Meeting at John Benton
9421   Lovell House Tour, Newport Beach
WWP   WW PETERS MEMORIAL SCHOLARSHIP FUND
9441   B[ruce] B[rooks] Pfeiffer & Pedro Guerrero lectures
9442   Oboler Estate Tour
9440   FRANK LLOYD WRIGHT WEEKEND, 1994
9460 IN THE CAUSE OF ARCHITECTURE 1994
COMP   COMPLIMENTARY MEMBERSHIP
94A1   ABLIN HOUSE MEETING
9541   AULDBRASS PLANTATION TOUR
9561   IN CAUSE OF /95: LAUTNER RETROSPECTIVE
NS   NEW MEMBERSHIP
DS RENEWAL DONOR GIFT MEMBERSHIP
NDS   NEW DONOR GIFT MEMBERSHIP
BS   BOOKSTORE SALES
9581   Jim DeLong House Tour
DJ   Donation to the Journal
LIBF   FLLW LIBRARY BOOK FUND
95C1 1995 Meeting at John Benton
9661   Lloyd Wright Week End/House Tour/Symposium
9691   Annual Meeting at San Francisco
96C1   Annual Meeting at John Benton's
KM   Kassler Memorial Fund
9961   Picnic at Eric Wright's
0061   Frank Lloyd Wright Picnic at Eric Wright's

The query structure is the same or similar to Procedure 7: TFCATEGORYLISTING and Procedure 14: TFCATEGORYLISTING in Database JGDB10; and Procedure 56: TFCATEGORYLISTING in Database JGDBFULL.

Database Search

Search based on this procedure cannot be executed through the version of the database available on the website; however, the complete contents of the table are presented above.

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDBFULL Procedure 44 query image

Report Format

JGDBFULL Procedure 44 report image 

Document: Dataease Procedure Definition Printout (PDF)