Identifying Missing Data Network Contract DES 24/25 in CQRS National Guide

Overview

This guide describes how to check what data is missing from your Network Contract DES (NCD) 2024/25 achievement.

Step by step guide

Once logged into CQRS, click on the ‘Data Submission’ tab

  • Choose the relevant financial year – 24/25
  • Select the quality service from the drop down box – DES— Annual—Network Contract DES 2024/25
Screenshot from CQRS National showing Record Achievement and financial year dropdown with Network Contract DES quality service and achievement date
  • From the list of achievement dates select 31/03/2025
Screenshot from CQRS National showing Quality Service Network Contract DES 2024/25 with two columns showing achievement dates and last updated
  • If 31/03/25 does not appear in the achievement date list ensure you have the correct service selected.
  • If it still does not appear select it from the “Achievement Date” drop down and click “Add New Achievement”
Screenshot from CQRS National showing Achievement date with date dropdown and 'add new achievement' button
  • Once selected you will need to make sure all indicators submitted are the total possible value you can submit e.g. 2 of 2. If they are not equal, you will need to click into the group and enter the missing indicator data.
Screenshot from CQRS National showing an Indicator Group table for Network Contract DES with Payment and Management Information and columns for indicators submitted, indicators in progress and last updated date

Date updated: 10 February 2025

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

User Roles in CQRS National

This job aid describes the steps required to check the user roles you have on CQRS. It also describes the responsibilities of each role.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

Checking User Roles

  1. You can check which user roles you are currently assigned by going to My Account from the top of the CQRS window.
Screenshot from CQRS National showing My Account tab top right of page

2. Expand the organisation you are assigned to, to see the role(s) you have been assigned.

Screenshot from CQRS National showing Organisation Access and user roles assigned

User Role Responsibilities

Advanced User Administrator

Training Module: Module 10 (CQRS Administration)

Commissioning Organisation (Area Team)

This role is for setting up and managing user access on CQRS.

A user with this role can manage users for both the Area Team and all the GP practices administered by the Area Team.

Service Provider (GP practice)

Not applicable

User Administrator

Training Module: Module 10 (CQRS Administration).

Commissioning Organisation (Area Team)

This role is for setting up and managing user access on CQRS.

A user with this role can manage users for the Area Team only.

Service Provider (GP practice)

This role is for setting up and managing user access on CQRS.

A user with this role can manage users for the GP practice only.

Finance View*

Training Module: Module 9 (Running Pre-defined Reports)

Commissioning Organisation (Area Team)

This role allows users to view the achievement for QOF, DES, and other supported Quality Services of all the GP practices administered by the Area Team.

Service Provider (GP practice)

This role allows users to view the achievement for QOF, DES, and other supported Quality Services for the GP practices.

View*

Training Module: Module 9 (Running Pre-defined Reports)

Commissioning Organisation (Area Team)

This role allows users to view points (but not pounds) achievement for QOF, DES, and other supported Quality Services of all the GP practices administered by the Area Team.

Service Provider (GP practice)

This role allows users to view points (but not pounds) achievement for QOF, DES, and other supported Quality Services for the GP practices.

Achievement Entry*

Training Module: Module 6 (Entering Achievement Data Manually)

Commissioning Organisation (Area Team)

This role allows users to manually enter achievement data for the GP practices administered by the Area Team.

Service Provider (GP practice)

This role allows users to manually enter achievement data for the GP practice where the data is not being supplied by GPES.

Commissioning Management*

Training Module: Module 4 (Participation Management for Commissioning Organisations)

Commissioning Organisation (Area Team)

This role allows users to commission QOF, DES, and other CQRS-supported Quality Services from the GP practices administered by the Area Team.

Service Provider (GP practice)

Not applicable

Service Management*

Training Module: Module 5 (Participation Management for Service Providers)

Commissioning Organisation (Area Team)

Not applicable

Service Provider (GP practice)

This role allows users to accept the Area Team offers of the QOF, DES, and other CQRS-supported Quality Services for the GP practice.

Declaration Management*

Training Module: Module 7 (Achievement and Payments for Commissioning Organisations)

Commissioning Organisation (Area Team)

Not applicable

Service Provider (GP practice)

This role allows users to confirm that their GP practices achievement for a Quality Service recorded on CQRS is correct and can be used for payment.

Approval Management*

Training Module: Module 8 (Achievement and Payments for Service Providers)

Commissioning Organisation (Area Team)

This role allows users to confirm that the achievement for a Quality Service recorded on CQRS for a GP practice administered by the Area Team is correct and can be used for payment.

Service Provider (GP practice)

Not applicable

Finance Management*

Training Module: Module 8 (Achievement and Payments for Service Providers)

Commissioning Organisation (Area Team)

This role allows users to confirm that a payment should be made for a Quality Service to a GP practice administered by the Area Team.

Service Provider (GP practice)

Not applicable

Supervisor

Training Module: Module 10 (CQRS Administration)

Commissioning Organisation (Area Team)

This role allows a user to see all the outstanding CQRS tasks and messages for their Area Team.

Service Provider (GP practice)

This role allows a user to see all the outstanding CQRS tasks and messages for their GP practice.

Organisation Administrator

Training Module: Module 10 (CQRS Administration)

Commissioning Organisation (Area Team)

This role can create and update organisations for descendant organisations.

This role controls creating Service Provider Clusters and Allocated Report access.

Service Provider (GP practice)

Not applicable

*These roles can be restricted by the Payment Type (for example QOF, DES).

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Restricting user access using a Service Provider Cluster in CQRS National

