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.