inst/QueryLibrary/Aggregate/condition/C04.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

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

Description

This query accepts a MedDRA concept ID as input and returns details of the equivalent SNOMED-CT concepts. The existing 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.

Query

The following is a sample run of the query to list all MedDRA concepts that have SNOMED-CT equivalents.

SELECT
  d.concept_id         AS meddra_concept_id,
  d.concept_name       AS meddra_concept_name,
  d.concept_code       AS meddra_concept_code,
  d.concept_class_id   AS meddra_concept_class,
  cr.relationship_id   AS relationship_id,
  r.relationship_name  AS relationship_name,
  a.concept_id         AS snomed_concept_id,
  a.concept_name       AS snomed_concept_name,
  a.concept_code       AS snomed_concept_code,
  a.concept_class_id   AS snomed_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 = 'MedDRA - SNOMED eq' AND
  cr.concept_id_1 = $1 AND
  cr.invalid_reason IS NULL
;

Input

| Parameter | Example | Mandatory | Notes | | --- | --- | --- | --- | | MedDRA Concept ID | 35205180 | Yes | Concept Identifier for 'Acute myocardial infarction' |

Output

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

Example output record

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

Documentation

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

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