This process checks for data that is missing from the relevant tables for the period specified.  If this process reports any missing data, you will have to import the relevant files to complete the data sets.

Check for missing data

The options include All data sets or individual data sets as specified below.

Actual Energy – Energex

Checks the table T045_AEX_year for entries where the date falls within the date range specified and half hourly entries 1-48 ( inclusive ) and where the field aex_do_not_use = 0 (zero)

Actual Energy – Ergon

Checks the table T046_AEN_year for entries where the date falls within the date range specified and half hourly entries 1-48 ( inclusive ) and where the field aen_do_not_use = 0 (zero)

Actual Energy – AEi

Checks the table T047_AEI_year for entries where the date falls within the date range specified and half hourly entries 1-48 ( inclusive ) and where the field aei_do_not_use = 0 (zero)

Actual Gas Consumption

Checks the table T051_AGC_year for entries where the date falls within the date range specified and half hourly entries 1-48 ( inclusive ) and where the field agc_do_not_use = 0 (zero)

Teleperm – Enertrade

Checks the table T049_TEN_year for entries where the date falls within the date range specified and half hourly entries 1-48 ( inclusive ) and where the field ten_do_not_use = 0 (zero)

Teleperm – TPS

Checks the tables T048_TPS_year  , and T050_REI_year for entries where the date falls within the date range specified and half hourly entries 1-48 ( inclusive ) and where the field tps_do_not_use/rei_do_not_use = 0 (zero)

Temperature Data

Checks the table T052_TMP_year for entries where the date falls within the date range specified and half hourly entries 1-48 ( inclusive ) and where the field tmp_do_not_use = 0 (zero)