The Product Profitability Reporting (PPR) system project was formed in 1988.
The concept of the PPR system includes two major components: PPR Accounting and Data Warehouse efforts. The data warehouse brings together many varied formats of transaction data into one consistent format which is reconciled to financial data, and is balanced from the transaction system to the warehouse.
The PPR Accounting effort identifies revenue and claims cost using a product matrix. This matrix includes SBU, Rating Line of Business, Risk, Fee Arrangement, Product, Network, Reinsurer, and Renewability.
Business decisions were made at the client place to move all reporting (internal and external) from current sources to the data warehouse. The data warehouse is the single source of data for this purpose.
The PPR is a data warehouse, on-line and reporting database. It contains both current, snapshot and historical data. The PPR project has different feeds in the form of Daily, Weekly and Monthly and contains tables loaded in different subject areas like as below:
- Claims Databases
- Corporate Decode
- Group Databases
- Income Databases
- Provider Databases
- Policyholder/Participant/Member Databases
- Summary Databases
This application was developed on the mainframes and data warehousing technologies and Tetrasoft effectively manages the maintenance and production support.