THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: CURRENTCODE
The structure of this table was designed to categorize solicitation mailings for the Taliesin Fellows and the Frank Lloyd Wright Conservancy.
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 NOTES
Table CURRENTCODE contains 13 rows arranged in 3 columns.
Entries record abbreviations and descriptions of membership and subscription mailings. The abbreviations are constructed to begin with "RR" for renewal mailings and "SR" for solicitation mailings. Row values found in Columns [RECORDNUMBER] and [RECORDNUMBER2] are identical due to the table structure; see DataEase Table Definition printout, below.
The table contains the following records:
| RECORD NUMBER | RECORD NUMBER2 | DESCRIPTION | ||
| RR85 | RR85 | Renewal Response May 1998 mailing | ||
| RR?A | RR?A | "A" designation is December | ||
| SRTF?? | SRTF?? | Solicitation Response TF never member | ||
| SRWC?? | SRWC?? | FLLW Conservancy Solicitation | ||
| SRPR?? | SRPR?? | Public Relations mailings | ||
| SRLM8B | SRLM8B | Lapsed member solicitation 0017/0022 | ||
| SRWB?? | SRWB?? | website response | ||
| RR8B | RR8B | Renewal Response for November 1998/198 | ||
| SRTF91 | SRTF91 | Apprentices never subscriber | ||
| RR92 | RR92 | Renewal solicitation <0027, >0021 | ||
| RR9C | RR9C | Membership renewal Dec. 1999 | ||
| RR09 | RR09 | Responses from JTF #26 mailing |
The table provides a lookup relationship for Column [CURRENTCODE] of Table SUB LINE ITEMS.
Database Search
The content of this table is not accessible through the version of the database available on the website, but is presented above in full, above.
ORIGINAL DATAEASE FORM SCREEN
Document: DataEase table definition printout (PDF)
COLUMN LABELS
Column: [RECORDNUMBER] records an abbreviation code related to Column [DESCRIPTION].
Column: [RECORDNUMBER2] records an abbreviation code through lookup on row entries ofColumn [RECORDNUMBER].
Column: [DESCRIPTION] records a description of a particular solicitation mailing.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.