Accounts incomplete data report

The Accounts Incomplete Data report provides details of accounts that contain missing or overlapping data across a reporting period.

The report also provides information about the data that is entered for an account if missing or overlapping data is reported. The information provides you with some context about the data that was captured for other months for the account. Table 1 describes the fields in the report.
Table 1. Report fields
Column Description
Organization Organization name.
Group Group name. Since an account can belong to multiple groups, this report includes the full group string, separated by a semi colon, as reference information.
Location Location name.
Account_Number Account number.
Start_Period Start date for the period that the report was run for.
End_Period End date for the period that the report was run for.
Account_Ref Account reference
Supplier Supplier of the utility or emission source.
Reader Indicator of whether the data was manually captured or captured by a connector.
Opened_On Date that the account was opened.
Replaced_On Date that the account was closed, if applicable.
Data_Type Type of data, for example, electricity, gas.
Period_Starting The data is reported in monthly blocks. The starting period refers to the start date within each monthly block.
Days_In_Month Number of days within that particular month.
Expected_Days_In_Month The number of days that data is expected in the month.
Days_Of_Data The number of days within that month that contain actual data.
Units Quantity or consumption units.
In Unit of measure.
Daily_Rate Daily rate or the monthly block that is calculated by dividing by the units.
Days_Mismatch The number of days missing in each monthly block for each account. This is calculated by subtracting Days_Of_Data from Expected_Days_In_Month.
Consolidation The percentage of the account that is included in enterprise reporting.

Report behavior

For the report to be effective in identifying missing data, accounts must have an Opened_On date defined. Otherwise, when the report is run for a reporting period that is dated earlier than the account has data for, it will report it as missing data. Similarly, if an account has been closed and no Replaced_On date has been set, then when the report is run for a period extending past the Replaced_On date, missing data will be reported for the account.

Account data is not be included in the report unless the account contains some missing or mismatched account data for the selected reporting period.

The report also provides information on what data has been entered in the account if missing or overlapping data is reported for you to have some context for the data that has been captured in other months for that account.

The report only shows contiguous data. Gaps in contiguous data indicate that data is missing. This is because by definition the data should be continuous. In contrast, gaps in event data could relate to periods of non-consumption, rather than missing data.

Contiguous and event data are described as follows:
Contiguous data
Relates to a continual data stream, for example, electricity data. In this case, one bill commences as the other ends. For example, 14-Jan-2011 to 13-Feb-2011 with the next bill from 14-Feb-2011 to 13-Mar-2011.
Event data
Relates to sporadic data points, for example, fuel or flight data. In this case, data is recorded as discrete consumption points. For example, flights were taken on 5-Jan- 2011 and 7-Jan-2011 and then no flights until 15-Apr-2011. This is not missing data

Finding data mismatches

To find mismatches, complete these steps:
  1. Run the report. In global search, select Report, and enter Accounts Incomplete Data report.
  2. Select the report from the Reports grid to open it.
  3. Define the report criteria.
  4. Download the report as a CSV file.
  5. Apply a filter on the header row.
  6. Filter the report to remove any 0 values in Days_Mismatch. The report updates to show records that have a value in Column T - Days_Mismatch only.
  7. Review the records that are identified as having missing data or mismatched account data.
Mismatch problems are described as follows:
Positive Days_Mismatch
There is missing account data in the period.
Negative Days_Mismatch
There are overlapping periods in your account data. For example, a value of -1 indicates that the last day of one period overlaps with the first day of another period.

Resolving mismatched data

Navigate to the mismatched accounts and follow the data capture process to fill in any missing data and to correct any periods of data that overlap. For more information, see Capturing data records manually.

Run the Accounts Incomplete Data report again to ensure the affected accounts no longer show with any mismatched days.
Note: It is recommended that you run this report weekly to keep up-do-date with missing data and to maintain account data integrity.