This is the most generic look-up for obtaining concept details associated with a concept identifier. The query is intended as a tool for quick reference for the name, class, level and source vocabulary details associated with a concept identifier.
Input:
| Parameter |
Example |
Mandatory |
Notes |
| Concept ID |
192671 |
Yes |
Concept Identifier for "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 run a search for concept ID of 192671 for the current date. The input parameters are highlighted in blue.
SELECT C.concept_id,
C.concept_name,
C.concept_code,
C.concept_class,
C.concept_level,
C.vocabulary_id,
V.vocabulary_name
FROM vocabulary.concept C,
vocabulary.vocabulary V
WHERE C.concept_id = 192671
AND C.vocabulary_id = V.vocabulary_id
AND sysdate BETWEEN valid_start_date AND valid_end_date
Output:
Output field list:
| Field |
Description |
| Concept_ID |
Concept Identifier entered as input |
| Concept_Name
|
Name of the standard concept |
| Concept_Code
|
Concept code of the standard concept in the source vocabulary |
| Concept_Class
|
Concept class of standard vocabulary concept |
| Concept_Level
|
Level of the concept if defined as part of a hierarchy |
| Vocabulary_ID
|
Vocabulary the standard concept is derived from as vocabulary code |
| Vocabulary_Name
|
Name of the vocabulary the standard concept is derived from |
Sample output record:
| Field |
Value |
| Concept_ID |
192671 |
| Concept_Name |
GI - Gastrointestinal haemorrhage |
| Concept_Code |
74474003 |
| Concept_Class |
Clinical finding |
| Concept_Level |
2 |
| Vocabulary_ID |
1 |
| Vocabulary_Name |
SNOMED-CT |
|
|
