OHDSI Home | Forums | Wiki | Github

NDC/Jcode to target concept mapping for Etelcalcetide/Parsabiv

Vocabulary Users
#1

I was looking for Rxnorm for Etelcalcetide/Parsabiv, did not find. This drug was approved in Feb 2017 in US and Nov 2016 in EU. Wondering when we should expect - mapping for this drug?

The NDCs for Etelcalcetide/Parsabiv are
• 55513-0740-01
• 55513-0740-10
• 55513-0741-01
• 55513-0741-10
• 55513-0742-01
• 55513-0742-10
The J code for Etelcalcetide is
• J0606

#2

Actually, RxNorm already has both etelcalcetide (concept_id 1593331) and Parsabiv. Mappings from NDC are also there.
What’s your query?
Should look like:
Select * from concept join concept_ancestor on concept_id = descendant_concept_id where ancestor_concept_id = 1593331;
This will give you all the standard drugs containing etelcalcetide. Or simply use Athena.ohdsi.org

#3

Currently I am using - OMOP Vocabulary v4.5 17-OCT-17. but I did not find for NDC and Jcode mapping.

#4

Here you go:
select * from concept c
join concept_relationship cr
on cr.concept_id_1 = c.concept_id
join concept c2 on c2.concept_id = concept_id_2 and c2.vocabulary_id = ‘RxNorm’ and c2.standard_concept = ‘S’
where c.concept_code in (‘55513074001’,‘55513074010’,‘55513074101’,‘55513074110’,‘55513074201’,‘55513074210’)
;
2017 HCPCS release doesn’t have J0606, may occur in 2018.

ndc.xlsx (8.6 KB)

t