This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
documentation:cdm:visit_occurrence [2017/01/08 18:31] cgreich |
documentation:cdm:visit_occurrence [2017/01/08 18:47] cgreich |
||
---|---|---|---|
Line 19: | Line 19: | ||
|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 38: | ||
* 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. |