I have just started learning OMOP. I am super excited to learn it and attend the upcoming symposium.
I came across concept_id 45576364 that links to two standard concepts, both are valid (without valid_end_date) and have same valid_start_date. Not sure which one should I use.
This is the query I am using:
select c_scr., '’ as Divider, cr., '**’ as Divider, c_tar.
from concept c_scr
join concept_relationship cr on c_scr.concept_id = cr.concept_id_1 and cr.relationship_id = ‘Maps to’
join concept c_tar on cr.concept_id_2 = c_tar.concept_id and c_tar.standard_concept = ‘S’
where c_scr.vocabulary_id in (‘ICD10’,‘ICD10CM’)
and c_scr.concept_id = 45576364
I would greatly appreciate if someone can guide me how to determine which standard concept_id should I use.