THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: MMTFNLSF
The structure of this table was designed to record donation and membership information for the Taliesin Fellows
Note: The column labels shown within the table structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.
Table MMTFNLSF contains 1,346 rows arranged in 10 columns.
Entries record subscription dates, amounts, and other management information reflecting subscriber status and serial donations to the Taliesin Fellows from December 13, 1992 through January 1, 2001.
The content of this table is not accessible through the version of the database available on the website.
ORIGINAL DATAEASE FORM SCREEN
Document: DataEase table definition printout (PDF)
Column: [ENTRY DATE] records a date in month/day/year format.
Column: [PREVIOUS YEAR DONAT] records a dollar amount of donations for a previous year.
Column: [JOURNAL SUBSCRIBER] records an issue number for the JTF through lookup on Column [THRU ISSUE #] of Table SUB LINE ITEMS.
Column: [YR/DATE DONATION] records a dollar amount of donations for the current year.
Column: [CONTRIB] records "YES" in all rows.
Column: [CONTRIB3] records "YES" in all rows.
Column: [CTRIB5] records "YES" in all rows.
Column: [TOTAL AMOUNT] records a total dollar amount of financial contributions through calculation formula of Column [AMOUNT] of Table SUB LINE ITEMS.
RELATED QUERY PROCEDURES
The data in this table is referenced in 7 query procedures devised by Geiger: