OMOP Common Data Model (CDM) Source to Concept Map

Source to Concept Map
Description

Source to Concept Map

Alias
UMLS CUI-1
C0596404
UMLS CUI-2
C0178566
UMLS CUI-3
C0449416
UMLS CUI-4
C0011001
UMLS CUI-5
C0024779
Source code
Description

The source code being translated into a standard concept.

Data type

integer

Alias
UMLS CUI [1]
C1710131
Source concept ID
Description

A foreign key to the source concept to which the source code is being mapped.

Data type

integer

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Source vocabulary ID
Description

A foreign key to the vocabulary table defining the vocabulary of the source code that is being mapped to the Standardized Vocabularies.

Data type

text

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C0042926
UMLS CUI [1,3]
C1300638
Target concept ID
Description

A foreign key to the target concept to which the source code is being mapped.

Data type

integer

Alias
UMLS CUI [1,1]
C1521840
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Target vocabulary ID
Description

A foreign key to the vocabulary table defining the vocabulary of the target concept.

Data type

text

Alias
UMLS CUI [1,1]
C1521840
UMLS CUI [1,2]
C0042926
UMLS CUI [1,3]
C1300638
valid start date
Description

The date when the mapping instance was first recorded.

Data type

date

Alias
UMLS CUI [1,1]
C0024779
UMLS CUI [1,2]
C0596404
UMLS CUI [1,3]
C0011008
valid end date
Description

The date when the mapping instance became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31- Dec-2099.

Data type

date

Alias
UMLS CUI [1,1]
C0024779
UMLS CUI [1,2]
C0596404
UMLS CUI [1,3]
C0011008
invalid reason
Description

Reason the mapping instance was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value.

Data type

text

Alias
UMLS CUI [1,1]
C0024779
UMLS CUI [1,2]
C0596404
UMLS CUI [1,3]
C3245471
UMLS CUI [1,4]
C0392360

Similar models

OMOP Common Data Model (CDM) Source to Concept Map

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Source to Concept Map
C0596404 (UMLS CUI-1)
C0178566 (UMLS CUI-2)
C0449416 (UMLS CUI-3)
C0011001 (UMLS CUI-4)
C0024779 (UMLS CUI-5)
Source code
Item
Source code
integer
C1710131 (UMLS CUI [1])
Source concept ID
Item
Source concept ID
integer
C0449416 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Source vocabulary ID
Item
Source vocabulary ID
text
C0449416 (UMLS CUI [1,1])
C0042926 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Target concept ID
Item
Target concept ID
integer
C1521840 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Target vocabulary ID
Item
Target vocabulary ID
text
C1521840 (UMLS CUI [1,1])
C0042926 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
valid start date
Item
valid start date
date
C0024779 (UMLS CUI [1,1])
C0596404 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
valid end date
Item
valid end date
date
C0024779 (UMLS CUI [1,1])
C0596404 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
invalid reason
Item
invalid reason
text
C0024779 (UMLS CUI [1,1])
C0596404 (UMLS CUI [1,2])
C3245471 (UMLS CUI [1,3])
C0392360 (UMLS CUI [1,4])