Service point and sensor information

On the Event Investigation page, information for each service point or sensor is listed in a table. Depending on the view selected, tables may include the following columns (listed alphabetically):

  • Account Number. The account number associated with a service point.

  • Account Type. An identifier associated with the service point that indicates the consumer use type (for example Residential, Commercial, Hospital).

  • Active Leak. An active leak occurred at this service point during the selected period. The value is True or False. If True, this field is color coded in red.

  • Active No Reads. No readings occurred at this service point during the selected period. The value is True or False. If True, this field is color coded in red.

  • Active Zero Reads. The reading was zero at this service point during the selected period. The value is True or False. If True, this field is color coded in red.

  • Address. The physical address where the service point is located.

  • ADU 7. The rolling average daily usage based on the interval data for the last seven days.

  • ADU 30. The rolling average daily usage based on the interval data for the last 30 days.

  • ADU 365. The rolling average daily usage based on the interval data for the last 12 months.

  • Average of Readings. The average all interval reading values within the period.

  • Confidence Bounds. Indicates how many service points are above and below the statistical bounds. Confidence bounds are calculated monthly, so both daily and monthly views provide the same results.

  • Consumer Leakage Score 1. The number of days until the cost to the consumer exceeds the cost of fixing the leak.

  • Consumer Leakage Score 2. The average daily consumer cost of the leak over the observation period.

  • Consumer Leakage Score 3. The estimated 100-day cost to the consumer due to the leak.

  • Count of Readings. The number of readings obtained within the period for the service point. For example, a service point with hourly readings should have 24 readings in a day and 168 readings in a week. This measure helps you determine whether a service point has sent all expected readings. This measure includes unique readings only (not duplicate readings).

  • Daily/Monthly Change - Units. The increase or decrease, in units of measurement, for the past seven or 30 days.

  • Decile Group. The grouping of the service points within a DMA. This decile grouping number enables you to sort the view by DMA and Decile to determine which service points are in which Decile group. Decile Group for Service Points are calculated monthly.

    Note: The configuration process on the Decile Analysis dashboard card (see Dashboard) assigns a decile grouping identifier to the service points within a DMA.

  • DMA Name. The associated District Metering Area (DMA).

  • DMA Type. Indicates the specific type of DMA associated with a given service point: Hourly, Daily, LowFrequency, or Stratification.

  • End Point ID. A device identifier that is most often associated with a Service Point ID. The End Point ID can also be associated with a sensor.

  • Entity. Provides a link to that Service Point ID's page. Click the water icon () to navigate to the Service point ID (entity) page.

  • Estimated Consumption Trend. The estimated consumption trend score for the service point. Depending on the analytics type, the score will be updated either daily or monthly.

  • Event Type. The type of event for each service point: Endpoints with No Reads, Customer Leakage, or Zero Consumption.

    Note: The Event Type column appears blank when there is not enough information to populate it.

  • Inflow. Incoming flow determined from the flow formula within the DMA csv or Sector file.

  • Irregular Consumer. Indicates whether the consumer associated with the service point has been identified as using large quantities of water without any definable pattern during the day or night.

    Note: Since the water balance requires a stable diurnal consumption pattern to exist, these consumers typically get flagged to have a half-hourly or hourly logging device attached so that the water balance can be accurately calculated.

  • IsCritical. The critical pressure threshold has been met as defined in the configuration file

  • Last Analysis Date. The latest date that the analytics were calculated.

  • Last Consumption Value. The last calculated consumption value obtained from the water meter associated with the service point.

  • Last Index Value. The last obtained meter interval value obtained from the water meter associated with the service point.

  • Last Processed DateTime. The date and time of last processed sensor read.

  • Last Read Date.The last reading obtained from the meter associated with the service point.

  • Last Reading DateTime. The date and time of last sensor read occurrence.

  • Latest Reading Value. The value of last sensor read occurrence.

  • Latitude. The geographic coordinate that specifies the north-south position associated with the sensor or service point.

  • Leakage/hour. The estimated hourly leakage in cubic meters.

  • Leakage Threshold. The threshold, in liters, of continuous consumption to determine whether a leak exists.

  • Leakage Threshold Cost. The threshold, in dollars, of continuous consumption to determine whether a leak exists.

  • Longitude. The geographic coordinate that specifies the east–west position associated with the sensor or service point.

  • Max Reading. The maximum interval reading value within the period.

  • Maximum Flow. The maximum allowed flow, in configured units, per sector. For units information, see Units of measurement.

  • Maximum Negative Reading. The negative value furthest from zero.

  • Meter Diameter. The diameter of the connecting service line to the water meter associated with the service point. The diameter is expressed in millimeters or inches, depending on whether the tenant uses metric or imperial units.

  • Meter Multiplier. A value used for correcting the meter value transmitted. In most cases the multiplier has already be applied by the receiving endpoint, but sometimes this is missed. Water meters can have a multiplier such as x1, x2, x5, x10, or x100. For example, if a reading of 1.32 is transmitted and the multiplier is x10, then the meter reading is actually 13.20 units.

  • Min Reading. The minimum interval reading value within the period.

  • Missing Days. Indicates the number of days with no data received from the water meter associated with a service point. The missing days threshold must be reached before a service point ID appears in the list.

  • Negative Readings Count. The count of all negative interval reading values within the period.

  • Negative Sum of Readings. The sum total of all negative interval reading values within the period.

  • Number of Days with Active Leak. The number of days since the start date of the leak.

  • Number of Days with Zero Consumption. The number of days with no recorded consumption.

  • Operational Status. The billing status of the account with respect to the service point. The operational status can be Active or Inactive.

  • Outflow. Outgoing flow determined from the flow formula within the DMA .csv or sector file.

  • Percent of Change - Day. Usage change for the last 24 hours. This field is color coded for configurable thresholds.

  • Percent of Change - Month. Usage change for the last 30 days. This field is color coded for configurable thresholds.

  • Percent of Change - Year. Usage change for the last 12 months. This field is color coded for configurable thresholds.

  • Percent of Readings. The percentage of expected readings obtained during the selected period of time.

  • Percentage of Data. The percentage of expected readings received per period. For daily readings where hourly data is present, 24 readings are expected to occur. For monthly data, you will need to determine the number of hours in each month (taking into account DST).

  • Reading (0–23). The hourly interval readings for a service point or sensor, available in the daily view option. This enables you to quickly identify anomalies within the data and to compare the data from two or more service points.

  • Reading Interval. The time period that lapses between regularly scheduled water-consumption reads.

  • Retail Unit Cost. The utility's cost, in dollars, for each cubic meter of water lost due to leakage.

  • Service Point ID. The key identifier that provides the connection between the utility and the consumer. A service point will have one or more associations to other fields such as physical address, Customer Name, Customer Account, Water Meter Serial Number, and Water meter type. As a key identifier, the service point value is unique and should not change throughout the life of the solution. This identifying string is provided by the utility for each connection that is required to be monitored.

  • Standard Deviation. Indicates the difference from the mean for the selected period. The standard deviation sample function is calculated as 1/N-1 rather than absolute (1/N).

  • Start Date of Leak. The date on which the leak actually started.

  • Sum of Readings. The volumetric sum total of all interval readings for a service point within the time period, shown in the configured unit of measurement (for example m3).

  • Threshold Days. A configurable value associated with a region or DMA that determines whether a service point crosses a set value causing the service point ID to display. For example, if the threshold days value is set to 30 days for service points with no readings greater than 30 days, all service points with no readings for more than 30 days will display in the table for Endpoints with No Reads table. Service points with no readings for less than 30 days will not display in the table.

  • Total Leakage Volume. The cumulative volume, in liters, lost over the detection period.

  • Trend Hypothesis. The actual consumption trend score for the service point. Depending on the analytics type, the score updates either daily or monthly.

    Note: If the installation date for a service point has not been entered, a zero read score displays.

  • Unit of Reading. The configured unit of reading for each sensor. For units information, see Units of measurement.

  • Year-Month. The year and month (YYYY-MM) that the analytics began.

  • Zero Consumption Start Date. The date on which zero consumption actually started.

  • Zero Read Score. The estimated zero-consumption trend score for the service point.

  • Zero Reading Count. The count of all unique periods for which the reading is zero.

Tip: To change the sort order, click any column header to sort by that attribute. An up arrow appears in the column header, indicating that the sort is in ascending order. Click the column header again to switch to descending order, indicated by a down arrow. For more information about viewing options, refer to Event Investigation page.