# CNA 2021 narrow-projection report adoption review

## Direct answer

Whole Picture v4.11.0 adopts the Master Control-accepted CNA release 0359 **only** for its narrow historical projection contract. The report can now show exactly what 297 numeric, source-verified rows in the 2021 Capital Needs Assessment projected for 2023–2031. It cannot call those projections a current capital plan, current need, current price, approval, appropriation, contract, expenditure, completed project, or asset in service.

**Reporter contract state:** `REPORTER_CONTRACT_ADOPTED`  
**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`  
**Master Control event:** `CNA2021-0359-MASTER-CONTROL-ADOPTED-V040-20260825-001`  
**Master Control final seal:** `7975b612b492ece6c6a1475f3e260bfdd4269f91d5f4b78bf261999226784f2d`

## What the accepted query establishes

The supplied safe 297-row projection query executed successfully in a PostgreSQL read-only transaction. Whole Picture reproduces it fresh during every governed refresh and validates these exact controls before replacing the reporting snapshot:

| Control | Accepted result |
|---|---:|
| Eligible numeric, source-verified projection rows | 297 |
| Controlled property codes | 17 |
| Recommendations represented by eligible rows | 118 |
| Projection years | 2023–2031 |
| Uninflated projected sum | $3,595,313.00 |
| Study-inflated projected sum | $4,125,992.55 |
| `SOURCE_BLANK_NOT_ZERO` rows excluded | 151 |
| Rows with NULL monetary fields | 151 |
| Total controlled schedule rows | 448 |
| Broader quarantined recommendations | 438 |
| `study_wide_complete` | false |
| `publishable` | false |

The row-level amount semantics are exactly:

`PROJECTED_SOURCE_ESTIMATE_NOT_ACTUAL_APPROVED_APPROPRIATED_CONTRACTED_EXPENDED_COMPLETED_OR_IN_SERVICE`

The nine accepted study-inflated year totals are:

| Projection year | Projected amount |
|---:|---:|
| 2023 | $346,692.85 |
| 2024 | $508,873.42 |
| 2025 | $668,015.72 |
| 2026 | $693,657.83 |
| 2027 | $370,335.90 |
| 2028 | $367,507.82 |
| 2029 | $342,190.28 |
| 2030 | $470,071.81 |
| 2031 | $358,646.92 |

## Why it matters

The Town no longer has to rely on memory or scattered PDF pages to ask what the 2021 study anticipated. The accepted series creates a traceable historical baseline. More importantly, it makes the missing bridge visible: for every projected need, what was completed, funded, replaced, rescoped, deferred, retired, or still remains open?

That is the bridge needed before the old study can strengthen a current budget choice. Without it, adding the $4.126 million projection total to current capital, debt, or household scenarios could count completed work again, treat obsolete work as active, or present a five-year-old estimate as today’s price.

## Reconciliation and missingness

The 151 source-blank rows remain SQL NULL and nonaggregatable. They are not converted to zero and do not enter the displayed totals. The accepted contract records 68 reconciliation results: 9 exact and 59 accepted rounding variances. Absolute variance is $76.52, the maximum variance is $6.45, and tolerance breaches are zero. Whole Picture discloses those controls rather than silently forcing the source to balance.

## Report implementation

The adopted source appears in:

- the new `capital-needs-2021` report route;
- the Whole Picture choices section;
- the choices-ahead, Middle School/BUC, affordability, and debt paths;
- the source-register, source-interpretation, query-coverage, and question-map paths; and
- the human-readable and machine-readable current source inventories.

The refresh package queries `cske.capital_cna2021_schedule_reportable_default_v1` for the accepted row, year, property-code, and portfolio summaries. It uses only the contract’s explicit safe filters for eligible-row, missingness, and containment controls. It does not query around exclusions or promote broader CNA data.

## Limitations and unresolved questions

- The contract does not establish current condition, current need, current scope, current price, funding, approval, spending, completion, or service effect.
- The safe view exposes controlled property codes but no accepted resident-readable property-name or BUC-only reporting bridge.
- The broader study remains incomplete and not publishable; all 438 recommendations remain quarantined for broader use.
- Three possible equipment/component references remain evidence only, not authoritative assets.
- No old projection is added to current debt, capital, or household totals until an accepted current-status and reconciliation bridge exists.

These gaps are recorded as WP-PMO-021 through WP-PMO-023 in the current defect register and in the four-part reporting-data assessment.

## Publication and authority state

This is an internal local development adoption. The report was not externally published, deployed, merged, pushed, or represented as an official Town product. No PostgreSQL state was changed.

## Method record

The item-level adoption mapping is `records/CNA-REPORT-ADOPTION-CROSSWALK.csv`. Fresh query controls and release reconciliation are recorded in `EXECUTION-EVIDENCE.md`, `VALIDATION-REPORT.md`, and `REPORT-RECONCILIATION-AND-COVERAGE.md`.