# Technical Query Library

This supporting folder preserves the supplied read-only query commands and reporting guides used through Portal v3.6.0's coverage review.

## Included

- `dor-0301/` — accepted DOR data-use manual and complete read-only row-display command.
- `tax-0200/` — FY2025 tax-normalization all-data query command.
- `town-accounting/` — Town-accounting classification schema and query guide.
- `cherry-sheet-0300/` — Cherry Sheet all-fields/history command and query guide.
- `debt-and-disclosure-0201/` — disclosure, bond, debt, and affordability reporting-builder handoff.
- `affordability-0303/` — accepted report-builder examples, reporting-surface query, and affordability use manual.
- `school-0400/` — organization-identity query and bounded data-use manual.

## Runtime boundary

The supplied DOR 0301 transcript was inspected and ended in `OVERALL PASS`; a compact hash and population record is included in `dor-0301/DOR-0301-QUERY-RUN-VERIFICATION-20260819.txt`. The full 143 MB runtime transcript is not duplicated inside the web-deployment ZIP.

The tax 0200 command and debt/disclosure reporting guidance are preserved as supplied. Their inclusion does not claim that a new runtime export was generated inside this reporting build. Affordability 0303 is adopted from its accepted loader transcript and reporting handoff. School 0400 is used only for organization identity and source context. The August 20 catalog records the database state through those accepted layers.

All commands are read-only reporting artifacts. They are not deployment or migration instructions. Official sources and accepted database evidence control.

For the web-distribution copy, user-specific credential fallback paths were removed. Set `CSKE_PGPASSFILE` to an existing PostgreSQL password-file path when running a command if `~/.pgpass` is not used. No credential value is included here.