Hi all,
I searched the forum but didn’t see the answer to this exact question.
I have been asked to explore the possibility of using a particular OMOP (EHR) database as a source of external controls. I know a lot about the criteria for selecting external controls, which in and of itself is challenging, but my problem is not with the methodology but with how the drugs were mapped. I did not perform the ETL on this data set so I am trying to untangle it.
Let’s say I want to exclude anyone who was already enrolled in a study. I noticed that many (but not all) of the unmapped drugs, where concept id = 0, have words like “IRB” or “investigational” or “placebo” in the source value, making it somewhat easier to identify these folks with a flag and then manual review.
However, I also noticed that a lot of people with the same words in their source values are mapped to a variety of codes like this: Athena (ohdsi.org)
I want to provide feedback to the data owner on how to map this in the future. Or perhaps there is nothing to be done for this particular use case?
Thank you in advance!