Civic Stewardship Studio™
Powered by the Civic Stewardship Knowledge Engine™
← Project overview

Complete detailed evidence map

Every technical section, table, row, CSV extract, database field preview, control, and source-lineage file remains available. This index lets decision-makers or residents begin with the appropriate teaching view and then inspect all supporting detail.

Preservation count

44
inherited technical sections
74
HTML tables
2045
technical table body rows
208
CSV evidence files
27932
CSV data rows
32
supporting source and control files

How to use this: begin with the Town decision guide or the current resident education sequence. When a number or conclusion raises a question, use the linked technical section, CSV, reviewed PDF, query output, guide, or SQL below. The detailed evidence remains complete; it has been relocated in the reading order, not discarded.

Portal v2.3 historical supplement

The official FY2025 Finance Committee presentation is used as a supplemental historical decision record. It does not change the controlled database source register, and its forecasts are not treated as current actuals.

All technical report sections, in original order

No.Linked technical sectionTablesBody rows
1Start here: what these numbers mean in everyday language00
2The short version before the detailed tables00
32026 Annual Town Meeting: proposed, presented, and final-voted evidence14
4Annual Town Meeting coverage, HWRSD share, and reporting boundaries14
5Two decisions to structure now: Middle School capacity and BUC buildings415
6Why did the Town budget rise so much?211
7Where did the additional $10,005,151 go?219
8If Proposition 2½ says 2.5%, how can these numbers grow faster?29
9The five-year story: Town finances rose approximately 15%–20%14
10Bringing the Town-wide story home: 481 Main Street18
11How does the Town spend its operating resources?190
12Did the published budget table add correctly?15
13Where does General Fund money come from?394
14What does the existing disclosure already tell us about Proposition 2½?110
15What reserves and one-time resources exist?226
16Are enterprise services supporting themselves?27
17Does development evidence show business-generated revenue?219
18How does Wilbraham compare with Massachusetts and the United States?123
19What additional employment, education and municipal-service context matters?223
20How do the FY2027 CSKE expense-control classifications deepen the spending picture?437
21Town-owned parcel inventory and managed assets5226
22How does the 2021 capital needs assessment connect to parcels, assets and buildings?5131
23Preliminary map of known grant sources4238
24Additional Release 5 walk-downs: capital assets, internal transfers, pension and OPEB6178
25Annual debt and affordability receiving table118
26Can the embedded audit be counted twice?17
27HWRSD reporting release, scope, and evidence gate00
28HWRSD denominator and non-duplication controls14
29Controlled HWRSD key metrics used by the resident guide142
30HWRSD evidence that remains missing00
31Audited FY2024 instruments — largest outstanding first15
32Audited remaining debt service — material periods first19
33Proposition 2½: what we know and what still needs work14
34Audit-to-disclosure bridge113
35Debt purposes and original financings254
36Town and HWRSD debt-service snapshots1336
37Long-term obligations beyond bonded debt135
38What would make the affordability answer definitive?15
39Open evidence controls — highest priority worklist138
40FY2024 audit reconciliation controls2252
41Debt-disclosure reconciliation and source-quality controls18
42Loaded evidence foundation122
43From Draft to Decision System: Data We Have, Data We Can Obtain, and What Town Partnership Could Unlock17
44Remaining existing data sources now connected00

All CSV evidence extracts and controls

