THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET
PROCEDURE 21: TFENTIRENAMESLIST
The query returns a complete list of all Taliesin Fellowship Apprentices, Taliesin Fellows members, and others recorded in the database as belonging to the Frank Lloyd Wright community.
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 TFENTIRENAMESLIST calls on Table MMFNL with extensive filters applied on Column [ID CODE 1] to exclude various categories ("*NP*", for non print record; "*FA*", for Wright family members; "*AIA*", for American Institute of Architects; "*AS*", for Architectural School; "*NX*", for address unknown; "*MU*", for resident summer musicians at Taliesin; "*PG*", for progeny of Taliesin Fellowship members; "*WS*", for Frank Lloyd Wright Foundation staff; "TFLA*", whose meaning is undetermined; and "*SP*", for spouse of Taliesin Apprentice or other), as well as excluding values on Columns [COMPANY] and [ADDRESS LINE]. The abbreviations for most of the filter terms can be found in Table MMTFID. The report format was dated October 28, 2000, and produced a directory of contact information with 3,234 entries.
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)