SYSTEM FOR CALCULATING, ANALYZING AND TRACKING REGULATORY RECOVERY IN A RELATIONAL DATABASE RELATING TO REGULATORY MANAGEMENT

摘要

A system for calculating, analyzing and tracking regulatory recovery relating to regulatory management has been developed. The system includes, a mapping interface for mapping the source data from multiple source databases, analysis keys that are applied and act as data tags to the mapped source data and a storage database for storing the mapped source data. A jurisdictional template is used for filtering mapped source data in order to model the data for a specific jurisdiction. Next, a case ledger layer that generates rate cases based on filtered mapped source data. A regulatory monitoring tool is then used to monitor regulatory recovery performance. Finally, a revenue requirements manager that analyzes both historical and forecast rate cases generates a user report.