A user may be restricted to specific organisations under a parent organisation through Service Provider Clusters. When a user is assigned to cluster, they may only access organisations listed in the cluster(s) along with the organisations descendants, even though they are not specifically listed in the cluster.

This job aid will demonstrate the steps for restricting user access with Service Provider Clusters.

This job aid is aimed at CQRS User Administrator and Advanced User Administrator who are responsible for overseeing and modifying user’s access to the CQRS system.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

  1. From the CQRS Home screen, select the Administrative Tasks tab, then select the Manage Org’s & Users sub-tab, and then select the Users sub-tab.
Screenshot from CQRS National showing Administrative Tasks menu item, Manage Org's & Users Tab and Users sub tab

2. Click the Name link of the user to update.

Screenshot from CQRS National showing Users sub tab with Name link highlighted

3. If the organisation is not already listed for the user, select the Add Organisation button on the User Details screen.

Screenshot from CQRS National showing user details screen

Once the organisation is added, available clusters will display under the organisations information along with the roles and payment types. If clusters have not been created for the organisation, a default message of “There are no Provider Clusters defined for this organisation” will display.

Screenshot from CQRS National showing Service Provider Clusters

4. Click the checkbox for the cluster(s) you want to assign the user to.

5. Click the Submit button at the bottom of the page.
A confirmation indicates that the user was successfully updated.

Screenshot from CQRS National showing confirmation message

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Adding or removing allocated reports in CQRS National

Ordinarily, Descendant Organisations are not allowed to run reports for services commissioned by their Parent Organisations. However, using the Allocated Reports functionality Parent Organisations may give permission to selected Descendant Organisations to view specific report information.

This job aid is aimed at users within a Commissioning Organisation with the role of Organisation Administrator.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

Adding Allocated Reports

  1. From the CQRS Home screen, select the Administrative Tasks tab, then select the Manage Org’s & Users sub-tab, and then select the Allocated Reports sub-tab.
Screenshot from CQRS National showing Admin Tasks menu, Manage Orgs & Users tab and Allocated Reports sub tab

All Descendant Organisations are displayed. You may search for specific organisations using the Search by function.

2. Select the Descendant Organisation you wish to grant allocated report permissions to by clicking on the Organisation ID link.

Screenshot from CQRS National showing Allocated Reports tab and Org ID link

3. Select one or more Quality Services to be allocated to the Descendant Organisation. To allocate all Quality Service, use the Select All checkbox.

Screenshot from CQRS National showing Allocated Reports tab and select quality service list

NOTE: Quality Services can be filtered by Financial Year and/or Payment Type.

4. Select the Submit button.

5. A confirmation message will display at the top of the screen to indicate the allocations have been saved. Now when the Descendant Organisation runs a report for the selected service, information from the Parent Organisation’s commissioned services will be included.

Screenshot from CQRS National showing confirmation message

Removing Allocated Reports

To remove reports from being allocated to an organisation, follow the same steps outlined above.

  1. From the CQRS Home screen, select the Administrative Tasks tab, then select the Manage Org’s & Users sub-tab, and then select the Allocated Reports sub-tab.

2. Select the Descendant Organisation.

3. Once on the Select Quality Service screen, the list of Quality Services will display with checkmarks beside the services allocated.

4. To remove the service from allocation, simply remove the checkbox beside the Quality Service.

5. Click the Submit button at the bottom of the page.

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

CQRS National Network Contract DES 21-22 Tick-Box Indicators

1. The overall payment value that you will approve is calculated after the data extracted from the GP Clinical system, via GPES is loaded into CQRS automatically.

2. The Commissioner and Financial Commissioners shall approve the outcomes of the full Network Contract Des 21/22 Service payment calculation including the tick-box indicator, which is allocated 220 points.

3. The following indicator is the tick-box indicator in the Network Contract Des 21/22 Service – COV-01 (NCD009)

4. The PCN user will see the tick-box indicator as follows:
You will then be able to use the drop-down to change this to a ‘Yes’ or ‘No’.

Screenshot from CQRS National showing tick box indicator: Yes / No

5. The GP Practice will see the tick-box indicator as follows:

As we can see, no action is required by the GP Practice for this indicator.

Screenshot from CQRS National showing tick box indicator: Yes / No (no entry allowed, this item is entered at PCN level)

6. Please note that this indicator will default to ‘No’ if it is not actioned by the PCN ahead of the data being loaded into CQRS by the GP Clinical System, via GPES.

7. If the Commissioner has not financially approved the payment, the drop-down selection can still be updated by the Commissioner after the extract has taken place, and the calculated payment value will update.

8. If the PCN has not declared the payment, the tick-box can still be updated by the PCN lead after the extract has taken place and the calculated payment value will update.

9. If a ‘Yes’ value is submitted for the 28 February 2022 achievement date, then this will continue to be ‘Yes’ as part of the calculation that will use the 31 March 2022 achievement data, unless this drop-down is changed to ‘No’, prior to the declaration taking place as detailed above in points 6 and 7.

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Removing an Organisation from a Service Provider Cluster in CQRS National

Once a Service Provider Cluster is created, you may remove organisations from the cluster. This job aid will review the steps for that task.

This job aid is aimed at users within a Commissioning Organisation with the role of Organisation Administrator.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

  1. From the CQRS Home screen, select the Administrative Tasks tab, then select the Manage Org’s & Users sub-tab, and then select the Service Provider Clusters sub-tab
Screenshot from CQRS National showing Administrative tasks tab and manage organisation and users sub tab with Service Provider Clusters highlighted

2. Click the Short Name of the Service Provider Cluster to update.

Screenshot from CQRS National showing Service Provider Clusters sub tab with Short Name field highlighted

The Service Provider Cluster screen displays. Scroll down to view the Service Providers section.

