What is DETECT DIY?
DETECT DIY is a Do-It-Yourself resource kit to help you identify patients with CKD, or at-risk of CKD, or may benefit from a clinical review. DETECT steps you through patient identification and recalls using your own practice software.
CHRONIC KIDNEY DISEASE (CKD)
Best Practice Resources
Custom SQL (Structured Query Language)
What is an SQL code and how do you use it?
Custom SQL (Structured Query Language) Query: is a automated search code to paste into your Best Practice software to quickly identify patients. By using SQL queries, users can systematically filter and identify specific groups of patients based on diagnosis codes, prescription records, age, and many other clinical criteria.
Step 1:
Identify diagnosed CKD patients
Review for optimal management
Use this customised code to identify patients with CKD and who are not prescribed an SGLT2i
Search Criteria: eGFR 20 - <45 mL/min/1.73m2 OR eGFR 45-90 mL/min/1.73m2 + uACR >22.6 mg/mmol, may or may not be on ACE/ARB, no SGLT2i in past 12m. A clinical review is suggested.
Step 2:
Identify undiagnosed CKD patients
Review for diagnosis & management
Use this customised code to identify patients at-risk of CKD
Search Criteria: eGFR 20 - 75 mL/min/1.73m2, history of ACE/ARB and/or metformin, no SGLT2i in past 12m. A clinical review is suggested.
More patients to identify or no SQL code? Follow below guides to conduct a data base search.
Data Base Search Guides: Follow below guides to conduct a manual data base search in Best Practice.
Identify diagnosed CKD patients
Review for optimal management
Use this simple search guide to identify patients with CKD who are not prescribed an SGLT2i
Search Criteria: 18+years, CKD stages 2-5, prescribed ACE/ARB, no SGLT2i in past 12m. A clinical review is suggested.
Identify at-risk CKD patients
Review for diagnosis & management
Use this simple search to identify at-risk patients
Search Criteria: 40+ years, Existing T2D (HbA1c >7% or metformin), hypertensive (current ACE/ARB), no SGLT2i. A clinical review is suggested.
Medical Director Resources
Custom Advanced Searches (using SQL codes)
What is an SQL code and how do you use it?
Custom SQL (Structured Query Language) Query: are automated search codes to paste into your Medical Director Practice Software to quickly identify patients. By using SQL codes, users can systematically filter and find specific groups of patients based on diagnosis codes, prescription records, age, and many other clinical criteria.
Step 1:
Identify diagnosed CKD patients
Review for optimal management
Use this customised code to identify patients with CKD and who are not prescribed an SGLT2i
Search Criteria: eGFR 20 - <45 mL/min/1.73m2 OR eGFR 45-90 mL/min/1.73m2 + uACR >22.6 mg/mmol, may or may not be on ACE/ARB, no SGLT2i in past 12m. A clinical review is suggested.
Step 2:
Identify undiagnosed CKD patients
Review for diagnosis & management
Use this customised code to identify patients at-risk of CKD
Search Criteria: eGFR 20 - 75 mL/min/1.73m2, history of ACE/ARB and/or metformin, no SGLT2i in past 12m. A clinical review is suggested.
More patients to identify or no SQL code? Follow below guides to conduct a simple search.
Data Base Search Guides: Follow below guides to conduct a manual simple search in Medical Director.
Identify diagnosed CKD patients
Review for optimal management
Use this simple search guide to identify patients with CKD who are not prescribed an SGLT2i
Search Criteria: 18+years, CKD stages 2-5, prescribed ACE/ARB, no SGLT2i in past 12m. A clinical review is suggested.
Identify at-risk CKD patients
Review for diagnosis & management
Use this simple search to identify at-risk patients
Search Criteria: 40+ years, Existing T2D (HbA1c >7% or metformin), hypertensive (current ACE/ARB), no SGLT2i. A clinical review is suggested.
HEART FAILURE (HF)
How to identify patients with heart failure who may benefit from a review of their treatment in line with guideline-directed medical therapy (GDMT)2
1
IDENTIFY
How to search your practice management software to identify patients,
review records and assess suitability for recall
- In Medical Director
Search 1: HF patients on Entresto, not on an SGLT2i
Search 2: HF patients not on an SGLT2i
- In Best Practice
Search: HF patients not on an SGLT2i
2
RECALL
How to use your practice management software to recall or send reminders to identified patients
3
REVIEW
Access resources on Australian Consensus Statement on management of heart failure.
4
REMIND
How to use your practice management software to automate follow up.
Cardiovascular Hub
Explore resources for the diagnosis and management of heart failure and cardiovascular disease.
Real World Evidence
Explore how Advara HeartCare’s Cardiology Group is transforming HFrEF treatment with real-world implementation of four-pillar therapy and SGLT2 inhibitors
Heart Health Symptom Tracker
A checklist to help patients track heart failure symptoms for more informed consultations
Abbreviations: CKD, chronic kidney disease; GDMT, guidelines-directed medical therapy; HF, heart failure; LVEF = left ventricular ejection fraction; SGLT2i = sodium-glucose transport(protein 2) inhibitor, SQL, Structured Query Language.
References: 1. Kidney Health Australia, Chronic Kidney Disease (CKD) Management in Primary Care (5th edition) 2024. Available at: https://kidney.org.au/health-professionals/ckd-managementhandbook. Accessed October 2025. 2. McDonagh TA et al. 2023 Focused Update of the 2021 ESC Guidelines for the diagnosis and treatment of acute and chronic heart failure
Want to know more?
AstraZeneca is committed to supporting you and your patients.
If you would like further information or have a request for resources not currently available, please request a rep visit below.
CHRONIC KIDNEY DISEASE (CKD)
How to identify patients with CKD not on GDMT
IDENTIFY IN MEDICAL DIRECTOR
How to search your practice management software to identify patients with CKD
IDENTIFY IN BEST PRACTICE
How to search your practice management software to identify patients with CKD not on SGLT2 inhibitors
You might also be interested in
