Below is a list of the common query builders used in most practices. Please click on the required heading to begin downloading the file. This file needs to be run on the server.
Please note: These queries are now certified and will function on both 32 bit and 64 bit systems.
00 Patient Alert Update
01 List all patients with asthma read
02 Count all patients with asthma read
03 Count reg patients with asthma read
04 List all reg patients with asthma read
05 List all patients with diabetes read
06 Count all patients with diabetes read
07 Count reg patients with diabetes read
08 List reg patients with diabetes read
09 List all patients with IHD read
10 Count all patients with IHD read
11 Count reg patients with IHD read
12 List reg patients with IHD read
13 List patients with 12+ consults
14 Patients given flu between dates
15 List reg 11yo – no imms
16 List reg 15mth – no imms
17 List reg 3mth – no imms
18 List reg 4-5yo – no imms
19 List reg 5mth – no imms
20 List reg 65+ – no flu
21 Count ethnicities for MeNZB vaccinations
22 Count all patients
23 Count all patients by age
24 Count all patients by age_sex
25 Count all patients by provider
26 Count all patients by ethnicity
27 Count all patients by gender
28 Count reg patients
29 Count reg patients by age
30 Count reg patients by age_sex
31 Count reg patients by provider
32 Count reg patients by ethnicity
33 Count reg patients by gender
34 Count reg patients by GMSbreakdown
35 List reg patients not seen since date
36 Cox-2 Inhibitors
37 Mobic
38 List reg no cx since date
39 No Mammogram Recall 65 – 70 years
40 GMS Over 65 Query Builder
41 SARS