3. Click the Remove Organisation link for the organisation you want to remove.

Screenshot from CQRS National showing Service Providers list and Remove Organisation button alongside organisation

The Service Providers list updates to show the selected service provider will no longer be included in this cluster.

4. Once all updates have been made, you must click the Submit button at the bottom of the page to commit your changes.

Screenshot from CQRS National showing Service Providers list for removal and submit button to make changes

A confirmation message indicates the cluster was updated successfully.

Screenshot from CQRS National showing confirmation message

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Declaring an achievement for payment in CQRS National

At the end of each payment period, a provisional payment is calculated by CQRS based on the data submitted by you in your capacity as a Service Provider.

To be sure payments are accurate, they are reviewed and agreed by the Service Provider and Commissioning Organisation before being paid.

Current achievement for each Quality Service in which you are participating can be viewed and reviewed from the Achievement Results sub-tab.

This job aid is aimed at Service Providers with the role of ‘Declaration Management’ who declare Quality Services for payment.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

  1. From the CQRS Achievement screen, select the Declare sub-tab.
Screenshot from CQRS National showing Achievement screen and Declare sub tab

If a payment declaration is awaiting Service Provider approval, you may update the Notes field and/or approve the payment declaration.

Some payment configurations may be designated as No Declaration Required, which automatically approves the payment declaration without action by you. Configurations may also be designated as No Approval Required, which automatically approves the payment declaration without action by the Commissioning Organisation.

2. If required, details of the declaration can be generated by selecting the Run Achievement Summary Report link in the upper right corner of the screen.

Screenshot from CQRS National showing Participation Management Payment Declaration screen with Run Achievement Summary Report link

3. To declare the achievement, select the checkbox to the left of the relevant Quality Service.

Screenshot from CQRS National showing Payment Declaration screen with checkbox and Declare Achievement button

4. Select the Declare Achievement button.

5. A confirmation message displays to confirm that the payment declaration request has been successfully submitted and is awaiting approval by the Commissioning Organisation.

Screenshot from CQRS National showing payment declaration confirmation message

NOTE: The newly declared achievement moves to the Payment Declaration History panel at the bottom of the screen with a status of “Awaiting Commissioning Organisation Approval.” Notification of the declaration is transmitted to the Commissioning Organisation. They will review and, if appropriate, approve the achievement.

Screenshot from CQRS National showing Payment Declaration History and awaiting commissioning organisation approval status

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Viewing and approving a final Achievement and Payment Declaration in CQRS National

At the end of each payment period, a provisional payment is calculated from the submitted achievement data. To be sure the payments are accurate, they are reviewed and agreed upon by the Service Provider and Commissioning Organisation before being paid.

Once approved and submitted by the Service Provider, you will receive a task notification on the Home screen of CQRS and by email (based on your notification preferences) that the achievement and payment declaration is available for approval or finance approval. 

This job aid is aimed at Commissioning Organisations with the role of ‘Approval Management’ and/or ‘Finance Management’ who approve final achievement and payment declarations.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

  1. From the CQRS Home screen, select the Achievement tab.
  2. Select the Declaration Management sub-tab.
Screenshot of CQRS National Declaration Management sub-tab

NOTE: If the Quality Service to be approved is not displayed, the Status and/or Quality Service filters can be used to manipulate which Quality Services are displayed.

3. Locate the required Quality Service and select the checkbox next to it. You may approve multiple achievements by selecting the relevant checkboxes or approve all the Quality Services by selecting the Select All checkbox.

4. Select the Approve button.

5. CQRS displays a confirmation message that the payment declaration has been successfully approved.

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Available Reports in CQRS National

The following information describes reports available in CQRS National.

Achievement Reports

Shows the Contracted Registered Population data held on CQRS for a GP practice for the selected quarter, including gender and age breakdown.

Instructions:
Select Reports tab and then Achievement sub tab.
Click Service Provider Population Report link.
On the next page select year and quarter you require data for.
Select practice(s) required (For RLO and ICBs only).
You can search via Parent Org name or ‘Select All’ practices. (For RLO and ICBs only).
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
GP Practices
Shows data entry for practices relating to achievement dates. Within this report you can drilled down to show the achieved pounds and the individual indicator information.

Instructions:
Select the Reports tab then the Achievement sub tab.
Select the Provider Achievement link.
Select the relevant financial year and the relevant quality service from the drop down box.
Select practice(s) required. Option to search via Parent Org name is available or you can ‘Select All’ practices.
Select a valid achievement date and measurement info required.
Click “Run Report”.
To view further information on a Practice click on the practice code shown on the report.
Each column can be drilled down into by clicking on its title to show further details.

Available to:
Regional Local Offices and ICBs
Provides information on how many checks were completed cumulatively. Report shows input data from multiple practices.

Instructions:
Select the Reports tab then Detailed Provider Achievement’ on the achievement sub tab.
Set the relevant financial year.
Select Service (e.g. Learning Disabilities).
Select All practices.
Select relevant Achievement.
Run the report for Exporting.
At the foot of the report, drill down into ‘LDGROUP’.
At the foot of the report, drill down into ‘Payment’.
At the foot of the report, drill down into ‘LD001’.
Click “Run Report”.
Practice(s) can be drilled down into by clicking the practice code shown on the report.
At the bottom of the report is a list of the groups making up the report totals. These can be drilled down into by clicking on their name to show further details.

Available to:
Regional Local Offices and ICBs
Presents exception/exclusion information for all practices selected. There is an option to click into the organisation ID to view further info; can then click into the domains and the individual indicators.

