ID

35325

Descripción

OMOP Common Data Model (CDM) Visit detail The VISIT_DETAIL table is an optional table used to represents details of each record in the parent visit_occurrence table. For every record in visit_occurrence table there may be 0 or more records in the visit_detail table with a 1:n relationship where n may be 0. The visit_detail table is structurally very similar to visit_occurrence table and belongs to the similar domain as the visit. 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_DETAIL All conventions used in VISIT_OCCURRENCE apply to VISIT_DETAIL, with some notable exceptions as detailed below: A Visit Detail is an optional detail record for each Visit Occurrence to a healthcare facility. For every record in VISIT_DETAIL there has to be a parent VISIT_OCCURRENCE record. One record in VISIT_DETAIL can only have one VISIT_OCCURRENCE parent. A single VISIT_OCCURRENCE record may have many child VISIT_DETAIL records. Valid Visit Concepts belong to the 'Visit' domain. Standard Visit Concepts are yet to be defined, but will represent a detail of the Standard Visit Concept in VISIT_OCCURRENCE. 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. On any one day, there could be more than one visit. VISIT_OCCURRENCE allows for more than one visit within a single day. VISIT_DETAIL is to be used to only capture details within the visit. One visit may involve multiple Providers, in which case, in VISIT_OCCURRENCE, the ETL must specify how a single PROVIDER_ID is selected or leave the PROVIDER_ID field null. VISIT_DETAIL allows for the ETL to specify multiple child records per VISIT_OCCURRENCE - and each of these child records may represent different PROVIDER_IDs. One visit may involve multiple Care Sites, in which case, in VISIT_OCCURRENCE, the ETL must specify how a single CARE_SITE_ID is selected or leave the CARE_SITE_ID field null. VISIT_DETAIL allows for the ETL to specify multiple child records per visit occurrence - and each of these child records may represent different CARE_SITEs. Just like in VISIT_OCCURRENCE, records in VISIT_DETAIL may be sequentially related to each. These sequential relations are represented using PRECEDING_VISIT_DETAIL_ID. Unlike VISIT_OCCURRENCE, VISIT_DETAIL may have nested visits with hierarchical relationships to each other. These relationships are represented using VISIT_DETAIL_PARENT_ID. In US claims data Header/summary data that summarizes the entire claim and Line/detail that details a claim, detail is thus a child of the summary, and for every record in summary there is one or more records in detail. i.e. there will be at least one foreign key link from VISIT_DETAIL to VISIT_OCCURRENCE. For more information, see https://github.com/OHDSI/CommonDataModel/wiki/VISIT_DETAIL

Link

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

Palabras clave

Versiones (1)
  1. 28/2/19 28/2/19 -
Titular de derechos de autor

Observational Medical Outcomes Partnership (OMOP)

Subido en

28 de febrero de 2019

DOI

Para solicitar uno, por favor iniciar sesión.

Licencia

Creative Commons BY-NC 3.0
Comentarios del modelo :

Puede comentar sobre el modelo de datos aquí. A través de las burbujas de diálogo en los grupos de elementos y elementos, puede agregar comentarios específicos.

Volver a los comentarios del modelo
Comentarios de grupo de elementos para :

Comentarios del elemento para :

Para descargar modelos de datos, debe haber iniciado sesión. Por favor iniciar sesión o Registrate gratis.

OMOP Common Data Model (CDM)

Inglés

Visit detail

1 formularios  
  1. StudyEvent: ODM
    1. Visit detail
Visit detail
Descripción

Visit detail

Alias
UMLS CUI-1
C1512346
UMLS CUI-2
C1522508
Visit detail ID
Descripción

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

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C1300638
Person ID
Descripción

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 de datos

integer

Alias
UMLS CUI [1]
C2348585
Visit detail concept ID
Descripción

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

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Visit detail start date
Descripción

The start date of the visit.

Tipo de datos

date

Alias
UMLS CUI [1,1]
C0808070
UMLS CUI [1,2]
C0545082
UMLS CUI [1,3]
C1522508
Visit detail start Datetime
Descripción

The date and time of the visit started.

Tipo de datos

datetime

Alias
UMLS CUI [1,1]
C0808070
UMLS CUI [1,2]
C0545082
UMLS CUI [1,3]
C1522508
UMLS CUI [2,1]
C1301880
UMLS CUI [2,2]
C0545082
UMLS CUI [2,3]
C1522508
Visit detail end date
Descripción

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

Tipo de datos

date

Alias
UMLS CUI [1,1]
C0806020
UMLS CUI [1,2]
C0545082
UMLS CUI [1,3]
C1522508
Visit detail end datetime
Descripción

The date and time of the visit ended.

Tipo de datos

datetime

