ID
35274
Description
OMOP Common Data Model (CDM) Concept Ancestor The CONCEPT_ANCESTOR table is designed to simplify observational analysis by providing the complete hierarchical relationships between Concepts. Only direct parent-child relationships between Concepts are stored in the CONCEPT_RELATIONSHIP table. To determine higher level ancestry connections, all individual direct relationships would have to be navigated at analysis time. The CONCEPT_ANCESTOR table includes records for all parent-child relationships, as well as grandparent-grandchild relationships and those of any other level of lineage. Using the CONCEPT_ANCESTOR table allows for querying for all descendants of a hierarchical concept. For example, drug ingredients and drug products are all descendants of a drug class ancestor. This table is entirely derived from the CONCEPT, CONCEPT_RELATIONSHIP and RELATIONSHIP tables. Each concept is also recorded as an ancestor of itself. Only valid and Standard Concepts participate in the CONCEPT_ANCESTOR table. It is not possible to find ancestors or descendants of deprecated or Source Concepts. Usually, only Concepts of the same Domain are connected through records of the CONCEPT_ANCESTOR table, but there might be exceptions. OMOP Common Data Model Specifications Version 6.0 Specifications 11October2018 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. Version updated on 26.02.2019, from https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT_ANCESTOR
Link
http://omop.fnih.org/publiclicense
Keywords
Versions (2)
- 1/4/17 1/4/17 -
- 2/26/19 2/26/19 -
Copyright Holder
Observational Medical Outcomes Partnership (OMOP)
Uploaded on
February 26, 2019
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
- StudyEvent: ODM
Similar models
OMOP Common Data Model (CDM) Concept Ancestor
- StudyEvent: ODM
C0449689 (UMLS CUI-2)
C0870134 (UMLS CUI-3)
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
C0750480 (UMLS CUI [1,2])
C0441889 (UMLS CUI [1,3])
C0699032 (UMLS CUI [1,4])
C0750480 (UMLS CUI [1,2])
C0441889 (UMLS CUI [1,3])
C0699032 (UMLS CUI [1,4])