Validation Closed on dates

Edit online

The Validation - Closed-on dates extract report compares the closed on date of all accounts with the end date of the last data record captured for those accounts. The report also shows variances between the active period of each account and the effective dates of the classification group of the account location.

About this task

Table 1 describes the columns in the report.
Table 1. Report columns
Column Description
Location Location name.
Type In IBM® ESG Suite, type is set to account or meter.
Supplier Supplier of the utility or emission source.
Account Account number.
Account Reference Account reference.
Account Style The account template that is associated with the account.
Data type Type of data, for example, electricity [kWh] or natural gas [GJ].
Replaced On The date on which the account is closed.
Maximum End Period The last end date of all of the records that were captured for the account.
Day Differences The difference between the replaced on date of the account and the maximum end period of the account.
Classification Group End Date The Effective To date of the classification group that the account belongs to, if applicable.
Days Difference from Classification Group End Date The difference between the classification group end date and the maximum end period of the account.

Procedure

  1. In the Global search field in the header, select Reports, and enter Validation - Closed-on Dates.
  2. Select the report from the search results to open the Reports grid.
  3. Click the report in the Reports grid.
  4. Select the option to display the report on the screen, which is the default option.
  5. Click Submit.
  6. Click Download AS CSV on the report.
  7. Review the CSV file to find records with dates that do not align with the date that the account was closed.
    1. Apply a filter to the first row, the header row, of the file.
    2. In Column K - Date Difference, remove 0 (zeros) and blank values.
  8. Review the CSV file to find classification group effective dates that do not align with date the account was closed.
    1. Apply a filter to the first row, the header row, of the file.
    2. In Column M - Days Difference from Classification Group End Date, remove 0 (zeros) and blank values.

What to do next

If you find that the data record dates do not align with the active dates of the account, either
  • Modify the closed on date of the account, or
  • Adjust the dates for the records so that they fall within the accounts active period.
If you find the effective dates of the classification group do not align with active dates of the account, either
  • Modify the closed on date of the account, or
  • Modify the effective dates of the classification group.