Database Items EI Reports

Accounts to Supply Point Assignment Issues

Identifying accounts that are assigned to multiple supply points overlapping the same period or not assigned to any. This issue has the potential to result in bill consumption or charges for the account (during the time period that overlaps) being potentially double counted. Water Accounts linked to Supplies via Supply (Water) commodity Service Types are not included as this can be a valid configuration.

Resolution: Investigate the accounts supply point assignment and ensure that, if correct, there are no reports in use that will result in the double counting of the accounts consumption.

Meters to Supply Points Assignment Issues

Identifying meters that are assigned to multiple supply points overlapping the same period or not assigned to any. This issue has the potential to result in the consumption for the meter (during the time period that overlaps) being potentially double counted. Water Meters linked to Supplies via Supply (Water) commodity Service Types are not included as this can be a valid configuration. Resolution: Investigate the meter’s supply point assignment and ensure that, if correct, there are no reports in use that will result in the double counting of the meter’s HF consumption.

Overview

Overview of the number of Sites and the number of Accounts per Commodity.

This shows both the reports below on one Dashboard.

Total number of Accounts for Active Sites by Commodity

Click on the link in the table to take you directly into the Report in Energy Intelligence in your own database.

Total number of Active Sites

Provides a count of the active sites i.e. those that do not have a Non Operational Flag or Closed Date Flag.   Report refreshed monthly on 2nd of the month.