Measures
The Measure hierarchy has one view:
- V_Meascode: The Measures recorded on site are stored in this view.
Note however that a MeasureType reference data group IS NOT displayed as a view in the Reporting database. There are three measure types: Cumulative, Movement, and Summed. These MeasureTypes are stored in the Production database and are usually configured at the Pitram installation phase of a project.
V_Meascode
The V_Meascode view displays the Measures that are recorded on site. For example, Tonnes, or Engine Hours, or BCM. These are defined in the Groups | Configuration Items | Measures reference data group.
| Column | Description |
|---|---|
| Mandatory column set | |
| Measure_MeasureType | Select the Measure Type of the measure. the defined Measure_MeasureType that best describes the token. |
| Measure Types are Movement, Cumulative and Summed. These are usually defined at the installation phase of the project in the Groups | Configuration Items | Measures | MeasureType reference data group. | |
| Measure_MesureType_Code | The value in this column is generated automatically by the system. It is the Measure Type Code of the selected Measure Type. |
| Measure_DecimalPlaces | Enter an appropriate number of decimal places for the measure. 0, 1, or 2, for example. |
| Measure_Multiplier | Enter the multiplier that will be applied to the measure value. 1, for example. |
| Measure_MaximumValue | Enter the maximum value of the measure. 999999, for example. |
| Measure_MinimumValue | Enter the minimum value of the measure. 0, for example. |
| Measure_DefaultValue | Enter the default value of the measure. 0, for example. |
| Measure_EquipmentMeasure | The value 1, for example, identifies the measure as a valid equipment measure. 0 (zero) indicates an invalid measure. |
| Measure_LocationMeasure | The value 1, for example, identifies the measure as a valid location measure. 0 (zero) indicates an invalid measure. |
| Measure_PersonMeasure | The value 1, for example, identifies the measure as a valid person measure. 0 (zero) indicates an invalid measure. |