Clinical Breakdown

If you are is using excel 2010 or older you will not be able to view this report as it has features from Office 365 that causes the report to appear corrupt in the older versions of Excel. If you do have this issue we advise you use a web-based spreadsheet viewer or upgrade to Office 365.

View Sample Report

Summary

This sheet has a summary of the information throughout the report. Note the numbers in this spreadsheet do not match the IPIF report - this is a clinical report that is not constrained by the indicator definitions. There are several tables each detailed below.

Smoking Status

Total Patients Aged over 15 - This is the number of patients who are aged over 15 enrolled in your practice
Current Smoker - This is the number and percentage of patients over 15 currently recorded as current smokers
Ex Smoker - This is the number and percentage of of patients over 15 currently recorded as ex-smokers
Non Smokers - This is the number and percentage of of patients over 15 currently recorded as non-smokers
Not Recorded - This is the number and percentage of of patients over 15 who don't have their smoking status recorded
Total Recorded - This is the number and percentage of of patients over 15 who have their smoking status recorded

Diabetes

Total Patients Aged over 15 - This is the number of patients who are aged over 15 enrolled in your practice
Diabetes Recorded - This is the number and percentage of patients aged over 15 who are recorded as having diabetes
Get Checked in last 12 Months - This is the number of patients who are recorded as having diabetes and have had a DAR in the last 12 months and the percentage of patients who are recorded as having diabetes who have received a DAR in the last twelve months.

CVD

Aged over 15 - This is the number of patients who are aged over 15 on your current register.​​
Eligible Male - This is the number of male patients on your current register who are eligible for a CVDRA.
Eligible Female - This is the number of female patients on your current register who are eligible for a CVDRA.
Total Eligible - This is the total number of patients on your current register who are eligible for a CVDRA.
For all three eligible values there is:
Screened - This is the number of patients who have been screened.
Percentage - This is the percentage of patients in the eligibility criteria who have been screened.

Cervical Screening

Total Female Patients aged 20-69 - This is the number of Female Patients aged 20-69 on your current register.
Screening complete or exempt - This is the number and percentage of female patients aged 20-69 who have been screened or marked exempt in the PMS
Recorded as Refused - This is the number and percentage of female patients 20-69 who have been recording as refusing a cervical screen
Not Recorded - This is the number and percentage of female patients 20-69 who haven't received a screening or aren't recorded as either exempt or refused

Mammography

Total Female Patients aged 45-69 - This is the number of female patients aged 45-69 on your current register.
Screening complete or exempt - This is the number and percentage of female patients aged 45-69 who have been screened or marked exempt in the PMS
Recorded as Refused - This is the number and percentage of female patients aged 45-69 who have been recording as refusing a mammogram screen
Not Recorded - This is the number and percentage of female patients aged 45-69 who haven't received a screening or aren't recorded as either exempt or refused

Ischaemic CVD

Total Patients aged over 15 - This is the number of patients who are aged over 15 on your current register.
Ischaemic CVD Recorded - This is the number and percentage of patients who have Ischaemic CVD recorded

Smoking Status

This sheet has 4 tables; these tables show a pattern of smoking across the practicee.g. higher percentages of 25-29 year old males or higher percentages of Maori who are smokers. This information is important when considering how to target smoking cessation information.

Each table shows the breakdown of the total enrolled patients and their smoking status. Each table has the following columns:
Current Smoker - The number of patients recorded as current smokers
Ex-Smoker - The number of patients recorded as Ex-smokers
Non-Smoker - The number of patients recorded as Non-smokers
Not Recorded - The number of patients who don't have a smoking status recorded.
Patients - Total number of registered patients
% Recorded - The percentage of Registered Patients who have a smoking status recorded

By Age Group

This table has the above columns broken down by the CPI age groups (5 year age bands)

By Ethnicity

This table has the above columns broken down by the main ethnic groups.

By Gender and Age Group

