## Business Value
Publish Finance-approved Crossover affiliations into the existing canonical School identity map and use them for Guide staffing eligibility. Stable team IDs keep room renames from changing ownership, and explicitly approved non-campus destinations remain separate from Schools. QuickBooks posting spend is preserved.
## Changes
- Publish a ledger-reconciled, atomic observed-room directory from native XO team IDs, retaining IDs across renames and exposing first/last invoice weeks. A real XO pipeline-success event refreshes this directory independently of the existing sources.
- Export Aerie approval metadata and scoped/non-campus rules through Rhodes. Require all six coherent raw publications in Core, extend the existing xref_school_source with crossover/teamroom, and atomically publish the governed affiliation reference alongside the ontology.
- Extend dim_school_identity with current native room IDs/names and a version 2 identity hash; add explicit mapping coverage. Include an atomic restricted view-recreation migration because Redshift cannot replace an existing view with extra columns.
- Replace Guide room-name inference with approved current affiliations. Native contractor IDs resolve first; name fallback must be unique. Exact person > exact title > room precedence avoids duplicate counts. Known unmapped/ambiguous Guide evidence fails before target replacement, retaining last-good output and all original QuickBooks spend.
- Preserve the legacy QTD affiliation table and existing Finalsite/source contracts. Document the staged rollout, precise isolated stack targets, prerequisite gates and rollback behavior in CROSSOVER_ROLLOUT.md.
Companion Aerie PR: https://github.com/AI-Builder-Team/Aerie/pull/1909
## Reviewed data scope
Column F's explicit changes are accepted as reviewed destinations under the user's instruction. The prepared Aerie plan contains 256 ready decisions (219 campus and 37 non-campus). TSA Onsite remains pending, as do two clarification rows and four potentially legacy rooms; the pending title-rule tab is not imported. Seven newly observed IDs absent from the workbook stay unmapped.
## Validation
- 928 focused Python tests pass: Core ontology 91; Rhodes staging 207; source directory 76; the full financial pipeline suite 554. Tests cover native IDs across renames, duplicate-name safety, exact rule precedence, exclusive periods, preserved spend, approval projection, source/event gates and shared lock ordering.
- Two focused CDK tests pass, verifying the real directory manifest has all four triggers and preserves the XO upstream execution context and notification suppression.
- Read-only live execution of the candidate directory SELECT returned 270 rooms and all 256 ready workbook IDs. Latest accepted XO publication: 2026-10-15 07:30:23 UTC; 1,662 fetched/published invoice rows.
- The candidate identity SELECT runs against live inputs with its directory supplied as a read-only CTE: 118 Schools and the existing 58 Finalsite-linked Schools. No candidate mappings were imported by this check.
- Changed Python files are formatted. Ruff baseline comparison finds no newly introduced diagnostics (28 existing findings in changed files versus 33 at base). No unrelated files were linted or formatted. git diff --check passes.
## Review follow-up — 20 October 2026
- Merged current main, retaining both Crossover and Finance lock-order coverage and all Rhodes API coverage tests.
- Guide/Lead Guide publication now requires an approved School, other-School or non-campus affiliation. Missing XO identities, unmapped/ambiguous evidence and unknown/null statuses fail before target replacement; original posting spend remains unchanged.
- The Core verifier validates the source run ID against the runner's shared 1–128 character allowlist before connecting or building any query.
- The Rhodes SchoolLink rejection finding was not reproducible: the reviewed transform already accepts xoTeamroom. Added active/archived link projection assertions and native team-ID regression cases.
- Current local validation: 1,225 Python tests pass across Core (100), Rhodes (298), source directories (76) and financials (751); two live financial integration tests are skipped. All 34 pipeline construct CDK tests pass. Ruff 0.15.22 lint/format pass for the five Python files changed in this follow-up; git diff --check origin/main passes.
- No production deployment or pipeline invocation occurred. The staged pre-merge live-validation requirements below still apply.
## BLOCKERS / pre-merge live validation
Pre-merge live validation remains blocked. No production schema/stack deployment, mapping import or candidate pipeline execution has occurred. User authorization is still needed for the staged candidate deployments against shared production schemas. The user has confirmed Marcin Pindral as reviewer and 15 October 2026 00:00 IST as the current-only effective cutover; the import plan now records that confirmation. No historical ownership before the cutover is asserted.
Before merge, deploy each affected candidate stack independently with --exclusively, verify CloudFormation events, trigger the required producer/affected pipeline with inherited failure-notification suppression, monitor terminal execution and reconcile the outputs. Deployment alone and read-only SELECT checks do not satisfy live validation. Preflight unresolved Guide evidence before running that consumer; report a data blocker rather than invoking a guaranteed failure or weakening the gate.
## Implementation Effort
Estimated 4–6 engineer-days for an average engineer to hand-code and test the four pipeline contracts, governed publication, SQL consumer changes, migrations and rollout workflow without AI assistance, excluding production validation and Finance wait time.
## Linear
https://linear.app/builder-team/issue/SURTR-1469/encode-finance-teamroom-rulings-in-ref-qtd-hc-teamroom-affiliation-r1
https://linear.app/builder-team/issue/SURTR-1478/tsa-onsite-platformcorporate-title-rule-in-ref-qtd-hc-title-role-r2