OHDSI Home | Forums | Wiki | Github

A question about relationships linking a drug to its adverse reaction

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

@Aya_Rezk Have you found a way to do that?

Hello, @Aya_Rezk and @Yanal_Shareef.
This post went unnoticed in 2021, but not now :slight_smile:

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 :raised_hands:

t