Instructions:
Select the Reports tab then the Achievement sub tab.
Select the Provider Exception/Exclusion link.
Select the relevant financial year and the quality service (usually QOF) from the drop down box.
You will then be given option to select practice(s) which can be searched via Parent Org and Select All.
Select the achievement date you would like to view data for from the drop down box.
Click “Run Report”.
Each column can be drilled down into by clicking on its title to show further details.

Available to:
Regional Local Offices and ICBs
Exception/exclusion info will be presented with option to click into the domains and the individual indicators.

Instructions:
Select the Reports tab then the Achievement sub tab.
Select the Exception/Exclusion link.
Select the relevant financial year and the quality service (usually QOF) from the drop down box.
Select the relevant achievement date.
Click “Run Report”.
Each row can be drilled down into by clicking on its title to show further details.

Available to:
Regional Local Offices and ICBs
GP Practices
Shows full details of an achievement per service and achievement date. Useful for QOF achievement as the report has the option to drill down into each domain / indicator to view individual achieved points and prevalence figures.

Instructions:
Select the Reports tab, which will default to the Achievement sub tab underneath.
Select the “Achievement Summary” link.
Set the relevant Financial Year.
Ignore the DES, LES, LQI, QOF boxes.
Select Quality & Outcome Framework (QOF) from the drop down menu.
Select practice required. Option to search via Parent Org name.
Select the relevant Achievement Date from the drop down box.
Ignore the formatting option.
Click “Run Report”.
Each row can be drilled down into by clicking on its title.

Available to:
Regional Local Offices and ICBs
GP Practices
Shows the achieved points/pounds per month/quarter per practice.

Instructions:
Select Reports tab then Achievement sub tab (default sub tab).
Click the Provider Achievement Trend link.
Select the relevant financial year and the quality service from the drop down boxes.
You will then be given option to select practice(s) which can be searched via Parent Org and Select All.
Select the Frequency (monthly or quarterly) and the Measurement (points, pounds or max points).
Click “Run Report”. At the bottom of the report is a list of the groups making up the report totals. These can be drilled down into by clicking on their name.

Available to:
Regional Local Offices and ICBs
The report shows all submitted data and payments for the selected GP practice for a single year.

Instructions:
Select Reports tab then Achievement sub tab (default sub tab).
Click on Annual Activity Summary.
Select relevant Financial Year (defaults to current).
Choose Payment Type(s) required.
To display Management Information in the report tick the MI option.
Select the relevant GP Practice.
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
GP Practices
Shows all data held in CQRS needed for the service. e.g. Register, Registered Patients, Care Plan, Patients over18, Departed Patients.

Instructions:
Select Reports tab then Achievement sub tab (default sub tab).
Click on Avoiding Unplanned Admissions.
From the drop down select the relevant month.
Select the relevant GP Practice(s).
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
GP Practices

Declaration Reports

This report will show the status of the payments. It will also show if the practice has submitted data or not, on a month to month basis for the whole financial year.

Instructions:
Select the reports tab, then declarations tab.
Click on the payment declarations link.
Select the relevant financial year.
Select the payment type you require.
Select practice required. Option to search via Parent Org name is available.
Select the declaration status required.
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
GP Practices
Shows information regarding the Quality Outcomes Framework (QOF) aspiration payments per individual practice.

Instructions:
Select the Reports tab then the Declarations sub tab.
Select the Aspiration Payment Declaration link.
Select the relevant financial year.
Select which payment type required.
Select practice required. Option to search via Parent Org name is available.
Select the required declaration status.
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
GP Practices
Shows information regarding the QOF aspiration with the option to view multiple practices’ data.

Instructions:
Select the Reports tab then the Declarations sub tab.
Select the Provider Aspiration Payment Declaration link.
Select the relevant financial year, Service and payment period.
Select organisation(s). Option to search per Parent Org and Select All.
Declaration Status can be set to ‘All’ or changed to reflect what information is required.
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
Shows declaration statuses of multiple practices for a particular service.

Instructions:
Select the Reports tab then the Declarations sub tab.
Select the Provider Payment Declaration link.
Select the relevant financial year, the quality service and the payment period.
Select organisation(s). Option to search per Parent Org and Select All.
Declaration Status can be set to ‘All’ or changed to reflect what information is required.
Click “Run Report”.

Available to:
Regional Local Offices and ICBs

Participation Management Reports

Shows the status of service offers to GP practices.

Instructions:
Select the Reports tab, then the Participation Management sub tab Select the Provider Participation link.
Select the DES Payment type. The select all function on this screen will select all practices.
Select run for exporting.
Click “Run Report”.

Available to:
Regional Local Offices and ICBs

Data Entry Reports

Show the latest automatic and manual submission dates and the relevant achievement dates. If you want details for a single achievement date set both the start and end dates to that date.

Instructions:
Select the Reports tab then the Data Entry sub tab.
Select the Data Submission link and select the relevant financial year.
Select a service from the drop down box and select a practice/practices required.
Use the default service dates or select the dates required.
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
Shows which GP practices have completed their manual indicators. While different quality services can be selected it is specifically written for QOF.

Instructions:
Select the Reports tab then the Data Entry sub tab.
Select the Data Entry Quality Service Data Complete link.
Choose the QS from the drop down box. These are listed in short format (e.g. LD1415 for Learning Disabilities Health Check Scheme).
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
Shows which GP practices have not completed their manual indicators. While different quality services can be selected it is specifically written for QOF.

Instructions:
Select the Reports tab then the Data Entry sub tab.
Select the Data Entry Quality Service Data Missing link.
Select the QS from the drop down box. These are listed in short format (e.g. LD1415 for Learning Disabilities Health Check Scheme).
Click “Run Report”.

