: Record Table 938

Record Table 938

Title:	OMOP Visit Detail
Access field:	20142 (Present in OMOP dataset)

Table name

omop_visit_detail

Table group

OMOP

Debut

Feb 2023

Row count

2,000,000+

Parent table

n/a

Version

Sep 2024

Size

200MB

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_visit_detail table represents details of each record in the parent omop_visit_occurrence table. A good example of this would be the movement between units in a hospital during an inpatient stay.
Further details can be found in the OMOP CDM Clinical Data Tables specifications - https://ohdsi.github.io/CommonDataModel/cdm53.html#VISIT_DETAIL
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.

19 Columns

#	Column	Type	Notes
1	admitting_source_concept_id	integer
2	admitting_source_value	string	The source code for the admitting source as it appears in the source data.
3	care_site_id	integer	A foreign key to the care site in the care site table that was associated with the visit detail.
4	discharge_to_concept_id	integer
5	discharge_to_source_value	string	The source code for the discharge disposition as it appears in the source data.
6	eid	integer	A foreign key identifier to the Person for whom the visit detail is recorded.
7	preceding_visit_detail_id	integer
8	provider_id	integer	A foreign key to the provider in the provider table who was associated with the visit detail.
9	visit_detail_concept_id	integer
10	visit_detail_end_date	date	The end date of the visit detail.
11	visit_detail_end_datetime	timestamp	The date and time of the visit detail end.
12	visit_detail_id	integer	A system-generated unique identifier for each detail of a Person's visit or encounter at a healthcare provider.
13	visit_detail_parent_id	integer
14	visit_detail_source_concept_id	integer	A foreign key to a Concept that refers to the code used in the source.
15	visit_detail_source_value	integer	The source code for the visit detail as it appears in the source data.
16	visit_detail_start_date	integer	The start date of when the visit detail.
17	visit_detail_start_datetime	timestamp	The date and time of when the visit detail started.
18	visit_detail_type_concept_id	integer
19	visit_occurrence_id	integer

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
927	omop_device_exposure	OMOP Device Exposure
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
939	omop_visit_occurrence	OMOP Visit Occurrence

Enabling scientific discoveries that improve human health