inst/QueryLibrary/Aggregate/condition/C03.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

C03: Translate a SNOMED-CT concept into a MedDRA concept

Description

This query accepts a SNOMED-CT concept ID as input and returns details of the equivalent MedDRA concepts.

The relationships in the vocabulary associate MedDRA 'Preferred Term' to SNOMED-CT 'clinical findings'. The respective hierarchy for MedDRA and SNOMED-CT can be used to traverse up and down the hierarchy of each of these individual vocabularies.

Also, not all SNOMED-CT clinical findings are mapped to a MedDRA concept in the vocabulary.

Query

The following is a sample run of the query to list MedDRA equivalents for SNOMED-CT concept whose concept ID is entered as input.

SELECT
  d.concept_id        AS snomed_concept_id,
  d.concept_name      AS snomed_concept_name,
  d.concept_code      AS snomed_concept_code,
  d.concept_class_id  AS snomed_concept_class,
  cr.relationship_id  AS relationship_id,
  r.relationship_name AS relationship_name,
  a.concept_id        AS meddra_concept_id,
  a.concept_name      AS meddra_concept_name,
  a.concept_code      AS meddra_concept_code,
  a.concept_class_id  AS meddra_concept_class
FROM @vocab.concept_relationship AS cr
  JOIN @vocab.concept AS d ON cr.concept_id_1 = d.concept_id
  JOIN @vocab.concept AS a ON cr.concept_id_2 = a.concept_id
  JOIN @vocab.relationship AS r ON cr.relationship_id = r.relationship_id
WHERE
  cr.relationship_id = 'SNOMED - MedDRA eq' AND
  cr.concept_id_1 = $1 AND
  cr.invalid_reason IS NULL
;

Input

| Parameter | Example | Mandatory | Notes | | --- | --- | --- | --- | | SNOMED-CT Concept ID | 312327 | Yes | Concept Identifier for 'Acute myocardial infarction' |

Output

| Field | Description | | --- | --- | | SNOMED_Concept_ID | Concept ID of SNOMED-CT concept entered as input | | SNOMED_Concept_Name | Name of SNOMED-CT concept | | SNOMED_Concept_Code | Concept code of SNOMED-CT concept | | SNOMED_Concept_Class | Concept class of SNOMED-CT concept | | Relationship_ID | Identifier for the type of relationship | | Relationship_Name | Description of the type of relationship | | MedDRA_Concept_ID | Concept ID of matching MedDRA concept | | MedDRA_Concept_Name | Concept name of matching MedDRA concept | | MedDRA_Concept_Code | Concept code of matching MedDRA concept | | MedDRA_Concept_Class | Concept class of matching MedDRA concept |

Example output record

| Field | Value | | --- | --- | | SNOMED_Concept_ID | 312327 | | SNOMED_Concept_Name | Acute myocardial infarction | | SNOMED_Concept_Code | 57054005 | | SNOMED_Concept_Class | Clinical finding | | Relationship_ID | SNOMED - MedDRA eq | | Relationship_Name | SNOMED-CT to MedDRA equivalent (OMOP) | | MedDRA_Concept_ID | 35205180 | | MedDRA_Concept_Name | Acute myocardial infarction | | MedDRA_Concept_Code | 10000891 | | MedDRA_Concept_Class | Preferred Term |

Documentation

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

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