Available to:
Regional Local Offices and ICBs

Administrative Reports

User Access per organisation.

Instructions:
Select the Reports tab, then the Administrative sub tab.
Run the Organisation – User report.
Once the report opens it allows specific parameters to be selected, select the relevant date and search for a specific Organisation ID. Ensure the radio button to the left of the required organisation name has been selected.
The user status dropdown box allows you to select particular statuses, or Select All to show all users regardless of their current status.
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
GP Practices
Shows a list of users with their names, IDs, status and last log in date.

Instructions:
Select the Reports tab, then the Administrative sub tab.
Click the Multi Organisation User link.
Select the Organisation required.
Enter a Start and End Date, tick the Roles and select the User Status required
Click “Run Report”.

Available to:
Regional Local Offices and ICBs
GP Practices

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Working with pre-defined reports in CQRS National

CQRS enables you to retrieve data based on a combination of criteria (e.g. Quality Service, Financial Year, Achievement Date, etc.). Once retrieved, you can view, print or save the results. These are known as pre-defined reports and are accessed from the Reports tab on the CQRS Home screen. It is important to note that your CQRS user role determines which reports you can view and run.

This job aid outlines the report categories and basic steps required to run, save and export a pre-defined report.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

Report Categories

Pre-defined reports are grouped into four categories and can be accessed from the sub-tabs under the Reports tab on the CQRS Home screen.

Image from CQRS National showing Reports tab

Each sub-tab has two elements:

A. Run a Report. This panel contains topic specific links to pre-defined reports.
B. Previously Run. This displays topic-specific reports that you have previously run and saved.

Screenshot from CQRS National showing Predefined Reports Run a Report screen

Running a Pre-defined Report

  1. Navigate to the sub-tab containing the pre-defined report (See CQRS Job Aid: CQRS Available Reports for a list of available pre-defined reports based on role).
  2. Select the pre-defined report link.
  3. Before you can run a report you must specify the search parameters against which CQRS will filter records that will be displayed in the report.
Screenshot from CQRS National showing search parameters screen

NOTE: Available search parameters will depend on the type of report you are running.

4. Select the Run Report button.

5. Pre-defined reports display in a new browser tab.

Screenshot from CQRS National showing pre-defined reports achievement report results

Note: The report window scrollbars allow you to move up and down or left and right to view the report.

6. Note that you can drill down and view a sub report on Domains by selecting the underlined Domain name listed in the first column.

Screenshot from CQRS National showing domains choice

7. Sub reports will appear in new browser tabs. Use these tabs to move back through previous reporting windows.

Saving a Pre-defined Report

8. Select the Save button in the report window.

9. Saved reports are retained for 30 days from the date they were first run and can be re-run from the Previously Run panel without the need to set parameters. Reports are saved with the date they were first run appended to the report name.

Exporting a Pre-defined Report

CQRS provides three options for exporting reports. Once exported data can be formatted and manipulated to suit your needs.

Screenshot from CQRS National showing report export options

PDF (Portable Document Format) is a widely used file format which can represent documents across a range of software applications and operating systems. It is especially useful if you wish to share the report with others who may not have access to applications such as Microsoft Excel. Note that PDF files have a limitation: They cannot easily be edited or formatted without specialist software.

Excel (XLS) permits you to save a report in a format that is compatible with all versions of Microsoft Excel.

CSV (comma-separated values) reports are exported in plain text format that can be read by most software applications. Use CSV if your spreadsheet or database application is unable to view reports exported in Excel format.

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Creating a Service Provider Cluster in CQRS National

A user may be further restricted to specific organisations under a parent organisation through Service Provider Clusters. When a user is assigned to cluster, they may only access organisations listed in the cluster along with the organisations descendants if applicable.

This job aid is aimed at users within a Commissioning Organisation with the role of Organisation Administrator.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

  1. From the CQRS Home screen, select the Administrative Tasks tab, then select the Manage Org’s & Users sub-tab, and then select the Service Provider Clusters sub-tab.
Screenshot from CQRS National showing Administrative Tasks menu, Manage Orgs & Users sub tab and Service Provider Clusters sub tab

2. Click the Add New Cluster button at the bottom of the primary Service Provider Cluster screen.

Screenshot from CQRS National showing Add New Cluster button

3. On the Create Service Provider Cluster screen, enter a Name and Description for the Cluster. NOTE: Ensure the name is unique and descriptive for the cluster so it is easily recognised.

Screenshot from CQRS National showing name and description fields

4. Add organisations to the cluster by selecting the organisation’s corresponding checkbox. You may select all organisations by using the Select All checkbox. To filter Service Providers, use the Search by function.

Screenshot from CQRS National showing select service providers list

5. Once you have selected the Service Providers, click the Continue button on the bottom of the page.

Screenshot from CQRS National showing continue button

A summary screen will display listing the cluster details and the associated service providers.

6. Using the confirmation box at the top of the page, select Yes to create the service offer or No to return to the Create Service Provider Cluster page.

Screenshot from CQRS National showing yes / no screen

7. A final confirmation will display. Through the confirmation message, you may return to the primary Service Provider Cluster screen by clicking the View Service Provider Clusters link, or you may create another cluster by clicking the create a new Service Provider Cluster link.

Screenshot from CQRS National showing final confirmation message

8. When you return to the primary Service Provider Cluster screen, the new cluster will be listed.

Screenshot from CQRS National showing Service Provider cluster screen with new cluster listed

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Updating a Service Provider Cluster in CQRS National

Once a Service Provider Cluster is created, you may add additional organisations to the cluster. This job aid will review the steps for that task.

