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.

  are preserved so deleted linked records can be identified.

Examples

Active ethnicity codes

SELECT
  code_id,
  snomed_concept_id,
  snomed_description,
  transform_datetime
FROM explorer_open_safely.mkb_mapping_ethnicity
ORDER BY
  snomed_description

Find specific ethnicity type

SELECT
  code_id,
  snomed_concept_id,
  snomed_description,
  transform_datetime
FROM explorer_open_safely.mkb_mapping_ethnicity
WHERE
  snomed_description LIKE '%Asian%'
ORDER BY
  snomed_description

Historical ethnicity codes

SELECT
  code_id,
  snomed_concept_id,
  snomed_description,
  snomed_description_id,
  transform_datetime
FROM explorer_open_safely.mkb_mapping_ethnicity
WHERE
ORDER BY
  transform_datetime DESC