| Title: | OMOP Device Exposure |
| Access field: | 20142 (Present in OMOP dataset) |
| Table name | omop_device_exposure | Table group | OMOP | Debut | Feb 2023 | ||
| Row count | 1,000,000+ | Parent table | n/a | Version | Sep 2024 | ||
| Size | 206MB | Stability | Complete | Cost Tier | dX o2 s2 |
Record Table 927
WARNING: the interactive features of this website use CSS3, which your browser does not support. To use the full features of this website, please update your browser.
Notes
The omop_device_exposure table captures information about a person's exposure to a foreign physical object or instrument which is used for diagnostic or therapeutic purposes through a mechanism beyond chemical action.Further details can be found in the OMOP CDM Clinical Data Tables specifications - https://ohdsi.github.io/CommonDataModel/cdm53.html#DEVICE_EXPOSURE
15 Columns
| # | Column | Type | Notes |
|---|---|---|---|
| 1 | device_concept_id | integer | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Device concept. |
| 2 | device_exposure_end_date | date | The date the Device or supply was removed from use. |
| 3 | device_exposure_end_datetime | timestamp | The date and time the Device or supply was removed from use. |
| 4 | device_exposure_id | integer | A system-generated unique identifier for each Device Exposure. |
| 5 | device_exposure_start_date | date | The date the Device or supply was applied or used. |
| 6 | device_exposure_start_datetime | timestamp | The date and time the Device or supply was applied or used. |
| 7 | device_source_concept_id | integer | A foreign key to a Device Concept that refers to the code used in the source. |
| 8 | device_source_value | string | The source code for the Device as it appears in the source data. This code is mapped to a standard Device Concept in the Standardized Vocabularies and the original code is stored here for reference. |
| 9 | device_type_concept_id | 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. |
| 10 | eid | integer | A foreign key identifier to the Person who is subjected to the Device. |
| 11 | provider_id | integer | A foreign key to the provider in the PROVIDER table who initiated of administered the Device. |
| 12 | quantity | integer | The number of individual Devices used for the exposure. |
| 13 | unique_device_id | string | A UDI or equivalent identifying the instance of the Device used in the Person. |
| 14 | visit_detail_id | integer | |
| 15 | visit_occurrence_id | integer | A foreign key to the visit in the VISIT table during which the device was used. |
15 Related OMOP Record Tables
| Table ID | Table | Title |
|---|---|---|
| 924 | omop_condition_era | OMOP Condition Era |
| 925 | omop_condition_occurrence | OMOP Condition Occurrence |
| 926 | omop_death | OMOP Death |
| 928 | omop_dose_era | OMOP Dose Era |
| 929 | omop_drug_era | OMOP Drug Era |
| 930 | omop_drug_exposure | OMOP Drug Exposure |
| 931 | omop_measurement | OMOP Measurement |
| 932 | omop_note | OMOP Note |
| 933 | omop_observation | OMOP Observation Period |
| 934 | omop_observation_period | OMOP Observation |
| 935 | omop_person | OMOP Person |
| 936 | omop_procedure_occurrence | OMOP Procedure Occurrence |
| 937 | omop_specimen | OMOP Specimen |
| 938 | omop_visit_detail | OMOP Visit Detail |
| 939 | omop_visit_occurrence | OMOP Visit Occurrence |
Enabling scientific discoveries that improve human health