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.

The searches have been built to look at the contract year (1st April to 31st March), so it is recommended to run the search WITHOUT a relative run date.

🏠 Care home identification

This search needs to be customised to include local care homes. To do this:

1. Right click the "Care home identification" search and choose Edit.

2. Find the rules marked with *PCode* and * Insert Street No. of institution here *.

3. 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.

🏚️ Homeless register

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).

📋 Care home QOF identifier & Homeless QOF identifier

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.

Key report columns:

• 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.