THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES

TABLE DETAIL: MEET LINE ITEMS

The structure of this table as designed to track registration information for participants in events held by 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 NOTES

Table MEET LINE ITEMS contains 1,421 rows arranged in 24 columns.

Entries record information about the participation of individuals in Taliesin Fellows membership events between 1991 and 1999.

The content of this table is displayed in a subform of Table MMTFMEETPEOPLE. The table relies on lookup relationships with Tables MMTFMEETPEOPLE, MMTFNL, MMTFMEETING LIST, and SUB LINE ITEMS. These connections are commented on the Dataease Form Screen image, below.

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 MEET LINE ITEMS image

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [RECORD #] records a row identifer number through lookup on a row value of Column [RECORD NUMBER] of Table MMTFMEETPEOPLE.

Column: [MP#] records a row identifier number through lookup on a row value of Column [MP#] of Table MMTFMEETPEOPLE.

Column: [RSL#] records a row identifier number through lookup on a row value of Column [RSL#] of Table MMTFMEETPEOPLE.

Column: [CATEGORY ID records an abbreviation through lookup on a row value of Column [CATEGORY] of Table SUB LINE ITEMS.

Column: [SUBREC#] records a unique row identifier number for each row in this table.

Column: [ID CODE 1] records an abbreviation through lookup on a row value of Column [ID CODE 1] of Table MMTFNL.

Column: [LAST] records a surname through lookup on a row value of Column [LAST] of Table MMTFNL.

Column: [FIRST] records a given name through lookup on a row value of Column [FIRST] of Table MMTFNL.

Column: [SPOUSE] records the first name of a spouse through lookup on a row value of Column [SPOUSE] of Table MMTFNL.

Column: [EVENT1] records a number representing the count of an individual party attending an event whose program title is related to Column [DESCRIPTION] of Table MMTFMEETING LIST.

Column: [EVENTA] records a number representing the count of an individual party attending an event whose program title is related to Column [DESCRIPTION] of Table MMTFMEETING LIST.

Column: [EVENT2] records a number representing the count of an individual party attending an event whose program title is related to Column [DESCRIPTION] of Table MMTFMEETING LIST.

Column: [EVENT3] records a number representing the count of an individual party attending an event whose program title is related to Column [DESCRIPTION] of Table MMTFMEETING LIST.

Column: [EVENT4] records a number representing the count of an individual party attending an event whose program title is related to Column [DESCRIPTION] of Table MMTFMEETING LIST.

Column: [EVENT5] records a number representing the count of an individual party attending an event whose program title is related to Column [DESCRIPTION] of Table MMTFMEETING LIST.

Column: [DUE] records a total dollar amount for the registration cost of attending an event through field calculation; see DataEase Table Definition printout, above, for complex formula.

Column: [PAID] records a dollar amount paid for the registration cost of attending an event.

Column: [BALDUE] records a dollar amount due for the registration cost of attending an event through field calculation on row values of Column [DUE] minus Column [PAID].

Column: [COST1] records a dollar amount for registration cost at an event through lookup on a row value of Column [COST1] of Table MMTFMEETING LIST.

Column: [COSTA] records a dollar amount for registration cost at an event through lookup on a row value of Column [COSTA] of Table MMTFMEETING LIST.

Column: [COST2] records a dollar amount for registration cost at an event through lookup on a row value of Column [COST2] of Table MMTFMEETING LIST.

Column: [COST3] records a dollar amount for registration cost at an even tthrough lookup on a row value of Column [COST3] of Table MMTFMEETING LIST.

Column: [COST4] records a dollar amount for registration cost at an event through lookup on a row value of Column [COST4] of Table MMTFMEETING LIST.

Column: [COST5] records a number for registration cost for an event through lookup on a row value of Column [COST5] of Table MMTFMEETING LIST.

RELATED QUERY PROCEDURES

The data in this table is referenced in 1 query procedure devised by Geiger: