Englisch

Visit detail

1 Formulare  
  1. StudyEvent: ODM
    1. Visit detail
Visit detail
Beschreibung

Visit detail

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

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

Datentyp

integer

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

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.

Datentyp

integer

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

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

Datentyp

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
Beschreibung

The start date of the visit.

Datentyp

date

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

The date and time of the visit started.

Datentyp

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
Beschreibung

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

Datentyp

date

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

The date and time of the visit ended.

Datentyp

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
Beschreibung

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.

Datentyp

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
Beschreibung

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

Datentyp

integer

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

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

Datentyp

integer

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

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

Datentyp

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
Beschreibung

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

Datentyp

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
Beschreibung

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

Datentyp

text

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

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

Datentyp

integer

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

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

Datentyp

text

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

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

Datentyp

integer

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

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

Datentyp

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
Beschreibung

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

Datentyp

integer

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

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.

Datentyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Zum Seitenanfang zurückkehren

Ähnliche Modelle

Visit detail

1 Formulare
  1. StudyEvent: ODM
    1. Visit detail
Name
Typ
Description | Question | Decode (Coded Value)
Datentyp
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])
Zum Seitenanfang zurückkehren