Model: GW - Claim Inventory History

Claim Inventory History offers a monthly historical analysis of claim volumes and status changes, enabling detailed trend insights by business line, geography, and other key dimensions.

Source tables

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

Fact:
  • efr_fact_statusactivity_claim
Dimensions:
  • efr_dim_uwcompany
  • efr_dim_claim
  • efr_dim_policyinfo
  • efr_dim_organization
  • efr_dim_producer
  • 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 inventory.

For every month, the following identity holds:

  • prior month-end pending claims
  • +new (this month)
  • + reopened (this month)
  • − closed (this month)
  • = current month-end pending claims 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