Claim lifecycle snapshot
Build a claim workflow fact where one row accumulates milestone dates from opened to closed.
Concept
fact-table-grain
The primary modeling idea this problem reinforces.
Requirements
4
Business needs the model must satisfy.
An insurance operations team wants to know where claims slow down. They need days from opened to assigned, approved, paid, and closed by policy line and claimant state.
Accumulating snapshots are the fact type for pipeline timing. A collection of disconnected milestone facts can answer event counts, but it makes the end-to-end workflow harder to inspect.
- Create a claim lifecycle fact where one row represents one claim workflow.
- Keep the source claim id queryable on the fact.
- Add opened and closed milestone columns plus a claim amount measure.
- Connect the fact to policy and claimant dimensions through explicit surrogate-key relationships.
Template
Claim lifecycle starter workspace
The model users start from in the full workspace.
Entities
2
Seeded tables visible in the public preview.
Dialect
postgresql
Generated SQL target for this starter model.
This preview is read-only. Open the workspace to edit and verify; saving needs a free account.
Open workspaceTry the question first.
The discussion has other people's approaches and solutions. Give it a real attempt before you read them.