View Source

Recipe Name:	QIM 1 – HBA1C status for patients with diabetes
Rationale:	Diabetes was the underlying cause of around 10% of all deaths in Australia in 2016 and recent reports show death rates for people with Type 2 diabetes are rising. As part of their care, people with Type 1 and 2 diabetes should have their glycosylated haemoglobin (HbA1c) measured at least every 12 months, or more frequently depending on the level of blood glucose control. Effective management of chronic disease can delay the progression of disease, improve quality of life, increase life expectancy, and decrease the need for high-cost interventions.
Target:	Proportion of regular clients who have Type 1, Type 2 or undefined diabetes and who have had an HbA1c measurement result recorded at the primary health care service within the previous 12 months.
CAT Starting Point:	CAT Open - CAT4 view (all reports) loaded Population Extract Loaded and Extract Pane “Hidden” Filter Pane open and under the ‘General’ tab ‘Active Patients’ (3x <2 years) selected

CAT4 starting point

RECIPE Steps Filters:

In the “Conditions” Tab, under the “Chronic” category, select “Yes" in the Diabetes category. This will select anyone with any type of diabetes.

CAT Recipes > QIM 1 – HBA1C status for patients with diabetes > diabetes_filter.png

Then select the 12 month date range result filter, to only show results that were entered in the last 12 months:

CAT Recipes > QIM 1 – HBA1C status for patients with diabetes > 2019-07-22 15_39_54.png

Click "Recalculate"

Click ‘Hide Filters’

Report Steps

Select the "Pathology/HbA1c" tab

The Pathology/HbA1c report will show the proportion of those without a result in the last 12 months (or longer) under the ‘No HbA1c Recorded’ category:

The HbA1c report will show you the numbers/percentage of your patients Hba1c status and will allow you to measure improvement over time by comparing reports. It will also allow you to see more details of those patients with a result by double clicking on a selected slice of the graph to see the patient details and measurements:

To Export Patient List to Microsoft Excel:

1. Click on the “Export Icon” at the top of the Patient Reidentification window.

2. Click on “Excel”

3. Choose a file name and a location to save to (eg. Create a folder C:/ClinicalAudit/CAT Patient FollowUp)

4. Click “Save”

The steps above will produce a list of patients with contact details in MS Excel which can then be used to:

1. Go back through the individual patient records in the GP Clinical Desktop System (CDS) and update known records

2. Phone patients to update their record

3. Produce a mail merge to recall patients for follow up