Query Builders

Below is a list of the most 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.

List all pts with asthma read
Count all pts with asthma read
Count reg pts with asthma read
List all reg pts with asthma read
List all pts with diabetes read
Count all pts with diabetes read
Count reg pts with diabetes read
List reg pts with diabetes read
List all pts with IHD read
Count all pts with IHD read
Count reg pts with IHD read
List reg pts with IHD read
List pts with 12+ consults
Pts given flu between dates
List reg 11yo - no imms
List reg 15mth - no imms
List reg 3mth - no imms
List reg 4-5yo - no imms
List reg 5mth - no imms
List reg 65+ - no flu

 

Count ethnicities for MeNZB vaccinations
Count all patients
Count all pts by age
Count all pts by age_sex
Count all pts by provider
Count all pts by eth
Count all pts by gender
Count reg patients
Count reg pts by age
Count reg pts by age_sex
Count reg pts by provider
Count reg pts by eth
Count reg pts by gender
Count reg pts by GMSbreakdown
List reg pts not seen since date
Cox-2 Inhibitors
Mobic
List reg no cx since da

No Mammogram Recall 65 - 70 years Query Builder

GMS Over 65 Query Builder

SARS Query Builder (April 2003)

This query builder provides a report of patients who may be exhibiting symptoms that could be due to SARS. The query builder looks at the "subjective: consultation note field. You may wish to change the condition of the "date of encounter" and "encounter notes" field to suit your requirements.

© 2009 Medtech Global Ltd

site developed by tasmanit