In the CDM, I cannot find any relationships linking Condition_Occurrence to Drug_Exposure tables.
Of course both tables have foreign keys linking them to the Patient table, but there is no way to know if the Condition has been caused by the drug, or treated by the drug.
How can one query the database for adverse reactions?
1 Like
Hello, @Aya_Rezk and @Yanal_Shareef.
This post went unnoticed in 2021, but not now 
There is no way to know if the Condition has been caused by the drug, or treated by the drug. Why? Because what you can see in real-world data are just facts about patients receiving drugs or having conditions. We can’t establish direct links between conditions and drugs or vice versa. This is not the first question on this topic. You may find this thread helpful.
If you are doing some custom mapping and fully control your data and ETL process, you may adjust CDM to your use case, however, not breaking basic rules, by creating separate records with custom concepts for adverse reactions of certain drugs, but this is not considered a best practice. There are already some concepts in standard vocabularies that might cover your use case.
1 Like
Appreciated 