THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: TFPRINTINGCOSTS
The structure of this table was designed to analyze printing costs for issues of the Journal of Taliesin Fellows (JTF).
TABLE NOTES
Table TFPRINTINGCOSTS contains 25 rows arranged in 29 columns.
Entries record cost information for Issues #1-26 of the JTF, though records are complete only for Issues #20-26. Records are undated. This table provides a lookup relationship with Table MMTF/JOURNAL/COST.
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: [LEADSTORY] records a description of the lead story for an issue of the JTF.
Column: [ISSUE#] records an issue number of the JTF.
Column: [ISSUE#2] records the whole number of pages in an issue of the JTF.
Column: [TQTYPRINTED] records a run number for an issue of the JTF.
Column: [COSTSIGCOVER] records a dollar amount through field calculation on row values of Column [TCOSTCOVER] divided by Column [SIGQTYCOVER].
Column: [SIGQTYCOVER] records the number "0" or "1".
Column: [TCOSTCOVER] records a dollar amount.
Column: [COST100COVER] records a dollar amount to three decimal places through field calculation on row values of Column [TCOSTCOVER] divided by Column [TQTYPRINTED] multiplied by 100.
Column: [#INTERIORPAGES] records the interior number of pages in an issue of the JTF.
Column: [#SIG] records a number through field calculation on row values of Column [#INTERIORPAGES] divided by 4.
Column: [COSTSIGINTERIOR] records a number through field calculation on row values of Column [TCOSTINTERIORPAGES] divided by Column [SIGQTYINTERIOR]
Column: [SIGQTYINTERIOR] records a number through field calculation on row values of Column [#SIG].
Column: [TCOSTINTERIORPAGES] records a dollar amount.
Column: [COST100INTERIOR] records dollar amout through field calculation on row values of Column [TCOSTINTERIORPAGES] divided by Column [TQTYPRINTED] multiplied by 100 and divided by 7.
Column: [UNITCOSTINSERT] records a number through field calculation on row values of Column [TCOSTINSERT] divided by Column [QTYINSERT].
Column: [QTYINSERT] records a run number for an issue of the JTF.
Column: [TCOSTINSERT] records a dollar amount.
Column: [COST100INSERT] records a dollar amount through field calculation on row values of Column [TCOSTINSERT] divided by Column [QTYINSERT] multiplied by 100.
Column: [UNITCOSTSCAN] records a number.
Column: [QTYSCANS] records a number.
Column: [TCOSTSCANPHOTO] records a dollar amount.
Column: [MISCELLANEOUS] records a description of expense.
Column: [MISC1] records a dollar amount.
Column: [MISCELLANEOUS2] records a description of expense.
Column: [MISC2] records dollar amount.
Column: [MISCELLANEOUS3] is void in all rows.
Column: [TOTALCOSTJOURNAL] records a dollar amount totaling numerous columns; see DataEase Table Definition printout, above.
Column: [COSTPERPAGE] records a dollar amount through field calculation of row values of Column [TOTALCOSTJOURNAL] divided by Column [ISSUE#2].
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.