THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: JTFCOSTBREAKDOWN
The structure of this table was designed to report a production cost breakdown for issues 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 JTFCOSTBREAKDOWN contains 6 rows arranged in 8 columns.
Entries record production and mailing expense information for Issues #20-25 of the JTF.
The table relies on lookup relationships with columns of Tables MMTFEVENTMAILERCOST, TFEDITORIALCOSTS, TFGRAPHICCOSTS, TFPRINTINGCOSTS, MMTFMAILCOST, and MMTFPUBLICATIONREC.
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 an issue number of the JTF.
Column: [MISCELLANEOUSPREP] records a dollar value for preparation expenses related to an issue of the JTF through lookup on a row value of Column[COST] of TableMMTFEVENTMAILERCOST.
Column: [EDITORIAL] records a dollar value for editorial costs related to an issue of the JTF through lookup on arow value of Column [COST] of Table TFEDITORIALCOSTS.
Column: [GRAPHICS] records a dollar value for graphics costs related to an issue of the JTF through lookup on a row value of Column [COST] of Table TFGRAPHICCOSTS.
Column: [PRINTING] records a dollar value for printing costs related to an issue of the JTF through lookup on a row value of Column [TOTALCOSTJOURNAL] of TableTFPRINTINGCOSTS.
Column: [MAILING] records a dollar value for postage costs related to an issue of the JTF through lookup on a row value of Column [TOTAL] of TableMMTFMAILCOST.
Column: [NONMEMBERMAILING] records a dollar value for postage costs for non-Taliesin Fellows members related to an issue of the JTF through a field calculation with lookup on row values of Column [COST222X] multiplied by Column [QTYNONMBR] of Table MMTFPUBLICATIONREC.
Column: [TOTALCOST] records a dollar value through field calculation adding all preceding columns.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.