WorkflowPatchPostgres statement email proof.
A redacted or synthetic proof that groups database rows into weekly statement drafts. Approved rows become a statement ledger and email draft queue; missing recipients, already-sent keys, draft source rows, and duplicate record ids are blocked or logged before any external email sends.
Statement Ledger CSV
Email Draft Queue CSV
Blocked Statements CSV
Error Log CSV
Session Records CSV
Send History CSV
Runbook
Source Script
Input
Eight mock source rows and one prior send-history key stand in for a PostgreSQL weekly query.
Accepted
Two weekly statements are grouped, totaled, and held as approval-required email drafts.
Blocked
Missing recipients, draft rows, already-sent statements, and duplicate source ids are visible.
| Record Or Statement | Status | Issue | Evidence | Reviewer Action |
|---|---|---|---|---|
| 2026-05-04 pair statement | draft ready | grouped weekly statement | REC-1001 and REC-1002 grouped into one statement key. | Approve draft before sending through the mail provider. |
| REC-1003 | blocked | missing pair recipient | party_b_email is empty for a pair statement. | Fix recipient mapping before any draft exists. |
| REC-1006 | blocked | statement already sent | Statement key already exists in send-history.csv. | Do not resend unless replay is explicitly approved. |
| REC-1005 | error | duplicate source record id | record_id appeared earlier in this run. | Repair the source query or dedupe before replay. |