# Evidence Topic: Markdown company-channel baseline freeze

## Metadata

- Date: 2026-07-31
- Status: Frozen and independently verified; live publication intentionally excluded
- Scope: Accepted Markdown Booking batch 1, July 31 Finance snapshot, processor 1.2.0 and five company XLSX outputs
- Confidence: Fact
- Source: exact source copy/hash, repeatable-read/read-only PostgreSQL snapshots, independent Markdown aggregation,
  artifact-tool export/reopen/value validation, rendered-sheet review and SHA-256 inventory
- Last verified: 2026-07-31 12:26 +08:00
- Stale trigger: Booking current-source activation, Finance current-version change, company processor/rule change or
  mutation of a frozen package file

## Question

What exact channel-processing result existed under the Markdown Booking fixture before the first real Booking Excel
activation, and can it be preserved as an independent comparison baseline?

## Evidence

- The source is
  `/Users/chillishark/ARR项目0727/outputs/res_comment_20260727/RES_COMMENT_TYPE_OF_ROOM.md`, SHA-256
  `ec2302170c5657d3e465691997e17f7694eb5a7f76feba7e43261632209b8c23`, 39,209 bytes.
- Independent parsing produced 867 source rows, six worksheets, 348 normalized Group Codes and total room quantity 867.
- A read-only database guard found accepted/current source batch 1, `expected_fixture`/`md/1.0`, with the same filename,
  byte size, hash and counts. The guard was repeated after workbook generation; the current source and current room-item
  counts were unchanged.
- The July 31 snapshot contains 417 supported-company Finance facts pinned to five current daily versions:
  2026-07-20/version 5, 2026-07-21/version 4, 2026-07-22/version 6, 2026-07-23/version 7 and
  2026-07-27/version 2. Twenty-seven requested Group Codes resolve to current Booking parse versions.
- Processor 1.2.0/rule SHA-256
  `12ab16062e9b4e5e3785b16cbb5724f3cf0a1d2364b8c4cb12c361a2dfd24c17` produced valid reports for all five
  companies:

| Company | Output rows | Booking Room filled | Booking Room blank | Warnings | Errors | Independent mismatches |
|---|---:|---:|---:|---:|---:|---:|
| LianTai | 138 | 16 | 122 | 2 | 0 | 0 |
| QBD | 139 | 11 | 128 | 4 | 0 | 0 |
| DY-AI-Easy-KB | 1 | 0 | 1 | 0 | 0 | 0 |
| FengRun | 33 | 0 | 33 | 0 | 0 | 0 |
| HanaTour | 3 | 0 | 3 | 0 | 0 | 0 |

- Every output row was compared with an expectation built directly from the copied Markdown by normalized
  `Group Code + room type`, summing quantity. All 314 rows match: 27 filled Booking Room values and 287 correct blanks.
- The checked-in artifact-tool builder exported and reopened each XLSX, verified exact worksheet names, headers and
  cell values, found zero formulas/formula errors, and rendered all three periods. All 15 previews were visually
  inspected; populated and empty periods are legible with no clipping or structural defect.
- `SHA256SUMS` verifies every retained source, mapping, payload, validation, workbook, summary and preview file. All five
  XLSX files also pass ZIP integrity checks.
- The package is saved at
  `outputs/019fb225-1b2c-7211-a4c1-2b12b482f6c1/markdown-channel-baseline-20260731-md-ec230217/`.
- The operation invoked neither the company publisher nor any database mutation. One reviewing Booking Excel draft
  existed before and after the freeze, remained outside accepted facts and was not edited or activated.

## Finding

The Markdown-driven channel-processing result is now a durable, independently checkable baseline rather than a
temporary preview. It proves current processor correctness for the exercised data and preserves the exact pre-Excel
comparison point. It does not claim Web job persistence, report-version registration or post-activation integration.

## Impact

- The current Excel draft can be reviewed and deliberately activated later without losing the prior expected result.
- Post-activation comparison should use the frozen source/hash, manifest, row-level comparison and workbook hashes rather
  than re-querying a changed current source.
- A released five-company Web job remains necessary to accept task creation, publication metadata and downloads.

## Open Items

- Finish or delete all pending items in the current Excel draft, activate the complete replacement deliberately, then
  generate one released five-company job and compare its five overlapping Group Codes against the Excel review result.
