This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:next_cdm:days_supply [2016/02/25 12:04] cgreich |
documentation:next_cdm:days_supply [2017/07/06 19:18] (current) clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Remove days_supply field ===== | + | ===== End of a drug exposure ===== |
| + | === Proposals are now tracked as github issues === | ||
| + | [[https://github.com/OHDSI/CommonDataModel/issues/71|link to issue in github]] | ||
| * Requester: Klaus Bonadt, Christian Reich, Patrick Ryan | * Requester: Klaus Bonadt, Christian Reich, Patrick Ryan | ||
| Line 6: | Line 8: | ||
| ---- | ---- | ||
| ==== Proposal ==== | ==== Proposal ==== | ||
| - | If the days_supply and the drug_exposure_end_date fields essentially designate the same thing they are therefore duplicates of the same information and create the danger of of inconsistency. One of them could be dropped. | + | Relevant table: http://www.ohdsi.org/web/wiki/doku.php?id=documentation:cdm:drug_exposure |
| - | + | ||
| - | Alternatively, we could split them into two different meanings: | + | |
| ^Field^Required^Type^Description^ | ^Field^Required^Type^Description^ | ||
| - | |drug_exposure_end_date|No|date|The end date for the current instance of Drug utilization. It is not available from all sources.| | + | |drug_exposure_end_date|Yes|date|The end date for the current instance of Drug utilization. Depending on different sources, it could be a known or an inferred date and denotes the last day at which the patient was still exposed to drug.| |
| - | |days_supply|No|integer|The number of days of supply of the medication as recorded in the original prescription or dispensing record.| | + | |days_supply|No|integer|The number of days of supply of the medication as prescribed. This reflects the intention of the provider for the length of exposure.| |
| + | |verbatim_end_date|No|date|The known end date of a drug exposure as provided by the source.| | ||
| + | |||
| + | The verbatim_end_dat field is only necessary as the drug_exposure_end_date becomes mandatory, and might be (wrongly) inferred. In cases where no good data are available to fill that end_date, the ETL will have to take a guess, and that may not satisfy some algorithms for dose calculation. | ||
| + | |||
| + | == Conventions == | ||
| + | |||
| + | * The drug_exposure_end_date denotes the day the drug exposure ended for the patient. This could be that the duration of drug_supply was reached (in which case drug_exposure_end_date = drug_exposure_start_date + days_supply -1), or because the exposure was stopped (medication changed, medication discontinued, etc.) | ||