004B Routine QOF work | i Cohort QOF management

004B Routine QOF work | i Cohort QOF management

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.

Warning
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 roundsQOF clean-up sessions, or targeting hard-to-reach patient groups.

    • Related Articles

    • 004B Routine QOF work | * Indicator Navigator | Diabetes

      Diabetes This folder supports opportunistic and end-of-year QOF work across all diabetes indicators, including blood pressure (DM036), HbA1c control (DM020/DM021), statin use (DM034/DM035), nephropathy management (DM006), foot checks (DM012), ...
    • 004B Routine QOF work | f High risk

      This folder highlights patients at increased cardiovascular risk who may be overlooked due to missing current-year data. All patients included have previously recorded elevated values, suggesting ongoing risk, but lack QOF-relevant results this year. ...
    • 004B Routine QOF work

      The 004B Routine QOF work search folder is located within population reporting under the 004 GP Contracts Pro folder. The 004 Routine QOF work folder is divided into 11 main folders (see below), as well as a denominator folder (z Denominators) where ...
    • 004B Routine QOF work | h Previous PCA

      This folder focuses on patients who have not yet achieved an indicator, but have had a relevant PCA recorded within the last 3 years. In this context, PCAs are any indicator specific adjustments (e.g. Maximal tolerated antihypertensive therapy, or ...
    • 004B Routine QOF work | b Weekly activities

      This folder includes a set of reports that should be reviewed weekly to stay on top of QOF targets. Each report identifies patients with incomplete QOF reviews and highlights which elements are missing, allowing practices to complete reviews promptly ...