Table postgres.omop.visit_occurrence
[CLINICAL] The VISIT_OCCURRENCE table contains the spans of time a Person continuously receives medical services from one or more providers at a Care Site in a given setting within the health care system. Visits are classified into 4 settings: outpatient care, inpatient confinement, emergency room, and long-term care. Persons may transition between these settings over the course of an episode of care (for example, treatment of a disease onset).

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
visit_occurrence_id int4 10
condition_occurrence.visit_occurrence_id fpk_condition_visit R
device_exposure.visit_occurrence_id fpk_device_visit R
drug_exposure.visit_occurrence_id fpk_drug_visit R
measurement.visit_occurrence_id fpk_measurement_visit R
note.visit_occurrence_id fpk_note_visit R
observation.visit_occurrence_id fpk_observation_visit R
procedure_occurrence.visit_occurrence_id fpk_procedure_visit R
visit_detail.visit_occurrence_id fpk_visit_occurrence R
A unique identifier for each Person's visit or encounter at a healthcare provider.
person_id int4 10
person.person_id fpk_visit_person R
A foreign key identifier to the Person for whom the visit is recorded. The demographic details of that Person are stored in the PERSON table.
visit_concept_id int4 10
concept.concept_id fpk_visit_concept R
A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies.
visit_start_date date 13 The start date of the visit.
visit_start_datetime timestamp 29,6  √  null The date and time of the visit started.
visit_end_date date 13 The end date of the visit. If this is a one-day visit the end date should match the start date.
visit_end_datetime timestamp 29,6  √  null The date and time of the visit end.
visit_type_concept_id int4 10
concept.concept_id fpk_visit_type_concept R
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.
provider_id int4 10  √  null
provider.provider_id fpk_visit_provider R
A foreign key to the provider in the provider table who was associated with the visit.
care_site_id int4 10  √  null
care_site.care_site_id fpk_visit_care_site R
A foreign key to the care site in the care site table that was visited.
visit_source_value varchar 50  √  null The source code for the visit as it appears in the source data.
visit_source_concept_id int4 10  √  null
concept.concept_id fpk_visit_concept_s R
A foreign key to a Concept that refers to the code used in the source.
admitting_source_concept_id int4 10  √  null
concept.concept_id fpk_visit_admitting_s R
A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the admitting source for a visit.
admitting_source_value varchar 50  √  null The source code for the admitting source as it appears in the source data.
discharge_to_concept_id int4 10  √  null
concept.concept_id fpk_visit_discharge R
A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the discharge disposition for a visit.
discharge_to_source_value varchar 50  √  null The source code for the discharge disposition as it appears in the source data.
preceding_visit_occurrence_id int4 10  √  null A foreign key to the VISIT_OCCURRENCE table of the visit immediately preceding this visit

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:
Column(s) Type Sort Constraint Name
visit_occurrence_id Primary key Asc xpk_visit_occurrence
visit_concept_id Performance Asc idx_visit_concept_id
person_id Performance Asc idx_visit_person_id

Close relationships  within of separation: