THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set
PROCEDURE 56: TFCATEGORYLISTING
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 (JTF).
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 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 similar to Procedure 44: MMTFCATEGORYLIST found in Database JGDBFULL. Other versions can be found in PROCEDURE 7: MMTFCATEGORYLIST and Procedure 14: TFCATEGORYLISTING in Database JGDB10.
Database Search
Search based on this procedure cannot be executed through the version of the database available on the website however, the complete content of the table is shown above.
ORIGINAL DATAEASE PROCEDURE SCREENS
Query Structure
Report Format
Document: Dataease Procedure Definition Printout (PDF)