ETL database tables and entities

When the Product Model Loader loads the product model information, it first creates entities that contain the product model information, then saves the entity information to database tables. Use the database table names to extract information from the PolicyCenter database. If you modify the Product Model Loader plugin, you may need to use the entity names.

ETL database tables

For each type of policy model data, the following table shows the ETL entity and database table.

Policy model data

ETL extraction entity

ETL table name

Clause pattern:

ETLClausePattern

pc_etlclausepattern

  • Coverage pattern
  • Exclusion pattern
  • Condition pattern

Coverage term pattern

ETLCoverageTermPattern

pc_etlcovtermpattern

  • Direct coverage term pattern

ETLDirectCovTermPattern

  • Generic coverage term pattern

ETLGenericCovTermPattern

  • Option coverage term pattern

ETLOptionCovTermPattern

  • Package coverage term pattern

ETLPackageCovTermPattern

  • Typekey coverage term pattern

ETLTypekeyCovTermPattern

Exclusion term pattern

ETLCoverageTermPattern

Condition term pattern

Coverage term option

ETLCovTermOpt

pc_etlcovtermoption

Package coverage term option pattern

ETLCovTermPack

pc_etlcovtermpackage

Package term

ETLPackageTerm

pc_etlpackterm

Modifier pattern

ETLModifierPattern

pc_etlmodifierpattern

Rate factor pattern

ETLRateFactorPattern

pc_etlratefactorpattern

ETL entities

The following illustration shows the ETL entities that the Product Model Loader creates. See the Data Dictionary for complete information. You may need to use these entities if you modify the Product Model Loader plugin.


ETL entity relationships.

See also