CQRS: Rotavirus searches

CQRS: Rotavirus searches

The current version of CQRS: Rotavirus vaccination programme is v2
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 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).

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)
ROTA002
Monthly count of the contractors registered patients who have received a first dose of rotavirus vaccine given by the GP practice between 6 weeks and 14 weeks and 6 days of age in the reporting period.
42 days (6 weeks)
14 weeks 6 days
ROTA003
Monthly count of the contractors registered patients who have received a second dose of rotavirus vaccine given by the GP practice between 10 weeks and 23 weeks and 6 days of age in the reporting period.
70 days (10 weeks)

Previous dose must have been at least 28 days prior
23 weeks 6 days

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: [ROTA002] ). 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 wrong code was added. The business rules are very strict and require 'First rotavirus vaccination' code, then 'Second rotavirus vaccination' code. Using the same code twice will not count. The legacy EMIS code 'Rotavirus vaccination' also does not count. We recommend using a template to minimise the chances of this occurring. 'Rotavirus vaccination given by other healthcare provider' also does not count so should not be used by summarisers/coders on records of young children.
  2. Patient was too old or too young. The rotavirus vaccination is exclusively for use in babies. It should not be given before the child is 42 days old, or after 15 weeks (for first dose) and 24 weeks (for second dose). For more information refer to the Green Book Chapter 27b.
  3. The code was added too early. The second dose of rotavirus vaccination (ROTA003) must not be given until at least 28 days after the first dose. Payment won't be given if the 2nd dose was administered at 27 days.
  4. The patient's historical record is incomplete. Where codes are missing patients won't be picked up, so adding 'Second rotavirus vaccination' when the first code isn't present will not count the patient in either ROTA002 or ROTA003.

Missed Activity

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.


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.

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.

    • Related Articles

    • 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 ...
    • CQRS: 6-in-1 searches

      The current version of CQRS: 6-in-1 vaccination programme is v4 There are nine 6in1 indicators to report on, which have a complex set of rules. Technically the indicator set looks at vaccines containing diphtheria, tetanus, and polio rather than the ...
    • CQRS: Men ACWY searches

      The current version of CQRS: Meningococcal ACWY vaccination is v2 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 ...
    • CQRS: HepB searches

      The current version of CQRS: Hep B at risk vaccination programme is v2 The Hepatitis B at risk (newborn) service indicators are extracted automatically from your system approximately 10 days after the end of the monthly reporting period. Practices ...
    • CQRS: Meningitis B searches

      The current version of CQRS: MenB vaccination programme is v3 The MenB 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 ...