CQRS: MMR searches

CQRS: MMR searches

Notes
The current version of CQRS: MMR vaccination programme is v5
The MMR vaccination programme service indicators are extracted automatically from your system approximately 10 days after the end of the monthly reporting period. Practices have a short opportunity to check their data prior to extraction and maximise their income potential. For reviewing data in historic months, the relative run date may be any date in the month following the achievement period (eg: for the achievement period of April, any date in May can be selected).

Info
This article assumes the reader has access to CQRS, and can interpret the descriptions of payment indicators; only payment indicator codes are used below.
Indicator
Description
Lower age limit
Upper age limit (inclusive)
MMRV003
Monthly count of the number of patients aged less than 1 year who received an MMR or MMRV vaccination administered by the GP within the reporting period.
No lower age
Day before 1st birthday
MMRV004
Monthly count of the number of patients who are aged at least 1 year who have yet to attain 6 years of age and have not previously been fully vaccinated against MMR or MMRV, who received a first MMR or MMRV vaccination administered by the GP within the reporting period.
1 year (1st birthday)
Day before 6th birthday
MMRV005
Monthly count of the number of patients who are aged at least 1 year who have yet to attain 6 years of age and have not previously been fully vaccinated against MMR or MMRV, who received a second MMR or MMRV vaccination administered by the GP practice within the reporting period.
1 year (1st birthday)

Previous dose must have been given at least 28 days prior
Day before 6th birthday
MMRV008
Monthly count of the number of patients aged at least 1 year who have yet to attain 6 years of age who have previously been fully vaccinated against MMR who received a single dose of MMRV vaccination administered by the GP practice within the reporting period.
1 year (1st birthday)

Previous dose must have been given at least 28 days prior
Day before 6th birthday
MMRV009
Monthly count of the number of patients who are aged at least 6 years of age who have previously been fully vaccinated against MMR who received a single dose of MMRV vaccination administered by the GP practice within the reporting period. 
6 years (6th birthday)

Previous dose must have been given at least 28 days prior
Born on or after 01/01/2015
MMRV010
Monthly count of the number of patients who are aged at least 6 years who have yet to attain 11 years of age and have not previously been fully vaccinated against MMR or MMRV, or with unknown or incomplete vaccination histories, who received a first MMR or MMRV vaccination administered by the GP practice within the reporting period.
6 years (6th birthday)
Day before 11th birthday
MMRV011
Monthly count of the number of patients who are aged at least 6 years who have yet to attain 11 years of age and have not previously been fully vaccinated against MMR or MMRV, who received a second MMR or MMRV vaccination administered by the GP practice within the reporting period.
6 years (6th birthday)

Previous dose must have been given at least 28 days prior
Day before 11th birthday
MMRV012
Monthly count of the number of patients who are aged 11 years and over and have not previously been fully vaccinated against MMR or MMRV, or with unknown or incomplete vaccination histories, who received a first MMR or MMRV vaccination administered by the GP practice within the reporting period.
11 years (11th birthday)
No upper age
MMRV013
Monthly count of the number of patients who are aged 11 years and over and have not previously been fully vaccinated against MMR or MMRV who received a second MMR or MMRV vaccination administered by the GP practice within the reporting period.
11 years (11th birthday)

Previous dose must have been given at least 28 days prior
No upper age

The main searches closely mirror the business rules to properly reflect the CQRS count, but each search is also based on a denominator (dependency) search designed by PCIT to include patients who may not be picked up by the extraction. These are similarly named, but with square brackets (eg: [MMRV003] ). When reviewing the figures prior to CQRS extraction, Practices are looking for the searches to show 100%. When the search is not 100%, Practices can refer to the corresponding report in the Missed Activity folder. It is also possible to use the Check Patient feature to try to understand why a patient has been picked up in the denominator search but not for CQRS. There are several reasons why a patient may not be included in an indicator, and these all need to be considered.
  1. The vaccination was recorded without the GMS qualifier. The business rules require that vaccinations given under GMS should be recorded correctly. Failure to select GMS may lead to the vaccination not being recognised for payment. 
  2. The wrong code was added. The business rules are accommodating if the same MMR vaccine code has been used twice, as long as the code relates to a first dose. There are a number of legacy EMIS codes which do not count. We recommend using a template to minimise the chances of this occurring. 
  3. Patient was too old or too young. The MMR vaccine should be given on or after the child's first birthday. MMRV03 does check for at-risk patients who received a first dose before their first birthday, but for the purposes of a complete schedule any doses given before the first birthday should be ignored (see Green Book Chapter 21). Consider the implications on where a patient may appear - the first dose given after their first birthday is counted as the first dose, not second dose, for most indicators. There is no upper age limit claiming payment on MMR. 
  4. The code was added too early. The second dose of MMR vaccination (MMRV005, MMRV008, MMRV009, MMRV011, MMRV013) must not be given until at least 28 days after the previous dose. Prior to 2026 the second dose isn't given until the patient is 40 months old, but if the first dose is given at 39 months + 2 weeks the second dose can be given 4 weeks later. Payment won't be given if the 2nd dose was administered at a 27 day interval. From 2026 the schedule changes and the doses will be offered closer together, but a minimum gap still applies.
  5. The patient's historical record is incomplete. Where codes are missing patients won't be picked up, so adding certain MMR vaccination codes when the first code isn't present may include the patient in the first dose indicators instead of the second dose.
  6. The patient has previously had single doses. Previously administered single doses of measles or mumps or rubella are ignored as the 'first dose', so only doses of MMR vaccine are counted. In a patient who had single vaccines for measles mumps and rubella 15 years ago, a dose of MMR now is considered the first dose rather than the second.
