Definition

Purpose

The mkb_mapping_ethnicity model provides mappings between EMIS codes and ethnicity-related SNOMED mappings used by the medical knowledge base for demographic standardisation.

Information

This mapping table enables translation of local EMIS ethnicity codes to SNOMED CT standard concepts. It supports demographic data standardisation and research reporting with standardised ethnicity classifications.

• snomed_concept_id (PK): The unique SNOMED concept for the ethnicity
• snomed_description_id (FK): Links to the SNOMED description text
• emis_code_id (FK): Links to the EMIS ethnicity code

Examples

Get all ethnicity mappings for an organisation

SELECT *
FROM hive.explorer_recruit.mkb_mapping_ethnicity
LIMIT 100;

Find mappings for a specific SNOMED concept

SELECT
  snomed_concept_id,
  snomed_description,
  emis_code_id,
  snomed_description_id
FROM hive.explorer_recruit.mkb_mapping_ethnicity
WHERE snomed_concept_id = '123456789'
LIMIT 100;

Find ethnicity mappings for a specific MKB version

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