News for hackers. Stuff that matters.
Re:Open source hospital price database by adunsulag on Tuesday June 13, 2023 @06:16PM (#36318361)
What the is the code you are using in your data. Is it SNOMED? CPT4? Something else?
Re:Open source hospital price database by tdstein on Tuesday June 13, 2023 @06:29PM (#36318508)
CDM codes and REV codes are listed, both of which are a different coding system than SNOMED or CPT, specifically built for billing purposes.

https://en.m.wikipedia.org/wiki/Chargemaster

Re:Open source hospital price database by alecst on Tuesday June 13, 2023 @09:24PM (#36320132)
We're gotta work with whatever the hospitals give us.

The most common codes we see are CPT/HCPCS codes (coupled with revenue codes), or DRG codes. When the hospital provides any one of REV, CPT, HCPCS, MS-DRG, APR-DRG, APC, NDC, or EAPG, we break them out into their own columns.

We keep all the code metadata -- that is, we leave the code strings mostly intact, and then extract the code itself into a separate column. This preserves things like "CPT4" or whatever, as a string, but we do not have a way yet of splitting CPT codes into multiple subtypes. So we haven't lost any data, but we haven't totally figured out how to query it perfectly well either.