documentation:cdm:device_exposure
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:cdm:device_exposure [2015/01/02 13:55] cgreich |
documentation:cdm:device_exposure [2017/09/25 15:02] (current) clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== DEVICE_EXPOSURE table ===== | ===== DEVICE_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 device_exposure_start_datetime and device_exposure_end_datetime were added. | ||
| + | |||
| + | ----- | ||
| The device exposure domain captures information about a person’s exposure to a foreign physical object or instrument that which is used for diagnostic or therapeutic purposes through a mechanism beyond chemical action. Devices include implantable objects (e.g. pacemakers, stents, artificial joints), medical equipment and supplies (e.g. bandages, crutches, syringes), other instruments used in medical procedures (e.g. sutures, defibrillators) and material used in clinical care (e.g. adhesives, body material, dental material, surgical material). | The device exposure domain captures information about a person’s exposure to a foreign physical object or instrument that which is used for diagnostic or therapeutic purposes through a mechanism beyond chemical action. Devices include implantable objects (e.g. pacemakers, stents, artificial joints), medical equipment and supplies (e.g. bandages, crutches, syringes), other instruments used in medical procedures (e.g. sutures, defibrillators) and material used in clinical care (e.g. adhesives, body material, dental material, surgical material). | ||
| Line 8: | Line 13: | ||
| |device_concept_id|Yes|integer|A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Device concept.| | |device_concept_id|Yes|integer|A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Device concept.| | ||
| |device_exposure_start_date|Yes|date|The date the Device or supply was applied or used.| | |device_exposure_start_date|Yes|date|The date the Device or supply was applied or used.| | ||
| + | |device_exposure_start_datetime|No|datetime|The date and time the Device or supply was applied or used.| | ||
| |device_exposure_end_date|No|date|The date the Device or supply was removed from use.| | |device_exposure_end_date|No|date|The date the Device or supply was removed from use.| | ||
| + | |device_exposure_end_datetime|No|datetime|The date and time the Device or supply was removed from use.| | ||
| |device_type_concept_id|Yes|integer|A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Device Exposure recorded. It indicates how the Device Exposure was represented in the source data.| | |device_type_concept_id|Yes|integer|A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Device Exposure recorded. It indicates how the Device Exposure was represented in the source data.| | ||
| |unique_device_id |No|varchar(50)|A UDI or equivalent identifying the instance of the Device used in the Person.| | |unique_device_id |No|varchar(50)|A UDI or equivalent identifying the instance of the Device used in the Person.| | ||
documentation/cdm/device_exposure.1420206925.txt.gz · Last modified: 2015/01/02 13:55 by cgreich
Page Tools
