OHDSI / Themis

Repository for OMOP CDM conventions as defined by THEMIS. These can be reference lists of concepts, pieces of standardized code for data generation or quality certification, and debates.

Apache License 2.0

27 stars 8 forks source link

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

Open burrowse opened 5 months ago

burrowse commented 5 months ago

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 commented 5 months ago

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