documentation:cdm:drug_exposure
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
documentation:cdm:drug_exposure [2014/12/06 17:02] cgreich [DRUG_EXPOSURE Table] |
documentation:cdm:drug_exposure [2017/09/25 15:01] clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== DRUG_EXPOSURE table ===== | ===== DRUG_EXPOSURE table ===== | ||
| + | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** | ||
| + | |||
| + | This table changed in version 5.1 of the OMOP CDM. The fields drug_exposure_start_datetime and drug_exposure_end_datetime were added. | ||
| + | |||
| + | ----- | ||
| The drug exposure domain captures records about the utilization of a Drug when ingested or otherwise introduced into the body. A Drug is a biochemical substance formulated in such a way that when administered to a Person it will exert a certain physiological effect. Drugs include prescription and over-the-counter medicines, vaccines, and large-molecule biologic therapies. Radiological devices ingested or applied locally do not count as Drugs. | The drug exposure domain captures records about the utilization of a Drug when ingested or otherwise introduced into the body. A Drug is a biochemical substance formulated in such a way that when administered to a Person it will exert a certain physiological effect. Drugs include prescription and over-the-counter medicines, vaccines, and large-molecule biologic therapies. Radiological devices ingested or applied locally do not count as Drugs. | ||
| Line 14: | Line 19: | ||
| |drug_concept_id|Yes|integer|A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Drug concept.| | |drug_concept_id|Yes|integer|A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Drug concept.| | ||
| |drug_exposure_start_date|Yes|date|The start date for the current instance of Drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a Drug administration procedure was recorded.| | |drug_exposure_start_date|Yes|date|The start date for the current instance of Drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a Drug administration procedure was recorded.| | ||
| + | |drug_exposure_start_datetime|No|datetime|The start date and time for the current instance of Drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a Drug administration procedure was recorded.| | ||
| |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|No|date|The end date for the current instance of Drug utilization. It is not available from all sources.| | ||
| + | |drug_exposure_end_datetime|No|datetime|The end date and time for the current instance of Drug utilization. It is not available from all sources.| | ||
| |drug_type_concept_id|Yes|integer| A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Drug Exposure recorded. It indicates how the Drug Exposure was represented in the source data.| | |drug_type_concept_id|Yes|integer| A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Drug Exposure recorded. It indicates how the Drug Exposure was represented in the source data.| | ||
| |stop_reason|No|varchar(20)|The reason the Drug was stopped. Reasons include regimen completed, changed, removed, etc.| | |stop_reason|No|varchar(20)|The reason the Drug was stopped. Reasons include regimen completed, changed, removed, etc.| | ||
| Line 44: | Line 51: | ||
| * If possible, the visit in which the drug was prescribed or delivered is recorded in the visit_occurrence_id field through a reference to the visit table. | * If possible, the visit in which the drug was prescribed or delivered is recorded in the visit_occurrence_id field through a reference to the visit table. | ||
| * If possible, the prescribing or administering provider (physician or nurse) is recorded in the provider_id field through a reference to the provider table. | * If possible, the prescribing or administering provider (physician or nurse) is recorded in the provider_id field through a reference to the provider table. | ||
| - | |||
documentation/cdm/drug_exposure.txt ยท Last modified: 2019/10/10 11:10 by dimshitc1
Page Tools
