search

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
28 stars 9 forks source link

How to determine drug_exposure_end_date when it is not given explicitly in the data #86

Open clairblacketer opened 8 months ago

clairblacketer commented 8 months ago

How to determine drug_exposure_end_date when it is not given explicitly in the data

CDM or THEMIS convention?

Summary of issues

Summary of answer

Related links

clairblacketer commented 7 months ago

ok this one looks good

clairblacketer commented 7 months ago

Issue # and location

Issue summary

The drug_exposure_end_date is a required field. How do you determine drug_exposure_end_date when it is not given explicitly in the data?

Convention type

Table

CDM table

Drug Exposure

CDM field

drug_exposure_end_date

Links to issue discussion

Provenance of data

All data

The ratified convention

If the drug end date or stop date is not explicitly available in the data, infer the end date using the following methods:

  1. Start first with duration or days supply using the calculation drug start date + days supply -1 day.
  2. Use quantity divided by daily dose that you may obtain from the sig or a source field (or assumed daily dose of 1) for solid, indivisibile, drug products. If quantity represents ingredient amount, quantity divided by daily dose * concentration (from drug_strength) drug concept id tells you the dose form.
  3. If it is an administration record, set drug end date equal to drug start date.
  4. If the record is a written prescription then set end date to start date + 29.
  5. If the record is a mail-order prescription set end date to start date + 89.

Note: The end date must be equal to or greater than the start date. Ibuprofen 20mg/mL oral solution concept tells us this is oral solution. Calculate duration as quantity (200 example) daily dose (5mL) /concentration (20mg/mL) 2005/20 = 50 days.

Date of ratification/published

Downstream implications

No, this is a current convention. And Atlas, the Dose Era table, and the Drug Era table rely on this field being populated to determine Era's in the Drug Era and Dose Era tables. And Atlas relies on this field being populated to determine the period of time a person was exposed to a drug.

Link to DQD check

Yes - isRequired.

Related conventions/further information

#Tags
Drug Exposure, drug end date, drug stop date

katy-sadowski commented 6 months ago

@clairblacketer i moved this one to "Done" - it was the demo page you added first, I think!

cgreich commented 6 months ago

I like the text, but I think it should say that this is an order of precedence. Now, it sounds like you should do all steps 1-5. Instead of "... infer the end date using the following methods:" I would say ".. infer the end date by using one of the methods below. Try them in the following order:"

Plus, I would make steps 3, 4 and 5 one step. Essentially saying "If you don't have any substantive information to determine, use the following defaults."