Yes, we have made some progress on our end. Initially we envisioned using Healthy Planet, the new population health management tool in Epic to build our registry. However, because it is a new product, they have released only a few registries that we can tinker with (so far). Therefore, in the interim we built out a registry using SQL coding to help us track our clients who had:
-at least 1 visit in 2019,
-at least one PHQ-9 score of 15 or higher (in any visit in 2019), and
-had at least 1 diagnosis code related to depression.
We then ordered the visits from oldest to newest and grouped the visits by visit provider. Note: we only included visits where a PHQ-9 score was entered.
Columns displayed include the client’s ID, Contact Date, Active Psychotropic Medications, PHQ-9 Score, Who the Score was Entered By, and the Visit Diagnoses respective to the ICD10 list (diagnoses related to depression).
The information that we have thus far will at least allow us to track our patients’ PHQ-9 scores over time.
I’m happy to share the headers and inclusions/exclusions of the report, however would have to cut out any patient information.