# Submission review — executed checks

Run: `python output/validate.py` from workspace root. Python standard library only.

- PASS: sales: exact source row-ID multiplicities preserved.
- PASS: sales: output row IDs unique.
- PASS: sales: every original field and derived inclusion, reason, retained-row and linkage value verified against raw evidence.
- PASS: refunds: exact source row-ID multiplicities preserved.
- PASS: refunds: output row IDs unique.
- PASS: refunds: every original field and derived inclusion, reason, retained-row and linkage value verified against raw evidence.
- PASS: ads: exact source row-ID multiplicities preserved.
- PASS: ads: output row IDs unique.
- PASS: ads: every original field and derived inclusion, reason, retained-row and linkage value verified against raw evidence.
- PASS: Exactly one exception per independently derived exclusion (13); no extra exceptions.
- PASS: Exception business IDs, reasons, retained-row references and policy citations verified.
- PASS: All seven metrics verified for Workshop, Course and combined using Decimal arithmetic.
- PASS: All 21 numerical results in summary.md match the independently derived CSV totals.
- PASS: Row-count and known-amount control totals verified; R06 remains the only missing amount.
- PASS: Unknown R06 amount preserved as blank, not zero.
- PASS: Known linked unique settled refunds, including November R07, do not exceed order gross; R05 and R06 cannot be fully cap-checked.
- PASS: Five archived original deliverables match the preservation SHA-256 manifest.
- PASS: Four revised CSVs are byte-identical to the original submission; no numerical correction needed.
- PASS: Four input files unchanged across this review validation run (SHA-256).

## Scope and limitations

The review derives duplicate/superseded records and eligibility from raw CSVs independently of the original hard-coded exclusion lists. All input fields, output linkage fields, exception keys and summary results are checked. CSV syntax was parsed, not tested in a spreadsheet application. Human-readable explanations and recommendations were reviewed against the supplied policy and row evidence. No external verification was performed. R06 remains unknown and R05 remains unmatched; known-value cap tests cannot clear either exception. Hash checks establish unchanged files during this review, not any earlier unobserved period.
