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 NOTES

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 table provides lookup relationships with columns of Table MEET LINE ITEMS, and relies on lookup relationships with columns of Tables MMTFNL, MMTFNLSF, CURRENTCODE, and MMTFCATEGORY.

Database Search

The content of this table is not accessible through the version of the database available on the website.

ORIGINAL DATAEASE FORM SCREEN

JGDBFULL Table SUB LINE ITEMS image

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [RECORD NUMBER] records a row number related to Column [RECORD NUMBER] of Table MMTFNLSF.

Column: [SUB REC#] records a number related to Column [SUBSCRIPTION REC #] 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: [CATEGORY] records another abbreviation (e.g., "S" to indicate a subscriber of the JTF; other abbreviations used can be found in the contents of Table MMTFCATEGORY).

Column: [CURRENTCODE] records abbreviation codes referenced in Columns [RECORDNUMBER] and [RECORD NUMBER2] of Table CURRENTCODE.

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: