Interval Status Summary

The Interval Status Summary is used to monitor interval datastreams for which reads are missing. Based on the results of this report, you can investigate why intervals are considered missing within IEE.

Important!  This screen is available only if the Meter Data module is installed and is limited to user personas with roles that include the “View Interval Status Report” grant.

Explanations for missing intervals include the following possibilities:

  • Reads may not have been received from a collection system.
  • IEE may not have generated substitutes for missing type 5 reads.
  • IEE may not have generated forward estimates for type 5 meters.
  • Substitutes may not have been converted to final within the required time frame.
  • A user may have incorrectly edited reads from IEE.
  • Unmetered Supply (UMS) may not have been calculated.

Important!  This report requires extensive data processing. It is supported by a scheduled process that runs in the background (preferably at least daily) to determine missing data. Basic meters are excluded from this report. This report does not consider whether MTS has successfully sent any given reads. While read status is used to generate results, it is excluded from the actual report.

Note:  By default, the screen displays missing records for the last month. To modify the date range, click the calendar icon () in the page header. You can select presets for Today, Yesterday and today, Yesterday, Last 7 days, Last 30 days, This month, Previous month, or Custom range. The Custom range option allows you to edit the date range (the beginning date can be up to two years in the past).

The table consists of the following columns:

  • NMI. The NMI with missing intervals.
  • Suffix. The suffix of the datastream with missing intervals. A suffix is a two-character identifier (for example, N1) used in conjunction with an NMI to identify a particular datastream.
  • Route. The route with missing intervals.
  • Meter data provider. The MDP participant with missing intervals.

  • First missed read. The first read date of the missing period (inclusive).

    Note:  The date fields do not display a time component. The Interval Status Summary identifies days that contain missing reads, not the missing intervals themselves.

  • Last missed read. The last read date of the missing period (inclusive).

Tip:  To filter the table by NMI or other known values, click the filter icon () to open a dialog box. From here, enter all or part of an NMI number or select any of the available items under Route, Meter type, Meter data provider, or NMI group. Under Include substituted readings, you can select whether to include Readings (substituted values from IEE count as readings) or Missing readings (substituted values from IEE count as missing readings). In addition, you can adjust the date range from the calendar in the page header.

The Actions menu () in the page header provides the following options:

  • Export. Creates a .csv or .xlsx file that contains the table data for the selected date range. The default date range is the last 30 days from the current day, as specified in the page header.
  • Column order. Enables you to adjust the order of the columns. The adjusted order will persist in subsequent views if you use the same device and browser.
  • Column visibility. Enables you to adjust which columns are visible or hidden. The adjusted visibility will persist in subsequent views if you use the same device and browser.