## Business Value
Resolve Finance-approved QuickBooks Classes to real Schools or explicit non-school business units, so central costs, camps and initiatives stop appearing as missing Schools. Deliver a weekly school-year-to-date digest to Ashwanth, Marcin, Jan, Keval and Prabal, while retaining self-only test delivery and immutable one-send-per-week evidence.
## Changes
- Add 11 governed non-school business units and 27 exact Realm/Class crosswalks. Add seven missing financial Class-to-School policies; preserve Port Chester's existing source mapping. Keep TSA Microschools unresolved pending Finance clarification, as explicitly requested.
- Preserve PR #2248's newer source-qualified Greenwich posting decisions. The guarded installer patches only the inspected live writer, preserves its owner/ACL and unrelated code, and seeds accepted policy through an atomic owned migration procedure.
- Publish one Core posting-assignment view with resolved School, resolved non-school, unresolved Class and classless partitions. Update report compatibility checks, policy fingerprints, accounting totals, HTML/CSV classification and source-race guards together.
- Schedule Mondays at 10:00 UTC (15:30 IST), retain 1 July-to-report-date coverage, and use UTC Monday weekly delivery claims. Update the exact application/SES production audience; preserve historical daily receipts, uncertain-send protection and self-only tests.
- Leave reader-policy ownership with the DBA. The legacy reader helper now only compiles required report-query columns/joins and verifies worktable capabilities and rejects --apply; pipeline DDL no longer grants/revokes reader access. The exact access request is retained for DBA review.
## Validation
- 230 Core tests and 152 report tests passed; 73 existing opt-in Core cases skipped. The actual Redshift TEMP allocation fixture also passed, scoped Ruff and whitespace checks passed, and the earlier complete CDK suite passed all 1,022 tests across 23 suites.
- Mercy round 1: fix classification from effective Finance dispositions, including stale stored Schools and line-vs-Class business-unit precedence. The writer already applies source-qualified posting overrides last; new SQL regressions execute that canonical UPDATE. The read-only helper now compiles all five actual report queries, including required columns and joins; its live reader check passed.
- Applied the candidate view via canonical transaction fecda385-2db4-4184-96fc-f4c67fca40ad. Quiet deployed preview e5aa1741-d43e-41bd-a9c6-c9efc56c09b3 succeeded with zero compatibility errors and identical 46 grouped rows. All posting values, School assignments, policies/creation metadata, Greenwich decisions, writer body and view owner/ACL remain unchanged. Preview sent no email and left the production receipt/schedule unchanged.
- Candidate task commits were replayed onto production 337e7442 in a separate checkout. Only the Core and report stacks deployed, each separately with --exclusively, [1/1] and verified CloudFormation UPDATE_COMPLETE.
- Quiet supported Core run c7dbb88e-a88d-483d-bff1-189cb63da9d6 succeeded. All 395,034 source posting identities/measures remain unchanged. Seven new School policies resolve 2,071 all-history postings; every other School-assignment fingerprint, all 41 preexisting School policy rows and all 215 Greenwich review rows remain unchanged.
- The Core assignment contract has exactly 395,034 unique postings and zero target mismatches. The 27 non-school Class policies classify 79,568 all-history postings correctly. Two deliberate rollback probes and the final owned-migration idempotence check passed, including unchanged policy creation metadata and removal of the temporary migration procedure.
- Deployed report preview succeeded. One test email went only to Ashwanth; exact CSV/MIME/SES receipt checks passed. The same-week retry skipped with the same SES acknowledgement. All four platform runs are SUCCESS with failure-notification suppression retained; automatic children preserve it.
- Final deployed Python/SQL bytes match the candidate. Production delivery was enabled only after validation; the first scheduled Finance delivery is 9 November, 10:00 UTC / 15:30 IST. No production-audience email was sent during validation. A separate user-authorized Finance digest was subsequently sent on 5 November, outside validation.
CI exposed the existing dev-entrypoint asset cleanup race (ENOTEMPTY after five retries). The test now uses a bounded 20-retry cleanup window; runtime behavior and pipeline assertions are unchanged. All eight checks on the reviewed head b24f9074 subsequently passed; Mercy's cleanup finding cited superseded failed run 42047324490. The task commits were cleanly rebased onto main 6104a54e after the Greenwich PR merged. The review fix changes the assignment view and capability helper; deployed report runtime bytes and schedule configuration are unchanged.
Source, procedure, execution and reconciliation evidence: pipelines/runners/quickbooks-core-tables/validation/2026-11-05-finance-class-mapping.md.
## Required Review and Separate Follow-ups
DBA ownership review is required before merge. During initial validation the legacy helper applied reader SELECT grants on four new dependencies and session TEMP, and initial Core DDL applied new-object reader grants/PUBLIC revokes. The final code removes those write/enforcement paths. The validation record discloses the exact initial scope and readbacks; the DBA owns approval or adjustment of those live permissions. They are not claimed to be DBA-approved by this PR.
TSA Microschools remains intentionally unresolved. Newly encountered/unapproved Classes remain visible in the digest. The shared Finance line-allocation table is the already-live contract from PR #2248; this change neither duplicates its canonical DDL nor overrides its approved rows.
Q22, School Performance QuickBooks, Unit Economics and Table 3 child refreshes succeeded. The separate Aerie financials child still fails at its existing 315-posting Facilities account-policy prerequisite; its failure is quiet and it does not block this Core-backed digest. Registry metadata publication follows the normal release.
## Implementation Effort
Approximately 3–4 engineer-days without AI assistance for policy/identity reconciliation, guarded migrations, Core/report integration, ownership corrections, regression coverage and isolated production validation.
## Linear
https://linear.app/builder-team/issue/SURTR-1699
Related: https://linear.app/builder-team/issue/SURTR-1650 and https://linear.app/builder-team/issue/SURTR-1496 .