THE GEIGER DATABASE


DATA TABLE STRUCTURES

DATABASE JGDBFULL TABLES

Along with the same 31 table structures found in Database JGDB10 and preceding similar versions, the older Database JGDBFULL (ca. 1994 to 2000) contains an additional 31 tables whose data records relate to activities of the Taliesin Fellows organization. The 11,062 records in these tables refer largely to membership, meetings, fundraising events, and subscription and production management of the Journal of the Taliesin Fellows from the early 1990s until 2000. Most of these tables are not accessible through the version of the database served on the website.

TABLE INVENTORY

Table: CostInTheMail

The structure of this table was designed to record costs related to the mailing of the Journal of the Taliesin Fellows.

Table: CurrentCode

The structure of this table was designed to categorize solicitation mailings for the Taliesin Fellows and the Frank Lloyd Wright Conservancy.

Table: JTFCostBreakdown

The structure of this table was designed to report a production cost breakdown for issues of the Journal of the Taliesin Fellows.

Table: JTFOnHand

The structure of this table was designed to record an inventory of back issues of the Journal of the Taliesin Fellows (JTF).

Table: JTFProfitLoss

The structure of this table was designed to produce an extensive profit and loss analysis for the Journal of the Taliesin Fellows.

Table: Meet Line Items

The structure of this table was designed to record registration information for participants in events held by the Taliesin Fellows.

Table: Meet Location

The structure of this table was designed to record events or meetings held by the Taliesin Fellows.

Table: MMTF/Journal/Cost

The structure of this table was designed to record financial information for issues of the Journal of the Taliesin Fellows (JTF).

Table: MMTFCategory

The structure of this table was designed to record an abbreviation code and related description for Taliesin Fellows membership, event registrations and donations, as well as subscriptions to the Journal of the Taliesin Fellows.

Table: MMTFEventMailerCost

The structure of this table was designed to record total cost for events held by the Taliesin Fellows and issues of the Journal of the Taliesin Fellows.

Table: MMTFFLLWLibraryFund

The structure of this table was designed to record total donations to the William Wesley Peters Memorial Scholarship Fund at the Frank Lloyd Wright School of Architecture at Taliesin West in Scottsdale, Arizona.

Table: MMTFFLLWLIBRARYLINEITEMS

The structure of this table was designed to record individual donations to the William Wesley Peters Memorial Scholarship Fund at the Frank Lloyd Wright School of Architecture at Taliesin West in Scottsdale, Arizona.

Table: MMTFJDISTRIBUTIONREC

The structure of this table was designed to manage inventory and shipping of the Journal of the Taliesin Fellows to retail outlets, university libraries, organizations, and individuals.

Table: MMTFMAILCOST

The structure of this table was designed to record costs for mailings sent by the Taliesin Fellows, including event notifications, press releases, and subscription and renewal solicitations for the Journal of the Taliesin Fellows.

Table: MMTFMEETING List

The structure of this table was designed to record program titles and descriptions of events held by the Taliesin Fellows.

Table: MMTFMEETPEOPLE

The structure of this table was designed to record registration information for participants who attended multiple events of the Taliesin Fellows.

Table: MMTFNLSF

The structure of this table was designed to record donation and membership information for the Taliesin Fellows.

Table: MMTFPUBLICATIONREC

The structure of this table was designed to record production and mailing costs for the Journal of the Taliesin Fellows.

Table: MMTFSubEventMailCost

The structure of this table was designed to record miscellaneous administrative and event expenses for the Taliesin Fellows.

Table: MMTFTALINFO

The structure of this table was designed to track dates related to a biographical questionnaire sent to members of the Taliesin Fellows.

Table: MMTFTALINFORMS

The structure of this table was designed to categorize various forms used to solicit biographical information about the Taliesin Fellows.

Table: MMTFWWPETERS

The structure of this table was designed to record total donations to a memorial fund for William Wesley Peters.

Table: Peter Line Items

The structure of this table was designed to record individual donations to memorial fund honoring William Wesley Peters.

Table: SUB LINE ITEMS

The structure of this table was designed maintain subscription information for the Journal of the Taliesin Fellows.

Table: TALINFO LINE ITEMS

The structure of this table was designed maintain subscription information for the Journal of the Taliesin Fellows.

Table: TFBio

The structure of this table was designed to record the receipt of biographical files related to the Taliesin Fellows.

Table: TFEditorialCosts

The structure of this table was designed to record editorial costs for an issue of the Journal of the Taliesin Fellows.

Table: TFGraphicCosts

The structure of this table was designed to record graphics costs for an issue of the Journal of the Taliesin Fellows.

Table: TFJTFCost

The structure of this table was designed to summarize costs and revenue for issues of the Journal of the Taliesin Fellows.

Table: TFPrintingCosts

The structure of this table was designed to analyze printing costs for issues of the Journal of Taliesin Fellows.

Table: TFSubEditorialCosts

The structure of this table was designed to record miscellaneous editorial costs for issues of the Journal of the Taliesin Fellows.

Table: TFSubGraphicsCost

The structure of this table was designed to record miscellaneous graphical costs for issues of the Journal of the Taliesin Fellows.