skin-subs: build HCPCS code universe from CMS rulemaking descriptions #232
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Objective
Define the complete set of skin substitute HCPCS codes based on CMS rulemaking language, not just the Q4xxx series.
Tasks
skin_subs.hcpcs_universein DuckDBStarting. First need to research the full code universe from CMS rulemaking, then build the reference table.
Progress:
Completed:
skin_subs.hcpcs_universeandskin_subs.hcpcs_referenceRemaining:
Key finding: 75% of active products are amniotic membrane HCT/P — the exact category exploited in the Gehrke ($1.2B) and Jenson ($90M) fraud cases. The regulatory barrier to market entry for HCT/P is minimal (Section 361, no clinical trials required), explaining the proliferation.
Commit:
2e6b2e0. Not closing yet — Zotero tagging outstanding.Status: Data loaded, Zotero tagging outstanding.
Checklist:
skin_subs.hcpcs_universe(286 rows) andskin_subs.hcpcs_reference(34 rows) in DuckDBKey findings:
Commits:
2e6b2e0Files:
data/cms/skin_substitute_hcpcs.csv,data/cms/skin_substitute_hcpcs_reference.csvAdditional scope identified — application/administration codes and fee schedule data.
The skin sub analysis requires TWO code families:
1. Product codes (Q4xxx) — what skin substitute was applied
skin_subs.hcpcs_universe2. Application codes (CPT 15271-15278) — the professional service of applying it
skin_subs.hcpcs_reference(34 reference codes)pfs.rvuhas 12 years (2015-2026) for all 8 current application codes3. Fee schedule history — needed for the predatory pricing analysis
pfs.rvu,pfs.carrier_locality,pfs.gpci4. CMS Town Hall meetings — grey literature source
Impact on claims extraction (#234):
When filtering claims for skin subs, must capture BOTH: