Store granular host and field date/time information

AVEVA Measurement Advisor has the ability to calculate and store the host and field date/time information inside the meter and gas quality readings for each granularity, reducing the complexity and amount of work required to generate reports.

Field values are using the timezone as defined by the Field device local timezone property for the object. Host values are using the timezone as defined in configDesc.

Note: The field hour is the gas hour that the record falls in. This may be the same value as the Time + Offset. For split records (using hourly data as an example), the field hour will be the top of the hour.

To begin recording host and field date/times, enable the feature by setting the booleanValue for CD_STORE_DATETIMES to Y in the configDesc table. For more information on enabling configDesc items, refer to the AVEVA Measurement Advisor Installer documentation.

In the configDesc table, you can configure which of the granularities will calculate the date/time information to ensure that you are not storing more information than you need.

For an example, refer to Example of system and meter configuration.

Note: For hourly meter readings, hostHourly is the same as contractTime. For daily meter readings, hostDaily is the same as contractTime. If CD_FIELD_DEVICE_AGGREGATES is enabled, the time of the daily and monthly aggregated rows will be provided by the field.

• CD_STORE_MINUTELY_DATETIMES will add the following information to minutelyMeterReading:

  • hostMinutely

  • hostHourly

  • hostDaily

  • hostMonthly

  • fieldMinutely

  • fieldHourly

  • fieldDaily

  • fieldMonthly

• CD_STORE_HOURLY_DATETIMES will add the following information to hourlyMeterReading:

  • hostHourly

  • hostDaily

  • hostMonthly

  • fieldHourly

  • fieldDaily

  • fieldMonthly

• CD_STORE_DAILY_DATETIMES will add the following information to dailyMeterReading:

  • hostDaily

  • hostMonthly

  • fieldDaily

  • fieldMonthly

• CD_STORE_MONTHLY_DATETIMES will add the following information to monthlyMeterReading:

  • hostMonthly

  • fieldMonthly

• CD_STORE_GQ_HOURLY_DATETIMES will add the following information to hourlyGasAnalysis:

  • hostHourly

  • hostDaily

  • hostMonthly

  • fieldHourly

  • fieldDaily

  • fieldMonthly

• CD_STORE_GQ_DAILY_DATETIMES will add the following information to dailyGasAnalysis:

  • hostDaily

  • hostMonthly

  • fieldDaily

  • fieldMonthly

• CD_STORE_GQ_SAMPLED_DATETIMES will add the following information to sampledGasAnalysis:

  • fieldHourly

  • fieldDaily

  • fieldMonthly

  • hostHourly

  • hostDaily

  • hostMonthly

When enabled, the values for these columns will be calculated for each data row after the data has been processed. These values will also be recalculated if the meter or gas quality (GQ) properties that affect the datetime value are changed. These recalculations behave in the following way:

• If the field device contract hour, or field device timezone changes for a meter or gas quality, the field columns will be recalculated using the new configuration, starting at a configured time in the past.

• If the official contract hour changes for a meter or gas quality, the host columns will be recalculated using the new configuration, starting at a configured time in the past.

• A synchronization routine has been provided to allow these new columns to be updated when AVEVA Measurement Advisor has undergone an upgrade. For more information, refer to Running a Synchronization Routine.

• To configure how far in the past the data should be recalculated, refer to Account for changes to the contract hours and timezones.