A nurse has a medication that they are trying to administer to a patient rectally. There’s no reason the patient can’t take the medication orally. How do you know if the medication is available in an oral dosage form?
This is how the medication shows up in your EHR:
prochlorperazine 25 mg suppository
You know the ingredient is prochlorperazine. How do you find other clinical products that have different dosage forms based on that ingredient?
Likely the best alternative product would be:
prochlorperazine 10 MG Oral Tablet (RXCUI = 198365)
prochlorperazine 5 MG Oral Tablet (RXCUI = 312635)
There IS a concept for prochlorperazine 25 MG Oral Tablet (RXCUI = 198366), but it doesn’t appear to have related NDCs and RxNorm marks it as prescribable = FALSE.
from staging.stg_rxnorm__ingredients ing
inner join staging.stg_rxnorm__clinical_product_components cpc
on ing.rxcui = cpc.ingredient_rxcui
inner join staging.stg_rxnorm__dose_forms df
on cpc.dose_form_rxcui = df.rxcui
where ing.name = 'prochlorperazine'
and df.name != 'Rectal Suppository'
and cpc.active and cpc.prescribable