| 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 |
Record Table 938
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
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