Model: GW - Exposure Inventory History

Exposure Inventory History offers a monthly historical analysis of exposure volumes and status changes, enabling detailed tracking and analysis of exposure trends across various business dimensions.

Source tables

The GW - Exposure Inventory History model is built from a fact table and multiple dimension tables, as shown in the diagram.

Fact:
  • efr_fact_statusactivity_exposure
Dimensions:
  • efr_dim_uwcompany
  • efr_dim_exposure
  • efr_dim_claim
  • efr_dim_producer
  • efr_dim_policyinfo
  • efr_dim_organization
  • efr_dim_account
  • efr_dim_namedinsured
  • efr_dim_month

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

Formulas

Each row in the model represents one claim for one calendar month. The measures capture counts of new, reopened, and closed claims for that month, and these measures reconcile to the month-end pending exposure inventory.

For every month, the following identity holds:

  • prior month-end pending claims exposure
  • +new (this month)
  • + reopened (this month)
  • − closed (this month)
  • = current month-end pending claims exposure inventory
If a claim is closed and reopened multiple times within the same month, each transition contributes to the monthly activity totals.

A parallel exposure-level model applies the same status-activity logic at exposure grain, while also carrying the parent claim so you can drill from exposure-level patterns up to claim-level views.

Note: Formulas are created on the model in Explore. They aren’t part of the source tables in Explore or Data Studio. Each formula performs a calculation and the result is an additional column in the model. For a list of all formula columns and their expressions, see the Data dictionaries for Explore models

Related information