English

OMOP Common Data Model (CDM) Concept Relationship

1 forms  
Concept Relationship
Description

Concept Relationship

Alias
UMLS CUI-1
C0178566
UMLS CUI-2
C0439849
Concept ID 1
Description

A foreign key to the concept in the concept table associated with the relationship. Relationships are directional, and this field represents the source concept designation.

Data type

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
Concept ID 2
Description

A foreign key to the concept in the concept table associated with the relationship. Relationships are directional, and this field represents the source concept designation.

Data type

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
Relationship ID
Description

The type of relationship as defined in the relationship table.

Data type

text

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C1300638
valid start date
Description

The date when the instance of the relationship is first recorded.

Data type

date

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C0011008
valid end date
Description

The date when the relationship 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]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C0011008
invalid reason
Description

Reason the relationship 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]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C3245471
UMLS CUI [1,4]
C0392360
Back to the top of the page

Similar models

OMOP Common Data Model (CDM) Concept Relationship

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Concept Relationship
C0178566 (UMLS CUI-1)
C0439849 (UMLS CUI-2)
Concept ID 1
Item
Concept ID 1
integer
C0178566 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Concept ID 2
Item
Concept ID 2
integer
C0178566 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Relationship ID
Item
Relationship ID
text
C0439849 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
valid start date
Item
valid start date
date
C0178566 (UMLS CUI [1,1])
C0439849 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
valid end date
Item
valid end date
date
C0178566 (UMLS CUI [1,1])
C0439849 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
invalid reason
Item
invalid reason
text
C0178566 (UMLS CUI [1,1])
C0439849 (UMLS CUI [1,2])
C3245471 (UMLS CUI [1,3])
C0392360 (UMLS CUI [1,4])
Back to the top of the page