How to populate drug_exposure.quantity when the dose form of the drug is a clinical drug with fixed dose forms (tablets etc.)

[burrowse]

How to populate drug_exposure.quantity when the dose form of the drug is a clinical drug with fixed dose forms (tablets etc.)

CDM or THEMIS convention?

Themis

Table or Field level?

Field

Is this a general convention?

No

Summary of issues

• Quantity is represented several different ways depending on the dose form of a drug.
• For clinical drugs with a fixed dose form it may be unclear how to store quantity.
• The CDM documentation currently states: "For clinical drugs with fixed dose forms (tablets etc.) the quantity is the number of units/tablets/capsules/suppositories prescribed or dispensed (can be partial, but then only 1/2 or 1/3, not 0.01)."
• A recent Forum discussion has a more simplified convention that "If you have a solid Clinical/Branded Drug then quantity represents the number of tablets, capsules, suppositories etc."

Summary of answer

• To find the dose form of a drug the RELATIONSHIP table can be used where the relationship_id is ‘Has dose form’.
• For solid clinical/branded drugs with fixed dose forms (tablets, capsules, suppositories etc.) the quantity is the number of tablets/capsules/suppositories prescribed or dispensed (can be partial, but then only 1/2 or 1/3, not 0.01).

Related links

• CDM Documentation: https://ohdsi.github.io/CommonDataModel/cdm54.html#drug_exposure
• Recent Forum discussion Linke: https://forums.ohdsi.org/t/drugs-with-dose-in-the-name-is-quantity-field-automacally-populated/8318/7
• More guidance on how to determine the quantity for solid fixed dose drugs: https://forums.ohdsi.org/t/how-to-store-medication-dose-and-or-quantity-in-drug-exposure-table/6460
• More supporting guidance on how to store quantity for tablets: https://forums.ohdsi.org/t/drug-exposure-quantity/18869/5
• Original Forum Post: https://forums.ohdsi.org/t/proposal-for-conventions-regarding-quantity-and-strength/1015/33 and Wiki Proposal :https://www.ohdsi.org/web/wiki/doku.php?id=documentation:next_cdm:denominator_units related to this topic

[MelaniePhilofsky]

Moving all "quantity" convention issues to Needs More Work column for further review of wording.