Product Model Loader

Overview

The PolicyCenter database stores policy data for individual policies. However, the policy data does not contain actual values for coverage terms and other product model information. That is, for an individual policy, the policy data includes a coverage term, but not the value of the coverage term. The data that the Product Model Loader creates enables you to discover that this coverage term is a $1,000 collision deductible. Using an ETL process, you can combine the policy data with the Product Model Loader data and store it in a data warehouse or data store for analysis or reporting.

You can access complete product model information in Product Designer or by browsing through policy transactions in the PolicyCenter application user interface. However, the PolicyCenter database does not store product model information such as the values of coverage terms. Usually, an ETL process works with the PolicyCenter database, not the PolicyCenter application. To facilitate ETL processing, the Product Model Loader creates and stores product model information in PolicyCenter database tables.

The Product Model Loader extracts product model data for all lines of business. In the base configuration, the Product Model Loader extracts the following information from the product model:

• Coverage term and coverage term option information, including type, name, and value. Common examples of coverage terms include limits and deductibles.
• Clause name and clause type (coverage, exclusion, or condition).
• Currency information on coverage term options.
• Modifier name and, if applicable, associated typelist and associated rate factor names.

The Product Model Loader loads database tables with the product model. This product model information enables you to map the data for individual policies to actual names and values in the product model. The Product Model Loader information provides the decoding or mapping of the pattern identifier, such as a coverage term option, to the name and/or value of that option. Join the policy information (which only contains the identifier) with the product model information to retrieve the name and value of the options selected in the policy.

If you add policy lines or add clauses and coverage terms to existing policy lines, the Product Model Loader creates ETL product model tables for these additions. You can also extend the Product Model Loader to access other product model data, including product offerings or questions in question sets. These changes may require modifying the ETL entities.

The Product Model Loader is implemented as a plugin that runs when PolicyCenter starts.

See also

• ETL Product Model Loader plugin