This table has the above columns broken down by the age groups in the Age Group table and then Gender (M or F) as well.

Smoking Status Graphs

Each Graph is on a separate sheet.

Smoking Age Group

There will usually be more people with a smoking status not recorded in the 15-19 age group. Generally the highest current smokers are those aged 20 - 29 years. However when combining the ex smoker and current smoking it is higher in the older age groups, decreasing after 65 (potentially show the impact of smoking on life expectancy)

Smoking Ethnicity

This sheet has a graph of the by Ethnicity table on the Smoking Recorded sheet, generally the rates of smoking are greater for Maori compared to other ethnicities.

Smoking Gender

This sheet has a graph of the by Gender and Age Group table on the Smoking Ever Recorded sheet. These rates reflect those of the age group graph but the rate of smoking for women relative to men is generally lower during child bearing age groups.

Diabetes Ever Recorded

This sheet contains five tables.

The first four tables are broken down by the CPI Age Group.
The ethnicity used in these tables are:
European
Maori
Pacific Island
Indian
Other Asian
Other – This includes Unknown Ethnicity

Ethnicity Count Table
This table shows the number of patients in each age group and each ethnic group who have been recorded in the PMS as having diabetes.

Ethnicity Percentage Table
This table shows what percentage in each age group and each ethnic group have diabetes recorded.

Gender Count Table
This table has a breakdown of patients who have diabetes by gender, please note that patients with unknown gender are not included in this table.

Gender Percentage Table
This table shows what percentage of the total population have Diabetes recorded. This table is broken down in the same columns and rows as the Gender Count Table.

Diabetes Ever Recorded Graphs

Each Graph is on a separate sheet.

Diabetes Ethnicity

This sheet shows the Diabetes Ethnicity Percentage Total from diabetes recorded as a graph.

Diabetes Gender

This sheet shows the Diabetes Gender Percentage table from diabetes recorded as a graph.

Diabetes Get Checked

This sheet contains five tables.

The first four tables are broken down by the CPI Age Group.
The ethnicity categories these tables are:
European
Maori
Pacific Island
Indian
Other Asian
Other – This includes Unknown Ethnicity

Ethnicity DAR in last 12 Months Count Table
This table has a breakdown of the patients who have diabetes by ethnicity.
PI Age Group and each Ethnicity who have received a DAR in the last 12 months.

Ethnicity Percentage Table
This table shows what percentage of Diabetics who have received a DAR in the last 12 months. This table is broken down in the same columns and rows as the Ethnicity DAR in last 12 Months Count Table.

Gender DAR last in last 12 Months Count Table
This table has a breakdown of patients who have received a DAR in the last 12 Months by Gender, please note that patients with unknown gender are not included in this table.

Gender Percentage Table
This table shows what percentage of Diabetics who have received a DAR in the last 12 months. This table is broken down in the same columns and rows as the Gender DAR last in last 12 Months Count Table

Diabetes Get Checked (DAR) Graphs

Each Graph is on a separate sheet .

Get Checked Ethnicity

This sheet shows the DAR Ethnicity Percentage Totals from the Diabetes Get Checked sheet as a graph.

Get Checked Gender

This sheet shows the Diabetes Get Checked Gender Percentage table from the Diabetes Get Checked sheet recorded as a graph.

CVDRA

This sheet has 7 tables.

The first six tables in this sheet contain a breakdown by CPI Age Group.
The ethnicity categories used in the tables in this sheet are:
European
Maori
Pacific Island
Indian
Other Asian
Other – This includes Unknown Ethnicity

Female CVDRA Count Table
This table shows the females who have received a CVDRA broken down by Ethnicity and by CPI Age Group.

Female CVDRA Percentage Table
This table shows the percentage of the eligible female population who have received a CVDRA broken down by Ethnicity and by CPI Age Group.

Male CVDRA Count Table
This table shows the males who have received a CVDRA broken down by Ethnicity and by CPI Age Group.

