Identity and traceability
Artifact code, title, issuing entity, dates, family/version, source type, acquisition, and lineage can be preserved.
Supporting layer · source and evidence control
How should a reader judge a number?
A source link is only the beginning. A responsible report also identifies the exact version and locator, the measure's scope and period, what transformation occurred, its evidence state, whether it is current for the question, and what remains unresolved.
Short answer: 410 source artifacts were registered at the August 16 database checkpoint. That historical register remains unchanged. Later accepted query layers and the August 20 catalog are documented separately below so a newer source, structure, or adoption checkpoint does not silently rewrite an earlier source-register total.
What “incorporated” means
Registration creates a traceable starting point—not a conclusion.
A source can be in the database while its meaning, relevant version, relationship, or completeness is still under review.
01Identified
02Registered and versioned
03Extracted with locator
04Normalized and typed
05Reconciled and related
06Fit for a named decision
Interpretation or completeness
The relevant table, footnote, member allocation, legal condition, later amendment, or missing page may still change the meaning.
Compatibility and sufficiency
The source must be current enough, scoped correctly, reconciled to related facts, and sufficient for the specific conclusion being considered.
Added after the August 16 catalog
Cherry Sheet final estimates · Wilbraham and HWRSD · FY2000–FY2027
This source family adds 56 official DLS final budget-estimate PDFs: one municipal and one regional-school report for each of 28 fiscal years.
Each source is connected to its entity, fiscal year, report type, family, version, and locator.
Labels, amounts, signs, zeros, blanks, detail rows, subtotals, and totals remain distinguishable.
Printed control rows support reconciliation without becoming additional revenue or charges.
Historical presentation gaps and unusual source signs are disclosed; none remained open or error-severity.
Evidence qualification carried with every annual summary
These are official final budget estimates. They are not actual receipts, expenditures, or cash-payment evidence. Monthly distributions and deductions, local accounting, Schedule A, audits, and District funding records are needed for those later questions.
Resident explanation and data questions
The current Wilbraham and HWRSD figures come first; full history and boundaries follow only when useful.
Annual summary · 56 rows
Receipts, charges, net effect, source file, report type, and qualification.
Current final detail · 1,023 rows
Source locators, original and conformed labels, values, flow, availability, assurance, verification, and notes.
Accepted layers through August 20
New query access does not give every row the same evidence status.
The latest layers make historical tax, DOR, accounting, debt, disclosure, parcel distribution, and organization-identity evidence easier to locate. The report still uses typed and canonical facts first and preserves candidates, missingness, duplicates, and source qualifications.
Historical observations and stage lineage
17,722 observation states, 8,603 Cherry-stage states, and source-quality controls. Similar source labels are not automatically one comparable series.
Query prepared; returned rows not supplied
The attached command expects tax-base, tax-rate, levy-limit, and FY2025 largest-taxpayer populations. Publish exact returned values only after the command is run and its transcript/output is returned.
Discovery evidence
6,701 source-linked affordability rows across nine Wilbraham/HWRSD disclosures. Candidate evidence is not automatically decision-ready.
Analytical classifications
CSKE purpose, expense, fund, facility, presentation, flexibility, and gap lenses remain distinct from the Town's source-authoritative labels.
Accepted tax-base and parcel distribution layer
Official DLS history, a bounded FY2026 parcel projection, a controlled reconciliation, and standardized levy sensitivity are adopted with source and calculation boundaries.
Identity foundation only
Organization names, codes, grades, and source-stated relationships improve entity resolution. They do not establish governed enrollment, finance, facility, agreement, capital, or scenario facts.
One safe query order
Typed canonical fact → accepted normalized observation → candidate evidence for discovery → original source and locator. If the layers conflict or remain incomplete, show that instead of selecting the most convenient number.
Affordability evidence · source and freshness strip
Each new finding carries a different date, status, and permitted use.
“Latest loaded” does not mean every observation is current for an August 2026 decision.
| Layer | Evidence date/coverage | Status | Permitted reporting use |
|---|---|---|---|
| DOR 0301 | Run 2026-08-19 02:04:24; topic coverage varies through FY2027 | Overall PASS | Historical series discovery and controlled observation reporting; not a current affordability forecast. |
| Tax 0200 | Command supplied 2026-08-18 | No returned transcript/output | Query contract and expected population only; do not publish exact returned values. |
| Disclosure 0201 | Nine Town/HWRSD documents; candidate evidence output 2026-08-18 | Discovery layer | Locate pages, lines, metrics, and mapping gaps; candidate rows do not become headline facts automatically. |
| FY2025 Town debt observations | Period end 2025-06-30 | Eight accepted normalized observations | Dated issuer-prepared unaudited disclosure-basis snapshot; not “current debt” in August 2026. |
| Affordability 0303 | Accepted 2026-08-19; FY2026 parcel projection and DLS history through FY2027 missing states | Accepted · overall PASS | Tax-base reconciliation, class composition, and standardized levy sensitivity. Not a tax bill, legal-capacity result, debt fact, or recommendation. |
| School Organization Identity 0400 | Accepted 2026-08-19 | Identity foundation | Source and entity resolution only; no governed enrollment, finance, facility, agreement, capital, or scenario use. |
| August 20 schema and backup checkpoint | Captured 2026-08-20 00:26:48 | Verified package checkpoint | Structure and custody reference. The public portal does not contain or expose the full database backup. |
| Affordability Evidence v2 | Assessment as of 2026-08-20 | Partial readiness | Legal/historical context, existing Town/HWRSD payment schedules, dated debt position, household mechanics, standardized tax-base distribution, and gap reporting; dependable remaining recurring capacity is not determinable. |
See the reporting result and every remaining boundary.
Evidence-state contract
The label should tell the reader what happened to the fact.
These states are not a simple quality ranking. A source-reported figure can be authoritative for one purpose and still be incomparable to another scope.
| State | Meaning | What must be visible |
|---|---|---|
| Source reported | Reproduced from an identified source without changing the source's meaning. | Artifact/version, locator, source label, unit, period, and scope. |
| Normalized | Conformed to a controlled type or label while preserving source meaning. | Original value, rule, typed result, and any exception. |
| Reconciled | Matched across compatible records through an explicit bridge or control. | Compared totals/keys, difference, method, and control result. |
| Calculated | Derived from identified inputs. | Formula, numerator, denominator, rounding, and input evidence states. |
| Allocated | A total distributed by an identified rule. | Source total, allocation basis, period, share, and rounding. |
| Estimated | A method-based value with uncertainty. | Method, assumptions, period, range/sensitivity where material, and owner. |
| Assumed | A selected scenario input—not an observed fact or forecast. | Scenario, rationale, range, source context, and refresh trigger. |
| Conflicted | Sources or scopes disagree and no valid bridge has resolved the difference. | Both values, scopes, source dates, consequence, and resolution owner. |
| Missing | Required compatible evidence is absent. | The missing field, why it matters, owner, next source, and due date. Never substitute zero. |
Minimum measure identity
A number should carry its meaning with it.
If these fields cannot be stated, the figure is not ready for a headline comparison.
Measure and unit
Stable code, human label, value, currency/count/percent/rate, precision, and whether it is a total, balance, flow, or share.
Entity, fund, and population
Town, District, Wilbraham member, fund, department, asset, parcel, account, or household denominator.
Period and lifecycle
Fiscal/calendar/academic period; proposed, budgeted, authorized, issued, actual, outstanding, projected, completed, or closed.
Source and transformation
Artifact/version, locator, effective/as-of date, evidence state, formula/allocation, reconciliation, freshness, and unresolved issue.
Version and freshness
“Latest loaded” is not automatically “current for the decision.”
A source family can identify the current loaded version while a report still needs a newer official event, condition check, forecast, or tax certification.
Is there a later version?
Track preliminary, recommended, motion, voted, amended, restated, and superseded versions without overwriting history.
Is the observation still representative?
A 2021 condition assessment remains valid evidence of what was reported then; it does not establish 2026 condition or price.
Is it timely enough for this action?
A dated baseline may frame a question while a live recommendation requires current scope, cost, schedule, legal status, and operating effect.
Freshness must be stated at the claim level.
The FY2027 final-voted budget is controlled through May 11, 2026; the FY2027 Expense Control extract is dated July 9, 2026; the latest included schema catalog was captured August 18 at 23:48:57; the Cherry Sheet final-estimate layer was accepted August 17; DOR 0301 was accepted August 18 and its supplied query transcript was produced August 19; and the principal facility condition study is dated August 23, 2021. These are not one common “as of” date.
Registers and catalogs
Inspect the underlying record when the summary is not enough.
The full source register lets a reader follow the evidence trail; the connected-data route shows what those domains and relationships can help Wilbraham understand; the raw catalog exposes schema structure and exact counts.
Follow the complete 410-artifact source trail
See how an original artifact becomes a source record and then a structured fact, or search the complete inventory by subject, year, family, filename, or source code.
What questions become possible?
See how budgets, accounting, schools, debt, assets, parcels, grants, audits, and Town context can deepen one decision explanation.
Which newer queries support the five journeys?
Coverage status, runtime evidence, story placement, publication boundaries, and machine-readable control.
August 18 schema summary
Exact table counts · migrations and loads · captured schema SQL.