inst/QueryLibrary/Aggregate/general/G01.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

G01: Find concept by concept ID

Description

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.

Query

SELECT
  c.concept_id,
  c.concept_name,
  c.concept_code,
  c.concept_class_id,
  c.standard_concept,
  c.vocabulary_id
FROM @vocab.concept AS c
WHERE c.concept_id = $1
;

Input

| Parameter | Example | Mandatory | Notes | | ---------- | ------- | --------- | --------------------------------------------------------- | | Concept ID | 192671 | Yes | Concept Identifier for "GI - Gastrointestinal hemorrhage" |

Output

| 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 | | Standard_Concept | Standard concept flag | | Vocabulary_Name | Name of the vocabulary the standard concept is derived from |

Example output record

| Field | Value | | ---------------- | -------------------------------- | | Concept_ID | 192671 | | Concept_Name | GI - Gastrointestinal hemorrhage | | Concept_Code | 74474003 | | Concept_Class | Clinical finding | | Standard_Concept | S | | Vocabulary_Name | SNOMED-CT |

Documentation

https://github.com/OHDSI/CommonDataModel/wiki/

sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.