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: EURMoney 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- definitionHead of Claims Finance finance v1 First version.