Definition

This Sensitive SNOMED Code model provides the SNOMED CT codes that are considered sensitive. This includes data related to areas such as gender, assisted fertilisation, sexually transmitted diseases, and other information deemed confidential.

Information

This model is created by identifying the codes defined as sensitive from within a refset or the SCR dataset. The model includes concept IDs and code IDs, which will assist with joining to other models.

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

Selecting a concept ID

SELECT
  *
FROM hive.explorer_open_safely.sensitive_snomed_code
WHERE concept_id =  2007581000006106 -- example code

Finding concept IDs with more than one code ID

SELECT
  concept_id
FROM hive.explorer_open_safely.sensitive_snomed_code
GROUP BY concept_id
HAVING count(code_id) > 1

Finding the terms of the example code

SELECT
  ssc.concept_id,
  cc.fully_specified_name,
  ssc.code_id,
  cc.term
FROM hive.explorer_open_safely.sensitive_snomed_code AS ssc
INNER JOIN  hive.explorer_open_safely.codeable_concept AS cc
ON ssc.code_id = cc.code_id
WHERE ssc.concept_id = 2007581000006106 -- example code