OMOP Common Data Model (CDM) Visit occurrence

Visit occurrence
Descrizione

Visit occurrence

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

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

Tipo di dati

integer

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

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.

Tipo di dati

integer

Alias
UMLS CUI [1]
C2348585
Visit concept ID
Descrizione

A foreign key that refers to a visit concept identifier in the Standardized Vocabularies.

Tipo di dati

integer

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

The start date of the visit.

Tipo di dati

date

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0011008
Visit start time
Descrizione

The time the visit started.

Tipo di dati

time

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0040223
Visit end date
Descrizione

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

Tipo di dati

date

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0011008
Visit end time
Descrizione

The time the visit ended.

Tipo di dati

time

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0040223
Visit type concept ID
Descrizione

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.

Tipo di dati

integer

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

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

Tipo di dati

integer

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

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

Tipo di dati

integer

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

The source code for the visit as it appears in the source data.

Tipo di dati

text

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

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

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638

Similar models

OMOP Common Data Model (CDM) Visit occurrence

Name
genere
Description | Question | Decode (Coded Value)
Tipo di dati
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
C1512346 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Visit start Time
Item
Visit start time
time
C1512346 (UMLS CUI [1,1])
C0040223 (UMLS CUI [1,2])
Visit end date
Item
Visit end date
date
C1512346 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Visit end time
Item
Visit end time
time
C1512346 (UMLS CUI [1,1])
C0040223 (UMLS CUI [1,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])