ID

35320

Description

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

Lien

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

Mots-clés

  1. 04/01/2017 04/01/2017 -
  2. 07/02/2019 07/02/2019 -
  3. 28/02/2019 28/02/2019 -
Détendeur de droits

Observational Medical Outcomes Partnership (OMOP)

Téléchargé le

28 février 2019

DOI

Pour une demande vous connecter.

Licence

Creative Commons BY-NC 3.0

Modèle Commentaires :

Ici, vous pouvez faire des commentaires sur le modèle. À partir des bulles de texte, vous pouvez laisser des commentaires spécifiques sur les groupes Item et les Item.

Groupe Item commentaires pour :

Item commentaires pour :

Vous devez être connecté pour pouvoir télécharger des formulaires. Veuillez vous connecter ou s’inscrire gratuitement.

OMOP Common Data Model (CDM) Visit occurrence

OMOP Common Data Model (CDM) Visit occurrence

Visit occurrence
Description

Visit occurrence

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

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

Type de données

integer

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

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.

Type de données

integer

Alias
UMLS CUI [1]
C2348585
Visit concept ID
Description

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

Type de données

integer

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

The start date of the visit.

Type de données

date

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

The date and time the visit started.

Type de données

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
Description

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

Type de données

date

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

The date and time of the visit ended.

Type de données

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
Description

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.

Type de données

integer

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

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

Type de données

integer

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

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

Type de données

integer

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

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

Type de données

text

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

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

Type de données

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
Description

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

Type de données

integer

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

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

Type de données

text

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

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

Type de données

integer

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

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

Type de données

text

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

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

Type de données

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
Type
Description | Question | Decode (Coded Value)
Type de données
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])

Utilisez ce formulaire pour les retours, les questions et les améliorations suggérées.

Les champs marqués d’un * sont obligatoires.

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