inst/QueryLibrary/Aggregate/general/G04.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

G04: Find synonyms for a given concept

Description

This query extracts all synonyms in the vocabulary for a given Concept ID.

Query

SELECT
  c.concept_id,
  s.concept_synonym_name
FROM @vocab.concept AS c
  JOIN @vocab.concept_synonym AS s ON c.concept_id = s.concept_id
WHERE c.concept_id = $1
;

Input

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

Output

| Field | Description | | --- | ----------------------------- | | Concept_ID | Unique identifier of the concept related to the input concept | | Concept_Synonym_Name | Synonym of the concept |

Example output record

| Field | Value | | --- | --- | | Concept_ID | 192671 | | Concept_Synonym_Name | GI bleeding |

Documentation

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

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