|
Database Design & Description
Information collected on the mines and equipment described above is incorporated into several files/tables using Microsoft Access(r) software in a relational database format (conversion to alternative software formats is available on request). The project developer can assist participants in identifying the necessary software and in training personnel to fully utilize the final database.
Each mine record includes, to the maximum extent possible:
-
Operating Company Name
-
Mine Name
-
Abbreviated Identification (e.g. "ASARCO/Ray", "CVRD/Carajas")
-
Mine ownership relationships (e.g. all Rio Tinto mines can be identified)
-
Complete Mailing Address
-
Country, state/province and postal codes (separate fields for search & sort functions)
-
Phone and fax numbers
-
Company website & mine operation page/link (as available)
-
Geographic region (e.g. Latin America)
-
Mine start-up date
-
Mineral(s) produced
-
Annual production and/or volume of material moved
-
Remarks (qualitative information not fitting above format)
-
Update field indicating currency of reported information
Each mining equipment record includes, to the maximum extent possible:
-
Product & Type (e.g. product = "hydraulic excavator", type = "front shovel")
-
Manufacturer
-
Model (including series where known, e.g. '793', '793B', '793C', '793D')
-
Manufacturer's serial number (when available)
-
Size: capacity of specific unit
-
Size-Class: capacity of comparable units (e.g. Caterpillar 793C & KMS 830E)
-
Ship Year
-
Price/Valuation (est. 2007 price level for each Product/Size-Class combination)
-
Country of origin (including units manufactured under license where known)
-
Operating Status (e.g. 'operating', 'parked', 'for sale')
-
Update field indicating currency of reported information
Each personnel record includes, to the maximum extent possible:
|