CONCEPT_ANCESTOR

Table Description

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.

CDM Field	User Guide	Datatype	Required	Primary Key	Foreign Key	FK Table
ancestor_concept_id	The Concept Id for the higher-level concept that forms the ancestor in the relationship.	integer	Yes	No	Yes	CONCEPT
descendant_concept_id	The Concept Id for the lower-level concept that forms the descendant in the relationship.	integer	Yes	No	Yes	CONCEPT
min_levels_of_separation	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.	integer	Yes	No	No
max_levels_of_separation	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.	integer	Yes	No	No



Column Name	Data Type	PK / FK	Nullable	Description

ancestor_concept_id	int4	PK / FK	No
descendant_concept_id	int4	PK / FK	No
min_levels_of_separation	int4		No
max_levels_of_separation	int4		No



Name	Begin	End

fpk_concept_ancestor_ancestor_concept_id : Relationship	concept : Entity	concept_ancestor : Entity
fpk_concept_ancestor_descendant_concept_id : Relationship	concept : Entity	concept_ancestor : Entity



	Name		Value

	Name		ancestor_concept_id
	Type		int4
	Nullable		false
	Unique		false
	Primary Key		true
	Index		false
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		true
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		descendant_concept_id
	Type		int4
	Nullable		false
	Unique		false
	Primary Key		true
	Index		false
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		true
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		min_levels_of_separation
	Type		int4
	Nullable		false
	Unique		false
	Primary Key		false
	Index		false
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Diagram

	Vocabulary_With_Standard : Entity Relationship Diagram
	Vocabulary_Tables : Entity Relationship Diagram