# Version Manifest

**Artifact:** CSKE WilbrahamCenter Financial Reporting Portal  
**Version:** 3.7.0  
**Date:** 2026-08-20  
**Protected baseline:** Portal v3.6.0  
**Adopted reporting-data baseline:** `RPT-DATA-BASELINE-20260820-03`

## Primary change

Version 3.7.0 adds a question-first answer library without changing the five protected user journeys. The homepage and connected-data Whole Picture now offer a compact “Start with the question you are trying to answer” bridge. The complete supporting page distinguishes findings that are answered now, newly measurable, or not yet determinable.

The release also differentiates Town/Vision property-card depth, MassGIS townwide release history, the bounded FY2026 parcel projection, and official DLS tax-system history. These sources are complementary and are not collapsed into one generic “GIS” source.

The five journey H1 openings and plain-answer openings remain unchanged. No sixth journey was added. The question library is a supporting layer inside the existing five stories.

## Question-first reporting added

- A compact six-question bridge on the homepage.
- A compact six-question bridge in the connected-data Whole Picture.
- A dedicated Questions We Can Answer supporting page.
- Nine question-led answers covering tax burden, current tax-base composition, proposal sensitivity, parcel history, exempt/other property, mapped parcel and assessment change, Town debt, HWRSD debt, and dependable remaining capacity.
- Three explicit readiness states: answered now, newly measurable, and not yet determinable.
- Collapsed evidence and boundary details so short answers remain easy to scan.
- A four-source parcel comparison: Town/Vision, MassGIS, FY2026 bounded parcel projection, and DLS.
- A sitewide compact-reading pass that reduces oversized headings, vertical section spacing, card padding, and table padding while retaining readable body text and responsive behavior.

The homepage also carries the project-defining question:

> Why is it so difficult for communities to make well-informed decisions when so much information already exists?

The answer is expressed as the gap between public information and usable public understanding: finding, collecting, linking, reconciling, and presenting the right evidence at the time a decision must be made.

## Reporting added

- Affordability Evidence v2 with a reconciled FY2026 property-tax base.
- FY2026 candidate taxable real-property base: **$2,709,335,687**.
- Official FY2026 DLS real-property base: **$2,709,468,846**.
- Reconciliation difference: **−$133,159**, or **−0.0049146%**, within the accepted 0.01% threshold.
- Aggregate FY2026 parcel composition: 5,670 residential, 167 commercial, 66 industrial, 295 exempt/other, and 9 unresolved rows.
- Standardized distribution sensitivity per $1 million of stated annual levy, using assessed value divided by the candidate taxable base.
- Neutral illustrations at $250,000, $400,000, $600,000, and $1,000,000 of assessed value.
- Town principal, interest, and total scheduled debt service by year for FY2025–FY2040: $14,797,467 total.
- Full-District HWRSD principal, interest, and total scheduled debt service by year for FY2026–FY2041: $30,115,833 displayed annual-row total.
- FY2026 Wilbraham school-debt context of $1,518,319.73 at the source-supported 79.9% allocation; the factor is not extended to later years as an official forecast.
- Affordability 0303 source, calculation, privacy, missingness, tax-status, classification-policy, debt, legal, and recommendation boundaries.
- School 0400 identity/source context, with explicit non-inference controls.
- August 20 database catalog and report-builder technical queries.

## Current affordability finding

**Dependable remaining recurring capacity is not determinable from current evidence.**

The new layer improves tax-base composition and distribution transparency. It does not complete:

- the FY2027 General Fund funding bridge;
- a governed multi-year recurring revenue and current-service forecast;
- same-grain municipal budget-to-actual detail;
- monthly cash timing;
- a complete forward capital/debt portfolio including future borrowing, later HWRSD member allocations, and consolidated scenarios;
- proposal-level service, alternative, status-quo, and household-burden evidence; or
- locally governed reserve, debt, capital, service, and acceptable-risk policies.

## Affordability 0303 acceptance controls

- Package: `CSKE-Wilbraham-Parcel-GIS-History-Tax-Base-and-Levy-Affordability-0303-v0.2.1-20260819.zip`.
- Package SHA-256: `bc5a122a02aeb489569285ac1115c347bcbc9c6ae382fe68ab3b364bb954a279`.
- Migration: `0303_PARCEL_GIS_HISTORY_TAX_BASE_AND_LEVY_AFFORDABILITY_V02`.
- Accepted transcript: `20260819-230824-CSKE-AFFORDABILITY-0303.txt`; SHA-256 `c9b4758f9336fcc472392f1703fbcc916082832a0f12d48ac916b834dbcd7fb9`.
- Transcript ended `OVERALL PASS` after shadow, live, replay, and post-replay checks.
- 6,207 FY2026 parcel projection rows: 6,198 complete and 9 incomplete.
- 512 normalized DLS observations and 512 exact 0301 conformance rows with zero differences.
- Six additive core and eight additive GIS reporting views; ten existing stable reporting contracts unchanged.
- Aggregate public reporting uses no owner, address, or geometry fields.

## Standardized distribution boundary

The displayed sensitivity is:

`illustrative assessed value ÷ 2,709,335,687 × stated annual levy amount`

For debt, the input is annual debt service by fiscal year—not project cost, authorization, or principal. The result is not a certified tax bill, parcel tax status, Proposition 2½ capacity calculation, classification-policy forecast, issued-debt fact, legal conclusion, or affordability recommendation.

## Debt-horizon boundary

