THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: COSTINTHEMAIL
The structure of this table was designed to record costs related to the mailing of the Journal of the Taliesin Fellows (JTF).
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 COSTINTHEMAIL contains 21 rows arranged in 18 columns.
Entries record mailing expenses for Issues #1-4, #9, and #13/14-26 of the JTF. Records are dated from February 24, 1996 to September 29, 2000.
The table provides lookup relationships for columns of Table MMTFPUBLICATIONREC, and relies on lookup relationships with columns of Tables MMTF/JOURNAL/COST andMMTFMAILCOST.
Database Search
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 LABELS
Column: [CURRENT DATE] records the date of the record entry in month/day/year format.
Column: [CURRENT TIME] records the time of the record entry in hour/minute/second format.
Column: [JOURNAL ISSUE #] records an issue number of the JTF.
Column: [JOURNALCOST] records the production cost per copy for an issue of the JTF through lookup on a row value of Column [COST2] of Table MMTF/JOURNAL/COST.
Column: [JOURNALCOST3] records the production cost per copy for an issue of the JTF through lookup on a row Entries are identical to [JOURNALCOST].
Column: [JOURNALCOST2] records the production cost per copy for an issue of the JTF through lookup on a row value of Column [COST2] of Table MMTF/JOURNAL/COST. Entries are identical to [JOURNALCOST].
Column: [9X12ENVELOPE] records a number to three decimal points for the cost of a mailing envelope through lookup on a row value of Column [9x12 E 1 M UNIT COST] of Table MMTFMAILCOST.
Column: [9X12ENVELOPE3] is void of entries in all rows.
Column: [9X12ENVELOPE2] records a number to three decimal points for the cost of a mailing envelope through lookup on a row value of Column [9x12 E 1 M UNIT COST] of Table MMTFMAILCOST. Entries are identical to [9X12ENVELOPE].
Column: [LABEL] records a number to three decimal points for the cost of a mailing label through lookup on a row value of Column [WHITE LBL UNIT COST] of Table MMTFMAILCOST.
Column: [LABEL3] is void of entries in all rows.
Column: [LABEL2] records a number to three decimal points for the cost of a mailing label through lookup on a row value of Column [WHITE LBL UNIT COST] of Table MMTFMAILCOST. Values identical to Column [LABEL].
Column: [POSTAGE] records a number for the cost of second class postage cost. Some rows in the column are null.
Column: [POSTAGE3] records a number for the cost of postage. Most rows in the column are null.
Column: [POSTAGE2] records a number for the cost of first class postage. Some rows in the column are null.
Column: [TOTAL] records a number for total cost to three decimal places through field calculation of various columns; see DataEase Table Definition printout, above, for details.
Column: [TOTAL3] records a number for total cost to three decimal places through field calculation of various columns; see DataEase Table Definition printout, above, for details
Column: [TOTAL2] records a number for total cost to three decimal places through field calculation of various columns; see DataEase Table Definition printout, above, for details.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.