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.

What’s changing in iPCV v2

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

Benefit

• The is_deleted column enables more effective data maintenance by allowing customers to identify and manage obsolete ethnicity mappings and codes that are no longer classified as ethnicity types

Customer Action

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

Examples

Active ethnicity codes

SELECT
  code_id,
  snomed_concept_id,
  snomed_description,
  organisation,
  transform_datetime
FROM hive.explorer_ipcv.srv_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_ipcv.srv_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_ipcv.srv_mkb_mapping_ethnicity
WHERE
  is_deleted = TRUE
ORDER BY
  transform_datetime DESC