Deploying Reference Data
In the Reference Data service, ensure that the following tables and their attributes have been deployed:
This option will open the Reference Data Deployment dialog.
Materials Management > Dilution Type
The following attribute must be set:
- Seq
Materials Management > Element
Select all attributes.
Pitram > Locations > Location
The following attributes must be set:
- Dilution Method
- Block Complete
- Fire
Other attributes such as Draw, SG, Moisture and MetalRecovery are optional. These should probably be set in the first instance and switched off if not required.
Configuration Items > Locations > Sublocation
The following attributes must be set:
- ParentLocation
- Fire
Click OK to deploy the reference data with the selected options.
Setting up Location Attributes
A number of location attributes need to be populated in the Reference Edit service under Groups > Locations in order for the Drill and Blast service to run. In most cases these attribute values will have been loaded as part of the deployment.
Dilution Method
The D&B functionality supports two dilution methods:
- Underground, which allows inventory to be adjusted
- Open Pit, which will not allow the inventory to be adjusted but will generate movements when the available inventory is over-dug (i.e. goes negative).
| Name | Code | Abbreviation |
|---|---|---|
| Open Pit | OPENPIT | Openpit |
| Underground | UNDERGROUND | Underground |
Flow Type
There may be any number of standard flow types set up, however the following two must exist:
| Name | Code | Abbreviation |
|---|---|---|
| Pre-Primary | PREPRI | Preprimary |
| Primary Source | PRI | Primary |
It is not possible to define attributes for different types of locations. Once an attribute is defined for a location, it is available for any type of location. This is not a problem if the populating of the attribute is made optional. Care should be taken when making an attribute mandatory, since this will mean that every location will require this attribute to be populated.
If a “Block” attribute is defined as mandatory, for example, the CSV importer will enforce this irrespective of whether the location is above ground, below ground, or a general non-mining location.
Location
Ensure that the following location exists at Groups > Pitram > Location. This is the Source location that is used for all firings. If not present, the only way of creating it is to use the Reference Data Import Utility since this utility ignores mandatory fields (unlike the Import utility available in Drill and Blast).
| Column | Entry |
|---|---|
| Name | Drill & Blast Design |
| Code | _BLAST_LOC_SOURCE |
| Abbreviation | Design |
| Flow Type (code) | PREPRI |
Dilution Types
All the dilution types that are likely to be needed at the site (both for surface and underground) are required to be set up under Groups > Grade Control.
Only those defined in this table will be available for selection. The order in which they are displayed is determined by the sequence number.
| Name | Code | Abbreviation | Sequence |
|---|---|---|---|
| Internal Dilution | INT | Internal | 1 |
| External Dilution | EXT | External | 2 |
| Planned Dilution | PLD | Planned | 3 |
| Unplanned Dilution | UPL | Unplanned | 4 |
Elements
For each element, additional attributes will need to be defined:
| Attribute | Description |
|---|---|
| Primary | 1= Primary, 0 = Secondary |
| Order | Where multiple elements are required, this will determine the order of the display of the elements. |
| Grade uom | The uom of the grade – select from the list available. If not available it will need to be added to the UNIT OF MEASURE table |
| Grade uom Decimal Places | Defines the number of decimal places of the grade to be displayed. |
| Content uom | The uom of the content of the element or product, typically for gold this is ounces, for copper it may be pounds, for other products kilos and so on. Select from the drop down list. If not available it will need to be added to the UNIT OF MEASURE table. |
| Content uom Decimal Places | Defines the number of decimal places of the content to be displayed. |
Although it is not possible to enforce a standard approach to a naming convention for Elements, the following is suggested:
| Name | Code | Abbreviation | |
|---|---|---|---|
| Standard: | Chemical Name in full | Chemical name all in uppercase | Chemical name in camel case |
| Example 1 | Gold | AU | Au |
| Example 2 | Silica | SIO2 | SiO2 |
There may be combinations of grade to content conversions that have not been covered. This will be apparent in the content columns. To fix this, additions will need to be made to the conversion table.
Location Status
Ensure that the following Groups | Configuration Items | States | Location States | LocationStatus have been set up as they will be required during the Drill and Blast configuration of the display.
| Name | Code | Abbreviation |
|---|---|---|
| Blasted | BLASTED | Blasted |
| Drilled | DRILLED | Drilled |
| Marked | MARKED | Marked |
Final Checks
Finally, check-in and publish the reference data before:
- deploying the Drill & Blast Module at System > Manage Services > Drill and Blast.
- enabling and restarting the connector at: System > Manage Connectors.
