THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set
PROCEDURE 83: TFBOGARTMAILLIST
The query returns a mailing list for the Taliesin Fellows in California.
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 TFBOGARTMAILLIST calls on Table MMTFNL with filters on Column [ID CODE 1] to include Taliesin Fellows members (*TF*) and exclude a variety of other conditions ("*DC*", for deceased; "*NX*", for address unknown, "*NP", for records not meant to be printed; "*TFLA*", whose meaning is undetermined [but likely meant Taliesin Fellows living in Los Angeles]; and "*SP*", for spouse of Taliesin Apprentice or other). The abbreviations for most of the filter terms can be found in Table MMTFID. The query also filters applied on Column [ZIP] to limit returns to addresses located in California. The report format is dated August 29, 2000, and produced a directory of mailing addresses. The list was probably preparedfor the use of Paul Bogart, who was President of the Taliesin Fellows following the resignation of John Geiger from that position.
Database Search
Search based on this procedure cannot be executed through the version of the database available on the website.
ORIGINAL DATAEASE PROCEDURE SCREENS
Query Structure
Report Format
Document: Dataease Procedure Definition Printout (PDF)