## Business Value
Schools with resolved enrollment can receive QTD reports using the approved Finance assumptions even when other students lack School mappings or QuickBooks budgets are incomplete. Missing budgets remain visible data gaps; actuals and independent unit-model comparisons remain available.
## Implementation
- Publish unresolved-enrollment findings and coverage atomically with financial marts. Retain source observations, restore resolved students automatically, and keep ambiguous identity and other non-budget gates blocking.
- Capture the approved Finance sheet's 31 model definitions and 12 canonical School assignments, including Highland Park's new model and the 1.15 staffing burden. Preserve effective history and unrelated Class assignments. The three QTD detail consumers now share the governed reference used by Tables 2/3.
- For the 42 approved October 16 Schools, permit missing QuickBooks budgets in every category, including Staffing, Guide and Lead Guide. Missing budget, variance and variance-percent cells display Unavailable, with an exact Data gaps to fix category list.
- Process up to ten Schools concurrently with independent clients, a fenced batch lease, API pacing, saved research and approved-text checkpoints, isolated School failures and review-only delivery. Version the renderer so a format repair can rebuild documents while retaining reviewed inputs and narratives. Fit unavailable labels at readable sizes.
- Preserve comparison categories and student units, require the claimed per-student measures, review every narrative field against full evidence, and reject incomplete or contradictory audit approvals. Keep adjacent per-student and School-total body claims on their own units.
- Apply the approved exact Novatio account 162 transaction-fee mapping using accepted source-ledger evidence. Idempotent retries inspect current state separately from retained history and preserve the original reviewed capture and marker.
- Keep warehouse application explicit: private backups, exact Class fingerprints and history verification, checks that survive Python optimization, and post-lock catalog guards before replacement DDL. Install the reference publisher, temporary migration, privileges and publication call in one transaction; preserve owners and ACLs.
## Validation before the October 20 review fixes
- Local suites: 524 report tests, 592 financial tests, 55 unit-economics tests and seven Novatio repair tests passed. Changed Python files pass Ruff formatting/checks. The model-consumer SQL tests execute all 31 approved fixtures. Every CI test/lint job on 45423ad7 passed; automated review of the latest commit is separate.
- Live reference publication verified all 31 exact definitions, 12 Schools and 42 reviewed Class identities. Seven superseded assignments remain historical, unrelated assignments and rendering rules are retained, and repeat publication adds no policy history. Annual staffing/program model amounts reconcile to the approved reference across all 42 positive-model Schools in the detail marts.
- QuickBooks Core e81bd02b-44a1-4d73-959d-439c9d476f20 and the required financial, QB-budget, unit-economics and per-student runs succeeded. Financial run 51afec55-12e9-4528-a6ba-5eb5c8a5ea37 passed every QTD sibling postcheck.
- Final 34-School batch 1b08e6a0-c7cc-42f8-b611-7127c0b3a3f1 succeeded with no remaining failures. Each report uses the new assumption version and 1.15 burden. Native document readback matches its payload, immutable PDFs pass validation, and the review digest was sent only to Ash. The prior 17 assumption-version-v1 documents remain historical copies. Provider/audit failures were recovered from checkpoints, with targeted narrative corrections reviewed before publication.
- Hardened helpers passed live with Python optimization enabled: three consumer definitions and enrollment DDL installed under locked catalog guards, an atomic reference publication passed exact-identity/history/idempotency verification, and repeated Novatio calls preserved policy. Owner/ACL parity was verified.
- Deployed only Pipeline-school-performance-reports-prod with --exclusively; CDK confirmed [1/1], and CloudFormation events confirmed UPDATE_COMPLETE. Candidate task revision 59 contains the reviewed runtime source. Fresh Charlotte validation 4dbf996d-416d-4027-bbcf-a0bfc826a24c succeeded with an approved narrative, exact native readback and validated PDF; completed 34-School artifacts were retained.
- All manual runs suppress failure notifications, and automatic downstream links inherit that preference. Logs/run records and operational alarms remain enabled. The unrelated Q22 consumer still rejects run_options; it is not a report input.
Eight Schools remain blocked only by enrollment inputs: Bethesda, Boston Suburbs, Houston Heights, Fort Lauderdale, Marin County, Orlando, San Juan PR and Tampa. Their model assignments are resolved; missing budgets no longer block this approved October 16 population.
## Review fixes — 20 October 2026
- Persist the Finance assumption version on all three QTD sibling marts, reject legacy or mixed versions in report reads, and migrate the existing Aerie P&L model consumer to the same approved reference, including Highland Park.
- Require the complete approved 31-model set, preserve unrelated policy versions, re-audit stale corrections regardless of the retained audit checkpoint, retain per-student budget evidence, and reject absent/duplicate enrollment telemetry.
- Check exact installed procedure sources and privileges before deployment transactions commit. Finance publication verifies approved values, preserved policy/history/rules and repeat-call idempotency, then removes its temporary procedure in the same transaction.
- Strengthen enrollment fixtures with exact eligible observations and ineligible cases; correct operator documentation and missing-assumption diagnostics. Three older claims already match the code: rejected audit aggregation, distinct student counting and null variance-percentage enforcement.
Validation for aeb7e86c: 632 financial, 540 report and 64 unit-economics tests passed; changed Python files pass CI-pinned Ruff 0.15.22 and all three deployment helpers pass offline dry runs. The helper-import follow-up also passed 27 targeted catalog/deployment tests. The Redshift reserved-alias repair passed the 64-test unit-economics suite and the live atomic publication.
Live validation on October 20:
- Applied the P&L and three QTD definitions with exact before-commit source/owner/ACL checks. The Finance helper verified 31 exact model definitions, 12 Schools, 42 Class identities, preserved policy/history/rules and repeat-call idempotency in one transaction. Its initial reserved-alias failure left all four reference/policy tables unchanged; the corrected retry succeeded.
- Deployed only Pipeline-mart-aerie-education-financials-refresh-prod and Pipeline-school-performance-reports-prod, each with --exclusively and [1/1]. Both stacks reached UPDATE_COMPLETE; CloudFormation events were retained. The financial Lambda source matches the candidate exactly; report task 61 uses the image whose staged reader/insights sources match the candidate.
- Financial run 27646f18-e912-4689-88df-1ff2a0e35c46 succeeded, including all three QTD postchecks. All 21,056 QTD rows across 64 Schools carry the approved v2 assumption version. All 6,948 model staffing-detail rows use 1.15. Highland Park's nine-student model now publishes annual tuition of $540,000, Programs of $90,000 and total staffing of $224,250.
- The reader accepts Highland Park's coherent live six-mart publication and rejects an in-memory legacy-version substitution in each QTD sibling. The run retained skip_failure_notification=true, produced no failure notification and recorded 1,433 historical enrollment exclusion observations / 11 current distinct students with has_unresolved_students.
BLOCKER — end-to-end report generation: the current cutoff is October 20. Thirty-eight Schools have missing required budgets (tuition, other revenue, Staffing, Facilities or Guide roles); the other four lack positive enrollment. Ash explicitly chose to retain the October 16 exception and leave report validation blocked. No report execution or report email was attempted. The prior live report-generation evidence above applies to the previous candidate.
CI on aeb7e86c: all seven CI jobs pass, including the full runner tests. The automated-review job completed its analysis but failed to post the review with HTTP 401 (Bad credentials); its saved artifact contains additional findings.
Merge decision on October 20: Sanket approved exact commit aeb7e86c. Ash explicitly authorized merging that approved commit while accepting the blocked end-to-end report validation and the additional unposted review findings. The October 16 reporting policy remains unchanged. Disclosed outstanding findings include the reproduced mixed-unit headline validation bug and the unqualified temporary-table cleanup risk. A tested headline fix is retained separately and is not included in this approved commit.
## Implementation Effort
Approximately four engineer days to implement, test and validate by hand without an AI agent.
## Linear
[SURTR-1640](https://linear.app/builder-team/issue/SURTR-1640/publish-resolved-school-financials-with-unresolved-enrollment-findings)