Engelsk

OMOP Common Data Model (CDM) Concept Relationship

1 Formulär  
Concept Relationship
Beskrivning

Concept Relationship

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

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.

Datatyp

integer

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

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.

Datatyp

integer

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

The type of relationship as defined in the relationship table.

Datatyp

text

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

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

Datatyp

date

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

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

Datatyp

date

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C0011008
invalid reason
Beskrivning

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.

Datatyp

text

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C3245471
UMLS CUI [1,4]
C0392360
Tillbaka till toppen

Similar models

OMOP Common Data Model (CDM) Concept Relationship

1 Formulär
Name
Typ
Description | Question | Decode (Coded Value)
Datatyp
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])
Tillbaka till toppen