This job aid is aimed at users within a Commissioning Organisation with the role of Organisation Administrator.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

  1. From the CQRS Home screen, select the Administrative Tasks tab, then select the Manage Org’s & Users sub-tab, and then select the Service Provider Clusters sub-tab.
Screenshot from CQRS National showing Administrative Tasks menu, Manage Orgs & Users sub tab, and Service Provider Clusters tab

2. Click the Short Name of the Service Provider Cluster to update.

Screenshot from CQRS National highlighting short name in service provider clusters list

3. On the Service Provider Cluster screen, you may modify the Name and/or the Description for the Cluster. The Short Name is system-defined and cannot be updated.

Screenshot from CQRS National showing screen where you can edit name and description of a service provider cluster

4. To add an organisation, click the Add Organisation button.

5. You may add an organisation to the cluster by selecting the organisation’s corresponding checkbox. You may select all organisations by using the Select All checkbox. To filter Service Providers, use the Search by function.

Screenshot from CQRS National showing search by and select all boxes on select service providers screen

6. Once you have selected the Service Provider(s) to add to the cluster, click the Continue button on the bottom of the page.

Screenshot from CQRS National showing continue button on updating cluster screen

Once the organisation(s) is added, you will be transferred back to the Cluster Detail screen. The newly added organisation(s) will be listed in the Service Providers section.

Click the Submit button to save your changes.

Screenshot from CQRS National showing Submit button

A confirmation message indicates the cluster was updated successfully.

Screenshot from CQRS National showing confirmation that cluster was updated successfully

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Viewing Quality Services offered by status in CQRS National

Commissioning Organisations are able to use the Participation Management process to view the Quality Services that have been offered to or withdrawn / cancelled from the Service Providers, as well as Quality Services accepted or rejected by Service Providers. This job aid outlines the steps required to filter and view Quality Services by status.

This job aid is aimed at Commissioning Organisations with the role of ‘Commissioning Management’.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

Viewing an Offered Quality Service

  1. From the CQRS Home screen, select the Participation Management tab and then select the Offered Services sub-tab
Screenshot from CQRS National showing Participation Management menu and offered services tab

NOTE: Quality Services offered in the chosen financial year display by default. Using the Financial Year dropdown, you can filter these by financial year.

2. At this level it is not possible to view which Service Providers have been offered a Quality Service. This can only be achieved by drilling down into individual services. To do this, select the Services link of the Quality Service you wish to view.

Screenshot from CQRS National showing Offered Services tab

3. In the Associated Service Providers panel, you can see which Service Providers have been offered the Quality Service.

Screenshot from CQRS National showing Associated Service Providers

4. The Status dropdown allows you to filter the list of Quality Service offers by:

  • Offered – Sent to the Service Provider by not yet Accepted or Rejected
  • Approved – Accepted by the Service Provider and automatically placed in the status of Approved
  • Rejected – The Service Provider has rejected the Quality Service Offer.
  • Cancelled – Both Cancelled and Withdrawn offers will appear in this list.
Screenshot from CQRS National showing Associated Service Providers Status dropdown

Viewing Quality Services in which a Specific Service Provider is Participating

  1. From the Offered Service detail screen, you can drill down to review all Quality Services in which a specific Service Provider has been offered.
  2. Select the Service Provider Name link to view the details.
Screenshot from CQRS National showing Associated Service Providers name and detail

3. All Quality Services offered to the Service Provider display.

Screenshot from CQRS National showing Service Provider Services quality services offered

NOTE: As with the Quality Service detail screen, the Status dropdown allows you to filter the Quality Services in which this Service Provider has been offered:

  • Offered – Sent to the Service Provider by not yet Accepted or Rejected.
  • Approved – Accepted by the Service Provider and automatically placed in the status of Approved.
  • Rejected – The Service Provider has rejected the Quality Service Offer.
  • Cancelled – Both Cancelled and Withdrawn offers will appear in this list.

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Cancelling a Quality Service in CQRS National

As a Commissioning Organisation, you have the ability to cancel Quality Services that have been accepted or rejected by Service Providers. This job aid outlines the basic steps required to perform this task.

This job aid is aimed at Commissioning Organisations with the role of ‘Commissioning Management’.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

  1. From the CQRS Home screen, select the Participation Management tab and then select the Offered Services sub-tab.
Screenshot from CQRS National showing Participation tab then Offered Services tab and list of services and date offered

NOTE: Offered Quality Services can be filtered by financial year. All Quality Services that have been offered in the current financial year display by default.

2. From the Offered Services list, select the link of the Quality Service you wish to cancel.

Screenshot from CQRS National showing Participation Management tab, Offered Services tab, list of services and date offered and QOF service highlighted

3. Select Approved or Rejected from the Status drop down menu to display the Service Providers who have Accepted or Rejected the offered service. Only services in these two statuses may be cancelled. Services which have been Offered cannot be cancelled but may be Withdrawn.

Screenshot from CQRS National showing QOF Associated Service Providers with box highlighting Status: Offered, Approved, Rejected and Cancelled

4. Locate the Service Provider(s) for whom you wish to cancel the Quality Service offer.

5. Select the checkbox adjacent to the Service Provider(s), and then select the Cancel Service button.

Screenshot from CQRS National showing list of Service providers with ticked checkbox and Cancel Service button highlighted

6. The confirmation message displays to make sure you want to cancel the Quality Service for the Service Provider(s). Select the Yes button.

Yellow highlighted area of screenshot from CQRS National showing Yes button highlighted

An acceptance confirmation message displays, confirming that you have successfully cancelled the Quality Service. Note that selecting the Yes button will trigger a message that tells the Service Provider(s) that the Quality Service has been cancelled.

