ID

35325

Description

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

Lien

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

Mots-clés

Versions (1)
  1. 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.

Retour au modèle Commentaires
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)

Anglais

Visit detail

1 Formulaires  
  1. StudyEvent: ODM
    1. Visit detail
Visit detail
Description

Visit detail

Alias
UMLS CUI-1
C1512346
UMLS CUI-2
C1522508
Visit detail 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]
C1522508
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 detail 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]
C1522508
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Visit detail 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
UMLS CUI [1,3]
C1522508
Visit detail start Datetime
Description

The date and time of the visit started.

Type de données

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
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
UMLS CUI [1,3]
C1522508
Visit detail 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 [1,3]
C1522508
UMLS CUI [2,1]
C1522314
UMLS CUI [2,2]
C0545082
UMLS CUI [2,3]
C1522508
Visit detail 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]
C1522508
UMLS CUI [1,3]
C0332307
UMLS CUI [1,4]
C0178566
UMLS CUI [1,5]
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 detail source value
Description

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

Type de données

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
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]
C1522508
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0178566
UMLS CUI [1,5]
C1300638
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
Admitted from concept ID
Description

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

Type de données

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
UMLS CUI [1,3]
C0030673
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
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
Preceding visit detail ID
Description

A foreign key to the VISIT_DETAIL 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]
C1522508
UMLS CUI [1,4]
C1300638
Visit detail parent ID
Description

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

Type de données

integer

Alias
UMLS CUI [1,1]
C0545082
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C1300638
Visit occurence ID
Description

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.

Type de données

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Retour au début de la page

Similar models

Visit detail

1 Formulaires
  1. StudyEvent: ODM
    1. Visit detail
Name
Type
Description | Question | Decode (Coded Value)
Type de données
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])
Retour au début de la page 

Contact

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

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

Aide

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