001 CQRS: 6-in-1 searches

001 CQRS: 6-in-1 searches

Notes
This article assumes the reader has access to CQRS, and can interpret the descriptions of payment indicators.
There are ten 6in1 indicators to report on, which have a complex set of rules. Technically the entire service looks at vaccines containing diphtheria, tetanus, and polio rather than the indicated hexavalent vaccine.
The 6in1 indicators are extracted automatically from your system approximately 10 days after the end of the monthly reporting period. The searches will return data for the claim month from the 25th of the month, until the 24th of the following month (eg: for activity performed in the month of April, use the searches between 25th April and 24th May). This is intended to provide sufficient time for Practices to check and update their data prior to extraction, and review activity once figures are available to declare on CQRS.
Info
The searches are built in a way which means it is not possible to review data in historic months. Practices may consider storing results for future reference.

Service Indicators

Indicator
Description
Lower age limit
Upper age limit (inclusive)
6IN1001
Monthly count of the number of patients who are aged at least 6 weeks old but have not yet attained 10 years old who received a DTaP/IPV/Hib/HepB vaccination administered by the GP practice within the reporting period and this vaccine was their first dose of a Diphtheria, Tetanus, and Polio containing vaccine.
42 days (6 weeks)
Day before 10th birthday
6IN1002
Monthly count of the number of patients who are aged 9 weeks but have not yet attained 10 years old who received a DTaP/IPV/Hib/HepB vaccination administered by the GP practice within the reporting period and this vaccine was their second dose of a Diphtheria, Tetanus, and Polio containing vaccine.
63 days (9 weeks)
Day before 10th birthday
6IN1003
Monthly count of the number of patients who are aged 13 weeks but have not yet attained 10 years old who received a DTaP/IPV/Hib/HepB vaccination administered by the GP practice within the reporting period, and this vaccine was their third dose of a Diphtheria, Tetanus, and Polio containing vaccine.
91 days (13 weeks)

Previous dose must have been at least 56 days prior
Day before 10th birthday
6IN1004
Monthly count of the number of patients who are aged 3 years 4 months old but have not yet attained 10 years old who previously completed the full primary course of Diphtheria, Tetanus and Polio containing vaccines, who received a dose of either DTaP/IPV or dTaP/IPV as their first booster vaccine administered by the GP practice within the reporting period.
40 months (3 years 4 months)
Day before 10th birthday
6IN1005
Monthly count of the number of patients who are aged 10 years and over who received a Td/IPV vaccination administered by the GP practice within the reporting period and this vaccine was their first dose of a Diphtheria, Tetanus, and Polio containing vaccine.
10 years (10th birthday)
No upper age
6IN1006
Monthly count of the number of patients who are aged 10 years and over who received a Td/IPV vaccination administered by the GP practice within the reporting period and this vaccine was their second dose of a Diphtheria, Tetanus, and Polio containing vaccine.
10 years (10th birthday)
No upper age
6IN1007
Monthly count of the number of patients who are aged 10 years and over who received a Td/IPV vaccination administered by the GP practice within the reporting period and this vaccine was their third dose of a Diphtheria, Tetanus, and Polio containing vaccine.
10 years (10th birthday)
No upper age
6IN1008
Monthly count of the number of patients who are aged 10 years and over who received a Td/IPV vaccination administered by the GP practice within the reporting period and this vaccine was their fourth dose (first booster dose) of a Diphtheria, Tetanus, and Polio containing vaccine.
10 years (10th birthday)
No upper age
6IN1009
Monthly count of the number of patients who are aged 10 years and over who received a Td/IPV vaccination administered by the GP practice within the reporting period and this vaccine was their fifth dose (second booster dose) of a Diphtheria, Tetanus, and Polio containing vaccine.
10 years (10th birthday)
No upper age
6IN1010
Monthly count of the number of patients who are aged 18 months but have not yet attained 10 years old who received a DTaP/IPV/Hib/HepB vaccination administered by the GP practice within the reporting period.
18 months
Day before 10th birthday

PCIT authored reports


Payment Reports

Primary Care IT has built a set of searches to support the 6in1 extraction. The main searches closely mirror the business rules, and it is expected that these will forecast the volume of activity recognised for payment by the CQRS count.

Missed Activity

Additional "Missed Activity" searches are provided to highlight additional patients who have not already been counted by the CQRS counts. They are identified by the prefix 6IN1x. Missed Activity searches are NOT built to return a specific service indicator but to capture likely activity based on vaccinations recorded during the month, grouped by a certain characteristic. In the case of 6IN1, this is grouped between under 10s and over 10s. 

