ID

35325

Beschrijving

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

Trefwoorden

Versies (1)
  1. 28-02-19 28-02-19 -
Houder van rechten

Observational Medical Outcomes Partnership (OMOP)

Geüploaded op

28 februari 2019

DOI

Voor een aanvraag inloggen.

Licentie

Creative Commons BY-NC 3.0
Model Commentaren :

Hier kunt u commentaar leveren op het model. U kunt de tekstballonnen bij de itemgroepen en items gebruiken om er specifiek commentaar op te geven.

Terug naar het model Commentaren
Itemgroep Commentaren voor :

Item Commentaren voor :

U moet ingelogd zijn om formulieren te downloaden. AUB inloggen of schrijf u gratis in.

OMOP Common Data Model (CDM)

Engels

Visit detail

1 Formulieren  
  1. StudyEvent: ODM
    1. Visit detail
Visit detail
Beschrijving

Visit detail

Alias
UMLS CUI-1
C1512346
UMLS CUI-2
C1522508
Visit detail ID
Beschrijving

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

Datatype

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C1300638
Person ID
Beschrijving

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.

Datatype

integer

Alias
UMLS CUI [1]
C2348585
Visit detail concept ID
Beschrijving

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

Datatype

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
Beschrijving

The start date of the visit.

Datatype

date

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

The date and time of the visit started.

Datatype

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
Beschrijving

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

Datatype

date

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

The date and time of the visit ended.

Datatype

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
Beschrijving

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.

Datatype

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
Beschrijving

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

Datatype

integer

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

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

Datatype

integer

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

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

Datatype

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
Beschrijving

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

Datatype

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
Beschrijving

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

Datatype

text

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

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

Datatype

integer

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

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

Datatype

text

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

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

Datatype

integer

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

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

Datatype

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
Beschrijving

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

Datatype

integer

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

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.

Datatype

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Terug naar het begin van de pagina

Similar models

Visit detail

1 Formulieren
  1. StudyEvent: ODM
    1. Visit detail
Name
Type
Description | Question | Decode (Coded Value)
Datatype
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])
Terug naar het begin van de pagina 

Contact

Gebruik dit formulier voor feedback, vragen en verbeteringsvoorstellen.

Velden gemarkeerd met een * zijn verplicht.

Help

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