Model: GW - Claim Loss Financial - Calendar Year

The GW - Claim Loss Financial - Calendar Year model includes monthly snapshots of claims financials based on the transaction booking date. The snapshots are aggregates of various transaction line item amounts, such as loss incurred amounts, expense payments, salvage recoveries, and medical reserve changes. Analysts can use the model to create visualizations of amounts within accounting periods. They can view amounts by loss cause, location, policy life cycle, and other attributes.

Source tables



The GW - Claim Loss Financial - Calendar Year model is built from a fact table and multiple dimension tables, as shown in the diagram.
Fact:
  • efr_fact_loss_calendaryear
Dimensions:
  • efr_dim_uwcompany
  • efr_dim_namedinsured
  • efr_dim_organization
  • efr_dim_exposure
  • efr_dim_producer
  • efr_dim_month
  • efr_dim_claimant
  • efr_dim_claim
  • efr_dim_region
  • efr_dim_account
  • efr_dim_policyinfo
  • efr_dim_loss_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.

Formulas

Many of the model’s columns are the result of formulas created on the model in Explore. The formula columns aren’t part of the source tables in Explore or Data Studio. Each formula performs a calculation or conversion, usually using source table columns, 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.

These formulas convert dates into business-friendly strings:

  • Accounting Month: The first day of the accounting month
  • Accounting Period: The accounting month
  • Current or Previous Year: Identifies a year as the Current Year (CY) or Previous Year (PY)

Other formulas calculate gross and net amounts for various claims financials. They include both Month-to-date (MTD) and Year-to-date (YTD) aggregates.

MTD, QTD, and YTD aggregates

The model includes Month-to-date (MTD), Quarter-to-date (QTD) and Year-to-date (YTD) aggregates for various claims financial amounts. These columns make it easier to create reports for those time periods. For example:
  • MTD, QTD, and YTD Medical Paid
  • MTD, QTD, and YTD ULAE Expense Reserve Change
  • MTD, QTD, and YTD Indemnity Recovery

Related information