Definition

DMD Preparation provides the mapping of EMIS preparation code ID for a medication to the NHS DMD (Dictionary of Medicines and Devices) product code ID (which is also a SNOMED CT concept ID).

Information

This model contains DMD codes and their mapped EMIS codes.

What’s changing in iPCV v2

Schema updates for data maintenance

• The is_deleted column has been added to indicate whether a mapping between EMIS preparation codes and DMD product codes has been marked as deleted

Benefit

• The is_deleted column enables more effective data maintenance by allowing customers to identify and manage obsolete mappings between EMIS preparation codes and NHS DMD product codes

Customer Action

• Update your ETL processes to use the is_deleted column to filter out obsolete mappings and maintain data quality for DMD preparation code mappings

Examples

Find codes from DMD product code

SELECT
  *
FROM hive.explorer_ipcv.srv_mkb_mapping_dmdpreparation
WHERE dmd_product_code_id = 4205211000001100

List of DMD drugs with price per unit under 1

SELECT
  term AS drug_name,
  dmd.dmd_product_code_id,
  dmd.preparation_code_id,
  price_per_unit
FROM hive.explorer_ipcv.srv_mkb_mapping_dmdpreparation AS dmd
JOIN hive.explorer_ipcv.srv_mkb_drugpack AS dc
ON dc.dmd_product_code_id = dmd.dmd_product_code_id
WHERE
  dc.is_deleted = FALSE
  AND price_per_unit < 1
GROUP BY
  term,
  dmd.dmd_product_code_id,
  dmd.preparation_code_id,
  price_per_unit