Model: GW - Cash Balancing

The GW - Cash Balancing model includes monthly aggregates of billing transactions that affect cash or cash held in a pending state. Analysts can use it to create visualizations of cash amounts by month, transaction subtype, product, producer, and other attributes.

Source tables



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

Fact:
  • efr_fact_cash_balancing
Dimensions:
  • efr_dim_bill_unappliedfund
  • efr_dim_bill_disbursement
  • efr_dim_bill_suspensepayment
  • efr_dim_bill_basemoneyreceived
  • efr_dim_bill_account
  • efr_dim_bill_producer
  • efr_dim_bill_policyperiod
  • efr_dim_bill_policy

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.

Line item aggregates

The model includes monthly aggregates for various line item amounts, such as cash, collateral held, and unapplied.

Cash balancing formulas

The model includes formulas that summarize how cash moves through the billing system each month, including cash paid out, cash received, and the resulting net cash position. These formulas also capture producer-related cash flows and suspense activity.

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