User Tools

Site Tools


documentation:cdm:visit_occurrence

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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.
  
documentation/cdm/visit_occurrence.txt ยท Last modified: 2017/09/25 15:00 by clairblacketer