Linked fileData rowsFieldsFirst fields
acct_category.csv138account_count, adjusted_budget, classification_origin, cske_category, fiscal_year, plus 3 more
acct_control.csv111account_count, adjusted_budget, classification_origin, corrected_hwrsd_row_count, fiscal_year, plus 6 more
acct_evidence_gap.csv19account_count, classification_origin, cost_driver_unassessed_account_count, cost_driver_unassessed_budget, facility_related_unallocated_account_count, plus 4 more
acct_expense_group.csv97account_count, adjusted_budget, classification_origin, cske_expense_group, fiscal_year, plus 2 more
acct_facility.csv38account_count, allocated_adjusted_budget, allocated_spent_positive, allocated_unexpended_balance, classification_origin, plus 3 more
acct_flexibility.csv19account_count, adjusted_budget, change_horizon, classification_origin, fiscal_year, plus 4 more
acct_fund_family.csv69account_count, adjusted_budget, classification_origin, enterprise_fund, financing_mechanism, plus 4 more
acct_presentation.csv97account_count, adjusted_budget, classification_origin, fiscal_year, presentation, plus 2 more
atm_budget_path.csv46event_sequence, evidence_date, stage_code, amount, change_from_april, plus 1 more
atm_known_change_ledger.csv48event_sequence, from_date, to_date, comparison_code, value_change, plus 3 more
atm_reporting_control.csv138migration_code, meeting_code, expected_base_table_count, expected_view_count, source_document_count, plus 33 more
audit_cross.csv48finrpt_audit_schedule_cross_control_code, finrpt_audit_schedule_cross_control_exact_note_value, finrpt_audit_schedule_cross_control_explanation, finrpt_audit_schedule_cross_control_id, finrpt_audit_schedule_cross_control_rsi_value, plus 3 more
audit_facts.csv96714finrpt_audit_schedule_code, finrpt_audit_schedule_fact_amount, finrpt_audit_schedule_fact_assurance_code, finrpt_audit_schedule_fact_code, finrpt_audit_schedule_fact_id, plus 9 more
audit_general_fund_revenue.csv509amount, assurance_status, fiscal_year, revenue_category, source_document_code, plus 4 more
audit_instruments.csv513finrpt_audit_schedule_code, finrpt_audit_schedule_debt_instrument_code, finrpt_audit_schedule_debt_instrument_id, finrpt_audit_schedule_debt_instrument_interest_rate_source_text, finrpt_audit_schedule_debt_instrument_maturity_source_text, plus 8 more
audit_link.csv79accounting_basis, assurance_status, canonical_artifact_code, canonical_file_name, component_code, plus 4 more
audit_recon.csv24810finrpt_audit_schedule_reconciliation_calculated_amount, finrpt_audit_schedule_reconciliation_code, finrpt_audit_schedule_reconciliation_difference, finrpt_audit_schedule_reconciliation_equation, finrpt_audit_schedule_reconciliation_id, plus 5 more
balances.csv207amount, appropriation_rule, certification_status, cske_balance_label, fiscal_year, plus 2 more
buc_scenario_register.csv45scenario_code, preserved_working_scenario, explicitly_named_assets, required_comparison_evidence, scenario_status
budget.csv807amount, cske_category, fiscal_year, pct_of_displayed_categories, source_category, plus 2 more
budget_control.csv56control_code, difference, displayed_row_sum, note, source_printed_total, plus 1 more
capital_assessment_building_links.csv279assessment_property_code, managed_asset_code, managed_asset_name, building_code, building_name, plus 4 more
capital_assessment_control.csv128checkpoint, study_code, report_date, assessment_year, original_horizon_start, plus 23 more
capital_assessment_parcel_links.csv189assessment_property_code, managed_asset_code, managed_asset_name, gis_parcel_code, source_native_parcel_id, plus 4 more
capital_assessment_property.csv1722capital_assessment_property_id, professional_study_id, assessment_property_code, canonical_property_number, source_property_number, plus 17 more
capital_assessment_property_asset.csv176capital_assessment_property_id, asset_id, relationship_role_code, verification_status_code, source_record_id, plus 1 more
capital_assessment_property_building.csv276capital_assessment_property_id, building_id, relationship_role_code, verification_status_code, source_record_id, plus 1 more
capital_assessment_property_parcel.csv186capital_assessment_property_id, gis_parcel_id, relationship_role_code, verification_status_code, source_record_id, plus 1 more
capital_assessment_snapshot.csv1724capital_assessment_snapshot_id, snapshot_code, capital_assessment_property_id, critical_repairs, non_critical_repairs, plus 19 more
capital_asset_assessment_summary.csv1736assessment_property_code, canonical_property_number, assessment_reported_property_name, managed_asset_code, managed_asset_name, plus 31 more
capital_condition_observation.csv14714capital_condition_observation_id, observation_code, capital_assessment_snapshot_id, facility_system_type_id, reported_building_system_text, plus 9 more
capital_condition_recommendation.csv1474capital_condition_observation_id, capital_recommendation_id, relationship_role_code, source_record_id
capital_recommendation.csv43828capital_recommendation_id, recommendation_code, capital_assessment_snapshot_id, facility_system_type_id, section_number, plus 23 more
capital_reconciliation_result.csv6813capital_reconciliation_result_id, professional_study_id, capital_assessment_property_id, qa_run_code, metric_code, plus 8 more
capital_ref_facility_system_type.csv205facility_system_type_id, facility_system_type_code, facility_system_type_name, active_flag, notes
capital_schedule_occurrence.csv44815capital_schedule_occurrence_id, schedule_code, capital_recommendation_id, occurrence_sequence, calendar_year, plus 10 more
capital_source_locator.csv25211capital_source_locator_id, source_artifact_id, source_page_text, source_table_section, property_scope, plus 6 more
connected_assessment_account.csv2209assessment_account_id, jurisdiction_id, assessment_account_code, vision_id, assessor_account_number, plus 4 more
connected_assessment_finding.csv113assessment_finding_id, assessment_account_id, assessment_finding_code, assessment_finding_type_code, assessment_component_code, plus 8 more
connected_assessment_finding_observation.csv23assessment_finding_id, assessment_observation_id, observation_role_code
connected_assessment_observation.csv87321assessment_observation_id, assessment_account_id, source_record_id, fiscal_year, record_effective_date, plus 16 more
connected_assessment_ref_finding_type.csv15assessment_finding_type_code, finding_type_name, definition, active_flag, sort_order
connected_cap_project.csv59cap_project_id, cap_project_code, cap_project_name, project_type_code, owning_entity_code, plus 4 more
connected_cap_project_component.csv611cap_project_component_id, component_code, cap_project_id, component_type_code, component_name, plus 6 more
connected_cap_project_context_observation.csv1412cap_project_context_observation_id, context_code, cap_project_id, context_domain_code, context_key, plus 7 more
connected_cap_project_cost_observation.csv912cap_project_cost_observation_id, cost_observation_code, cap_project_id, cost_type_code, amount, plus 7 more
connected_cap_project_financing_cost.csv513cap_project_financing_cost_id, financing_cost_code, cap_project_id, sec_debt_issue_id, cost_type_code, plus 8 more
connected_cap_project_funding.csv2010cap_project_funding_id, funding_code, cap_project_id, funding_type_code, amount, plus 5 more
connected_cap_project_interim_financing.csv213cap_project_interim_financing_id, interim_financing_code, cap_project_id, financing_type_code, principal_amount, plus 8 more
connected_cap_project_issue_bridge.csv57cap_project_issue_bridge_id, bridge_code, cap_project_id, sec_debt_issue_id, relationship_type_code, plus 2 more
connected_cap_project_operating_context_series.csv2613cap_project_operating_context_series_id, operating_context_code, subject_scope_code, cap_project_id, metric_code, plus 8 more
connected_cap_project_reconciliation.csv59cap_project_reconciliation_id, control_code, cap_project_id, topic, left_amount, plus 4 more
connected_cap_project_service_metric.csv7212cap_project_service_metric_id, metric_code, cap_project_id, metric_domain_code, metric_key, plus 7 more
connected_control_finrpt_disclosure_follow_up.csv37control_finrpt_disclosure_follow_up_id, control_finrpt_disclosure_follow_up_code, finrpt_disclosure_document_id, control_finrpt_disclosure_follow_up_topic_code, control_finrpt_disclosure_follow_up_description, plus 2 more
connected_core_asset.csv2214asset_id, asset_code, asset_name, asset_type_id, jurisdiction_id, plus 9 more
connected_core_asset_parcel.csv2310asset_parcel_id, asset_id, gis_parcel_id, relationship_type_code, primary_parcel_flag, plus 5 more
connected_core_building.csv3011building_id, building_code, building_name, asset_id, primary_address_id, plus 6 more
connected_core_building_parcel.csv3010building_parcel_id, building_id, gis_parcel_id, relationship_type_code, primary_parcel_flag, plus 5 more
connected_core_ref_civic_function.csv66civic_function_id, function_code, function_name, function_category_code, description, plus 1 more
connected_finrpt_audit_business_fact.csv12718finrpt_audit_business_fact_id, finrpt_audit_business_fact_code, finrpt_audit_business_fact_source_artifact_id, finrpt_audit_business_fact_source_pdf_page, finrpt_audit_business_fact_source_label, plus 13 more
connected_finrpt_audit_engagement.csv113finrpt_audit_engagement_id, finrpt_audit_engagement_code, finrpt_audit_engagement_source_artifact_id, finrpt_audit_engagement_source_page_start, finrpt_audit_engagement_source_page_end, plus 8 more
connected_finrpt_audit_nonmajor_fund_fact.csv54419finrpt_audit_nonmajor_fund_fact_id, finrpt_audit_nonmajor_fund_fact_code, finrpt_audit_nonmajor_fund_fact_source_artifact_id, finrpt_audit_nonmajor_fund_fact_source_fund_label, finrpt_audit_nonmajor_fund_fact_source_printed_page, plus 14 more
connected_finrpt_audit_note.csv2410finrpt_audit_note_id, finrpt_audit_note_code, source_artifact_id, finrpt_reporting_entity_id, finrpt_reporting_period_id, plus 5 more
connected_finrpt_audit_note_inventory.csv1511finrpt_audit_note_inventory_id, finrpt_audit_note_inventory_code, finrpt_audit_note_inventory_source_artifact_id, finrpt_audit_note_inventory_source_title, finrpt_audit_note_inventory_source_printed_page_start, plus 6 more
connected_finrpt_audit_opinion.csv110finrpt_audit_opinion_id, finrpt_audit_opinion_code, finrpt_audit_opinion_source_text, finrpt_audit_opinion_source_page, finrpt_audit_opinion_business_audit_engagement_id, plus 5 more
connected_finrpt_audit_report_section_inventory.csv138finrpt_audit_report_section_inventory_id, finrpt_audit_report_section_inventory_code, source_artifact_id, finrpt_audit_report_section_inventory_section_type_code, finrpt_audit_report_section_inventory_source_title, plus 3 more
connected_finrpt_audit_schedule_cell_fact.csv65920finrpt_audit_schedule_cell_fact_id, finrpt_audit_schedule_cell_fact_code, finrpt_audit_schedule_cell_fact_source_artifact_id, finrpt_audit_schedule_cell_fact_source_row_label, finrpt_audit_schedule_cell_fact_source_column_label, plus 15 more
connected_finrpt_audit_schedule_inventory.csv2811finrpt_audit_schedule_inventory_id, finrpt_audit_schedule_inventory_code, finrpt_audit_schedule_inventory_source_artifact_id, finrpt_audit_schedule_inventory_source_printed_page, finrpt_audit_schedule_inventory_source_pdf_page, plus 6 more
connected_finrpt_audit_statement.csv2013finrpt_audit_statement_id, finrpt_audit_statement_code, source_artifact_id, finrpt_reporting_entity_id, finrpt_reporting_period_id, plus 8 more
connected_finrpt_audit_statement_row.csv48811finrpt_audit_statement_row_id, finrpt_audit_statement_row_code, finrpt_audit_statement_id, finrpt_audit_statement_row_ordinal, finrpt_audit_statement_row_source_label, plus 6 more
connected_finrpt_audit_statement_value.csv99010finrpt_audit_statement_value_id, finrpt_audit_statement_value_code, finrpt_audit_statement_row_id, finrpt_audit_statement_value_ordinal, finrpt_audit_statement_value_source_column_label, plus 5 more
connected_finrpt_audit_supporting_row.csv25138finrpt_audit_supporting_row_id, finrpt_audit_supporting_row_code, finrpt_audit_supporting_section_id, finrpt_audit_supporting_row_ordinal, finrpt_audit_supporting_row_source_label, plus 3 more
connected_finrpt_audit_supporting_section.csv10712finrpt_audit_supporting_section_id, finrpt_audit_supporting_section_code, source_artifact_id, finrpt_reporting_entity_id, finrpt_reporting_period_id, plus 7 more
connected_finrpt_audit_supporting_value.csv38169finrpt_audit_supporting_value_id, finrpt_audit_supporting_value_code, finrpt_audit_supporting_row_id, finrpt_audit_supporting_value_ordinal, finrpt_audit_supporting_value_amount, plus 4 more
connected_finrpt_disclosure_compliance_event.csv112finrpt_disclosure_compliance_event_id, finrpt_disclosure_compliance_event_code, source_artifact_id, finrpt_disclosure_compliance_event_date, finrpt_disclosure_compliance_event_type_code, plus 7 more
connected_finrpt_disclosure_document.csv213finrpt_disclosure_document_id, finrpt_disclosure_document_code, source_artifact_id, finrpt_reporting_entity_id, finrpt_reporting_period_id, plus 8 more
connected_finrpt_disclosure_normalized_observation.csv822finrpt_disclosure_normalized_observation_id, finrpt_disclosure_normalized_observation_code, finrpt_disclosure_document_id, finrpt_disclosure_semantic_token_id, finrpt_disclosure_normalized_observation_domain_code, plus 17 more
connected_finrpt_disclosure_observation_bridge.csv689finrpt_disclosure_observation_bridge_id, finrpt_disclosure_observation_bridge_code, finrpt_disclosure_document_id, finrpt_observation_id, finrpt_disclosure_observation_bridge_pdf_page, plus 4 more
connected_finrpt_general_fund_fact.csv21219finrpt_general_fund_fact_id, finrpt_general_fund_fact_code, finrpt_general_fund_fact_source_artifact_id, finrpt_general_fund_fact_source_metric_label, finrpt_general_fund_fact_source_disclosure_pdf_page, plus 14 more
connected_finrpt_observation.csv25426finrpt_observation_id, finrpt_observation_code, finrpt_reporting_entity_id, finrpt_reporting_period_id, finrpt_ref_metric_id, plus 21 more
connected_finrpt_ref_accounting_basis.csv54finrpt_ref_accounting_basis_id, finrpt_ref_accounting_basis_code, finrpt_ref_accounting_basis_label, created_at
connected_finrpt_ref_assurance_status.csv154finrpt_ref_assurance_status_id, finrpt_ref_assurance_status_code, finrpt_ref_assurance_status_label, created_at
connected_finrpt_ref_metric.csv1358finrpt_ref_metric_id, finrpt_ref_metric_code, finrpt_ref_metric_label, finrpt_ref_metric_cske_category_code, finrpt_ref_metric_cske_defined_flag, plus 3 more
connected_finrpt_reporting_entity.csv28finrpt_reporting_entity_id, finrpt_reporting_entity_code, finrpt_reporting_entity_name, finrpt_reporting_entity_type_code, finrpt_reporting_entity_jurisdiction_code, plus 3 more
connected_finrpt_reporting_period.csv768finrpt_reporting_period_id, finrpt_reporting_period_code, finrpt_reporting_entity_id, finrpt_reporting_period_type_code, finrpt_reporting_period_end_date, plus 3 more
connected_gis_card_assessment_component.csv80132gis_card_assessment_component_id, load_batch_code, source_row_hash, vision_id, card_year, plus 27 more
connected_gis_card_building.csv162gis_card_building_id, load_batch_code, source_row_hash, vision_id, card_year, plus 57 more
connected_gis_card_building_section.csv446gis_card_building_section_id, load_batch_code, source_row_hash, vision_id, card_year, plus 41 more
connected_gis_card_construction_summary.csv19736gis_card_card_construction_summary_id, load_batch_code, source_row_hash, vision_id, card_year, plus 31 more
connected_gis_card_extraction_qa.csv104218gis_card_extraction_qa_id, load_batch_code, source_row_hash, qa_id, vision_id, plus 13 more
connected_gis_card_follow_up_control.csv1713gis_card_follow_up_control_id, load_batch_code, source_row_hash, follow_up_id, vision_id, plus 8 more
connected_gis_card_land.csv30557gis_card_land_id, load_batch_code, source_row_hash, vision_id, card_year, plus 52 more
connected_gis_card_note.csv48331gis_card_card_notes_id, load_batch_code, source_row_hash, vision_id, card_year, plus 26 more
connected_gis_card_outbuilding.csv2348gis_card_outbuilding_id, load_batch_code, source_row_hash, vision_id, card_year, plus 43 more
connected_gis_card_parcel.csv19770gis_card_parcel_id, load_batch_code, source_row_hash, vision_id, card_year, plus 65 more
connected_gis_card_parcel_identity_event.csv419gis_card_parcel_identity_event_id, load_batch_code, source_row_hash, vision_id, event_sequence, plus 14 more
connected_gis_card_reconciliation_reference.csv19726gis_card_reconciliation_reference_id, load_batch_code, source_row_hash, parcel_sequence, vision_id, plus 21 more
connected_gis_card_sale_history.csv27836gis_card_sale_history_id, load_batch_code, source_row_hash, vision_id, card_year, plus 31 more
connected_gis_card_site_feature.csv243gis_card_site_feature_id, load_batch_code, source_row_hash, vision_id, card_year, plus 38 more
connected_gis_card_summary.csv19739gis_card_card_summary_id, load_batch_code, source_row_hash, vision_id, card_year, plus 34 more
connected_gis_card_valuation.csv78142gis_card_valuation_id, load_batch_code, source_row_hash, vision_id, card_year, plus 37 more
connected_gis_card_visit_change_history.csv731gis_card_visit_change_history_id, load_batch_code, source_row_hash, vision_id, card_year, plus 26 more
connected_gis_parcel_assessment_account.csv2209gis_parcel_assessment_account_id, gis_parcel_id, assessment_account_id, relationship_type_code, effective_from, plus 4 more
connected_map_finrpt_audit_disclosure.csv815map_finrpt_audit_disclosure_id, map_finrpt_audit_disclosure_code, map_finrpt_audit_disclosure_source_audit_artifact_id, map_finrpt_audit_disclosure_source_disclosure_artifact_id, map_finrpt_audit_disclosure_source_disclosure_pdf_page, plus 10 more
connected_property_constraint.csv425property_constraint_id, constraint_code, constraint_name, constraint_category_code, constraint_status_code, plus 20 more
connected_property_constraint_asset.csv56property_constraint_asset_id, property_constraint_id, asset_id, relationship_type_code, notes, plus 1 more
connected_property_constraint_evidence.csv510property_constraint_evidence_id, property_constraint_id, evidence_sequence, evidence_type_code, evidence_status_code, plus 5 more
connected_property_constraint_feature.csv15property_constraint_feature_id, property_constraint_id, environmental_feature_id, relationship_type_code, created_at
connected_property_constraint_investigation.csv1220constraint_investigation_id, property_constraint_id, investigation_code, investigation_name, investigation_type_code, plus 15 more
connected_property_constraint_parcel.csv66property_constraint_parcel_id, property_constraint_id, gis_parcel_id, relationship_type_code, affected_area_description, plus 1 more
connected_property_constraint_possible_outcome.csv1310constraint_possible_outcome_id, property_constraint_id, outcome_code, outcome_name, outcome_type_code, plus 5 more
connected_property_environmental_feature.csv111environmental_feature_id, feature_code, feature_name, feature_type_code, identification_status_code, plus 6 more
connected_property_environmental_feature_parcel.csv28environmental_feature_parcel_id, environmental_feature_id, gis_parcel_id, relationship_type_code, relationship_status_code, plus 3 more
connected_property_research_unit.csv21910property_research_unit_id, property_code, property_name, property_category_code, research_status_code, plus 5 more
connected_scenario_asset_action.csv3213scenario_asset_action_id, scenario_version_id, asset_id, scenario_action_type_id, action_sequence, plus 8 more
connected_scenario_delivery_component.csv615scenario_delivery_component_id, scenario_version_id, asset_id, component_code, component_name, plus 10 more
connected_scenario_execution_requirement.csv819scenario_execution_requirement_id, scenario_version_id, subject_asset_id, related_asset_id, requirement_code, plus 14 more
connected_scenario_family.csv48scenario_family_id, scenario_family_code, scenario_family_name, description, active_flag, plus 3 more
connected_scenario_function_assignment.csv1810scenario_function_assignment_id, scenario_version_id, civic_function_id, asset_id, assignment_outcome_code, plus 5 more
connected_scenario_leaseback_term.csv224scenario_leaseback_term_id, scenario_delivery_component_id, lease_start_date, initial_term_years, renewal_option_count, plus 19 more
connected_scenario_parameter_definition.csv137scenario_parameter_definition_id, parameter_code, parameter_name, data_type_code, unit_code, plus 2 more
connected_scenario_parameter_value.csv614scenario_parameter_value_id, scenario_version_id, scenario_parameter_definition_id, asset_id, value_sequence, plus 9 more
connected_scenario_ref_action_type.csv126scenario_action_type_id, action_type_code, action_type_name, description, active_flag, plus 1 more
connected_scenario_requirement_constraint.csv85scenario_requirement_constraint_id, scenario_execution_requirement_id, property_constraint_id, relationship_type_code, created_at
connected_scenario_risk.csv712scenario_risk_id, scenario_version_id, asset_id, risk_code, risk_name, plus 7 more
connected_scenario_variant.csv68scenario_variant_id, scenario_family_id, scenario_variant_code, scenario_variant_name, description, plus 3 more
connected_scenario_version.csv611scenario_version_id, scenario_variant_id, version_number, version_label, scenario_status_code, plus 6 more
connected_sch_asset_class_fact.csv716sch_asset_class_fact_id, sch_asset_class_fact_code, sch_asset_class_fact_source_artifact_id, sch_asset_class_fact_source_asset_class_label, sch_asset_class_fact_source_pdf_page, plus 11 more
connected_sch_business_fact.csv1216sch_business_fact_id, sch_business_fact_code, sch_business_fact_source_artifact_id, sch_business_fact_source_pdf_page, sch_business_fact_source_label, plus 11 more
connected_sch_facility_capital_event.csv513sch_facility_capital_event_id, sch_facility_capital_event_code, sch_facility_capital_event_source_artifact_id, sch_facility_capital_event_source_label, sch_facility_capital_event_source_pdf_page, plus 8 more
connected_sch_finance_rule_fact.csv1215sch_finance_rule_fact_id, sch_finance_rule_fact_code, sch_finance_rule_fact_source_artifact_id, sch_finance_rule_fact_source_disclosure_pdf_page, sch_finance_rule_fact_business_reporting_entity_id, plus 10 more
connected_sch_governance_fact.csv2013sch_governance_fact_id, sch_governance_fact_code, sch_governance_fact_source_artifact_id, sch_governance_fact_source_text, sch_governance_fact_source_pdf_page, plus 8 more
connected_sch_official_term_fact.csv1012sch_official_term_fact_id, sch_official_term_fact_code, sch_official_term_fact_source_artifact_id, sch_official_term_fact_source_office_label, sch_official_term_fact_source_person_name, plus 7 more
connected_sch_operating_relationship_fact.csv713sch_operating_relationship_fact_id, sch_operating_relationship_fact_code, sch_operating_relationship_fact_source_artifact_id, sch_operating_relationship_fact_source_counterparty_name, sch_operating_relationship_fact_source_service_purpose_text, plus 8 more
connected_sch_operational_challenge_fact.csv813sch_operational_challenge_fact_id, sch_operational_challenge_fact_code, sch_operational_challenge_fact_source_artifact_id, sch_operational_challenge_fact_source_statement, sch_operational_challenge_fact_source_pdf_page, plus 8 more
connected_sch_program_service_fact.csv822sch_program_service_fact_id, sch_program_service_fact_code, sch_program_service_fact_source_artifact_id, sch_program_service_fact_source_program_label, sch_program_service_fact_source_service_description_text, plus 17 more
connected_sch_reserve_fact.csv1512sch_reserve_fact_id, sch_reserve_fact_code, sch_reserve_fact_source_artifact_id, sch_reserve_fact_source_reserve_type_label, sch_reserve_fact_source_pdf_page, plus 7 more
connected_sch_workforce_fact.csv812sch_workforce_fact_id, sch_workforce_fact_code, sch_workforce_fact_source_artifact_id, sch_workforce_fact_source_pdf_page, sch_workforce_fact_business_metric_code, plus 7 more
connected_sec_contractual_cash_flow.csv325814sec_contractual_cash_flow_id, sec_contractual_cash_flow_code, sec_debt_issue_id, sec_security_id, source_artifact_id, plus 9 more
connected_sec_debt_funding_observation.csv2116sec_debt_funding_observation_id, sec_debt_funding_observation_code, sec_debt_issue_id, source_artifact_id, sec_debt_funding_observation_subject_code, plus 11 more
connected_sec_debt_issue.csv2023sec_debt_issue_id, sec_debt_issue_code, finrpt_reporting_entity_id, source_artifact_id, sec_debt_issue_name, plus 18 more
connected_sec_debt_issue_authorization.csv616sec_debt_issue_authorization_id, sec_debt_issue_authorization_code, sec_debt_issue_id, source_artifact_id, sec_debt_issue_authorization_type_code, plus 11 more
connected_sec_debt_issue_ban_term.csv227sec_debt_issue_ban_term_id, ban_term_code, sec_debt_issue_id, source_artifact_id, cusip, plus 22 more
connected_sec_debt_issue_continuing_disclosure_term.csv789sec_debt_issue_continuing_disclosure_term_id, continuing_disclosure_term_code, sec_debt_issue_id, source_artifact_id, term_group_code, plus 4 more
connected_sec_debt_issue_lifecycle_link.csv210sec_debt_issue_lifecycle_link_id, link_code, from_sec_debt_issue_id, to_sec_debt_issue_id, link_type_code, plus 5 more
connected_sec_debt_issue_os_fact.csv14112sec_debt_issue_os_fact_id, sec_debt_issue_os_fact_code, sec_debt_issue_id, source_artifact_id, fact_type_code, plus 7 more
connected_sec_debt_issue_party_role.csv339sec_debt_issue_party_role_id, sec_debt_issue_party_role_code, sec_debt_issue_id, source_artifact_id, role_type_code, plus 4 more
connected_sec_debt_issue_redemption_term.csv1012sec_debt_issue_redemption_term_id, sec_debt_issue_redemption_term_code, sec_debt_issue_id, source_artifact_id, term_type_code, plus 7 more
connected_sec_direct_loan_obligation.csv117sec_direct_loan_obligation_id, sec_direct_loan_obligation_code, finrpt_reporting_entity_id, source_artifact_id, sec_direct_loan_obligation_name, plus 12 more
connected_sec_official_statement_change.csv1211sec_official_statement_change_id, sec_official_statement_change_code, sec_debt_issue_id, preliminary_document_id, final_document_id, plus 6 more
connected_sec_official_statement_debt_service_version.csv3212sec_official_statement_debt_service_version_id, sec_official_statement_debt_service_version_code, sec_official_statement_document_id, fiscal_year, outstanding_principal, plus 7 more
connected_sec_security.csv18515sec_security_id, sec_security_code, sec_debt_issue_id, source_artifact_id, sec_security_cusip9, plus 10 more
connected_sec_security_attribute_assertion.csv2915sec_security_attribute_assertion_id, sec_security_attribute_assertion_code, sec_security_id, source_artifact_id, sec_security_attribute_type_code, plus 10 more
connected_sec_security_initial_pricing.csv18511sec_security_initial_pricing_id, sec_security_initial_pricing_code, sec_security_id, source_artifact_id, sec_security_initial_pricing_price_pct, plus 6 more
connected_sec_security_rate_term.csv18511sec_security_rate_term_id, sec_security_rate_term_code, sec_security_id, source_artifact_id, sec_security_rate_term_type_code, plus 6 more
connected_sec_security_sinking_fund_schedule.csv3110sec_security_sinking_fund_schedule_id, sec_security_sinking_fund_schedule_code, sec_security_id, source_artifact_id, sec_security_sinking_fund_schedule_redemption_date, plus 5 more
connected_source_artifact.csv40312source_artifact_id, source_artifact_code, source_system_id, artifact_title, artifact_type_code, plus 7 more
connected_source_artifact_alias.csv499source_artifact_alias_id, source_artifact_alias_code, source_artifact_id, source_artifact_alias_module_code, source_artifact_alias_native_id, plus 4 more
connected_source_artifact_quality_exception.csv413source_artifact_quality_exception_id, source_artifact_quality_exception_code, source_artifact_id, source_artifact_quality_exception_native_refs, source_artifact_quality_exception_type_code, plus 8 more
connected_source_artifact_relationship.csv2613source_artifact_relationship_id, source_artifact_relationship_code, source_artifact_from_id, source_artifact_to_id, source_artifact_relationship_from_native_ref, plus 8 more
connected_source_system.csv610source_system_id, source_system_code, source_system_name, source_system_type_code, owning_organization, plus 5 more
cpa.csv15adoption_year, fiscal_year, fund_balance, restriction, surcharge_pct
CROSS-DOMAIN-BRIDGE-REGISTER.csv74bridge, chain, connection_status, boundary
DATA-SOURCE-CONNECTION-REGISTER.csv3217domain, relation_name, object_type, loaded_rows, connection_mode, plus 2 more
DEBT-AFFORDABILITY-ANNUAL-VIEW.csv1822fiscal_year, evidence_layer, opening_principal, new_borrowing, principal_retired, plus 17 more
decision_case_asset_evidence.csv520decision_case_code, managed_asset_name, current_primary_address, assessment_reported_address, linked_parcel_codes, plus 15 more
enterprise.csv39cost_recovery_source_text, coverage_pct, customers, debt_service, enterprise_fund, plus 4 more
enterprise_rates.csv46charge, effective_year, enterprise_fund, rate_amount, rate_unit, plus 1 more
followups.csv388control_debt_follow_up_code, control_debt_follow_up_owner, control_debt_follow_up_priority, control_debt_follow_up_question, control_debt_follow_up_status, plus 3 more
grant_award.csv6818grant_award_id, award_code, funding_instrument_id, recipient_organization_id, award_number, plus 13 more
grant_control.csv115migration_count, organization_count, program_count, instrument_count, award_count, plus 10 more
grant_core_project.csv11711project_id, project_code, project_name, project_description, responsible_organization_id, plus 6 more
grant_evidence_fact_assertion.csv12413assertion_id, assertion_code, subject_entity_type, subject_entity_id, predicate, plus 8 more
grant_evidence_link.csv1308evidence_link_id, assertion_id, source_record_id, source_locator_id, evidence_role, plus 3 more
grant_funding_instrument.csv11717funding_instrument_id, instrument_code, funding_program_id, instrument_type, instrument_title, plus 12 more
grant_funding_program.csv4811funding_program_id, program_code, program_name, administrator_organization_id, funding_source_type, plus 6 more
grant_organizations.csv78organization_id, organization_code, organization_name, organization_type, record_status, plus 3 more
grant_research_question.csv12111research_question_id, question_code, related_entity_type, related_entity_id, question_text, plus 6 more
grant_source_record.csv11611source_record_id, source_code, canonical_url, title, publisher, plus 6 more
homeowner_assessments.csv410assessment_account_code, building_value, example_scope, fiscal_year, land_value, plus 5 more
HWRSD-REPORT-SECTION-SPEC.csv129section_order, section_title, primary_question, primary_database_object, primary_filter, plus 4 more
hwrsd_key_metrics.csv427metric_code, period, value, unit, assurance_or_status, plus 2 more
issues.csv2010finrpt_reporting_entity_code, sec_debt_issue_code, sec_debt_issue_dated_date, sec_debt_issue_final_maturity_date, sec_debt_issue_instrument_class_code, plus 5 more
middle_school_capacity_evidence.csv67measure_code, period, value, unit, evidence_status, plus 2 more
migrations.csv223applied_at, migration_code, migration_name
parcel_control.csv116checkpoint, gis_parcel_rows, gis_card_parcel_rows, current_ownership_rows, town_owned_current_parcels, plus 11 more
parcel_gis_card_ownership.csv27842gis_card_ownership_id, load_batch_code, source_row_hash, vision_id, card_year, plus 37 more
parcel_gis_card_parcel.csv19770gis_card_parcel_id, load_batch_code, source_row_hash, vision_id, card_year, plus 65 more
parcel_gis_card_valuation.csv78142gis_card_valuation_id, load_batch_code, source_row_hash, vision_id, card_year, plus 37 more
parcel_managed_asset_registry.csv2314asset_code, asset_name, asset_type, asset_status, primary_address, plus 9 more
parcel_ownership_reconciliation.csv266vision_id, location_address, current_owner, owner_classification, reason_not_in_town_owned_view, plus 1 more
parcel_status_summary.csv55dimension, classification, parcel_count, reported_acres_sum, interpretation
parcel_town_owned_current.csv17127vision_id, location_address, parcel_identifier, map_id, state_use_code, plus 22 more
permits.csv55calendar_year, estimated_value, permit_count, residential_business_split_status, source_qualification
position.csv648finrpt_reporting_entity_code, sec_debt_position_snapshot_amount, sec_debt_position_snapshot_as_of_date, sec_debt_position_snapshot_code, sec_debt_position_snapshot_metric_native_code, plus 3 more
prop25_levy.csv607amount, assurance_status, fiscal_year, metric, source_document_code, plus 2 more
purposes.csv347sec_debt_issue_code, sec_debt_issue_purpose_allocated_par_amount, sec_debt_issue_purpose_allocation_status, sec_debt_issue_purpose_description, sec_debt_issue_purpose_native_code, plus 2 more
recon.csv816control_debt_reconciliation_code, control_debt_reconciliation_created_at, control_debt_reconciliation_difference, control_debt_reconciliation_displayed_row_sum, control_debt_reconciliation_id, plus 11 more
relationships.csv139sec_debt_issue_from_code, sec_debt_issue_relationship_amount, sec_debt_issue_relationship_code, sec_debt_issue_relationship_effective_date, sec_debt_issue_relationship_from_native_subject, plus 4 more
REPORTING-VIEW-CONNECTION-REGISTER.csv165domain, view_name, connection_mode, reporting_use, loaded_rows
research_professional_study.csv111professional_study_id, study_code, study_title, consultant_name, consultant_project_number, plus 6 more
residential_tax_rates.csv57assurance_status, fiscal_year, fiscal_year_source_value_code, rate_source_value_code, residential_rate_per_1000, plus 2 more
revenue.csv178amount, cske_revenue_label, fiscal_year, payer_attribution, recurring, plus 3 more
service.csv11212cske_reconciliation_difference, finrpt_reporting_entity_code, sec_debt_service_snapshot_as_of_date, sec_debt_service_snapshot_code, sec_debt_service_snapshot_fiscal_year, plus 7 more
statistics.csv10910domain, estimate_status, fiscal_year, footnote, geography, plus 5 more
tax.csv415sec_debt_issue_id, sec_debt_issue_tax_treatment_amount, sec_debt_issue_tax_treatment_code, sec_debt_issue_tax_treatment_created_at, sec_debt_issue_tax_treatment_description, plus 10 more
tax_policy.csv47adopted, adoption_year, cske_tax_label, local_rate_pct, source_status, plus 2 more

