# Reporting Window Acknowledgement

## v4.12 platform-expansion state

- Release use: existing accepted SQL contracts remain the factual reporting baseline; v4.12 adds conceptual and navigational connections without broadening any accepted query boundary.
- Working-reference use: Balanced Scorecard, portfolio, asset, role, scenario, and Understanding Together materials are reviewed foundations only; they are not promoted to accepted reporting data or Town-adopted policy.
- Public status: `CivicSS™ analytical working draft—not an official Town or Finance Committee report`.
- Official-presentation gate: not authorized until supporting data completes applicable Town review and approval, including Finance Committee review when applicable.
- Publication state: `LOCAL_ONLY_NOT_DEPLOYED_NOT_OFFICIAL`.
- Database state: fresh read-only query use only; no mutation performed.

- Receiving window/workstream: `Codex Web Reporting | Whole Picture`
- Current baseline acknowledged: `RPT-DATA-BASELINE-20260823-12` plus Master Control-adopted CNA 2021 release 0359 narrow projection contract.
- Mode used: `FULL_CUMULATIVE_BASELINE_WITH_BOUNDED_CNA_ADOPTION`.
- CNA contract reviewed: `[private-user-home]/Library/Mobile Documents/com~apple~CloudDocs/Sherie Knowledge Base/01  Organizing the Portfolio of Civic Stewardship/06 CSKE - Civic Stewardship Knowledge Engine - PostGreSQL and ODBC/CSKE/Loading Plans/CSKE-CNA2021-0359-Narrow-Projection-Data-Use-and-Query-Contract-v1.0.0-20260825`.
- Contract checksum-list hash: `a9da49ddd511c08f3ef2f281e222b54afc77681e0b2f4d6347c9031582efe905`; safe-query file hash: `10bc30379ba9deddbcfb31b2e0adab1ac866a3613be6135fa8b5f26c6aee1eb9`.
- Reporter contract state: `REPORTER_CONTRACT_ADOPTED`. The 297-row projection query executes successfully and is now used by Whole Picture v4.11.0.
- SQL executed: `source/whole_picture_refresh.sql`, including only the accepted CNA default view and exact safe control filters. No query around exclusions was performed.
- Final query timestamp and database: `2026-08-24T22:07:04.671829-04:00`; PostgreSQL 18.4; database `cske_dev`; schema `cske`; `transaction_read_only=on`; final `ROLLBACK`.
- CNA output reconciliation: 297 eligible rows; 17 property codes; 118 represented recommendations; years 2023–2031; $3,595,313.00 uninflated; $4,125,992.55 study-inflated; nine year rows and 17 property-code rows each reconcile to 297.
- Missingness and containment: 151 `SOURCE_BLANK_NOT_ZERO` rows remain SQL NULL and excluded; 438 recommendations remain quarantined; `study_wide_complete=false`; `publishable=false`.
- Projection-only semantics preserved: yes. No amount is labeled or inferred as actual, approved, appropriated, contracted, expended, completed, in service, currently needed, or currently priced.
- Calculations/pages changed: added the bounded capital-needs route and connected it to Whole Picture choices, choices-ahead, Middle School/BUC, affordability, debt, source register, source interpretation, query coverage, and the question map. No old projection is added to a current obligation or household total.
- Traceability and issue records: `CNA-REPORT-ADOPTION-REVIEW.md`; 21-item `records/CNA-REPORT-ADOPTION-CROSSWALK.csv`; four-part `REPORTING-DATA-ASSESSMENT.md`; PMO items WP-PMO-021 through WP-PMO-023.
- Output hashes: current data `81220e0f4257b9b58a20ea90d3001131fbc24e1991c1b75f408991d2f8c04da8`; refresh status `d5f27fffdbd46cc41011ad2214d82e4f06231744655d61acfff43ca2a9cb5984`; direct-file snapshot `569d3d78dec361f5a44f01814fe9b82696faea094500e83724588fe87be239d5`; structural record `84faa02bf4dd2d1ea32efbb838d8dd645e87b237c1dd4306bf4924f56184e73f`.
- Structural reconciliation: 30 current routes; 6 categories; 39 preserved-original links; 38 unique existing targets; 7 concrete choices; 74 static local references; zero failures.
- Data reviewed but not adopted: broader CNA content outside the 0359 safe contract; 151 source-blank amounts; property/BUC mapping outside the safe query; possible component identities; Annual Town Report 0455 discovery.
- QA state: `PASS_WITHOUT_NEW_BROWSER_RENDER_CLAIM`. Fresh read-only query, syntax, structural, local-reference, preservation, reconciliation, current-pointer, and runner controls passed. No visual/browser test was requested for this adoption.
- Git state: no commit, merge, push, or source-control adoption performed.
- Deployment state: `NOT_DEPLOYED`.
- Public-adoption state: `NOT_PUBLISHED_NOT_TOWN_ACCEPTED`. Whole Picture v4.11.0 is a validated local development release only.
- Open CNA blockers: current recommendation/project/account/status/cost/funding bridge; accepted resident-readable property and BUC bridge; authoritative ASSET-001 component relationship.
- Acknowledged by / UTC timestamp: Whole Picture reporting workstream / `2026-08-25T02:07:06Z`.

Acknowledgement means this reporting workstream consumed the control package within its permitted boundary. It does not mean the Town accepted the report, the whole CNA is publishable, or the release was externally published.