Definition

The MKB Mapping — Ethnicity model provides a standardized reference for ethnicity codes, mapping local codes to SNOMED CT concepts for consistent ethnicity information across healthcare systems.

Information

The model includes deleted status indicators to show when codes are no longer active or have been reclassified from ethnicity codes to other types.

Schema updates for data maintenance

• The is_deleted column has been added to indicate whether an ethnicity code mapping has been marked as deleted or reclassified

Examples

Active ethnicity codes

SELECT
  code_id,
  snomed_concept_id,
  snomed_description,
  organisation,
  transform_datetime
FROM hive.explorer_open_safely.mkb_mapping_ethnicity
WHERE
  is_deleted = FALSE
ORDER BY
  snomed_description

Find specific ethnicity type

SELECT
  code_id,
  snomed_concept_id,
  snomed_description,
  organisation,
  transform_datetime
FROM hive.explorer_open_safely.mkb_mapping_ethnicity
WHERE
  is_deleted = FALSE
  AND snomed_description LIKE '%Asian%'
ORDER BY
  snomed_description

Historical ethnicity codes

SELECT
  code_id,
  snomed_concept_id,
  snomed_description,
  snomed_description_id,
  organisation,
  transform_datetime
FROM hive.explorer_open_safely.mkb_mapping_ethnicity
WHERE
  is_deleted = TRUE
ORDER BY
  transform_datetime DESC