|A: Types of MINFILE Reports Available
1: Master Report
2: Production Report
3: Capsule Geology/Bibliography Report
4: Map Legend Report
5: Map Commodity Legend Report
6: Data Dictionary Control Report
7: MINFILE Number Index
8: Primary Name Index
9: Primary Commodity Index
10: NTS Map Index
11: Alphabetical Index
12: Commodity Index
13: MINFILE Reserves/Resources Report
14: Confidential Notes Report
The MINFILE Report option allows you to generate reports on the MINFILE data. See Generating Reports in MINFILE/pc (Chapter II, Section F) for additional information. You can report on the data you have isolated using the search facility or on the complete database. The reports you can generate range from the Master Report, which provides all the data on each occurrence (except production), to indexes of occurrence names, commodities, NTS map sheet locations, and map legends.
Select Reports from the MINFILE Deposits section of Main System Menu and you will see the MINFILE Reports Menu which looks like this:
Types of MINFILE Reports Available
The following sections provide a brief description of the 14 different reports available and a few hints on how to best make use of this facility. A complete set of sample MINFILE reports is contained in Appendix O of this manual.
Select the type of report you would like by highlighting your choice using the arrow keys, the mouse or pressing the highlighted letter key (for example, press 'P' to generate a Production Report).
1. Master Report (RGEN0100.RPT)
The Master report is the most comprehensive report generated on the MINFILE database. It contains all the information on each mineral occurrence in the database EXCEPT production. This report often uses two or more pages for each occurrence, so it is strongly recommended that you use the search option to narrow the database before you begin generating master reports.
On a 80486 IBM PC Compatible (66 MHz), it takes 40 seconds to generate the master reports for three occurrences (sent to screen). If you are using a slower computer, or are sending your reports to a printer, rather than to the screen, you may find that it takes longer than this.
NOTE: All reports will display location in either NAD 27 or NAD 83, depending on the datum selection in the System Configuration menu.
2. Production Report (RGEN0200.RPT)
The Production report is a listing of annual production figures for occurrences in your selected data that have this information.
It is important to note that many of the occurrences in the MINFILE database do not have production figures. In this case, when generating a Production report, you will see the message "Report successfully generated! No output resulted." in the bottom left corner of your screen.
While many MINFILE occurrences do not have production data, those that do may have several pages of it. The Production report for an occurrence which has produced three commodities for the past 31 years, for example, will have a production report of over a page in length. If you request a production report for ten occurrences which have production figures for the past 50 years, you will find that a substantial number of pages is generated. Once again, it is advisable that you narrow the database to only a few occurrences BEFORE generating a Production report.
NOTE: The Master report and Production report together equal the sum total of the data in the MINFILE database for each occurrence.
3. Capsule Geology/Bibliography Report (RGEN0300.RPT)
The Capsule Geology/Bibliography report provides you with a textual description (Capsule Geology) of the occurrences you have selected, and a list of the sources used to research those occurrences (Bibliography). It also includes the commodities, location, status, region and mining division for each occurrence.
The Capsule Geology varies in length from occurrence to occurrence, depending on how much information is available. In some cases, it is a few lines long, in others, it may be 3 pages. The size of the Capsule Geology is loosely tied to the status. For example, there is generally more information available on a developed prospect than a showing and therefore the capsule should be larger.
The bibliography section of the report contains references and information sources used to research each occurrence. These references generally include codes. For example, the code "EMPR AR" indicates that information has been drawn from a Minister of Mines Annual Report between 1874 and 1968 (the date and page numbers will be specified). For a complete list of these Bibliographic codes, and what each represents, see Appendix H in this manual.
4. Map Legend Report (RGEN0400.RPT)
This report option will produce numerical legends for all of the occurrences in your selected dataset (the number in your "Deposits:___" line).
It is useful to search the database by NTS map sheet before generating this report. This will result in a separate legend for each NTS map sheet represented in your dataset.
The Map Legend report is of limited use to the average user. The Geological Survey Branch of the Ministry of Energy and Mines uses these legends on the MINFILE maps.
5. Map Commodity Legend Report (RGEN4400.RPT)
This 2-column report sorts alphabetically by commodity code and description and is generally used in conjunction with the Map Legend report discussed above. It provides a list of all the commodity codes and the corresponding commodity names which occur in your dataset.
6. Data Dictionary Control Report (RGEN0500.RPT)
This report creates a list of all the entity-relationship file names in your dataset. It also displays the number of records in each file of the dataset. The most important use of this report is that it outlines what data is in which file (the database structure).
This report can also be used to keep track of the number of records in your dataset, especially when data has been transferred between computers. However, data transfer in MINFILE/pc is exceptionally reliable, so it is not necessary to track the number of records.
7. MINFILE Number Index (RGEN0600.RPT)
This report compiles a list of all occurrences in the selected dataset in numerical order based on MINFILE number. Listed for each occurrence are the MINFILE number, primary name, commodities, status, and location information.
This report is best suited to medium-sized sets of data. If you generate this report for the entire MINFILE provincial database (over 11,800 occurrences), more than 200 pages of printed output will result.
8. Primary Name Index (RGEN0700.RPT)
This report provides the same information as the MINFILE Number Index, excluding the location. However, the occurrences are sorted in alphabetical order on the basis of the primary name.
Because there is some duplication of names between various MINFILE occurrences (for example, over twenty occurrences have the name "Bonanza"), you may find that some names are repeated in this index. However, since this report lists ONLY the primary name of each occurrence, there should be NO duplication of MINFILE numbers, which appear to the immediate right of the primary name.
NOTE: The coding rule is that there should be no duplication of the primary name within a 1:250 ,00 or 1:100,000 scale NTS mapsheet.
The primary name index is most effective on a large set of data. There is no need to narrow your dataset to only a few occurrences before you generate this report.
9. Primary Commodity Index (RGEN0800.RPT)
This function will generate a listing of all the occurrences in the selected dataset, divided into groupings based on the primary commodity (see Appendix P for a sample of this report). In MINFILE, the primary commodity is the commodity listed first because of its importance.
The Primary Commodity report provides you with commodities, status, location, primary name, and the MINFILE number for each occurrence in your dataset. It will also count how many occurrences have a specific primary commodity.
This report is more effective, and generally more useful with a medium-sized set of data. Too large a dataset will result in very large amounts of output, and too small a dataset will result in sketchy information that might be better presented in a Master Report.
10. NTS Map Index (RGEN0900.RPT)
This report option will generate a listing of the occurrences in your selected dataset sorted on the basis of their 1:50,000 scale map sheet designation, further subdivided into east and west halves. The list will display the NTS map sheet number first, then the MINFILE number, primary name and location information. This report can be used on large sets of data.
11. Alphabetical Index (RGEN1000.RPT)
This report is similar to the Primary Name Index in that it sorts the occurrences in your selected dataset alphabetically on the basis of name. However, this report does NOT limit itself to the primary name of an occurrence (the first name). Instead, this report lists every name for every occurrence in your database. This means that you may have up to sixteen entries for each occurrence in your dataset.
The Alphabetical Index provides the name, MINFILE number, NTS map sheet, and location information for each occurrence. It also contains two columns at the far right of the report, headed "R" and "P". A "Y" in either of these columns indicates that there are either reserves data or production data available for that occurrence. You may access reserves information through the Master Report or the Reserves/Resources Report and production figures through the Production Report.
The Alphabetical Index produces a large amount of output if a very large set of data is used. For example, when the provincial dataset of over 11,800 occurrences was used to generate a printed copy of this report, over 400 pages of printed output resulted.
12. Commodity Index (RGEN1100.RPT)
This report option, sorted on commodity, will provide you with the same information as the Alphabetical Index, including the "R" and "P" columns. The difference between this report and the Primary Commodity Index is that each occurrence will be listed under every commodity it contains. For example, an occurrence which has gold, silver, lead and zinc in its list of commodities will appear four times in the Commodity Index, once for each commodity. Each occurrence can have up to 15 commodities.
Unlike the other tabular reports generated by MINFILE/pc, the Commodity Index does not print continuously. Instead, it generates one (or more) page for each commodity. A new page of the report is started for every commodity (one page for silver, a new page for gold, a new page for copper, and so on). For this reason, it is advisable to narrow the dataset before generating this report.
13. MINFILE Reserves/Resources Report (RGEN5300.RPT)
Each MINFILE occurrence in your dataset with one Reserve calculation flagged with the "Report_on = Y" will be included in the report. The report presents the following information: Name, MINFILE number, location, NTS Map, Status, Mining Division, Deposit type, Ore zone name, Year (of reserve calculation), Reference, Comments, Tonnage, Category, Grade and Commodity.
A Reserves/Resources report on the complete provincial MINFILE database is about 110 pages long. This can be purchased in hard copy as an Open File.
14. Confidential Notes Report (RGEN1200.RPT)
This report contains all the information contained in the Confidential Notes field of the occurrences in your selected dataset. This cannot be accessed without complete access to the database.
Confidential Notes appear on a report which is similar to the Capsule Geology Report. Remember to narrow your search to include only those occurrences for which you want the Confidential Notes. Otherwise the Report will scan the complete database before terminating.