There are several reasons why a patient may appear in a "Missed Activity" report instead of a "Payment" report, and these all need to be considered.
  1. The patient is pregnant. Pregnant women will receive a pertussis containing vaccination which is normally covered under the separate Pertussis in pregnant women service on CQRS, which picks up the code Pertussis vaccination in pregnancy. Pregnant patients may be flagged as potential missed activity for 6IN1 if there are no recent codes indicative of a pregnancy.
  2. 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. 
  3. The wrong vaccination or part was added. The business rules are accommodating if 2nd 6-in-1 vaccine has been coded twice, but there are some codes which do not count, including the 5-in-1 vaccine. We recommend using a template to minimise the chances of this occurring.
    Using a 4-in-1 (DTaP/IPV) code for the 5th dose 6IN1009 will not count, and likewise a 3-in-1 (Td/IPV) code used for any dose other than the 5th valid dose will be flagged in Missed Activity.
  4. The patient has been on an alternative schedule. Children who had their course interrupted or delayed may be kept on a 5-in-1 vaccine which is not counted for 6IN1001-6IN1003. Patients who began their childhood vaccinations abroad may have not followed the sequence required by certain indicators.
  5. Patient was too old or too young. 6IN1001-6IN1004 and 6IN1010 are exclusively for children under the age of 10; 6IN1005-6IN1009 are for patients aged 10 or older. The older patients should be receiving DT+polio vaccines and not 6-in-1.
  6. The code was added too early. There are some 21 day, 28 day, 1 month, 1 year minimum intervals which must not be breached. The same principle actually applies to other vaccines such as rotavirus, where payment won't be given if the 2nd dose was given at 27 days.
  7. The patient's historical record is incomplete. Where codes are missing, patients may fall into the wrong denominator. This is most likely to happen for patients in denominators [6IN1005]-[6IN1007].
  8. The patient has already received 5 DTP containing doses in their lifetime. Patients over the age of 10, especially those born in the last 40 years, are likely to have received 5 DTP containing doses during their child and adolescent years. Subsequent doses given for post-exposure prophylaxis are unlikely to be recognised in 6IN1009, and instead will be returned in 6IN1x.
  9. Patients who have received a stem cell transplant. Following a stem cell transplant a patient's immune system is wiped, and an accelerated individualised schedule of childhood type vaccinations is planned. Practices are likely to be asked to deliver these vaccinations, but CQRS is often not designed to accommodate these additional doses.
Idea
Missed activity data offers some opportunities for learning.   Hopefully most entries highlighted by the Missed Activity reports are due to coding which can easily be fixed. Whilst it isn't possible to 'fix' where a vaccination has been given to an ineligible patient, there is an opportunity for reflection and learning to ensure the same scenario is not repeated.
Notes
The Polio Outbreak Campaign in 2022/2023 for children living in London may explain discrepancies between PCIT's 6IN1004 and the figures that CQRS extracts report. The 6IN1x Missed Activity report for under 10s will show patients with no apparent problems with coding or dates.
Children vaccinated as part of the campaign had their 4th DTP containing vaccine much earlier than scheduled. The advice at the time was that the dose was additional, and they should still receive a pre-school booster dose on or after 3 years 4 months. Children are now receiving a 5th dose which is not recognised by 6IN1004. The advice offered to Primary Care IT by NHS Digital was that any additional doses need to be claimed manually.
The Missed Activity searches have been built around vaccinations, while the business rules allow for codes OR medication issues. Using vaccinations in SystmOne helps to offer a more precise vaccination history, but some patients may present with a mixed code and vaccination history especially if they were previously registered with a GP surgery using EMIS Web or Vision. 

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 Missed Activity searches. Where patients appear in the Missed Activity searches, don't discount that there are other factors which erroneously brought the patient into the 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

    • 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 ...
    • 001 CQRS: Advice and Guidance searches

      This article assumes the reader has access to CQRS, and can interpret the descriptions of payment indicators. Unlike most other indicators on CQRS which are extracted automatically from your system approximately 10 days after the end of the monthly ...
    • 034B Eligible for shingles vaccination searches

      This folder now sits within 034 Eligibility. It was previously found in 020 Practice Administration. The shingles eligibility searches were completely re-written to account for the changes to the vaccination programme from September 2023. These ...
    • 004C QOF VI searches (Child & Shingles vaccination uptake)

      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 within the performance searches. Here ...
    • 001 CQRS: COVID vaccination

      This article assumes the reader has access to CQRS, and can interpret the descriptions of payment indicators. The COVID vaccination service is new to CQRS for 2026, now primary responsibility for administering seasonal COVID vaccinations has been ...