Missing NDC and HCPCS in OMOP and Athena

[dennisrobert (Dennis)]

I have a list of about 5000 NDC and HCPCS codes in a flat file which I am trying to see if those are existing in OMOP concept table. I downloaded NDC and HCPCS CDM tables from Athena and what I found was about 700 codes (NDC + HCPCS codes) are missing in the latest Athena download. That is, about 15% of the source NDC and/or HCPCS codes does not have a valid concept_code in concept table. What could be the reasons for this? If it’s of any help, here are sample 10 codes that don’t have a match in concept table.

38779227403
10106006101
J7630
49452233902
K0511
54569571300
W9092
54569296200
38779021206

[Dymshyts (Dmytry Dymshyts)]

@dennisrobert:

The reason is probably that they are old and obsolete, and the places we source them from don’t have them anymore. Remember: When the CMS deprecates a HCPCS code it will eradicate it from the website, so no dummy will still use it accidentally. We have been discussing this very subject here

Missing NDCs remote studies

There are 150K+ unmapped NDC concepts. We are going to make these mappings. But before doing this we need to know if it worth it and what concepts are really used, so it would be helpful to run such a remote study on datasets you have: Select concept_code, concept_name from drug_exposure join concept c on concept_id=drug_source_concept_id left join concept_relationship r on r.concept_id_1 = c.concept_id and r.invalid_reason is null and r.relationship_id =‘Maps to’ where c.vocabulary_id…

and here

Missing NDC/HCPCS Codes and Missing Maps to RxNorm

I am working with the ‘CanMED: Cancer Medications Enquiry Database’ from the NCI/SEER Observational Research in Oncology Toolbox (see here https://seer.cancer.gov/oncologytoolbox/) in hopes that it can be used for the vocabulary portion of the Oncology Treatment Proposal (see here: https://github.com/OHDSI/CommonDataModel/issues/163). CANMed classifies low-level NDC/HCPCS codes to higher-level concepts: ‘Minor Class’, ‘Major Class’ and a ‘SEERRx Category’. Importantly, CanMED’s highest level c…

So, can you please create google document with those 700 concepts, and put the link here. And we can add the concepts then.
the format of the file:
code, description, vocabulary_id, earliest observation, latest observation

[dennisrobert (Dennis)]

code, description, vocabulary_id, earliest observation, latest observation

Thanks @Dymshyts for the response. I do not have information on the description, earliest and latest observation. Will this still be useful if I share the data then?

[Dymshyts (Dmytry Dymshyts)]

Earliest and latest observation are the first and last occurrence of those concepts in your data.
Yes, you can share the data or just the list of the concept codes.
Actually, they are not very useful without the description, but we can try to find these descriptions elsewhere.

[dennisrobert (Dennis)]

@Dymshyts
Alright, here is the file
https://drive.google.com/file/d/1znF4kSO9pqNhQ2fvhvU7w8f6Re06vrwW/view?usp=sharing

Thanks again.

[Dymshyts (Dmytry Dymshyts)]

So I took a look on HCPCS codes,
some can be found here

HCPCS Procedure and Supply Medical Codes - Durable Medical Equipment (DME)...

so we need to scrap all this https://www.findacode.com/hcpcs-supply-codes.html in order to find some missing codes.
some can be found here:
CanMED: HCPCS
this list we have already, so we add HCPCS concepts from here to the next HCPCS release

[Christian_Reich]

@dennisrobert:

Thanks for the spreadsheet, but you don’t have the descriptions? And can you see in your data and give us the first and last time stamp?

[dennisrobert (Dennis)]

@Christian_Reich
I don’t have the corresponding NDC/HCPCS descriptions. The objective was to get it from OMOP CDM CONCEPT table. With regard to the timestamps, as I have access only to these codes and not anything else, getting first and last timestamps is also not possible. Apologies.

[Christian_Reich]

@dennisrobert:

Understood. I thought you got data with these codes. Dima started hunting them down, but feel free to also google or use other methods. There is no magic to this.