Equipment

The Equipment hierarchy is defined in the Pitram | Equipment Reference Data Group.

  • V_Equipment_Function
  • V_Equipment_Model
  • V_Equipment

V_Equipment_Function

The V_Equipment_Function view defines the overall function of each equipment model type. A function, for example, might be Loading, Hauling, or Drilling.

Column Description
Mandatory Column Set
Equipment_Function_PrimaryStates This column points to an active list of primary states defined in the Equipment States Hierarchy.
  Equipment primary states can be defined at either the equipment model or equipment function level. Primary States are defined in the Reference Data (Groups | Configuration Items | States | Equipment States).
Equipment_Function_DisplayMeasure Select a Display Measure from the list of defined measure attributes. These are defined in the V_Meascode table of the Measures Hierarchy. The selected Display Measure is the default measure displayed on many of the Data Acquisition panels.
  The defined Display Measure must be a member of the selected V_Equipment_Model | Equipment_Model_MeasureCodeEq active list (see V_Equipment_Model).
Equipment_Function_DisplayMeasure_Code The value in this column is generated automatically by the system. It is the Display Measure Code defined for the selected Display Measure.

V_Equipment_Model

The V_Equipment_Model view defines the model type of an equipment unit. For example, models such as Cat385, Cat774 and Cat793. Each model type has an Equipment Model Function attribute.

Column Description
Mandatory Column Set
Equipment_Model_Function Select the function of this model of equipment from the list of defined V_Equipment_Function attributes.
Equipment_Model_Function_Code The value in this column is generated automatically by the system. It is the Function Code defined for the selected Equipment Model Function.
Equipment_Model_MeasureCodeEq The value in this column points to a defined active list of measures.
  When working in Data Acquisition, select the appropriate measure for the equipment unit from the list of measures. The list must include the V_Equipment_Function | Equipment_Function_DisplayMeasure attribute you have selected below.
  Measure attributes in the V_Meascode view of the Measures Hierarchy and Measure active lists must be defined prior to defining V_Equipment_Model.
Equipment_Model_KPI* Equipment KPIs may be defined for an equipment model. KPIs are a way to set performance indicators for all units of a model type. Up to five KPIs can be defined for each model. The default value = NULL. * = 1 to 5
Equipment_Model_KPI*_Code The value in this column is generated automatically by the system. It contains the Model KPI Codes for the defined Equipment Model KPIs. * = 1 to 5
Equipment_Model_Capacity Enter the carrying capacity of the equipment unit. This value is used to quantify the weight of material moved.

V_Equipment

The V_Equipment view defines the units of equipment (Truck1, Drill1, Loader1 etc. ) used on site.

Column Description
Mandatory Column Set
Equipment_Model Select the Equipment Model Type of the equipment unit.
Equipment_Model_Code The value in this column is generated automatically by the system. It is the Model Code defined for the selected Equipment Model.
Equipment_Owner The value of this column is an Equipment Owner defined in the Reference Data (Groups | Configuration Items | Equipment | EquipmentOwner).
  This is not an essential attribute for the definition of V_Equipment, although it is a recommended attribute.
Equipment_Owner_Code The value in this column is generated automatically by the system. It is the Equipment Owner Code defined for the selected Equipment Owner.
Equipment_Capacity Enter the Capacity of the equipment unit. The carrying capacity of the unit is defined in terms of either its volume or its weight.
Equipment_CuttingWidth Enter the Cutting Width of the equipment unit.
Equipment_TyreType The value of this column is an Tyre Type defined in the Reference Data (Groups | Configuration Items | Equipment | TyreType).
  This attribute could be used, for example, by the Maintenance Department to track equipment performance.
Equipment_TyreType_Code The value in this column is generated automatically by the system. It is the Equipment Tyre Type Code defined for the selected Equipment Tyre Type.
Equipment_LocationsEq This column points to an active list of locations. Location are defined in the V_Locations view of the Location Hierarchy.
Equipment_DestinationsEq This column points to an active list of destination locations. Destination locations are defined in the V_Destinations view of the Location Hierarchy.
Equipment_WeightUnloaded The difference between the unloaded weight and loaded weight of a truck is used at some sites to accurately quantify the weight of material moved.
Equipment_PositiveCorrectionVector This value is used on sites that utilise GPS tracking of equipment. By default the value = 1.
Equipment_PositiveCorrectorVector_Code The value in this column is generated automatically by the system. It is the code of the defined Equipment Positive Corrector Vector.
Equipment_LoaderGroup Assigning equipment to a Loader Group is a way of grouping equipment that can be implemented on site.
Equipment_LoaderGroup_Code The value in this column is generated automatically by the system. It is the code of the selected Loader Group.
Equipment_DispatchZone The Dispatch Zone to which the equipment unit has been allocated. Dispatch zones are used by the Micromine Pitram Dispatch system to restrict a unit's movement to that zone.