Andrew Charlwood
21 lines
528 B
SQL
21 lines
528 B
SQL
/*
|
|
Clinical coding cluster lookup
|
|
==============================
|
|
|
|
Purpose:
|
|
List SNOMED codes attached to maintained clinical coding clusters.
|
|
|
|
Use maintained clusters where possible instead of free-text matching on
|
|
SNOMED descriptions.
|
|
*/
|
|
|
|
SET CLUSTER_ID = 'DEPR_COD';
|
|
|
|
SELECT DISTINCT
|
|
ccs."Cluster_ID",
|
|
ccs."SNOMEDCode",
|
|
ccs."SNOMEDDescription"
|
|
FROM DATA_HUB.PHM."ClinicalCodingClusterSnomedCodes" ccs
|
|
WHERE ccs."Cluster_ID" = $CLUSTER_ID
|
|
ORDER BY ccs."SNOMEDDescription", ccs."SNOMEDCode";
|