We have recently made some updates to our CQRS Reports. These have been redesigned based on user feedback.

These new reports are currently available in a 'New' folder 'Reporting > Clinical Reporting > Contracts | 2023 24 | CQRS NEW'. The earlier versions have been left in place to help with the transitional.The reports have been built based on either the current month or the previous month. It is worth taking into consideration when using these reports that data is extracted by TPP to CQRS around the 10th of each month. You will notice that we have only built reports for the current month and the previous month and will no longer be creating separate reports for each month. This is due to the size of the reports and the load that they potentially add to the SystmOne Servers.

The Ardens CQRS reports are not designed to act as payment reports and for many reasons will often not match the numbers reported by CQRS for payment. These reports have been put in place to help practices with possible data quality issues with the aim of increasing monthly claims through missed activity not identified by the CQRS data extraction reports. As these have fewer business rules and requirements applied they will include more activities that, after further investigation, potentially could be claimed for.      

'Current month | Not predicted to be in Extract'

These reports are your work to-do list and will show patients who have been vaccinated in the current month but for whatever reason are not predicted to be identified by CQRS for payment. The work identified in this set of reports will not have been extracted to CQRS yet so there is time to review records and take action to correct any data quality issues.

Please note: These reports are very complex and may take a while to run. Rather than trying to run them all at once, it might be advisable to run these in small batches

'Current month | Predicted to be in Extract'

These reports will show you what we believe will be included in the next scheduled CQRS extraction. 

'Previous month | Not predicted to be in Extract'

These reports are your lists of patients who have been vaccinated in the previous month but for whatever reason were not identified by CQRS for payment. The work identified in this set of reports has already been extracted to CQRS. These records should be reviewed with a view to making a manual adjustment claim, if appropriate.

'Previous month | Predicted to be in Extract'

These reports will show you what has been included in the last CQRS extraction. 

Possible reasons for non-inclusion in CQRS

There are many reasons why an activity is not identified for payment, these are the common reasons

• Vaccination given outside of the schedule requirements
• Wrong vaccine/dose recorded
• Recorded with incorrect event details (elsewhere, PCN administration)
• Wrong age
• Entered too late for extraction but backdated
• Registration status
  
  
  

Please Note: There are no reports for SFLU016, 017 or 018 as these are based on an immediately necessary registration type that we are unable to report on