Ingredient --> Source Code Relationships - Injectable Examples

[ericaVoss]

Version: v5.0 17-JUL-15

Had a researcher doing some analysis on certolizumab pegol, anakinra, adalimumab, and golimumab and noticed the exposure counts had gone down from a previous run (from 2012). I noticed there were some NDC/HCPCs that could have mapped into these ingredients via relationships but did not.

WITH CTE_RELATIONSHIP AS (
    SELECT c3.CONCEPT_ID, c3.concept_name, c3.vocabulary_id
    FROM CONCEPT c
        JOIN concept_ancestor ca
            ON ca.ANCESTOR_CONCEPT_ID = c.concept_id
        JOIN CONCEPT c2
            ON c2.concept_id = ca.DESCENDANT_CONCEPT_ID
        JOIN CONCEPT_RELATIONSHIP cr
            ON cr.CONCEPT_ID_1 = c2.concept_id
        JOIN concept c3
            ON c3.concept_id = cr.concept_id_2
    WHERE c.CONCEPT_ID IN (
        912263,1114375,1119119,19041065
    )
    AND c3.VOCABULARY_ID IN ('HCPCS','NDC')
),
CTE_TEXT_SEARCH AS (
    SELECT *
    FROM CONCEPT c
    WHERE (
        c.concept_name LIKE '%certolizumab pegol%'
        OR c.concept_name LIKE '%anakinra%'
        OR c.CONCEPT_NAME LIKE '%adalimumab%'
        OR c.CONCEPT_NAME LIKE '%golimumab%'
    )
    AND c.VOCABULARY_ID IN ('HCPCS','NDC')
)
SELECT *
FROM CTE_TEXT_SEARCH
WHERE CONCEPT_ID NOT IN (
    SELECT CONCEPT_ID FROM CTE_RELATIONSHIP
)
ORDER BY 2

I get 48 hits

45867389    {3 (0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]) } Pack [Humira Pediatric Crohn's Disease Starter Package (3 count)]
45875952    {6 (0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]) } Pack [Humira Pediatric Crohn's Disease Starter Package (6 count)]
45043123    {6 (0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]) } Pack [Humira Pen - Crohn's Disease Starter Pack]
44991725    {6 (0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]) } Pack [Humira Pen - Crohn's Disease Starter Pack]
45867368    0.2 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45299199    0.4 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45210440    0.4 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45094230    0.4 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45331354    0.5 ML golimumab 100 MG/ML Prefilled Syringe [Simponi]
45242785    0.5 ML golimumab 100 MG/ML Prefilled Syringe [Simponi]
44905374    0.5 ML golimumab 100 MG/ML Prefilled Syringe [Simponi]
45157161    0.5 ML golimumab 100 MG/ML Prefilled Syringe [Simponi]
45037767    0.67 ML anakinra 149 MG/ML Prefilled Syringe [Kineret]
45037768    0.67 ML anakinra 149 MG/ML Prefilled Syringe [Kineret]
44853984    0.67 ML anakinra 149 MG/ML Prefilled Syringe [Kineret]
45280273    0.67 ML anakinra 149 MG/ML Prefilled Syringe [Kineret]
45003490    0.67 ML anakinra 149 MG/ML Prefilled Syringe [Kineret]
45297326    0.67 ML anakinra 149 MG/ML Prefilled Syringe [Kineret]
45008883    0.8 ML adalimumab 50 MG/ML Prefilled Syringe
44866816    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
46253092    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45333051    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45179186    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45043120    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45074125    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45230818    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
44855775    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45316148    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45060243    0.8 ML adalimumab 50 MG/ML Prefilled Syringe [Humira]
45086112    1 ML certolizumab pegol 200 MG/ML Prefilled Syringe [Cimzia]
45052121    1 ML certolizumab pegol 200 MG/ML Prefilled Syringe [Cimzia]
45376117    1 ML certolizumab pegol 200 MG/ML Prefilled Syringe [Cimzia]
44936164    1 ML golimumab 100 MG/ML Prefilled Syringe [Simponi]
45191324    1 ML golimumab 100 MG/ML Prefilled Syringe [Simponi]
45060235    adalimumab  KIT [humira]
45333050    adalimumab  KIT [humira]
45350179    adalimumab  KIT [humira]
45804517    adalimumab  KIT [humira]
44894579    anakinra 100 mg/.67mL INJECTION, SOLUTION [Kineret]
45851799    anakinra 100mg/.67mL SUBCUTANEOUS INJECTION, SOLUTION [kineret]
45234747    certolizumab pegol   KIT [Cimzia]
45166363    certolizumab pegol 200 mg/mL INJECTION, SOLUTION [Cimzia]
45829089    certolizumab pegol 200mg/mL SUBCUTANEOUS INJECTION, SOLUTION [cimzia]
45166634    golimumab 100 mg/mL INJECTION, SOLUTION [Simponi]
45286327    golimumab 50 mg/.5mL INJECTION, SOLUTION [Simponi]
44842898    golimumab 50 mg/4mL SOLUTION [SIMPONI ARIA]
44786558    Injection, certolizumab pegol, 1 mg (code may be used for medicare when drug administered under the direct supervision of a physician, not for use when drug is self administered)
44786562    Injection, golimumab, 1 mg, for intravenous use

[cgreich]

This is a bug in NDC to RxNorm mappings. Some of them are currently wrongly recorded as “Quantified form of” instead of “Maps to”. Fixing that now and doing a re-release.

[ericaVoss]

Will this be something that comes out with a larger release or will this be something I can grab soon?

[cgreich]

Very soon. This week.

[cgreich]

The list is down to 8 now. They are HCPCS (we are redoing the mapping completely) and some 9-digit NDC (we are fixing those mappings over time). There are a gigantic amount of unmapped NDC.

[ericaVoss]

I can see this problem has gone from 48 --> 6. The 6 left are newer NDCs, they probably will pick up mappings over time. Closing the issue.