Adjust claims desk · Quillmark Mutual
World clock Mon 17:00:00 CET paused · 60×

Definitions

The claims terms the operator, its detectors and Ask all run on. Each has an owner, a version, SQL and tests. Edits make a new version.

Benchmark

benchmark unit: documents

What a repair of this kind usually costs: the p50 and p90 of last year's settled claims for the same line, peril and band (vehicle class, or home product). Every estimate is read against its benchmark.

pricingHead of Claims Pricing · pricing v3

Estimates received in the period, each with the benchmark for its claim's line, peril and band (benchmark table version 3) and the estimate's ratio to the p50.

latest change: Benchmarks refreshed from the year to September; property contents became its own band.

  • pass count_betweenobserved 2163, expected between 500.0 and 5000.0
SQL, rendered for now
SELECT d.id AS document_id, c.id AS claim_id, c.claim_no, c.line, c.peril, c.band, d.amount AS estimate,
       b.p50, b.p90, round(d.amount / b.p50, 2) AS ratio_to_p50
FROM documents d JOIN claims c ON c.id = d.claim_id
JOIN benchmarks b ON b.line = c.line AND b.peril = c.peril AND b.band = c.band
WHERE d.kind = 'estimate' AND d.received_at >= TIMESTAMP 'Mon 17:00:00 (7 days ago)' AND d.received_at < TIMESTAMP 'Mon 17:00:00'
ORDER BY d.id

History

append-only; nothing is edited in place
  1. definitionHead of Claims Pricing pricing v3 Benchmarks refreshed from the year to September; property contents became its own band.
  2. definitionHead of Claims Pricing pricing v2 Spring refresh.