ID

19477

Description

OMOP Common Data Model (CDM) Concept Ancestor The CONCEPT_ANCESTOR table contains records that define the inferred hierarchical relationships between all standard concepts. The concept ancestor table is fully derived from the concept, CONCEPT_RELATIONSHIP, and relationship tables, whereby all ancestor-descendant relationships can be inferred from traversing all parent-child relationships between standard concepts. The concept ancestor table includes records for all parent-child relationships, as well as grandparent-grandchild relationships and additional levels of lineage. The concept ancestor table enables efficient identification of multi-step hierarchical relationships, such as branded drugs that fall within a therapeutic class or specific diagnosis that are classified within a particular system organ class. 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

Keywords

  1. 1/4/17 1/4/17 -
  2. 2/26/19 2/26/19 -
Uploaded on

January 4, 2017

DOI

To request one please log in.

License

Creative Commons BY-NC 3.0

Model comments :

You can comment on the data model here. Via the speech bubbles at the itemgroups and items you can add comments to those specificially.

Itemgroup comments for :

Item comments for :

In order to download data models you must be logged in. Please log in or register for free.

OMOP Common Data Model (CDM) Concept Ancestor

OMOP Common Data Model (CDM) Concept Ancestor

Concept Ancestor
Description

Concept Ancestor

Alias
UMLS CUI-1
C0178566
UMLS CUI-2
C0449689
UMLS CUI-3
C0870134
Ancestor concept ID
Description

A foreign key to the concept in the concept table for the higher-level concept that forms the ancestor in the relationship.

Data type

integer

Alias
UMLS CUI [1,1]
C0870134
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Descendant concept ID
Description

A foreign key to the concept in the concept table for the lower-level concept that forms the descendant in the relationship.

Data type

integer

Alias
UMLS CUI [1,1]
C1707686
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Min levels of separation
Description

The minimum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis.

Data type

integer

Alias
UMLS CUI [1,1]
C0445406
UMLS CUI [1,2]
C0441889
UMLS CUI [1,3]
C0699032
Max levels of separation
Description

The maximum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis.

Data type

integer

Alias
UMLS CUI [1,1]
C0445406
UMLS CUI [1,2]
C0441889
UMLS CUI [1,3]
C0699032

Similar models

OMOP Common Data Model (CDM) Concept Ancestor

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Concept Ancestor
C0178566 (UMLS CUI-1)
C0449689 (UMLS CUI-2)
C0870134 (UMLS CUI-3)
Ancestor concept ID
Item
Ancestor concept ID
integer
C0870134 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Descendant concept ID
Item
Descendant concept ID
integer
C1707686 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Min levels of separation
Item
Min levels of separation
integer
C0445406 (UMLS CUI [1,1])
C0441889 (UMLS CUI [1,2])
C0699032 (UMLS CUI [1,3])
Max levels of separation
Item
Max levels of separation
integer
C0445406 (UMLS CUI [1,1])
C0441889 (UMLS CUI [1,2])
C0699032 (UMLS CUI [1,3])

Please use this form for feedback, questions and suggestions for improvements.

Fields marked with * are required.

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