Attempting to identify all concepts, from specific vocabularies, associated exclusively with Tdap administration, I wrote a query that looks for descendants of the Tdap CVX Vaccine group and the concepts mapped to them.
However, the results include concepts which appear to related to the pediatric formulation, DTaP. What am I misunderstanding?
select distinct
c.Concept_id ,vocabulary_id,c.concept_name,c.concept_class_id
from
vocabulary.concept c ,
vocabulary.concept_ancestor ca ,
vocabulary.concept_relationship cr
where
ca.ancestor_concept_id =40213230 /* CVX Vaccine group: tetanus toxoid, reduced diphtheria toxoid, and acellular pertussis vaccine, adsorbed */
and
cr.concept_id_1 = ca.descendant_concept_id
and
cr.relationship_id in ( ‘Mapped from’)
and
c.concept_id= cr.concept_id_2
and c.vocabulary_id in
(‘SNOMED’,‘NDC’,‘RxNorm’,‘CPT4’,‘Multum’,‘CVX’)
;