ID

35320

Beskrivning

OMOP Common Data Model (CDM) Visit occurrence 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). OMOP Common Data Model Version 6.0 Specifications 11October2018. The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics. Version updated on 28.02.2019, from https://github.com/OHDSI/CommonDataModel/wiki/VISIT_OCCURENCE A Visit Occurrence is recorded for each visit to a healthcare facility. Valid Visit Concepts belong to the 'Visit' domain. Standard Visit Concepts are defined, among others, as Inpatient Visit, Outpatient Visit, Emergency Room Visit, Long Term Care Visit and combined ER and Inpatient Visit. The latter is necessary because it is close to impossible to separate the two in many EHR system, treating them interchangeably. To annotate this correctly, the visit concept 'Emergency Room and Inpatient Visit' should be used. Handling of death: In the case when a patient died during admission, a record in the Observation table should be created. Source Concepts from place of service vocabularies are mapped into these standard visit Concepts in the Standardized Vocabularies. At any one day, there could be more than one visit. One visit may involve multiple providers, in which case the ETL must specify how a single PROVIDER_ID is selected or leave the PROVIDER_ID field null. One visit may involve multiple Care Sites, in which case the ETL must specify how a single CARE_SITE_ID is selected or leave the CARE_SITE_ID field null. Visits are recorded in various data sources in different forms with varying levels of standardization. For example: 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 whether the EHR system is used at the different Care Sites./li> For concepts, that could be used in addition to the 'Place of Service' vocabulary, please see https://github.com/OHDSI/CommonDataModel/wiki/VISIT_OCCURRENCE. PRECEDING_VISIT_ID can be used to link a visit immediately preceding the current visit. Visit end dates are mandatory. If end dates are not provided in the source there are three ways in which to derive them: Outpatient Visit: VISIT_END_DATE = VISIT_START_DATE, Emergency Room Visit: VISIT_END_DATE = VISIT_START_DATE, Inpatient Visit: Usually there is information about discharge. If not, you should be able to derive the end date from the sudden decline of activity or from the absence of inpatient procedures/drugs. Long Term Care Visits: Particularly for claims data, if end dates are not provided assume the visit is for the duration of month that it occurs. For inpatient visits ongoing at the date of ETL, put date of processing the data as mandatory VISIT_END_DATE and VISIT_TYPE_CONCEPT_ID with "Still patient" to identify the visit as incomplete. For more information, please see https://github.com/OHDSI/CommonDataModel/wiki/VISIT_OCCURRENCE

Länk

https://github.com/OHDSI/CommonDataModel/wiki/VISIT_OCCURENCE

Nyckelord

  1. 2017-01-04 2017-01-04 -
  2. 2019-02-07 2019-02-07 -
  3. 2019-02-28 2019-02-28 -
Rättsinnehavare

Observational Medical Outcomes Partnership (OMOP)

Uppladdad den

28 februari 2019

DOI

För en begäran logga in.

Licens

Creative Commons BY-NC 3.0

Modellkommentarer :

Här kan du kommentera modellen. Med hjälp av pratbubblor i Item-grupperna och Item kan du lägga in specifika kommentarer.

Itemgroup-kommentar för :

Item-kommentar för :

Du måste vara inloggad för att kunna ladda ner formulär. Var vänlig logga in eller registrera dig utan kostnad.

OMOP Common Data Model (CDM) Visit occurrence

OMOP Common Data Model (CDM) Visit occurrence

Visit occurrence
Beskrivning

Visit occurrence

Alias
UMLS CUI-1
C1512346
UMLS CUI-2
C2745955
Visit occurrence ID
Beskrivning

A unique identifier for each person's visit or encounter at a healthcare provider.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Person ID
Beskrivning

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.

Datatyp

integer

Alias
UMLS CUI [1]
C2348585
Visit concept ID
Beskrivning

A foreign key that refers to a visit concept identifier in the Standardized Vocabularies belonging to the 'Visit' Vocabulary.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Visit start date
Beskrivning

The start date of the visit.

Datatyp

date

Alias
UMLS CUI [1,1]
C0808070
UMLS CUI [1,2]
C0545082
Visit start Datetime
Beskrivning

The date and time the visit started.

Datatyp

datetime

Alias
UMLS CUI [1,1]
C0808070
UMLS CUI [1,2]
C0545082
UMLS CUI [2,1]
C1301880
UMLS CUI [2,2]
C0545082
Visit end date
Beskrivning

The end date of the visit. If this is a one-day visit the end date should match the start date.

Datatyp