Alias
UMLS CUI [1,1]
C0806020
UMLS CUI [1,2]
C0545082
UMLS CUI [1,3]
C1522508
UMLS CUI [2,1]
C1522314
UMLS CUI [2,2]
C0545082
UMLS CUI [2,3]
C1522508
Visit detail type concept ID
Descripción

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.

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C0332307
UMLS CUI [1,4]
C0178566
UMLS CUI [1,5]
C1300638
Provider ID
Descripción

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

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Care site ID
Descripción

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

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C0337950
UMLS CUI [1,2]
C1300638
Visit detail source value
Descripción

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

Tipo de datos

text

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C1522609
Visit detail source concept ID
Descripción

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

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0178566
UMLS CUI [1,5]
C1300638
Admitted from source value
Descripción

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

Tipo de datos

text

Alias
UMLS CUI [1,1]
C0805701
UMLS CUI [1,2]
C0600091
UMLS CUI [1,3]
C0030673
Admitted from concept ID
Descripción

A foreign key to the predefined concept in the 'Place of Service' Vocabulary reflecting the admitting source for a visit.

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
UMLS CUI [1,3]
C0030673
Discharge to source value
Descripción

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

Tipo de datos

text

Alias
UMLS CUI [1,1]
C0805701
UMLS CUI [1,2]
C0600091
UMLS CUI [1,3]
C1550390
Discharge to concept ID
Descripción

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

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
UMLS CUI [1,3]
C1550390
Preceding visit detail ID
Descripción

A foreign key to the VISIT_DETAIL table of the visit immediately preceding this visit

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0205156
UMLS CUI [1,3]
C1522508
UMLS CUI [1,4]
C1300638
Visit detail parent ID
Descripción

A foreign key to the VISIT_DETAIL table record to represent the immediate parent visit-detail record.

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C0545082
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C1300638
Visit occurence ID
Descripción

A foreign key that refers to the record in the VISIT_OCCURRENCE table. This is a required field, because for every visit_detail is a child of visit_occurrence and cannot exist without a corresponding parent record in visit_occurrence.

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Volver a la parte superior de la página

Similar models

Visit detail

1 formularios
  1. StudyEvent: ODM
    1. Visit detail
Name
Tipo
Description | Question | Decode (Coded Value)
Tipo de datos
Alias
Item Group
Visit detail
C1512346 (UMLS CUI-1)
C1522508 (UMLS CUI-2)
Visit detail ID
Item
Visit detail ID
integer
C1512346 (UMLS CUI [1,1])
C1522508 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Visit detail concept ID
Item
Visit detail concept ID
integer
C1512346 (UMLS CUI [1,1])
C1522508 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Visit detail start date
Item
Visit detail start date
date
C0808070 (UMLS CUI [1,1])
C0545082 (UMLS CUI [1,2])
C1522508 (UMLS CUI [1,3])
Visit detail start Datetime
Item
Visit detail start Datetime
datetime
C0808070 (UMLS CUI [1,1])
C0545082 (UMLS CUI [1,2])
C1522508 (UMLS CUI [1,3])
C1301880 (UMLS CUI [2,1])
C0545082 (UMLS CUI [2,2])
C1522508 (UMLS CUI [2,3])
Visit detail end date
Item
Visit detail end date
date
C0806020 (UMLS CUI [1,1])
C0545082 (UMLS CUI [1,2])
C1522508 (UMLS CUI [1,3])
Visit detail end datetime
Item
Visit detail end datetime
datetime
C0806020 (UMLS CUI [1,1])
C0545082 (UMLS CUI [1,2])
C1522508 (UMLS CUI [1,3])
C1522314 (UMLS CUI [2,1])
C0545082 (UMLS CUI [2,2])
C1522508 (UMLS CUI [2,3])
Visit detail type concept ID
Item
Visit detail type concept ID
integer
C1512346 (UMLS CUI [1,1])
C1522508 (UMLS CUI [1,2])
C0332307 (UMLS CUI [1,3])
C0178566 (UMLS CUI [1,4])
C1300638 (UMLS CUI [1,5])
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 detail source value
Item
Visit detail source value
text
C1512346 (UMLS CUI [1,1])
C1522508 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C1522609 (UMLS CUI [1,4])
Visit detail source concept ID
Item
Visit detail source concept ID
integer
C1512346 (UMLS CUI [1,1])
C1522508 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C0178566 (UMLS CUI [1,4])
C1300638 (UMLS CUI [1,5])
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])
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])
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])
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])
Preceding visit detail ID
Item
Preceding visit detail ID
integer
C1512346 (UMLS CUI [1,1])
C0205156 (UMLS CUI [1,2])
C1522508 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Visit detail parent ID
Item
Visit detail parent ID
integer
C0545082 (UMLS CUI [1,1])
C1522508 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Visit occurence ID
Item
Visit occurence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Volver a la parte superior de la página 

Contacto

Utilice este formulario para comentarios, preguntas y sugerencias.

Los campos marcados con * son obligatorios.

Ayuda

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