How to populate drug_exposure.quantity when the dose form of the drug is liquid

[burrowse]

How to populate drug_exposure.quantity when the dose form of the drug is liquid

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 liquids it may be unclear how to store quantity.

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’.
• If the drug is a liquid, quantity stands for the total amount dispensed or ordered of ingredient in the units given by the drug_strength table (typically stored as some measure of volume e.g. milliliters etc)
• If the unit from the source data does not align with the unit in the DRUG_STRENGTH table the quantity should be converted to the correct unit given in DRUG_STRENGTH.

Related links

• CDM Documentation: https://ohdsi.github.io/CommonDataModel/cdm54.html#drug_exposure
• Guidance from forum on how to store quantity for liquids: https://forums.ohdsi.org/t/how-to-store-medication-dose-and-or-quantity-in-drug-exposure-table/6460
• 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

[MNairn]

PLEASE COPY THIS TEMPLATE INTO ASSIGNED ISSUE
Note: if no information available, put in 'NA'.

Issue # and location

Themis

Format as follows:
Themis issue #139

Issue summary

Quantity is represented in several different formats which all depends on the form of the drug. For drugs in the form of liquids it may be unclear how to store quantity.

Convention type

Field

CDM table

Drug Exposure

CDM field

Quantity

Links to issue discussion

Links to location of discussion on forums, CDM GitHub, Themis GitHub, etc.

Format as follows:
Themis issue #139
CDM Documentation
[Original Forum Post] ( https://forums.ohdsi.org/t/proposal-for-conventions-regarding-quantity-and-strength/1015/33 )
[Forum Post for Solution] (https://forums.ohdsi.org/t/how-to-store-medication-dose-and-or-quantity-in-drug-exposure-table/6460)
[Wiki Proposal] (https://www.ohdsi.org/web/wiki/doku.php?id=documentation:next_cdm:denominator_units ]

Provenance of data

This applies to all data. Different types of sources will have drug information.

The ratified convention

To find the dose form of a drug the RELATIONSHIP table can be used where the relationship_id is ‘Has dose form’.If the drug is a liquid, quantity stands for the total amount dispensed or ordered of ingredient in the units given by the drug_strength table (typically stored as some measure of volume e.g. milliliters etc). If the unit from the source data does not align with the unit in the DRUG_STRENGTH table the quantity should be converted to the correct unit given in DRUG_STRENGTH.

Date of ratification/published

April 17, 2024

Downstream implications

No

Link to DQD check

No

Format as follows:

Related conventions/further information

#Tags
#drugexposure #drugquantity #quantity

[MelaniePhilofsky]

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