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.