opps: APC weight file ingestion (annual + quarterly updates) #264

Closed
opened 2026-03-25 19:54:09 +00:00 by kert · 0 comments
Owner

Objective

Ingest CMS OPPS APC weight files, mirroring how PFS ingests RVU files.

Tasks

  • Download APC weight files from CMS.gov (Addendum A/B)
  • Parse: APC code, short descriptor, relative weight, payment rate, status indicator
  • Historical files: CY 2014–2026 (aligned with skin sub rule history)
  • Store as opps.apc_weights in DuckDB
  • Track status indicator changes over time (S/T/Q for skin subs)
## Objective Ingest CMS OPPS APC weight files, mirroring how PFS ingests RVU files. ## Tasks - [ ] Download APC weight files from CMS.gov (Addendum A/B) - [ ] Parse: APC code, short descriptor, relative weight, payment rate, status indicator - [ ] Historical files: CY 2014–2026 (aligned with skin sub rule history) - [ ] Store as `opps.apc_weights` in DuckDB - [ ] Track status indicator changes over time (S/T/Q for skin subs)
kert added this to the P31: OPPS Module — outpatient payment system parity with PFS milestone 2026-03-25 19:54:09 +00:00
kert closed this issue 2026-03-26 06:14:36 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: homelab/stack#264