This query accepts a concept ID as the input and returns all concepts that are its immediate parents of that concept. Parents are concepts that have a hierarchical relationship to the given concepts. Hierarchical relationships are defined in the relationship table.
The query returns only the immediate parent concepts that are directly linked to the input concept and not all ancestors.
Input:
Parameter |
Example |
Mandatory |
Notes |
Concept ID |
192671 |
Yes |
GI - Gastrointestinal hemorrhage |
As of date |
Sysdate |
No |
Valid record as of specific date. Current date – sysdate is a default |
Sample query run:
The following is a sample run of the query to extract the parent concepts of the input concept. The input parameters are highlighted in blue.
SELECT A.concept_id Parent_concept_id,
A.concept_name Parent_concept_name,
A.concept_code Parent_concept_code,
A.concept_class Parent_concept_class,
A.vocabulary_id Parent_concept_vocab_ID,
VA.vocabulary_name Parent_concept_vocab_name
FROM vocabulary.concept_ancestor CA,
vocabulary.concept A,
vocabulary.concept D,
vocabulary.vocabulary VA
WHERE CA.descendant_concept_id = 192671
AND CA.min_levels_of_separation = 1
AND CA.ancestor_concept_id = A.concept_id
AND A.vocabulary_id = VA.vocabulary_id
AND CA.descendant_concept_id = D.concept_id
AND sysdate BETWEEN A.valid_start_date AND A.valid_end_date
Output:
Output field list:
Field |
Description |
Parent_Concept_ID |
Concept ID of parent concept |
Parent_Concept_Name |
Name of parent concept |
Parent_Concept_Code |
Concept Code of parent concept |
Parent_Concept_Class |
Concept Class of parent concept |
Parent_Concept_Vocab_ID |
Vocabulary parent concept is derived from as vocabulary code |
Parent_Concept_Vocab_Name |
Name of the vocabulary the child concept is derived from |
Sample output record:
Field |
Value |
Parent_Concept_ID |
4000610 |
Parent_Concept_Name |
Disease of gastrointestinal tract |
Parent_Concept_Code |
119292006 |
Parent_Concept_Class |
Clinical finding |
Parent_Concept_Vocab_ID |
1 |
Parent_Concept_Vocab_Name |
SNOMED-CT |
|