Sources
Which system each fact comes from, who owns it, and how fresh it is at 17:00:00 CET.Systems
8| System | What it holds | Owner | Refresh | Last refreshed (CET) | Age | Keys | Note |
|---|---|---|---|---|---|---|---|
| ClaimDesk | claims system | Head of Claims Operations | realtime | Mon 17:00 | 0 s ago | ||
| PolicyBook | policy administration | Head of Underwriting Operations | nightly | Mon 00:00 | 17 h 00 min ago | ||
| DocVault | document store | Claims Operations | realtime | Mon 16:59 | 60 s ago | ||
| PayRun | payments ledger | Claims Finance | every 15 minutes | Mon 16:51 | 9 min ago | ||
| CallLog | telephony and email log | Customer Contact | every 5 minutes | Mon 16:57 | 3 min ago | ||
| Benchmark tables | repair-cost benchmarks | Claims Pricing | quarterly | Thu 17:00 (46 days ago) | 46 days ago | ||
| Recoveries tracker | subrogation register | Recoveries | hourly | Mon 16:26 | 34 min ago | ||
| Workforce planner | rosters and leave | Claims Operations | nightly | Mon 00:00 | 17 h 00 min ago |
The world
Quillmark Mutual, an invented insurer in the invented country Estmark · clock CET| Code | Country | Currency | Time zone | Regions |
|---|---|---|---|---|
| EM | Estmark | EUR | Europe/Amsterdam (CET) | Saltmere Coast, Brennmoor, Calvenshire, Westerfen, Duneholt, Orrisdale, Ketterlund |
Public knowledge
- claims practice in general: first notice of loss, police reports for theft, total-loss lines, subrogation
Assumed
- every name, number, share, cost, delay and fault in the world
Facts and their source
| Fact | System | Table / column | Join key | Used by |
|---|---|---|---|---|
| assignment | ClaimDesk | claims.adjuster_id | ||
| claim | ClaimDesk | claims.* | ||
| claim event | ClaimDesk | claim_events.* | ||
| policy in force | PolicyBook | policies.term_start | ||
| policyholder | PolicyBook | policyholders.* | ||
| vehicle value | PolicyBook | policies.vehicle_value | ||
| document | DocVault | documents.* | ||
| photo taken at | DocVault | documents.taken_at | ||
| payment | PayRun | payments.* | ||
| contact | CallLog | contacts.* | ||
| benchmark | Benchmark tables | benchmarks.p50 | ||
| recovery | Recoveries tracker | recoveries.* | ||
| adjuster on leave | Workforce planner | adjusters.leave_from | ||
| team caseload | Workforce planner | teams.caseload |