There are 150K+ unmapped NDC concepts.
We are going to make these mappings.
But before doing this we need to know if it worth it and what concepts are really used,
so it would be helpful to run such a remote study on datasets you have:
Select concept_code, concept_name
from drug_exposure
join concept c on concept_id=drug_source_concept_id
left join concept_relationship r on r.concept_id_1 = c.concept_id and r.invalid_reason is null and r.relationship_id =‘Maps to’
where c.vocabulary_id=‘NDC’ and r.concept_id_1 is null
;