Red to Green (R2G) Aggregate Measures

DPN Ref. No: 2026 / 01 Red to Green (R2G) Aggregate Measures

A Data Provision Notice to require the submission of data for NHS Wales Red to Green (R2G) 

Purpose

This notice sets out the requirements for collecting and reporting Red to Green (R2G) data to provide a standardised view of patient flow and delays in hospital care. Hospital stays, particularly for older and frail patients, can lead to rapid deconditioning, and key Operational Health Flow Framework (OHFF) principles such as SAFER, Discharge to Recover and Assess (D2RA) and Red to Green (R2G) are not consistently embedded in practice.      

The collection standardises the definitions and reporting of Red and Green days to improve data quality, reduce variation, and give clearer insight into delays affecting patient care and discharge. The data will primarily support operational management and service improvement and will remain aggregated due to current system constraints.

Under this framework:

• Green Day: Care delivered adds value and progresses the patient toward discharge.
• Red Day: No added value due to avoidable delays or care that could be delivered outside an acute setting.

Scope of Collection

The DPN sets out the requirements for the collection of the following aggregate data items:  

1. Date 

2. Total number of patients in the cohort (preclinically optimised) 

3. Total number of patients with a green status 

4. Total number of patients with a red status 

5. If red status, total number of patients with red constraint code/s 

6. If red status, and constraint code/s, total number of patients against each of the red constraint code/s 

7. If red status, total number of patients with NO red constraint code/s 

The above information would be collected using a Proforma that has already been shared with the Health Boards. A copy of this proforma is attached here: 

Inclusion criteria are as follows:

1. All adults only (age 18+)
2. Pre-clinically optimised patients on the day of reporting only to be included
3. Inpatients (admitted/ordinary admission) - (with a length of stay >=1day, i.e. where the patient has remained in hospital until midnight the day following admission)
4. Allocated a red or green status each day of hospital stay

Exclusion criteria are as follows:

1. Patients age < 18 years
2. Clinically optimised patients
3. Day case admission, regular day admissions, regular night admissions, women using delivery facilities only and not applicable (patient classification 2, 3, 4, 5 and 8)
4. Where patient's Treatment Function is Mental Health Services or Midwifery Service (see Treatment Function codes below)
5. Patients with zero length of stay

Form and Manner

The following HBs collect Red to Green information and are required to submit this data collection:

• Aneurin Bevan University Health Board (UHB)
• Betsi Cadwaladr UHB
• Cardiff and Vale UHB
• Cwm Taf Morgannwg UHB
• Hywel Dda UHB
• Powys Teaching Health Board (THB)
• Swansea Bay UHB

Data will be submitted to NHS Performance and Improvement via an Excel spreadsheet. It must be submitted via email to nhspi_data.analytics@wales.nhs.uk.  Details of the data items collected, and their definitions can be found in the Form Specification.

Period of Collection

All Health Boards are required to commence completion of the R2G proforma on a monthly basis from 1^st August 2026 and submission latest by 7^th September 2026. This includes input from the relevant hospital sites and designated digital/data leads to ensure all data fields and reporting requirements are fully completed and validated.

Submissions must:

• Cover a complete calendar month.
• Be received no later than the 7th working day of the subsequent month.

The data collection will continue until the scheduled review period of 12 months, i.e. 1^st August 2027.

Read the Data Provision Notice

Change Control

There are no previous versions of this DPN to display

Reviews

Next Review Date:  1^st August 2027

Previous Reviews:

N/A