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.

Claims paid

paid_amount unit: EUR

Money paid out on claims, to garages, contractors and claimants.

financeHead of Claims Finance · finance v1

Payments whose paid_at falls in the period, in EUR. Held payments are not paid.

latest change: First version.

  • pass value_betweenobserved 7177353.11, expected between 500000.0 and 30000000.0
SQL, rendered for now
SELECT p.id AS payment_id, p.claim_id, p.payee_type, p.amount, p.paid_at
FROM payments p
WHERE p.paid_at >= TIMESTAMP 'Mon 17:00:00 (7 days ago)' AND p.paid_at < TIMESTAMP 'Mon 17:00:00'
ORDER BY p.id

History

append-only; nothing is edited in place
  1. definitionHead of Claims Finance finance v1 First version.