Idea
Admin staff should be reminded that when recording vaccinations given elsewhere (eg: private clinic) to not select the GMS qualifier as will be incorrectly counted towards the LES. 

The MMR indicators are divided into age groups but share the same criteria:

1st MMR dose
2nd MMR dose
Booster MMRV dose
Age under 1 year
MMRV003
x

Age 1 - 5 years
MMRV004
MMRV005
MMRV008
Age 6 - 10 years
MMRV010
MMRV011
MMRV009
Age 11+ years
MMRV012
MMRV013


Valid codes

1st & 2nd dose codes
Info
1050971000119104 - Measles, mumps and rubella vaccination given
308081000000105 - Measles mumps and rubella vaccination - first dose
38598009 - Administration of measles and mumps and rubella vaccine
505001000000109 - Measles mumps rubella catch-up vaccination
432636005 - Administration of measles and mumps and rubella and varicella vaccine
871909005 - Administration of second dose of measles and mumps and rubella and varicella vaccine

2nd dose codes
Info
170431005 - Administration of booster dose of measles and mumps and rubella vaccine
170432003 - Administration of pre-school booster dose of measles and mumps and rubella vaccine
170433008 - Administration of second dose of measles and mumps and rubella vaccine
433733003- Administration of second dose of measles and mumps and rubella and varicella vaccine

Catch up dose MMRV codes
Info
432636005 - Administration of measles and mumps and rubella and varicella vaccine
871909005 - Administration of second dose of measles and mumps and rubella and varicella vaccine
433733003- Administration of second dose of measles and mumps and rubella and varicella vaccine
 

Missed Activity

Idea
Having run the top folder, check that the report MMRV000X - medication issued but no codes is empty; all of the claiming searches have been built primarily around codes rather than medication issues, and this search/report will identify any patients who had a medication issue last month but there was no corresponding clinical code in the same period. The reason for this is to support good practice of coding vaccinations; not only does this make future reporting easier, it ensures whenever the patient requests their vaccination history that everything is included from the vaccination filter in Care History.

Reports to help review potential data can be found in the Missed Activity folder, named with the indicator code followed by an X. If the searches have run, highlight the report and press View Results from the ribbon or right click for the quick menu.
The missed activity reports for CQRS have been designed in a standard fashion for ease of understanding.
      CHECK - data in the CHECK column means that the codes used are correct, but the patient was either too old or young, or a subsequent dose was given too early or too late. It may be necessary to refer to 
      INVALID - data in the INVALID column means that activity has been found but with a different code that may indicate claimable activity. This column only focuses on the code and not on the age or the interval, meaning the report may need to be re-run or work out the time criteria yourself offline.
There may be a few scenarios where data appears in both CHECK and INVALID columns due to the way missed activity reports have been configured; prioritise CHECK before considering wither INVALID contains claimable activity.
The MMR reports contain a column on the right hand side which will list any single dose vaccinations coded to support decision making.


Warning
Always check the 0% searches to ensure that single patients from the denominator are not missed!
The Full Hierarchy button on the ribbon can make checking the parent searches of 0% searches easier.


Review the CQRS article for points to consider when using these searches.

The business rules and code cluster lists for enhanced services can be found on the NHS Digital website.

Warning
While the main searches have been built to closely mirror the business rules, there is a creative element to the denominator searches. Where the main search isn't 100%, don't discount that there are other factors which erroneously brought the patient into the denominator search. PCIT is always happy to hear about problems, but is unable to assist with every query why a specific patient is/isn't included.

Version History

v5 - full update of indicators based on April 2025 ruleset. Introduced GMS flag requirement to all indicators.
v4.1 - added criteria to ignore autofiled reports
    • Related Articles

    • 001 CQRS searches

      CQRS extracts data from the clinical system to support payment and management of various Enhanced Services. The automation of these monthly reports saved Practices having to construct their own searches, which did not always accurately reflect the ...
    • 004C QOF VI searches (Child & Shingles vaccination uptake)

      The current version of QOF VI is v4 Unlike all other QOF indicators there are no declined codes for childhood vaccination indicators (VI001, VI002, VI003). There are however exclusion criteria to remove patients recently registered with the surgery ...
    • CQRS: Learning Disability searches

      The current version of CQRS: Learning Disability Health Check Scheme is v1 The Learning Disability Health Check scheme indicators are extracted automatically from your system approximately 10 days after the end of the monthly reporting period. ...
    • CQRS: Rotavirus searches

      The current version of CQRS: Rotavirus vaccination programme is v5 The rotavirus service indicators are extracted automatically from your system approximately 10 days after the end of the monthly reporting period. Practices have a short opportunity ...
    • CQRS: Men ACWY searches

      The current version of CQRS: Meningococcal ACWY vaccination is v5 The meningococcal ACWY service indicator is extracted automatically from your system approximately 10 days after the end of the monthly reporting period. Practices have a short ...