Screenshot from CQRS National showing tickbox against The selected service(s) have been successfully Cancelled. View Offered Services.

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Withdrawing a Quality Service in CQRS National

As a Commissioning Organisation, you have the ability to withdraw Quality Services that have been offered to Service Providers. This job aid outlines the basic steps required to perform this task.

This job aid is aimed at Commissioning Organisations with the role of ‘Commissioning Management’.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

  1. From the CQRS Home screen, select the Participation Management tab and then select the Offered Services sub-tab.
Screenshot from CQRS National showing Participation Management tab and Offered Services sub tab

NOTE: Offered Quality Services can be filtered by financial year. All Quality Services that have been offered in the current financial year display by default.

2. From the Offered Services list, select the link of the Quality Service you wish to withdraw.

Screenshot from CQRS National showing Offered Services tab and QOF service highlighted

3. Select Offered from the Status drop down menu to display the Service Providers who have the offered service.

Screenshot from CQRS National showing QOF Status dropdown box

4. Locate the Service Provider(s) for whom you wish to withdraw the Quality Service offer.

5. Select the checkbox adjacent to the Service Provider(s), and then select the Withdraw Service button.

Screenshot from CQRS National showing Withdraw Service button

6. The confirmation message displays to make sure you want to withdraw the Quality Service for the Service Provider(s). Select the Yes button.

Screenshot from CQRS National showing withdraw a service yes button

An acceptance confirmation message displays, confirming that you have successfully withdrawn the Quality Service. Note that selecting the Yes button will trigger a message that tells the Service Provider(s) that the Quality Service has been withdrawn.

Screenshot from CQRS National showing withdraw a service acceptance message

NOTE: Once the offer has been withdrawn, it will appear under the Cancelled status. Select Cancelled from the Status drop down menu to display service offers both cancelled and withdrawn.

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Viewing, accepting and rejecting a Quality Service offered in CQRS National

Service Providers are alerted that a Quality Service offer has been made to them by the Message Centre on the CQRS Home screen. This job aid outlines how to view offered services and how to accept or reject them.

This job aid is aimed at Service Providers with the role of ‘Service Management’.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

Viewing Offered Quality Services

  1. Offered Quality Services appear in your CQRS Message Centre as a new task.
Screenshot from CQRS National showing offered quality service as a new task in message centre

2. View the offered Quality Service by either selecting the Task Summary link or the Participation Management tab.

Screenshot from CQRS National of view offered quality service on participation management tab

NOTE: By default, the My Services screen displays all offered Quality Services for the current financial year.

Although you can accept or reject the Quality Service by selecting the checkbox next to the service name and selecting either the Accept Service or Reject Service button, you should always view details of the Quality Service offer before deciding the appropriate course of action.

3. To view details of the offer, select it from the list of services by selecting the service name.

4. For the QOF, the top-level domains (Clinical, Organisational, Patient Experience and Additional Services) display as appropriate.

5. Each domain can be expanded and viewed by selecting the coloured arrows on the left.

Screenshot from CQRS National showing expand each domain to view by selecting coloured arrows on left

6. Once you have reviewed the Quality Service details and are ready to accept or reject it, select the Back to Select a Quality Service link in the upper right of the screen.

7. The Service details screen displays again. Select the checkbox to the left of the Quality Service and then select either the Accept Service or Reject Service button.

Screenshot from CQRS National showing service detail with checkbox and accept or reject service button

8. A confirmation message displays to make sure that you wish to accept or reject the selected service. Select the Yes button to confirm your selection.

Screenshot from CQRS National showing accept or reject yes or no button

9. CQRS displays a confirmation message that the Quality Service has been successfully accepted or rejected.

Screenshot from CQRS National showing quality service accepted or rejected message

NOTE: If you reject the offer, the Commissioning Organisation will receive a message informing them of your action in regard to the offer. If you accept the offer, the offer is automatically moved into the “Approved” status and no additional notifications are sent to the Commissioning Service regarding the offer’s acceptance.

Non-urgent advice: Need help?

If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

Viewing the status of a Quality Service in CQRS National

As a Service Provider, you can view all Quality Services you are participating in, including their status, from your Participation Management screen. This job aid outlines the steps and filters you can use to view offered Quality Services and their status.

This job aid is aimed at Service Providers with the role of ‘Service Management’.

Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

  1. From the CQRS Home screen, select the Participation Management tab.
Screenshot from CQRS National showing Quality Service and Participation Management tab and content

NOTE: By default, the My Services screen displays Offered Quality Services for the current financial year.

