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

JGDBFULL TableTFJTFCost image

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.