OMOP Common Data Model (CDM) Note

Note
Beschreibung

Note

Alias
UMLS CUI-1
C1317574
UMLS CUI-2
C0947611
Note ID
Beschreibung

A unique identifier for each note.

Datentyp

integer

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C1300638
Person ID
Beschreibung

A foreign key identifier to the person about whom the note was recorded. The demographic details of that person are stored in the person table.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0027361
UMLS CUI [1,2]
C1300638
Note date
Beschreibung

The date the note was recorded.

Datentyp

date

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0011008
Note time
Beschreibung

The time the note was recorded.

Datentyp

time

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0040223
Note type concept ID
Beschreibung

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type data from which the note.

Datentyp

integer

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Note text
Beschreibung

The content of the note.

Datentyp

text

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C1527021
Provider ID
Beschreibung

A foreign key to the provider in the provider table who was responsible for taking the note.

Datentyp

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Visit occurrence ID
Beschreibung

Foreign key to visit

Datentyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Note source value
Beschreibung

The source value associated with the origin of the note, as standardized using the note_concept_id

Datentyp

text

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609

Ähnliche Modelle

OMOP Common Data Model (CDM) Note

Name
Typ
Description | Question | Decode (Coded Value)
Datentyp
Alias
Item Group
Note
C1317574 (UMLS CUI-1)
C0947611 (UMLS CUI-2)
Note ID
Item
Note ID
integer
C1317574 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Person ID
Item
Person ID
integer
C0027361 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Note date
Item
Note date
date
C1317574 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Note time
Item
Note time
time
C1317574 (UMLS CUI [1,1])
C0040223 (UMLS CUI [1,2])
Note type concept ID
Item
Note type concept ID
integer
C1317574 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Note text
Item
Note text
text
C1317574 (UMLS CUI [1,1])
C1527021 (UMLS CUI [1,2])
Provider ID
Item
Provider ID
integer
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Visit occurrence ID
Item
Visit occurrence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Note source value
Item
Note source value
text
C1317574 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])