Apologies if this question has been asked before, but I did not see a topic when I searched.
Researchers at Weill Cornell often request pharmaceutical classification in combination with cuts of data from DRUG_EXPOSURE. We do not have this classification stored in OMOP, so we have to go back to source to get it. It would be elegant if this information was stored in OMOP, but we were not sure about the best place to store it.
I see that there is the ATC classification in the CONCEPT table, which has many high-level terms that we could map to our pharmaceutical classifications. For example, we would map “Antihistamine” from our source to 21602002 (ANTIPRURITICS, INCL. ANTIHISTAMINES, ANESTHETICS, ETC.) from the vocabulary. Would we store these mappings in DRUG_EXPOSURE, OBSERVATION, or some other table?