: Record Table 927

Record Table 927

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

This item is regarded as restricted and will be supplied to researchers only when absolutely necessary.

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
Due to some data quality issues identified by research groups who have been using the returned OMOP derivation dataset, the record-level tables are now restricted. Please see Field 20142 for more information.

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