2. Use the Quality Service Status filter to view:

    • Offered Quality Services: Services that have been offered to you by the Commissioning Organisation that you have not yet taken any action on.
    • Approved Quality Services: Services that have been offered to you, you have accepted and automatically approved, and you are now participating in.
    • Rejected Quality Services: Services offered to you that you have rejected.
    Screenshot from CQRS National showing Quality Service Status: offered, approved, rejected

    3. If no Quality Services are in this status, a blank panel will display.

    Version: v2.0

    Non-urgent advice: Need help?

    If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

    Manually inputting achievement data in CQRS National

    Most achievement data within CQRS are extracted automatically from GP clinical systems. However, data can be entered manually in the following instances:

    • The Service Provider does not support automatic extracts.
    • The Service Provider’s clinical system does not support automatic extracts for the Quality Service(s).
    • The Quality Service achievement data cannot be manually extracted.
    • There is a technical issue that prevents automatic extracts.

    This job aid is aimed at Service Providers with the role of ‘Achievement Entry’ who input achievement data manually.

    Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

    1. From the CQRS Home screen, select the Data Submission tab.
    Screenshot from CQRS National showing Data Submission tab

    NOTE: The Record Achievement screen displays. You can filter on any combination of Financial Year and Quality Service in order to view the service against which you wish to enter data.

    2. Having located the required service, select the Achievement Date drop-down. This displays a list of valid submission dates for the selected service.

    Screenshot from CQRS National showing achievement date drop down

    3. Select the date you are making a submission for and select the Add New Achievement button.

    NOTE: Achievement Dates highlighted yellow indicate a payment date.

    4. CQRS displays a summary of all Indicator Groups within your chosen service.

    Screenshot from CQRS National showing Record Achievement Indicator Groups

    5. Select the Indicator Group against which you wish to input data.

    6. The selected Indicator Group details are displayed.

    Screenshot from CQRS National showing selected Indicator Group details

    7. By selecting the available fields, you can add new achievement data against submission dates and values at a group and indicator level.

    Once you have entered the necessary data, you have the choice of saving the achievement as work in progress (allowing you to return later to add or update it) or submitting the data and triggering calculations.

    8. Select either the Submit Achievement Data or Save Work in Progress button.

    9. Depending on your choice, CQRS will display confirmation that the achievement has been saved as work in progress or that it has been successfully submitted.

    Non-urgent advice: Need help?

    If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.


    Offering a Quality Service in CQRS National

    Offering a Quality Service to a Service Provider is a five step process. This job aid outlines each of those steps.

    This job aid is aimed at Commissioning Organisations with the role of ‘Commissioning Management’.

    Note: The data that appears in this job aid is for training purposes only and does not represent actual data.

    Step 1: Select the Quality Service

    1. From the CQRS Home screen, select the Participation Management tab and then select the Create Offers sub-tab.
    Screenshot from CQRS National showing Participation Management menu and Creative Offers tab

    NOTE: Quality Services available to you and those that your organisation has customised display on the Quality Services commissioning panel. Selecting a Quality Service displays the details for the chosen Quality Service.

    2. From the Payment Type dropdown, select the Service Type you wish to offer.

    3. Select the radio button next to the Quality Service and then select the Continue button.

    Screenshot from CQRS National showing radio button next to the quality service and continue button

    Step 2: Define Quality Service Details

    4. In Step 2, you have the option of defining the Quality Service details and setting parameters such as Service Start, End, Response, and Target Dates.

    5. Selecting the Help button on this screen lets you access the User Guide, which provides descriptions of these parameters.

    Screenshot from CQRS National showing Step 2 define service details  with editable dates for service start date and end date, service response date and end date

    6. Enter or adjust your parameters and then select the Continue button.

    NOTE: Adjustments to either the Service Start or End dates must remain within the original service’s Start and End date parameters.

    Step 3: Choose Service Provider(s)

    7. Next, identify the Service Provider(s) to whom you wish to offer the Quality Service.

    Screenshot from CQRS National showing list of service providers

    8. Select the checkbox next to each Service Provider to whom you wish to make the offer. If offering it to all Service Providers, select the Select All checkbox in the panel header.

    Screenshot from CQRS National showing list of service providers to select from

    9. Select the Save & Continue button.

    Step 4: Review Offer

    10. Next you have the opportunity to review details of the offer. Pay special attention to the details displayed on this screen, making sure that start, end, response and target dates are accurate and that the intended Service Providers are correct.

    Screenshot from CQRS National showing review offer screen (step 4)

    NOTE: If you wish to make any corrections, select the << Back to Select Service Providers link and make the desired changes. (You may also select a specific step from the steps listed at the top of the screen to return to a specific one).

    11. When you are satisfied that the offer is correct, select the Submit button.

    Step 5: Confirm Offer

    12. Once submitted, a confirmation message displays to make sure that you wish to make the offer. Select the Yes button.

    A confirmation message displays, stating that the Quality Service has been offered to the selected Service Provider(s).

    Screenshot from CQRS National showing confirmation message

    Non-urgent advice: Need help?

    If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.

    Completing your user registration and signing in to CQRS National

    After your CQRS User Administrator has set you up on the system, you will receive an automated email containing a link directing you to the CQRS Registration screen. From here you must complete your user registration and create a password. This Job Aid provides you with the basic steps required to access and sign in to CQRS for the first time.

    1. You will receive an email with a link. Please click on this link as highlighted in the image below.
    Image showing the email you will receive from CQRS

    2. Once you have clicked on the above link, you will be taken to the following Security Information screen. Please ensure you read the Password Policy. Create a password and confirm it. Alternatively, if you prefer or do not have an NHS mail account, you can log in with your User ID and password as normal.

    Password may only be changed once every 72 hours.
Password can not contain all or part (first or last part) of the User ID.
Password must be 8-32 characters long.
Password must be different from the previous 8 passwords.
Password must be different from the current password, Password must address three of the following four categories:
• Uppercase characters (A...z)
• Lowercase characters (a...z)
• Base 10 digits (0...9)
• Non alphanumeric (I, ?, E etc.) |

    3. Once you have confirmed your password, you will need to go to the CQRS Login page which is www.cqrs.nhs.uk. If you have an NHS email address which ends in .nhs.net you can use the Sign In option below.

    sign in page to log into system via NHS login. Alternatively, if you prefer
or do not have an NHS mail
account, you can log in with
your User ID and password

    4. If you have chosen to login using your NHS email address, you will be taken to the NHSmail login page where you will be prompted to enter your email address and password. Once you have done this, click the Sign in button. This is also referred to as Single sign-on (SSO).

    NHS login screen with username and password values

    Non-urgent advice: Need help?

    If you need help with CQRS, you can log a call with the service desk. Please email: support@cqrs.co.uk or call 0330 124 4039.