WorkflowPatchProgram ops KPI proof.
A redacted or synthetic proof for Airtable and Zapier-backed education program operations. It turns redacted or synthetic attendance, staffing, and KPI source rows into a program ledger, dry-run KPI output, exception queue, blocked event queue, and hard errors before any live child/family data, staff-facing decision, parent message, Airtable write, Zapier action, or ongoing support commitment.
Program Ledger CSV
KPI Output CSV
Exception Queue CSV
Blocked Event Queue CSV
Error Log CSV
Source Events CSV
Program Policy CSV
Field Policy CSV
Runbook
Source Script
Source Rows
Attendance, staffing, and KPI rows stay synthetic or redacted.
Program Ledger
Accepted rows map one site and week to a dry-run ops decision.
KPI Output
Reporting rows are internal-review only until approved.
Exception Handling
Missing attendance, coverage gaps, sensitive rows, duplicate rows, and malformed inputs stop visibly.
| Source | Site Week | Decision | Output | Boundary |
|---|---|---|---|---|
| Attendance export | nory-tribeca / 2026-W25 | attendance_ready | attendance_completion_snapshot | Dry-run ledger only. |
| Staffing chart | nory-boston-cambridge / 2026-W25 | staffing_ready | staff_coverage_snapshot | No staffing decision. |
| Missing attendance | nory-downtown / 2026-W25 | missing_attendance_rows | exception-queue | Confirm source completeness before KPI output. |
| Child/family-sensitive row | nory-tribeca / 2026-W25 | child_family_scope | blocked-event | Use redacted or synthetic rows only. |