THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES

TABLE DETAIL: PETER LINE ITEMS

The structure of this table was designed to record individual donations to a memorial fund honoring William Wesley Peters.

TABLE NOTES

Table PETER LINE ITEMS contains 16 rows arranged in 4 columns.

Entries record the amount and date of donations between October 13, 1992, and December 19, 1994.

Records from the table are displayed as a subform of Table MMTFWWPETERS. The table relies on lookup relationships with columns of Table MMTFWWPETERS.

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

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [RECORD NUMBER] records a numerical identifier through lookup on a row value of Column [RECORD NUMBER] of Table MMTFWWPETERS.

Column: [PETERREC#] records a numerical identifier through lookup on a row value of Column [PETERREC#] of Table MMTFWWWPETERS.

Column: [PSFR#] records a unique numerical identifier for each row in the table.

Column: [CHECK #] records a check number.

Column: [CHECK DATE] records a date in month/day/year format.

Column: [AMOUNT] records a dollar amount.

Column: [COMMENTS] records a description or comment about the source or purpose of the donation.

RELATED QUERY PROCEDURES

This table is not referenced directly in any of the query procedures devised by Geiger.