THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: TFJTFCOST
The structure of this table was designed to summarize costs and revenue for issues of the Journal of the Taliesin Fellows (JTF).
TABLE NOTES
Table TFJTFCOST contains 9 rows arranged in 12 columns.
Entries record an array of editorial, graphics, printing, and mailing expenses, together with revenue and page count, for Issues #18-26 of the JTF. The table relies on lookup relationships with columns of Tables MMTF/JOURNAL/COST and MMTFMAILCOST.
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: [ISSUE#] records the number of an issue of the JTF.
Column: [MISPREP] records a dollar amount through lookup on a row value of Column [PREP1] of Table MMTF/JOURNAL/COST.
Column: [EDITOR] is void of entries in all rows.
Column: [EDITCOST] records a dollar amount through lookup on a row value of Column [PREP3] of Table MMTF/JOURNAL/COST.
Column: [GRAPHICCOST] records a dollar amount through lookup on a row value of Column [PREP2] of Table MMTF/JOURNAL/COST.
Column: [PRINTCOST] records a dollar amount through lookup on a row value of Column [PRINTING COST] of Table MMTF/JOURNAL/COST.
Column: [MAILCOST] records dollar amount through lookup on a row value of Column [TOTAL] of Table MMTFMAILCOST.
Column: [TOTALCOST] records a total dollar amount through calculation formula of the above costs.
Column: [#PAGES] records the number of pages in an issue of the JTF through lookup on a row value of Column [NUMBER OF PAGES] of Table MMTF/JOURNAL/COST.
Column: [COSTPERPAGE] records a dollar amount through field calculation on row values of Column [TOTALCOST] divided by Column [#PAGES].
Column: [REVENUE] records a dollar amount.
Column: [NETCOST] records a dollar amount.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.