I converted coronary angiography report into note table of OMOP-CDM ver 5.0.2.
I want to convert all reports from radiology and pathology into CDM, too.
But I’m wonder how I can set relationship between these notes with primary procedure or measurements or specimens.
(How can I know where the coronary angiography report comes from, when the patient has multiple coronary angiography in the same day? Current note table has visit_occurrence_id, so I can tag it. But I don’t find any room for procedure_id or measurement_id)
Is there any established logic for this issue? Or should we extend the note table further?