Definition

A reference to original EMISWeb codes for translating a patient’s clinical information, like observations, diagnosis’ and treatments. Similar to the codeable concept table as it contains snomed codes but also contains national codes, readv2 codes etc.

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

Constraint 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

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'