Supporting reports, query output, controls, and specifications

Linked fileTypeBytes
ATM-2026-DATA-COVERAGE-AND-REPORTING-BOUNDARIES.mdMD3,573
ATM-2026-DECISION-REPORT.htmlHTML5,141
CAPITAL-ASSESSMENT-DATA-COVERAGE-AND-BOUNDARIES.mdMD7,839
CAPITAL-ASSESSMENT-REPORTING-QUERIES.sqlSQL14,462
CONNECTED-DATA-EXTRACTION-MODE.txtTXT44
CSKE-Debt-Questions-and-Disclosure-Decision-Report-Summary.txtTXT4,917
CSKE-Whole-Picture-Reporting-Coverage-Gap-Review-v0.1.0-20260814.mdMD22,782
CSKE-Wilbraham-2026-ATM-0100-Comprehensive-Reporting-Queries-v0.1.0-20260814.sqlSQL47,790
EXISTING-DATA-SOURCE-CONNECTIONS-BOUNDARIES.mdMD4,805
EXISTING-DATA-SOURCE-CONNECTIONS.htmlHTML24,483
FY2027-Town-Accounting-Reporting-Queries-Output.txtTXT50,162
FY2027-Town-Money-Flow-and-Materiality-Report.pdfPDF154,409
GRANT-DATA-COVERAGE-AND-BOUNDARIES.mdMD2,944
HWRSD-REPORT-QA-CHECKLIST.mdMD5,470
HWRSD-REPORTING-EXTRACTS.sqlSQL27,231
HWRSD-REPORTING-INTEGRATION-HANDOFF.mdMD22,558
MIDDLE-SCHOOL-AND-BUC-DECISION-VIEW-BOUNDARIES.mdMD4,762
MIDDLE-SCHOOL-AND-BUC-DECISION-VIEW.htmlHTML13,015
PARCEL-DATA-COVERAGE-AND-BOUNDARIES.mdMD6,031
REMAINING-DATA-SOURCE-REPORTING-EXTRACTS.sqlSQL9,088
REPORTING-IDEAS-DATA-COVERAGE-AND-NEXT-INPUTS.mdMD4,738
SOURCE-EXECUTION-EVIDENCE-v0.3.8-20260813-032801.txtTXT27,124
TOWN-ACCOUNTING-CLASSIFICATION-SCHEMA-AND-QUERY-GUIDE.mdMD30,261
TOWN-ACCOUNTING-MONEY-FLOW-REPORT.sqlSQL16,462
TOWN-ACCOUNTING-READ-ONLY-VALIDATION.sqlSQL1,787
V0.3.4-EXECUTION-CORRECTION-NOTE.txtTXT3,796
V0.3.5-ATM-INTEGRATION-NOTE.txtTXT1,730
V0.3.6-DECISION-CASE-INTEGRATION-NOTE.txtTXT1,299
V0.3.7-EXISTING-DATA-CONNECTIONS-NOTE.txtTXT1,739
V0.3.8-FORWARD-DECISION-STORY-NOTE.txtTXT2,869
V0.3.9-CORRECTION-NOTE.txtTXT951