Clinical Operations Analytics Path · Mission 17 of 25Expert

Diabetic kidney disease cohort

Encounter cohort intersection: encounters that have BOTH an E11.x (T2DM) diagnosis AND an N18.x (CKD) diagnosis at any rank. The exact pattern behind CMS's DKD quality measure denominator, and the SQL behind every diabetic-kidney registry roster in production.

The Brief

You'll practice

Cohort intersection (INNER JOIN)LIKE pattern familiesDISTINCT in CTE