Examiner audit trail
Run templatedemo-audit-reviewno bindings
select examiner_id, query_signature, row_count, accessed_at from compliance.examiner_audit order by accessed_at desc
Fetching read-only canonical view.
Seeded from compliance.examiner_query_templateruns as compliance_examiner5-minute statement timeout
demo-audit-reviewselect examiner_id, query_signature, row_count, accessed_at from compliance.examiner_audit order by accessed_at desc
demo-metropol-exceptionsselect borrower_id, bureau_name, exception_code, odpc_basis, reviewed_at from credit.bureau_review where bureau_name = :bureau_name order by reviewed_at desc
demo-loan-chainselect event_type, occurred_at, subject from events.events where correlation_id = :correlation_id order by occurred_at
demo-mpesa-disbursement-reconselect loan_id, mpesa_receipt, till_number, amount_kes, posted_at from payments.mpesa_disbursement where till_number = :till_number and posted_at >= :since
demo-ecl-stageselect loan_id, current_stage, ead, pd, lgd, ecl_amount from risk.ecl_snapshot where current_stage = :stage