THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: SUB LINE ITEMS
The structure of this table was designed maintain subscription information for the Journal of the Taliesin Fellows (JTF) and track attendance at events held by the Taliesin Fellows.
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.
Table SUB LINE ITEMS contains 4,924 rows arranged in 19 columns.
Entries record individual donations and payments to the Taliesin Fellows, including amount, type, method, date, and related financial details from December 10, 1990, through December 24, 2000.
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: [RECORD NUMBER] records a row number related to Column [RECORD NUMBER] of Table MMTFNLSF.
Column: [THRU ISSUE #] records the number of an issue of the JTF.
Column: [RSL#] records a unique (but not always sequential) number as a row identifier.
Column: [METHOD PAY] records a text character to indicate method of payment (e.g. "C" [check], "$" [cash], [Mastercard], or "V" [VISA].)
Column: [CHECK #] records a check number for payment received.
Column: [CHECK DATE] records a date in month/day/year format.
Column: [AMOUNT] records a payment amount.
Column: [COMMENTS] records a note indicating subscription status, invoicing, or similar details; alternatively may contain text referenced from Column [DESCRIPTION] of Table MMTFCATEGORY.
Column: [MEMBER50] is void of entries in all rows.
Column: [DONATION] records a number through field calculation relating to Column [CATEGORY].
Column: [S] records "YES" or "NO" to indicate subscription.
Column: [NS] records the same value found in Column [S], above
Column: [CONT2] records "YES" or "NO" to indicate subscription status.
Column: [CONT4] records "YES" or "NO" to indicate subscription status in 1999.
Column: [CONT6] records "YES" or "NO" to indicate subscription status in 2000.
Column: [DATE] records a date in month/day/year format, referenced from Column [ENTRY DATE] of Table MMTFNLSF.
RELATED QUERY PROCEDURES
The data in this table is referenced in 4 query procedures devised by Geiger: