General Queries‎ > ‎

G02: Find a concept by code from a source vocabulary

This query obtains the concept details associated with a concept code, such as name, class, level and source vocabulary.
Only concepts from the Standard Vocabularies can be searched using this query. If you want to translate codes from other Source Vocabularies to Standard Vocabularies use G06 query.

Input:
 Parameter  Example  Mandatory  Notes
 Concept Code  '74474003'  Yes SNOMED-CT code for "GI - Gastrointestinal hemorrhage". Concept code can be alpha-numeric and should be enclosed in single quotes.
 Vocabulary ID  1  Yes The vocabulary ID as listed in the VOCABULARY table. Code 1 represents SNOMED-CT
 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 details for concept code of ‘74474003’ from concept vocabulary ID of ‘1’ (for SNOMED-CT) for the current date. The input parameters are highlighted in blue. Note that in contrast to concept ID the concept codes are not unique across different vocabularies. If you don't specify the vocabulary, you might get results for the same code in different vocabularies.
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_code   = '74474003'
AND    C. vocabulary_id = 1
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 Idenitifer for the standard concept
 Concept_Name  Name of the standard concept
 Concept_Code  Concept code from the source vocabulary entered as input
 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 concept is derived from as vocabulary ID
 Vocabulary_Name  Name of the vocabulary the standard concept is derived from

Sample output record:
 Field  Value
 Concept_ID  192671
 Concept_Name  GI - Gastrointestinal hemorrhage
 Concept_Code  74474003
 Concept_Class  Clinical finding
 Concept_Level  2
 Vocabulary_ID  1
 Vocabulary_Name  SNOMED-CT
Comments