Vacant Premises with Consumption - CI_VACANT
Report Description
This report shows all premises that are considered vacant, and provides information about the level of consumption, the period of vacancy, and the service point and register information.
This report selects service points that are linked to a service agreement that is either canceled or closed. The report excludes any service points that have never been linked to a service agreement. If consumption has been registered at such a service point since the end date of the service agreement, the service point's details are displayed.
This report may be used by the utility to investigate sites where problems such as service theft or leakage may be occurring.
Note:
Performance Consideration. If your implementation chooses to use this report, you may consider adding an index to the CI_SA_SP on STOP_DT to aid in performance. When making this decision, carefully weigh the benefit of improving report performance against the possible degradation to the performance of day-to-day processing as a result of defining a new index. In addition, many companies opt to create a reporting database that is a shadow of production to ensure that indexes defined to benefit reports may be created without any effect on the production environment.
Parent topic