Clinical Operations Analytics Path · Mission 24 of 25Master

Data quality audit — POA gaps and legacy codes

Practice the LEFT-JOIN-vs-INNER-JOIN gotcha — the #1 silent bug in healthcare reporting. Detect codes that don't map to the reference terminology table (likely ICD-9 legacy that survived the 2015 cutover) and surface POA documentation gaps that hurt CMS hospital-acquired-condition reporting.

The Brief

You'll practice

LEFT JOIN auditCOUNT FILTERAnti-join