Clinics Using Best Practice
Quickly identify patients who may benefit from a review of their BP management
DOWNLOAD SQL QUERY:
1. Download SQL query to your Downloads folder
2. Click Utilities > Search
3. Click Load Query in Best Practice
4. Select the Query that you have downloaded from your Downloads folder
5. Click Run Query
Note: The query will generate a list of patients for whom BP should be a priority at their next visit. Please note that the download option is just the SQL query and does not download any additional software or add-ons.
Untreated
Patients with a recorded systolic BP >160mmHg after 1st Jan 2024 and have not been prescribed an antihypertensive
Treated but Not Controlled
Patients with a hypertension diagnosis and not adequately treated to a Systolic BP target of 140 mmHg after 1st Jan 2024
Hypertension with Unknown BP
Patients seen in 2024 with a hypertension diagnosis and no BP recorded on their last visit
DOWNLOAD SQL QUERY AS TEXT FILE:
1. Download SQL Query as Text File to your Downloads folder
2. Open .txt file from Downloads folder
3. Copy SQL Query text and paste into SQL Query / Best Practice
4. Click Run Query
Note: The query will generate a list of patients for whom BP should be a priority at their next visit. Please note that the download option is just the SQL query and does not download any additional software or add-ons.
Best Practice SQL Query Disclaimer
The SQL query information and documents provided on this webpage are for your convenience only and used at your own risk. While we have made every effort to ensure the accuracy and completeness of the information contained in these documents and codes, we do not provide any warranties, express or implied, with respect to the information. These documents and codes do not provide any medical advice or treatment. We assume no liability for any damages or losses that may arise from the use of these documents or codes. We do not warrant or guarantee that the SQL queries will function with your mobile or computing device or be compatible with the hardware or software on any particular devices. Please refer to our terms of use for further information.
For more information or to report an adverse event contact Medical Information on 1800 153 590.
Thank you for using the Best Practice SQL Queries responsibly.
Material prepared April 2024.