OHDSI Home | Forums | Wiki | Github

Drugs with dose in the name- is quantity field automacally populated?


(Ed) #1

Hi all,

We are mapping to the Drug Exposure table and have the following question. When mapping to a specific standard RxNorm Extension where the name indicates the quantity, will this attribute automatically be captured or do we need to specify it?

For example, say we are mapping to drug_concept_id 21151336 (infliximab 100 MG [Remsima]). Would the quantity field automatically be populated with ´100´, or do we add this ourselves?

Many thanks,
Ed


(Qi Yang) #2

The drug concept (drug name) only shows the strength of the medication, not the quantity. For example, drug_concept_id 21151336 (infliximab 100 MG [Remsima]) indicates the strength of the drug is 100 MG/per syringe. If the patient gets 2 shots, the quantity will be 2, which should be put in the Quantity field.


(Ed) #3

Thanks for the clarification!

So, just to make sure I understand fully, the strength of the medication will be stored in the drug strength table (not the drug exposure table). And, for a standard concept such as 21151336, there would be a corresponding entry in the derived drug strength table.

But, how would you suggest we go about mapping an example like ´REMSIMA 150mg´? This doesn´t appear to have an obvious standard concept equivalent. So would we map to a higher level term like 937368 infliximab? But then would this have an associated strength?


(Qi Yang) #4

So, just to make sure I understand fully, the strength of the medication will be stored in the drug strength table (not the drug exposure table).

No. That is not correct. The strength of the medication is stored in concept_id filed in Drug_Exposure table. For example, concept_id 21151336 contains the strength information 100 MG/per bottle or per pre-filled syringe. Of course, you get that information from the concept_name column in the Concept table.

And, for a standard concept such as 21151336, there would be a corresponding entry in the derived drug strength table.

Yes. But please note that Drug_Strength table is a derived table from the Drug_Exposure and vocabulary tables. In another word, if the information does not exist in Drug_Exposure table, it will not be in the Drug_Strength table either.

But, how would you suggest we go about mapping an example like ´REMSIMA 150mg´?

In this case, there is no corresponding concept in the vocabulary that has the strength of 150 mg/per bottle REMSIMA. If you are sure that the drug comes with this strength, the best practice is to to ask @Dymshyts to create a new concept with this strength (150 mg). As a alternative, you can certainly map it to the ingredient level as you suggested that has no strength information.
.


(Anna Ostropolets) #5

Although it doesn’t change the overall answer, drug_strength is the table where dose of a drug is stored and it’s not a derived table but rather the original vocabulary table that was created specifically for the dose data.
The general rules for populating quantity are:
if you have Quant Clinical/Branded Drug or a Pack, quantity represents the number of units (syringes, bottles, etc.)
if you have a solid Clinical/Branded Drug then quantity represents the number of tablets, capsules, suppositories etc.
Otherwise quantity represent the dose itself. E.g. if you map you source REMSIMA 150mg to an ingredient, then you put 150 in the quantity field.
And another comment: you’re highly welcome to submit your vocabulary to be added to OMOP Vocabularies, but for that you need a vocabulary and not just free-text strings.


(Qi Yang) #6

OK. @aostropolets is correct. Drug_Strength table is not a derived table. I messed it up with the Dose_Era table.


(Ed) #7

Thanks @QI_omop and @aostropolets for the additional clarifications, much appreciated.


t