This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:cdm:visit_occurrence [2017/01/08 18:31] cgreich |
documentation:cdm:visit_occurrence [2017/09/25 15:00] (current) clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== VISIT_OCCURRENCE table ===== | ===== VISIT_OCCURRENCE table ===== | ||
+ | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** | ||
- | This table changed version 5.X of the OMOP CDM. The fields admitting_source_concept_id, discharge_to_concept_id, admitting_source_value and discharge_to_source_value were added. | + | This table changed version 5.1 of the OMOP CDM. The fields visit_start_datetime and visit_end_datetime were added. For 5.0.1, the fields admitting_source_concept_id, discharge_to_concept_id, admitting_source_value and discharge_to_source_value were added. |
---- | ---- | ||
Line 19: | Line 20: | ||
|admitting_source_concept_id|No|integer|A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the admitting source for a visit.| | |admitting_source_concept_id|No|integer|A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the admitting source for a visit.| | ||
|discharge_to_concept_id|No|integer|A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the discharge disposition (destination) for a visit.| | |discharge_to_concept_id|No|integer|A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the discharge disposition (destination) for a visit.| | ||
+ | |preceding_visit_occurrence_id|No|integer|A foreign key to the VISIT_OCCURRENCE table record of the visit immediately preceding this visit.| | ||
|visit_source_value|No|string(50)|The source code for the visit as it appears in the source data.| | |visit_source_value|No|string(50)|The source code for the visit as it appears in the source data.| | ||
|visit_source_concept_id|No|Integer|A foreign key to a Concept that refers to the code used in the source.| | |visit_source_concept_id|No|Integer|A foreign key to a Concept that refers to the code used in the source.| | ||
Line 37: | Line 39: | ||
* Medical Claims include Inpatient Admissions, Outpatient Services, and Emergency Room visits. | * Medical Claims include Inpatient Admissions, Outpatient Services, and Emergency Room visits. | ||
* Electronic Health Records may capture Person visits as part of the activities recorded depending wether the EHR system is used at the different Care Sites. | * Electronic Health Records may capture Person visits as part of the activities recorded depending wether the EHR system is used at the different Care Sites. | ||
- | * If applicable, the sequential relationships between Visits within an episode of care may be represented in the FACT_RELATIONSHIP table. | + | * Sequential relationships between Visits within an episode of care are represented through chaining them in the preceding_visit_occurrence_id. |