Best Practice like many Australian GP Electronic Health Record systems allows arbitrary SQL searches. n Best Practice this facility is found on the Main Console under Utilities Search.
Queries are posted into the "SQL Query" box and executed by pressing the Run Query button.
Many queries can be found on the Best Practice SQL Search Queries Bulletin Board. These searches can be saved in BP and run on a regular basis.
Finding BP CDM At Risk Patients
The following query finds current patients who have more than 8 active, "summary" conditions one of which belongs to IHD, CCF, COPD, renal disease and mental health issues. They also are on 8 or more medications. The results are grouped by "usual doctor".
The Integrated Care (ICC) will commence in October 2015 and conclude on June 30, 2016. The ICC will consist of an Orientation session and 3 learning workshops, interspersed with activity periods.
The learning workshops will provide participants with the opportunity to hear from topic and quality improvement experts, and actively share knowledge and experiences with their peers. Participants will also learn about the Model for Improvement, which will enable them to test change ideas in their local setting and then reflect, learn and refine these tests.
- Written by Improvement Foundation
Page 5 of 5