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 PHO
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 PHO
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 a screened and percentage value.
Screened - This is the number of patients who have had a CVDRA in the last 5 years
Percentage - This is the percentage of patients in the eligibility criteria who have had a CVDRA in the last 5 years

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 spreadsheet has 4 tables; these tables show a pattern of smoking across the PHO e.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.

By Practice

This table has the columns broken down practice.

Smoking Status Graphs

These graphs all combine to 100% for each group with red representing current smokers, orange represent ex-smokers, green represents never smoker and grey status not recorded.

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 spreadsheet has a graph of the by Ethnicity table on the Smoking Recorded spreadsheet, generally the rates of smoking are greater for Maori compared to other ethnicities.

Smoking Gender

This spreadsheet has a graph of the by Gender and Age Group table on the Smoking Recorded spreadsheet. These rates reflect those of the age group graph but the rate of smoking for women relative to men is 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 ethnicities used in these tables are:
European
Maori
Pacific Island
Indian
Other Asian
Other – This includes Unknown Ethnicity

Ethnicity by Age Group Numbers
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.

By Practice
This table shows the number of patients with diabetes recorded by practice.
This table includes all practices with the PHO and includes the total number of patients and the percentage of this population who are recorded as having Diabetes.

Diabetes Ever Recorded Graphs

Each Graph is on a separate sheet and show the percentage of the population who have ever been recorded as having diabetes.

Diabetes Ever Recorded by Ethnicity

It is import to identify which ethnic group has the highest incidence of diabetes in order to tailor the clinical services. Generally the percentage is higher amongst Pacific Island, Indian and Maori ethnicities

Diabetes Ever Recorded by Age and Gender

Not surprisingly there is a big upward trend in diabetes starting around 35 which steadily grows in number, generally men seem to have a higher prevalence than women.

Diabetes Get Checked

This sheet contains five tables.

The first four tables are broken down by the CPI Age Group.
The ethnicities 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

By Practice
This table shows the number of patients who have received a DAR in the last 12 Months by practice. This table includes all practices with the PHO and includes the total number of Diabetics and the percentage who have received a DAR in the last 12 Months

Diabetes Get Checked Graphs

Each Graph is on a separate spreadsheet.

Get Checked Ethnicity

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

Get Checked Gender

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

CVDRA

This spreadsheet has 7 tables.

The first six tables in this spreadsheet contain a breakdown by CPI Age Group.
The ethnicities categories used in the tables in this spreadsheet 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

By Practice
This table shows the total screened patients, total eligible patients and percentage of total eligible patients screened by practice.

CVDR Population

This spreadsheet 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 spreadsheet.

CVDRA Ethnicity

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

CVDRA Gender

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

CX 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 these results should not be taken as absolute - they should be used as a relative measure.

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

By Practice
This table has the count by Practice.

CX Screening Graphs

Each Graph is on a separate spreadsheet.

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 spreadsheet has 3 tables show PMS Mammography screening 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 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 female patients and the results of their most recent screening who are in the age range for screening by Age Group.

By Practice
This table has the count by Practice.

Mammography Graphs

Each Graph is on a separate spreadsheet.

Mammography by Age Group

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

Mammography by Ethnicity

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

Isch CVD

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

By Ethnicity Count

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

By Ethnicity Percentage

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

By Gender Count

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

By Gender Percentage

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

By Practice

This table shows the count of currently registered patients the count of patients who have Ischaemic CVD recorded and the percentage of patients who fit this category. This information is broken down by Practice.

Ischaemic CVD Graphs

Each Graph is on a separate sheet.

Ischaemic CVD by Ethnicity

This sheet has a graph showing the percentage of patients with Ischaemic CVD ever recorded by ethnicity.

Ischaemic CVD Gender

This sheet has a graph showing the percentage of patients with Ischaemic CVD ever recorded by gender and age group.

Population

This is the raw data that is used for calculating the population figures in all of the sheets. This is based on patients enrolled in your PHO with the age calculated as at the end of the quarter.