date

Alias
UMLS CUI [1,1]
C0806020
UMLS CUI [1,2]
C0545082
Visit end datetime
Beskrivning

The date and time of the visit ended.

Datatyp

datetime

Alias
UMLS CUI [1,1]
C0806020
UMLS CUI [1,2]
C0545082
UMLS CUI [2,1]
C1522314
UMLS CUI [2,2]
C0545082
Visit type concept ID
Beskrivning

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 belonging to the 'Visit Type' vocabulary.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Provider ID
Beskrivning

A foreign key to the provider in the provider table who was associated with the visit.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Care site ID
Beskrivning

A foreign key to the care site in the care site table that was visited.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0337950
UMLS CUI [1,2]
C1300638
Visit source value
Beskrivning

The source code for the visit as it appears in the source data. (Type varchar(50))

Datatyp

text

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609
Visit source concept ID
Beskrivning

A foreign key to a concept that refers to the code used in the source.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Admitted from concept ID
Beskrivning

A foreign key to the predefined concept in the Place of Service Vocabulary reflecting where the patient was admitted from.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
UMLS CUI [1,3]
C0030673
Admitted from source value
Beskrivning

The source code for where the patient was admitted from as it appears in the source data. (Type varchar(50))

Datatyp

text

Alias
UMLS CUI [1,1]
C0805701
UMLS CUI [1,2]
C0600091
UMLS CUI [1,3]
C0030673
Discharge to concept ID
Beskrivning

A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the discharge disposition for a visit.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
UMLS CUI [1,3]
C1550390
Discharge to source value
Beskrivning

The source code for the discharge disposition as it appears in the source data. (Type varchar(50))

Datatyp

text

Alias
UMLS CUI [1,1]
C0805701
UMLS CUI [1,2]
C0600091
UMLS CUI [1,3]
C1550390
Preceding visit occurence ID
Beskrivning

A foreign key to the VISIT_OCCURRENCE table of the visit immediately preceding this visit.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0205156
UMLS CUI [1,3]
C0920316
UMLS CUI [1,4]
C1300638

Similar models

OMOP Common Data Model (CDM) Visit occurrence

Name
Typ
Description | Question | Decode (Coded Value)
Datatyp
Alias
Item Group
Visit occurrence
C1512346 (UMLS CUI-1)
C2745955 (UMLS CUI-2)
Visit occurrence ID
Item
Visit occurrence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Visit concept ID
Item
Visit concept ID
integer
C1512346 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Visit start date
Item
Visit start date
date
C0808070 (UMLS CUI [1,1])
C0545082 (UMLS CUI [1,2])
Visit start Datetime
Item
Visit start Datetime
datetime
C0808070 (UMLS CUI [1,1])
C0545082 (UMLS CUI [1,2])
C1301880 (UMLS CUI [2,1])
C0545082 (UMLS CUI [2,2])
Visit end date
Item
Visit end date
date
C0806020 (UMLS CUI [1,1])
C0545082 (UMLS CUI [1,2])
Visit end datetime
Item
Visit end datetime
datetime
C0806020 (UMLS CUI [1,1])
C0545082 (UMLS CUI [1,2])
C1522314 (UMLS CUI [2,1])
C0545082 (UMLS CUI [2,2])
Visit type concept ID
Item
Visit type concept ID
integer
C1512346 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Provider ID
Item
Provider ID
integer
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Care site ID
Item
Care site ID
integer
C0337950 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Visit source value
Item
Visit source value
text
C1512346 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])
Visit source concept ID
Item
Visit source concept ID
integer
C1512346 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Admitted from concept ID
Item
Admitted from concept ID
integer
C0178566 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
C0030673 (UMLS CUI [1,3])
Admitted from source value
Item
Admitted from source value
text
C0805701 (UMLS CUI [1,1])
C0600091 (UMLS CUI [1,2])
C0030673 (UMLS CUI [1,3])
Discharge to concept ID
Item
Discharge to concept ID
integer
C0178566 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
C1550390 (UMLS CUI [1,3])
Discharge to source value
Item
Discharge to source value
text
C0805701 (UMLS CUI [1,1])
C0600091 (UMLS CUI [1,2])
C1550390 (UMLS CUI [1,3])
Preceding visit occurence ID
Item
Preceding visit occurence ID
integer
C1512346 (UMLS CUI [1,1])
C0205156 (UMLS CUI [1,2])
C0920316 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])

Använd detta formulär för feedback, frågor och förslag på förbättringar.

Fält markerade med * är obligatoriska.

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial