| # | Column | Type | Notes |
|---|
| 1 | admitting_source_concept_id | integer | A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the admitting source for a visit. |
| 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 visited. |
| 4 | discharge_to_concept_id | integer | A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the discharge disposition (destination) for a visit. |
| 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 is recorded. |
| 7 | preceding_visit_occurrence_id | integer | A foreign key to the VISIT_OCCURRENCE table record of the visit immediately preceding this visit. |
| 8 | provider_id | integer | A foreign key to the provider in the provider table who was associated with the visit. |
| 9 | visit_concept_id | integer | A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies. |
| 10 | visit_end_date | date | The end date of the visit. If this is a one-day visit the end date should match the start date. |
| 11 | visit_end_datetime | timestamp | The date and time of the visit end. |
| 12 | visit_occurrence_id | integer | A unique identifier for each Person's visit or encounter at a healthcare provider. |
| 13 | visit_source_concept_id | integer | A foreign key to a Concept that refers to the code used in the source. |
| 14 | visit_source_value | integer | The source code for the visit as it appears in the source data. |
| 15 | visit_start_date | date | The start date of the visit. |
| 16 | visit_start_datetime | timestamp | The date and time of the visit started. |
| 17 | visit_type_concept_id | integer | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the visit record is derived. |
