ID

19474

Descripción

OMOP Common Data Model (CDM) Concept Relationship The CONCEPT_RELATIONSHIP table contains records that define direct relationships between any two concepts and the nature of the relationship. The type of relationship is defined in the Relationship table, and is generally classified as hierarchical (parent-child) or non-hierarchical (lateral). All relationships are directional, and each concept relationship is represented twice symmetrically within the concept relationship table. For example, the two SNOMED concepts of ‘Acute myocardial infarction of the anterior wall’ and ‘Acute myocardial infarction’ have two concept relationships: 1- ‘Acute myocardial infarction of the anterior wall’ ‘is a’ ‘Acute myocardial infarction’, and 2- ‘Acute myocardial infarction’ ‘subsumes’ ‘Acute myocardial infarction of the anterior wall’. OMOP Common Data Model Specifications Version 5.0 The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense.

Link

http://omop.fnih.org/publiclicense

Palabras clave

Versiones (3)
  1. 4/1/17 4/1/17 -
  2. 26/2/19 26/2/19 -
  3. 26/2/19 26/2/19 -
Subido en

4 de enero de 2017

DOI

Para solicitar uno, por favor iniciar sesión.

Licencia

Creative Commons BY-NC 3.0
Comentarios del modelo :

Puede comentar sobre el modelo de datos aquí. A través de las burbujas de diálogo en los grupos de elementos y elementos, puede agregar comentarios específicos.

Volver a los comentarios del modelo
Comentarios de grupo de elementos para :

Comentarios del elemento para :

Para descargar modelos de datos, debe haber iniciado sesión. Por favor iniciar sesión o Registrate gratis.

OMOP Common Data Model (CDM) Concept Relationship

Inglés

OMOP Common Data Model (CDM) Concept Relationship

1 formularios  
Concept Relationship
Descripción

Concept Relationship

Alias
UMLS CUI-1
C0178566
UMLS CUI-2
C0439849
Concept ID 1
Descripción

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.

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
Concept ID 2
Descripción

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.

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
Relationship ID
Descripción

The type of relationship as defined in the relationship table.

Tipo de datos

text

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C1300638
valid start date
Descripción

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

Tipo de datos

date

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C0011008
valid end date
Descripción

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

Tipo de datos

date

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C0011008
invalid reason
Descripción

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.

Tipo de datos

text

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C3245471
UMLS CUI [1,4]
C0392360
Volver a la parte superior de la página

Similar models

OMOP Common Data Model (CDM) Concept Relationship

1 formularios
Name
Tipo
Description | Question | Decode (Coded Value)
Tipo de datos
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])
Volver a la parte superior de la página 

Contacto

Utilice este formulario para comentarios, preguntas y sugerencias.

Los campos marcados con * son obligatorios.

Ayuda

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial