Database Design & Description

Information collected on the mines and equipment described previously is incorporated into several files/tables using Microsoft Access® 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 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 in cubic meters, payload capacity, engine size, working weight
• Key specifications (e.g., tire size, drive type and manufacturer)
• Size-Class: capacity of comparable units (e.g. Caterpillar 793C & Komatsu 830E)
• Ship Quarter and Year
• Price/Valuation (est. 2012 market 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:
• First & Surname
• Title
• Email