Model: GW - Policy Premium ITD

GW - Policy Premium ITD includes inception-to-date monthly snapshots of various charges related to policies. Aggregates span the period from the time that a policy originates to the current month. Analysts can use the model to create visualizations of premium amounts for a policy by the policy effective date. They can view amounts by line of business, coverage, producer, and other attributes.

Source tables



The GW- Policy Financial Premium ITD model is built from a fact table and multiple dimension tables, as shown in the diagram.

Fact:
  • efr_fact_prem_itd
Dimensions:
  • efr_dim_policyinfo
  • efr_dim_uwcompany
  • efr_dim_organization
  • efr_dim_producer
  • efr_dim_region
  • efr_dim_coverage

From each table, Guidewire selected specific columns to include in the model. They’re typical columns used in reporting and analysis. For details about each column in the model, see the Data dictionaries for Explore models.

Filters

The model is intended to be a current row view, containing only the latest records. But, some of its source dimension tables contain historical change data. In order to exclude that change data from the model, filters are added to the following expiration date columns in Explore. The filters work because the latest records always have an expiration date of 12/31/9000.
Source table Model column name Filter expressions
efr_dim_organization Organization Row Exp Date >= 12/30/9000
efr_dim_producer Producer Row Exp Date >= 12/30/9000
efr_dim_uwcompany UW Company Row Exp Date >= 12/30/9000
To learn more about filters, see Filters.

Hidden columns

The expiration date columns have the property Hidden = Yes, which is set on the model. These columns are hidden because they aren’t useful for reporting, but are used in the model’s filter.
  • Organization Row Exp Date
  • Producer Row Exp Date
  • UW Company Row Exp Date

To learn more about hidden columns, see Column properties.

Related information