pfs: NPRM Addendum B loader → pfs.rvu_proposed (duckdb + lake) #592

Closed
opened 2026-08-12 14:51:10 +00:00 by kert · 1 comment
Owner

Component 5. Dedicated loader (src/pfs/nprm.py) reading the NPRM Addendum B from bib storage into pfs.rvu_proposed (pfs.rvu shape + cms_rule_id), delete-and-reload per rule id, wired into dev/scripts/ingest_pfs.py --nprm under duckdb_batch, replica + lake publish, rows logged to cms.ingest_log.

Spec: docs/superpowers/specs/2026-08-12-cy2026-pfs-proposed-rule-design.md (P36)

Component 5. Dedicated loader (src/pfs/nprm.py) reading the NPRM Addendum B from bib storage into pfs.rvu_proposed (pfs.rvu shape + cms_rule_id), delete-and-reload per rule id, wired into dev/scripts/ingest_pfs.py --nprm under duckdb_batch, replica + lake publish, rows logged to cms.ingest_log. Spec: docs/superpowers/specs/2026-08-12-cy2026-pfs-proposed-rule-design.md (P36)
kert added this to the P36: CY2026 PFS Proposed Rule — capture, ingest, APM analysis milestone 2026-08-12 14:51:10 +00:00
kert added the datapfslakehouse labels 2026-08-12 14:51:10 +00:00
Author
Owner

Merged to main in 53b97b8 (branch p36-cy2026-rule, 17 commits). Done in 6563a54 + c0ad6f8 + bc248ea. src/pfs/nprm.py loads the NPRM Addendum B from bib storage into pfs.rvu_proposed: 14,169 rows (CMS-1832-P), delete-and-reload idempotent, in aco.duckdb + read replica + DuckLake. Real-file quirks (padded cells, NA markers, footnote rows) handled and mutation-tested. cms.ingest_log provenance rows carry source_file, sha256, 90 FR 32352, pincite 2KVJ2HKX. Lake publish extended to cms schema. Follow-up #607: column-name alignment with pfs.rvu.

Merged to main in 53b97b8 (branch p36-cy2026-rule, 17 commits). Done in 6563a54 + c0ad6f8 + bc248ea. src/pfs/nprm.py loads the NPRM Addendum B from bib storage into pfs.rvu_proposed: 14,169 rows (CMS-1832-P), delete-and-reload idempotent, in aco.duckdb + read replica + DuckLake. Real-file quirks (padded cells, NA markers, footnote rows) handled and mutation-tested. cms.ingest_log provenance rows carry source_file, sha256, 90 FR 32352, pincite 2KVJ2HKX. Lake publish extended to cms schema. Follow-up #607: column-name alignment with pfs.rvu.
kert closed this issue 2026-08-13 20:29:45 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: homelab/stack#592