This folder includes searches and reports designed to help manage large cohorts of patients (e.g. care homes, homeless populations) and track QOF achievement across multiple indicators.
This search needs to be customised to include local care homes. To do this:
Right click the "Care home identification" search and choose Edit.
Find the rules marked with *PCode* and * Insert Street No. of institution here *.
Double click each rule and replace the asterisks with the appropriate postcode and address for each care home.
π Case sensitivity matters. Be sure to enter every variation used in your clinical system (e.g. NR15 2UY, nr152uy, NR152UY) as separate rules.
β Add more homes by copying/pasting rules from the top menu bar.
Once complete, the "Care home QOF identifier" will be active.
The Homeless QOF identifier is based on a register found in the z Denominators folder. It includes patients coded as:
Homeless
Sofa surfing
Squatting
Rough sleeping
Patients can be removed by applying a code from the "Housing ownership and tenure" hierarchy (e.g. Lives in flat, Rented, Own home).
These searches only include patients with outstanding QOF work.
Reports show relevant QOF areas and whether theyβre achieved.
Scroll across to view all columns.
Consider exporting to Excel for highlighting and triage.
π Interpretation requires understanding of QOF business rules.
PCA columns: show both current and previous exception reporting
Asthma: shows review dates and whether one is due
BP required: identifies any QOF condition needing BP monitoring
Statins & Cholesterol: indicates whether statin is prescribed, and shows recent lipid results
COPD: includes review dates, MRC score, and pulmonary rehab coding
Dementia: review dates listed where applicable
Diabetes/NDH/MH: shows HbA1c status, foot check, frailty, and other relevant data
Heart failure: highlights if patient is on ACEI/ARB and beta-blocker
SMI: breaks down each MH021 component: care plan, BMI, alcohol, lipids, smoking, BP
π§ These cohort tools are ideal for practices undertaking care home rounds, QOF clean-up sessions, or targeting hard-to-reach patient groups.