Over time, we’ve built lists of drugs for various purposes, primarily utilizing NDC and RxNorm codes, with a few oddballs thrown-in, to keep it interesting.
I would like to standardize these lists at the generic product with form and strength level. It would seem that the Clinical Drug concept type (RxNorm) would best suit our needs at present. Once the lists are cleaned up, I expect to explore moving then to ATC, with which I have had very little experience.
I tried a fairly simple way of translating the lists, using the “Maps to” relationship and filtering the results for concept_class_id=‘Clinical Drug’. When tested on some very small files, it appeared to work. However, when I used larger files, it became obvious that I losing many drug products in the process.
Exploring data, I note that many drug concepts do not map directly to concepts of the Clinical Drug class. I am thinking of writing a recursive query to follow appropriate relationships until I find a suitable concept is encountered, but A, I don’t know if that would work, and B, I assume that there MUST be a better (= simple & reliable) way to do this, which I am overlooking.
Here’s a list of the concept classes to which entries on my lists belong, by vocabulary. finding mappings .xlsx (10.4 KB) Some of these classes are clearly inappropriate and will be dropped, but I expect that for every NDC & RxNorm code, I should be able to find what I seek. No?