OMOP Common Data Model (CDM) Note

Note
Description

Note

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

A unique identifier for each note.

Type de données

integer

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

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.

Type de données

integer

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

The date the note was recorded.

Type de données

date

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

The time the note was recorded.

Type de données

time

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

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

Type de données

integer

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

The content of the note.

Type de données

text

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

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

Type de données

integer

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

Foreign key to visit

Type de données

integer

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

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

Type de données

text

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

Similar models

OMOP Common Data Model (CDM) Note

Name
Type
Description | Question | Decode (Coded Value)
Type de données
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])