The Town schedule uses the final March 11, 2025 official-statement version and runs FY2025–FY2040. The HWRSD schedule uses FY2025 continuing-disclosure evidence and runs FY2026–FY2041. HWRSD values are 100% of the District. Only FY2026 has a source-supported 79.9% Wilbraham allocation. Future borrowing, refunding, early retirement, later schedule changes, later member allocations, and project operating effects are excluded. The displayed HWRSD annual rows total $30,115,833, $2 above the printed source total; the difference is preserved rather than forced to balance.

- Town schedule source extract: `detailed-town-reporting/as-of-2026-08-14/technical-appendix/connected_sec_official_statement_debt_service_version.csv`; SHA-256 `9f407d9101fe2ade401f7017b1997b319ee35ccd4d95976a8492be95d7048734`; only `OS-TOWN-WIL-2025-SC-FINAL-DS-*` rows are used.
- HWRSD recovery package: `CSKE-HWRSD-FY2024-Audit-and-FY2025-Continuing-Disclosure-Recovery-v0.5.2-20260813.zip`; SHA-256 `51963924039a596f03478c95ae310c28c2eb09149c9cc3c39ad8bb9bc04f6822`; `sch_debt_service_fact.csv` provides the annual schedule.
- Published combined schedule CSV SHA-256: `4c2f0ceed5428fbe92b3bc992bec0651f8c66cffacb92883c93e5a7692a3a8c6`.

## School 0400 boundary

The accepted identity foundation contains 15 canonical organizations, 304 identity observations, 43 grade observations, and 5 relationship observations. Portal v3.6.0 uses it only to improve source and entity context. It supplies no governed enrollment, finance, facility, agreement, capital, or scenario facts and adds no stable reporting view.

## Latest included database checkpoint

- Schema catalog: `CSKE-Schema-Catalog-Capture-20260820-002648.zip`.
- Catalog SHA-256: `bf7989144967ba1a9093bdd71d1d2a18a1698191470f40f91e3d5ad5ed4deca9`.
- Database backup: `CSKE-Full-Database-Backup-20260820-002648.dump.zip`.
- Backup ZIP SHA-256: `5416ffbf86374759519bf2f7be0fe2dff98c30c9b48548ea1281e4fd9fe3c51d`.
- Captured database state: 2026-08-20 00:26:48; PostgreSQL 18.4.
- 425 base tables; 140 views; 8,419 columns; 1,010 foreign keys; 34 functions; 59 triggers; 106 schema migrations.
- The backup was verified as a PostgreSQL custom-format archive checkpoint. It was not restored in this reporting environment and is not included in the portal.

## Protected resident controls

- The current-budget journey begins with the complete FY2027 General Fund: **$57,018,471**.
- FY2027 HWRSD assessment and debt remain a component inside that whole.
- The remaining approximately $23.924 million remains allocated budget authority—not automatically contractual, mandatory, already spent, or unchangeable.
- FY2026 actual Town-wide levy remains **$48,746,259**.
- FY2026 unused levy capacity remains **$1,322,755 — current figure**.
- FY2025 unused levy capacity remains **$986,000 — prior-year comparison only**.
- Unused levy capacity remains legal room—not cash, savings, spending authority, or proof of affordability.
- The approximately **$66.372 million** multi-fund figure remains provisional and visibly qualified.
- Town and HWRSD remain separate entities.
- Budget, actual, cash, estimate, assessment, payment, authorization, issuance, and outstanding debt remain distinct.
- Missing remains distinct from zero; incomplete choices remain unranked.

## Public pages added or revised

Added:

- `questions-we-can-answer/as-of-2026-08-20/index.html`
- `CHANGE-REPORT-v3.7.0.md`
- `QA-REPORT-v3.7.0.md`
- `affordability-evidence/as-of-2026-08-20/index.html`
- `affordability-evidence/as-of-2026-08-20/data/AFFORDABILITY-0303-ACCEPTED-CONTROLS.csv`
- `affordability-evidence/as-of-2026-08-20/METHODOLOGY-AND-BOUNDARIES.md`
- `query-coverage/as-of-2026-08-20/index.html`
- `query-coverage/as-of-2026-08-20/data/QUERY-COVERAGE-MATRIX-20260820.csv`
- `debt-horizon/as-of-2026-08-20/index.html`
- `debt-horizon/as-of-2026-08-20/data/TOWN-AND-HWRSD-ANNUAL-DEBT-SERVICE-FY2025-FY2041.csv`
- `database-catalog/2026-08-20/`
- `AFFORDABILITY-EVIDENCE-V2-STORY-MAP.md`
- `CHANGE-REPORT-v3.6.0.md`
- `QA-REPORT-v3.6.0.md`
- `REPORTING-WINDOW-ACKNOWLEDGEMENT.md`

Revised without changing the five openings:

- `index.html`
- `detailed-town-reporting/as-of-2026-08-14/index.html`;
- `shared/v3.css`;
- the five journey entry pages;
- `data-sources/as-of-2026-08-15/index.html`; and
- `VERSION-MANIFEST.md`.

## Gate and deployment state

- Generated: complete.
- Narrative, calculation, link, disclaimer, responsive, compact-reading, and five-journey regression QA: passed; see `QA-REPORT-v3.7.0.md`.
- Library custody: recorded when the final package is saved.
- Portal Git closure: not verified / not closed.
- Cloudflare deployment: not deployed.
- Public URL verification: not run.
- WilbrahamCenter.org adoption/link: not adopted.
- Town adoption or endorsement: not applicable / not claimed.

Deploy the archive contents through Cloudflare Pages Direct Upload. `index.html` is at the archive root and all primary links are relative. The package excludes credentials, the database backup, owner/address/geometry extracts, Apple metadata, caches, and temporary files.