Impute drug_exposure_end_date using ATC Defined Daily Dose (DDD)

[crabcakeworld]

CDM or THEMIS convention?

THEMIS

Table or Field level?

Field

Is this a general convention?

Not sure

Summary of issues

Under following situation:
1). Source data does not provide drug_exposure_end_date or any information to impute drug_exposure_end_date, e.g., days_supply etc.
2). Quantity is provided in source data.
3). Daily dose is not provided in source data

If above criteria are all satisfied, then ATC Defined Daily Dose (DDD) can be used to calculated days_supply to impute drug_exposure_end_date

Summary of answer

This has not been rectified.

days_supply = (Quantity/ATC DDD)

drug_exposure_end_date = drug_exposure_start_date + (Quantity/ATC DDD) - 1

Related links

https://forums.ohdsi.org/t/atc-ddd-to-impute-drug-exposure-end-date/12233
https://www.ohdsi.org/wp-content/uploads/2021/08/2-abstract-Medication-dosage-and-exposure-duration.pdf
https://www.ohdsi.org/wp-content/uploads/2021/08/2-poster-Medication-dosage-and-exposure-duration.pdf

Other comments/notes

[MelaniePhilofsky]

@crabcakeworld Do you want to sponsor this issue?

[crabcakeworld]

Hello Melanie, Yes. I'd love to. What does "sponsor" mean though? Thanks, Qi From: MelaniePhilofsky ***@***.***> Sent: Wednesday, August 28, 2024 12:03 PM To: OHDSI/Themis ***@***.***> Cc: Yang, Qi ***@***.***>; Mention ***@***.***> Subject: Re: [OHDSI/Themis] Impute drug_exposure_end_date using ATC Defined Daily Dose (DDD) (Issue #171) @crabcakeworld<https://github.com/crabcakeworld> Do you want to sponsor this issue? - Reply to this email directly, view it on GitHub<#171 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AIUI5WNTUO2KUO5B5O5PY63ZTXYEZAVCNFSM6AAAAABGZ6CNGKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMJVG42DONJYGU>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

…

________________________________________ IMPORTANT - PLEASE READ: This electronic message, including its attachments, is CONFIDENTIAL and may contain PROPRIETARY or LEGALLY PRIVILEGED or PROTECTED information and is intended for the authorized recipient of the sender. If you are not the intended recipient, you are hereby notified that any use, disclosure, copying, or distribution of this message or any of the information included in it is unauthorized and strictly prohibited. If you have received this message in error, please immediately notify the sender by reply e-mail and permanently delete this message and its attachments, along with any copies thereof, from all locations received (e.g., computer, mobile device, etc.). To the extent permitted by law, we may monitor electronic communications for the purposes of ensuring compliance with our legal and regulatory obligations and internal policies. We may also collect email traffic headers for analyzing patterns of network traffic and managing client relationships. For further information see our privacy-policy<https://www.iqvia.com/about-us/privacy/privacy-policy>. Thank you.

[MelaniePhilofsky]

It means you help move the issue through the Themis process. Currently, we have conventions on how to impute drug_exposure_end_date when it is not explicitly stated in the source. From this issue, it looks like you want to add additional guidance. Step #1 is to create a Themis issue, which is this. The next step is to create a new post on OHDSI forums for debate. The title should be “Expansion of the Themis drug exposure end date convention” or something along those lines. We want to make it easy for people to find. Please include the following in your post on the forums:

1. Use case: drug_exposure_end_date is a required field in the CDM
2. Issue summary:
3. Proposed solution: and more detail if you have information. From the linked forum post, it looks like this method would work for oral solid drugs, but there are other dose forms out there. So, be sure to be specific with your recommendation.
4. Ensure to link the newly created forum post to this Themis issue and vice versa
5. Reply to all previous forum posts and add “This issue is now being discussed here” and hyperlink the ‘here’ to the newly created forum post. We want all debate and discussion in one place.