Multiple Modifier with Single Procedure

[MPhilofsky (Melanie Philofsky)]

Hi @TMS,

@TMS

How can we differentiate Modifiers in clinical, supplemental and as additional informatio

Have a clinical informatician assess the data. I suggest writing some SQL to pull the data into a csv:

SELECT
Modifier1,
Modifier2,
Modifier3,
count (*)
FROM Your data source
GROUP BY
1,2,3
ORDER BY
4 desc

@TMS

Also what if there are two clinical modifiers are attached?

I think this will be a rare occurrence. But you can add another row in your Procedure table with procedure_concept_id = 0 (you don’t want to repeat the procedure_concept_id because your Person only got one Procedure) and then the modifier in the modifier_concept_id and link them using the Fact Relationship table. O