Definition

Purpose

The mkb_mapping_dmdpreparation model contains mappings between SNOMED concepts and DMD drug preparation codes, enabling pharmaceutical product identification and standardisation.

Information

This mapping table establishes relationships between SNOMED drug concepts and DMD (Dictionary of Medicines and Devices) product codes. It supports medication reconciliation and enables references to standardised pharmaceutical terminology.

• snomed_concept_id (PK): The unique SNOMED concept for the drug
• snomed_description_id (FK): Links to the SNOMED description text
• drug_preparation_code_id (FK): Links to the DMD drug preparation code

Examples

Get all DMD preparation mappings for an organisation

SELECT *
FROM hive.explorer_recruit.mkb_mapping_dmdpreparation
LIMIT 100;

Find mappings for a specific SNOMED concept

SELECT
  snomed_concept_id,
  snomed_description_id,
  drug_preparation_code_id,
  other_code_system,
  other_code
FROM hive.explorer_recruit.mkb_mapping_dmdpreparation
WHERE snomed_concept_id = '123456789'
LIMIT 100;

Find mappings for a specific MKB version

SELECT *
FROM hive.explorer_recruit.mkb_mapping_dmdpreparation
WHERE _mkb_version = 'MKB-229'
LIMIT 100;