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.
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
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
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.
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.