Definition

The MKB Mapping — Ethnicity model provides a standardized reference for ethnicity codes, mapping local codes to SNOMED CT concepts. Can be joined to the patient table to identify patient demographics relating to ethnicity.

Constraints and Notes

• Soft deletion : When is_deleted is true, data fields may be nullified in upstream transformations and should be excluded from most analytical queries. Primary keys and foreign keys are preserved so deleted linked records can be identified

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