Definition

Purpose

The mkb_mapping_attributes model contains MKB mapping attributes linking EMIS codes to SNOMED and national data dictionary mappings for terminology standardisation.

Information

This mapping table provides cross-references between EMIS clinical codes and standardised coding systems. It enables translation of local EMIS codes to national and international coding standards including SNOMED CT.

• emis_code_id (PK): The unique identifier for the EMIS code
• snomed_concept_id (FK): Links to the mapped SNOMED concept

Examples

Get all MKB attribute mappings for an organisation

SELECT *
FROM hive.explorer_recruit_anon.mkb_mapping_attributes
LIMIT 100;

Find attributes for a specific EMIS code

SELECT
  emis_code_id,
  snomed_concept_id,
  attribute_type,
  data_dictionary_national_code,
  _mkb_version
FROM hive.explorer_recruit_anon.mkb_mapping_attributes
WHERE emis_code_id = 'A123'
LIMIT 100;

Find attribute mappings for a specific MKB version

SELECT *
FROM hive.explorer_recruit_anon.mkb_mapping_attributes
WHERE _mkb_version = 'MKB-229'
LIMIT 100;