Definition

The clinical code data model provides a reference to original EMISWeb codes for translating a patients clinical information, like observations, diagnosis’ and treatments.

Information

The clinical code model contains EMISWeb code ids and their category description, mapped SNOMED CT codes, as well as other national codes, a variety of standardised coding systems used for different purposes, defined by the NHS

Schema updates for data maintenance

• The is_deleted column has been added to indicate whether a clinical code has been marked as deleted

Benefit

• The is_deleted column enables more effective data maintenance by allowing customers to identify and manage deleted clinical codes

Examples

Distinct EMIS Codes

SELECT
  DISTINCT(emis_code_category_description)
FROM hive.explorer_open_safely.clinical_code
ORDER BY emis_code_category_description ASC

Distinct National Codes for a category

SELECT
DISTINCT national_code,
national_description
FROM hive.explorer_open_safely.clinical_code
WHERE national_code_category = 'PREFERRED COMMUNICATION LANGUAGE'