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. |