This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
documentation:cdm:device_exposure [2014/12/04 09:32] cgreich |
documentation:cdm:device_exposure [2017/01/02 23:51] cukarthik |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== DEVICE_EXPOSURE table ===== | ===== DEVICE_EXPOSURE table ===== | ||
- | 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), durable medical equipment and supplies (e.g. bandages, crutches, syringes), and other instruments used in medical procedures (e.g. sutures, defibrillators). | + | 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). |
^Field^Required^Type^Description^ | ^Field^Required^Type^Description^ | ||
Line 8: | Line 8: | ||
|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.| |