Claims FNOL

A property-and-casualty claims process from first notice of loss to settlement. A claim is triaged, validated against coverage, and assigned to a regional adjuster whose caseload is capped — assignment is a first-match message that the adjuster can defer when full, with the claim retrying later. Reserves develop during investigation, drawn from a peril-and-severity dependency chain, before the claim settles, is denied, or is withdrawn.

A faithful model of a staffing bottleneck. Because the coastal region receives a disproportionate share of claims against a thin adjuster pool, a queue emerges there while other regions idle — the kind of capacity-versus- demand imbalance you can quantify directly from the exported tables. Built to study throughput, routing and where to add headcount.

# claims-fnol.osi.yaml — emitted automatically
semantic_model:
  name: "claims-fnol"
  source: "duckdb://claims-fnol.db"
  entities:
    - name: claim
      primary_key: id
  dimensions:
    - name: state
      type: categorical
    - name: t
      type: time
  measures:
    - name: row_count
      agg: count
    - name: active
      agg: sum
      filter: "state = 'ACTIVE'"