Locations
The Locations hierarchy is defined in the Pitram | Locations Reference Data Group. There are two views: V_Locations and V_Destinations. These two views are identical except for the Column Name prefix:
- V_Location columns have a Source prefix.
- V_Destination columns have a Destination prefix.
Since a location can be a Source and a Destination, whenever you create a location, a record is added in the V_Locations view and the V_Destinations view.
Sublocations
A location may have one or more sublocations. When working in an underground mine, for example, development is usually advanced sublocation by sublocation, or face by face. Sublocations are identified using an "s" Code prefix.
V_Destinations
This view has the same structure as the V_Locations view (See Below) except that the Column Names have a Destination prefix rather than a Source prefix.
V_Locations
The V_Locations and V_Destinations views contain the locations defined on site . A Source location, for example, might be Face1, while a Destination location might be StockPile1.
| Column | Description |
|---|---|
| Mandatory column set | |
| Source_Parent_Code | If the location is not a sublocation the value of this column will be NULL. Otherwise it will contain the Source_Code of its parent location. |
| Source_Parent_Description | If the location is not a sublocation the value of this column will be NULL. Otherwise it will contain the Source_Description of its parent location. |
| Source_Parent_Abbreviation | If the location is not a sublocation the value of this column will be NULL. Otherwise it will contain the Source_Abbreviation of its parent location. |
| Source_Mine | The value of this column is a Mine Type defined in the Reference Data (Groups | Configuration Items | Locations | Mine). |
| Source_Mine_Code | The value in this column is generated automatically by the system. It is the Mine Code defined for the selected Mine Type. |
| Source_Material | The value in this column is the Material Type of the location, as stored in the V_Material view. |
| Source_Material_Code | The value in this column is generated automatically by the system. It is the Material Code defined for the selected Material Type. |
| Source_DepletionModel | The value in this column is a Depletion Model defined in the Reference Data (Groups | Configuration Items | Locations | DepletionModel). |
| At Micromine Pitram installation stage, depletion models FIFO 100, LIFO 100 and Weighted Average are established. These are the only depletion model types currently supported by Micromine Pitram for work with the Grade Control service. | |
| Source_DepletionModel_Code | The value in this column is generated automatically by the system. It is the Depletion Model Code of the selected Depletion Model. |
| Source_RingNo | The value in this column is a Ring Number defined in the Reference Data (Groups | Configuration Items | Locations | RingNo). Ring Numbers are applicable to underground mines. |
| Source_RingNo_Code | The value in this column is generated automatically by the system. It is the Ring Number Code defined for the selected Ring Number. |
| Source_StockpileNo | The value in this column is a Stockpile Number defined in the Reference Data (Groups | Configuration Items | Locations | StockpileNo). |
| Source_StockpileNo_Code | The value in this column is generated automatically by the system. It is the Stockpile Number Code defined for the selected Stockpile Number. |
| Source_FlowType | The value in this column is a Flow Type defined in the Reference Data (Groups | Configuration Items | Locations | FlowType). Both the Grade Control service and the Reporting service use FlowType, which defines the material moved from a location, either: |
| • Primary. The material from a primary source. The grade of the material from a primary source is the grade of the material as it is carried through to the final product. | |
| • Intermediate. The material from an intermediate source - orepass to stockpile, for example. | |
| Source_FlowType_Code | The value in this column is generated automatically by the system. It is the Flow Type Code of the selected Flow Type. |
| Source_LocType | The value in this column is a Location Type defined in the Reference Data (Groups | Configuration Items | Locations | LocType). The Location Type of a location is used in the Reporting service. |
| Source_LocType_Code | The value in this column is generated automatically by the system. It is the Location Type Code of the selected Location Type. |
| Source_CapOp | The value in this column is a flag which identifies the Capital/Operating Costs state of the location, as defined in the Reference Data (Groups | Configuration Items | Locations | CapOp). |
| The Capital/Operating Costs flag can be used for accounting purposes and is referenced by the Reporting service. It identifies a location as being at one of the following stages of the project: | |
| • Capital. All associated costs are capital costs. | |
| • Operating. All associated costs are operating costs. | |
| Source_CapOp_Code | The value in this column is generated automatically by the system. It is the Capital/Operating Costs Code of the selected Capital/Operating Costs flag. |
| Source_DevPrd | The value in this column is a flag which identifies the Development/Production type of the location, as defined in the Reference Data (Groups | Configuration Items | Locations | DevPrd). The Development/Production type is referenced by the Reporting service. |
| The following DevPrd types are supported: | |
| • Development. Location is in its development phase. | |
| • Production. Location is in its production phase. | |
| Source_DevPrd_Code | The value in this column is generated automatically by the system. It is the Development/Production Code of the selected Development/Production type. |
| Source_MineLevel | The value in this column is a Mine Level defined in the Reference Data (Groups | Configuration Items | Locations | MineLevel). |
| Source_MineLevel_Code | The value in this column is generated automatically by the system. It is the Mine Level Code Code of the selected Mine Level |
| Source_OreBody | The value in this column is an Ore Body defined in the Reference Data (Groups | Configuration Items | Locations | OreBody). |
| Source_OreBody_Code | The value in this column is generated automatically by the system. It is the Ore Body Code of the selected Ore Body. |
| Source_Direction | The value in this column is a Direction (North, West and so on) defined in the Reference Data (Groups | Configuration Items | Locations | Direction). |
| Source_Direction_Code | The value in this column is generated automatically by the system. It is the Direction Code of the selected Direction. |
| Source_DestinationLoc | The value in this column defines an active list of locations. This list defines the possible destination locations associated with the location. Destination locations are the locations to which the material will be moved and dumped. |
| Source_MinimumLevel | Enter an appropriate Minimum Level for the location. This is appropriate, for example, when you are defining the benches of an open cut mine. |
| Source_MaximumLevel | Enter the appropriate Maximum Level for the location. |
| Source_TotalCapacity | Enter the Total Capacity of the location. |
| Source_PitName | The value in this column is a Pit Name defined in the Reference Data (Groups | Configuration Items | Locations | PitName). |
| Source_PitName_Code | The value in this column is generated automatically by the system. It is the Pit Name Code of the selected Pit Name. |
| Source_Bench | The value in this column is a Bench defined in the Reference Data (Groups | Configuration Items | Locations | Bench). |
| Source_Bench_Code | The value in this column is generated automatically by the system. It is the Bench Code of the selected Bench. |
| Source_Envelope | The value in this column is an Envelope defined in the Reference Data (Groups | Configuration Items | Locations | Envelope). Envelopes are used when working with the Grade Control service. |
| Source_Envelope_Code | The value in this column is generated automatically by the system. It is the Envelope Code of the selected Envelope. |
| Source_PlannedTonnes | Enter a Planned Tonnes value for the location. This column and the following four columns are used when working with Automatic Status Change. |
| In Data Acquisition, for example, a status change is made, conditional on the performance of a location to meet its target or planned measure. | |
| Source_PlannedMetresDrilled | Enter a Planned metres to be drilled value for the location. |
| Source_PlannedCreteSprayed | Enter a value Planned shotcrete to be sprayed at the location before the status of the location is automatically changed. |
| Source_PlannedFaceCharge | Enter a value Planned faces to be charged at the location before the status of the location is automatically changed. |
| Source_PlannedFaceFire | Enter a value Planned number of faces to be fired at the location before the status of the location is automatically changed. |
| Source_MineArea | The value in this column is a Mine Area defined in the Reference Data (Groups | Configuration Items | Locations | MineArea). |
| Source_MineArea_Code | The value in this column is generated automatically by the system. It is the Mine Area Code of the selected Mine Area. |
| Source_Zones | The value in this column is a Zone defined in the Reference Data (Groups | Configuration Items | Locations | Zone). |
| Source_Zones_Code | The value in this column is generated automatically by the system. It is the Zone Code of the selected Zone. |