Male CVDRA Percentage Table
This table shows the percentage of the eligible male population who have received a CVDRA broken down by Ethnicity and by CPI Age Group.

Total Age Group Table
This table shows the percentage of the eligible population who have received a CVDRA broken down by Gender and CPI Age Group.

Total Ethnicity Table
This table shows the percentage of the eligible population who have received a CVDRA broken down by Ethnicity and CPI Age Group

CVDR Population

This sheet has the eligible CVDRA population tables.

There are two tables both breaking down the eligible population by Ethnicity and CPI Age Group. One table shows this information for Males and one for Females.

By Practice table
This table shows the total cvdra eligible population, total population over 15 years old and percentage of the total population over 15 who are CVDRA eligible. It has this information breakdown by practice.

CVDRA Graphs

Each Graph is on a separate sheet .

CVDRA Ethnicity

This sheet has a graph showing the total CVDRA ethnicity percentage.

CVDRA Gender

This sheet has a graph showing the Total Age Group table.

Cervical Screening

This sheet has 3 tables the data is sourced from the PMS, however it has to be noted that not all practice management systems export the result of the screening so if you are using one of those then this information will not be adequately broken down

Every table shows a breakdown in the following columns:
Abnormal Screening
Exempt from Screening
Normal Screening
Unknown
Refused Screening
No Screening
Patients
% Screened

By Age group
This table has the count of female patients and the results of their most recent screening who are in the age range for screening by Age Group.

By Ethnicity
This table has the count of female patients and the results of their most recent screening by Ethnicity

Cervical Screening Graphs

Each Graph is on a separate sheet .

Cervical Screening by Age Group

This spreadsheet contains a graph showing the By Age Group Table and what percentage of each screening result makes up each Age Group.

Cervical Screening by Ethnicity

This spreadsheet contains a graph showing the By Ethnicity Table and what percentage of each screening result makes up each Ethnicity.

Mammography

This sheet has 3 tables show PMS Mammography screening data (This sheet doesn’t include NSU data)

Every table shows a breakdown in the following columns:
Abnormal Screening
Exempt from Screening
Normal Screening
Unknown
Refused Screening
No Screening
Patients
% Screened

By Age group
This table has the count of (I think this is Patients but I’m not actually sure) by Age Group

By Ethnicity
This table has the count (Is it screens or patients) by Ethnicity

Mammography Graphs

Each Graph is on a separate sheet .

Mamm Age Group

This sheet contains a graph showing the By Age Group Table and what percentage of each of (Screening Types) makes up each Age Group.

Mamm Ethnicity

This sheet contains a graph showing the By Ethnicity Table and what percentage of each of (Screening Types) makes up each Ethnicity

Isch CVD

The first four tables in this sheet contain a breakdown by CPI Age Group.
The ethnicities categories used in the tables in this sheet are:
European
Maori
Pacific Island
Indian
Other Asian
Other – This includes Unknown Ethnicity

By Ethnicity Count

This table shows the count of patients who have Ischaemic CVD recorded broken down by CPI Age Group and Ethnicity.

By Ethnicity Percentage

This table shows the percentage of currently registered patients who have Ischaemic CVD recorded broken down by CPI Age Group and Ethnicity.

By Gender Count

This table shows the count of patients who have Ischaemic CVD recorded broken down by CPI Age Group and Gender.

By Gender Percentage

This table shows the percentage of currently registered patients who have Ischaemic CVD recorded broken down by CPI Age Group and Gender.

Isch CVD Graphs

Each Graph is on a separate sheet .

Isch CVD Ethnicity

This sheet has a graph showing the total Ischaemic CVD ethnicity percentage.

Isch CVD Gender

This sheet has a graph showing the total by Gender Percentage table.

Population

This is the raw data that is used for calculating the population figures in all of the sheets. This is based on your current enrolment register.