Is there a way to merge the CDM condition occurrence table with the CDM procedure occurrence table?

General
1

Hello everyone,

I’m trying to achieve the target of knowing which procedure is utilized for which condition by mapping procedure_occurrence to condition_occurrence tables along with the person table.

My question is if there is a way to do such a mapping knowing that achieving this mapping through the visit_occurrence table will not solve the issue as a person may have multiple conditions and multiple procedures mapped to the same visit_occurrence_id.

Thanks in advance!

2

@Qamar_Quqa:

Won’t work for the many-to-many problem you pointed out. Plus, many procedures don’t have a specific condition. Take vaccinations (well, they are drugs, but you get the point).

What you want is the indication for a procedure. You cannot do it at a patient level easily, but you could try something at the population level: Calculate some dysproportionality of conditions prior to visits with your procedure compared to other procedures, and the indication will stick out. Other noise will also stick out, though.