Hello,
I’m looking into the mapping from ATC to RxNorm for the ATC-code J07BB, Influenza vaccines.
I’ve found the ATC-concept-id to be 21601333 and running
select max_levels_of_separation, c.*
from cdm_synthea10.concept_ancestor ca, cdm_synthea10.concept c
where ca.ancestor_concept_id = 21601333 and c.standard_concept='S'
and ca.descendant_concept_id=c.concept_id
order by max_levels_of_separation;
gives me 8 different meningococcal vaccines, e.g. “Haemophilus influenzae b (Ross strain) capsular polysaccharide Meningococcal Protein Conjugate Vaccine Injectable Solution [Enzira]”.
But a search for ‘%influenza%vaccines%’ seems to indicate that there are many other (2870) influenza vaccines in the concept table.
(SELECT * from concept
WHERE concept_name like '%influenza%vaccine%')
Am I doing something wroing, is this a bug or something that simply hasn’t been covered yet in the mapping?
Thank you!