Report guidance
This guidance provides the underlying logic behind the various reports generated within the Cancer Waiting Times system.
Further details about the terms and standards used in Cancer Waiting Times Reports can be found in the guidance section of the main website.
Provider reports
Report 1.1 - Cancer Two Week Wait
Calculated period
Date First Seen minus Cancer Referral To Treatment Period Start Date minus Waiting Time Adjustment (First Seen) - and the outcome should be less than or equal to 14.
Numerator: Patients seen within 14 days
Denominator: All patients seen within the period
All percentage performances are given with 1 decimal place (i.e., xx.x%).
Patients to be included
Any patient record with:
- Priority Type Code = 3
- Two Week Wait Cancer or Symptomatic Breast Referral Type other than 16.
- Source of Referral for Outpatient <> 17
- Date first seen and Cancer Referral To Treatment Period Start Date must be present
Report 1.2 - Breast Symptom Two Week Wait
Calculated period
Date First Seen minus Cancer Referral To Treatment Period Start Date minus Waiting Time Adjustment (First Seen) - and the outcome should be less than or equal to 14.
Numerator: Patients seen within 14 days
Denominator: All patients seen within the period
All percentage performances are given with 1 decimal place (i.e., xx.x%)
Patients to be included
Any patient record with:
- Priority Type Code = 3
- Two Week Wait Cancer or Symptomatic Breast Referral Type of 16
- Source of Referral for Outpatient <> 17
- Date first seen and Cancer Referral To Treatment Period Start Date must be present.
Report 19.1- 28 Day General FDS
Calculated period
Scenario 1
When Cancer Treatment Period Start Date IS BLANK OR Cancer Faster Diagnosis Pathway End Date is before or the same as Cancer Treatment Period Start Date then,
Cancer Faster Diagnosis Pathway End Date minus Cancer Referral To Treatment Period Start Date minus Waiting Time Adjustment First Seen
Scenario 2
When Cancer Treatment Period Start Date is before Cancer Faster Diagnosis Pathway End Date
Cancer Treatment Period Start Date minus Cancer Referral To Treatment Period Start Date minus Waiting Time Adjustment First Seen
Numerator: Patients seen within 28 days
Denominator: All patients seen within the period
All percentage performances are given with 1 decimal place (i.e., xx.x%)
Patients to be included
Any patient record with:
- (Priority Type Code = 3 and Source of Referral for Outpatient <> 17) OR (Priority Type Code = 2 and Source of Referral for Outpatient = 17)
- Cancer Faster Diagnosis Pathway End Reason IN (01, 02, 04) OR (Cancer Faster Diagnosis Pathway End Reason = 03 AND Cancer Faster Diagnosis Pathway Exclusion Reason = 01 AND Number of Days > 28)
- Cancer Faster Diagnosis Pathway End Date <> BLANK
- Cancer Referral to Treatment Period Start Date <> BLANK.
Report 19.3- 28 Day General FDS Incomplete Pathway
Patients to be included
Any patient record with:
- (Priority Type Code = 3 and Source of Referral for Outpatient<> 17) OR (Priority Type Code = 2 and Source of Referral for Outpatient = 17)
- Cancer Faster Diagnosis Pathway End Date = BLANK
- Cancer Referral to Treatment Period Start Date <> BLANK.
Report 25.1 - 31 Day General Treatment Standard (Tumour) Report
Calculated period
Treatment Start Date for Cancer minus Cancer Treatment Period Start Date minus Waiting Time Adjustment (Treatment)
Numerator: Number of patients treated within 31 days within the period.
Denominator: Total number of patients treated within the period.
Patients to be included
Any patient record with:
- Cancer Treatment Event Type IN (01,07, 12) AND Cancer Treatment Modality <> 98)
OR - (Cancer Treatment Event Type IN (02, 03, 04, 05, 06, 08, 09, 10, 11) AND Cancer Treatment Modality NOT IN (07, 08, 09, 98))
- Primary Diagnosis <> BLANK
- Cancer Treatment Period Start Date <> BLANK
- Treatment Start Date for Cancer <> BLANK
Cancer Treatment event type along with Cancer Treatment Modality in the above criteria helps identify whether the patient is under First Treatment or Subsequent Treatment:
- If Cancer Treatment event type IN (01, 07, 12) then irrespective of Cancer Treatment Modality, the patient is under First Treatment.
- If Cancer Treatment Event Type IN (02, 03, 04, 05, 06, 08, 09, 10, 11) in combination with Cancer Treatment Modality NOT IN (07, 08, 09, 98) then the patient is under Subsequent Treatment
Note
Patients included in All Treatment are combination of First treatment and Subsequent treatment
Report 25.2 - 31 Day General Treatment Standard (Treatment Group)
Treatment groups are determined based on this table.
Calculated period
Treatment Start Date for Cancer minus Cancer Treatment Period Start Date minus Waiting Time Adjustment (Treatment).
Numerator: Number of patients treated within 31 days within the period.
Denominator: Total number of patients treated within the period.
Patients to be included
Any patient record with:
- (Cancer Treatment Event Type IN (01,07, 12) AND Cancer Treatment Modality <> 98)
OR - (Cancer Treatment Event Type IN (02, 03, 04, 05, 06, 08, 09, 10, 11) AND Cancer Treatment Modality NOT IN (07, 08, 09, 98))
- Primary Diagnosis <> BLANK
- Cancer Treatment Period Start Date <> BLANK
- Treatment Start Date for Cancer <> BLANK
Cancer Treatment event type along with Cancer Treatment Modality in the above criteria helps identify whether the patient is under First Treatment or Subsequent Treatment:
- if Cancer Treatment event type IN (01, 07, 12) then irrespective of Cancer Treatment Modality, the patient is under First Treatment
- if Cancer Treatment Event Type IN (02, 03, 04, 05, 06, 08, 09, 10, 11) in combination with Cancer Treatment Modality NOT IN (07, 08, 09, 98) then the patient is under Subsequent Treatment
Note: Patients included in All Treatment are combination of First treatment and Subsequent treatment
Report 25.3 - 31 Day General Treatment Standard (Treatment)
The treatment type groupings are to be determined using the field CANCER TREATMENT MODALITY - https://www.datadictionary.nhs.uk/data_elements/cancer_treatment_modality.html
Calculated Period:
Treatment Start Date for Cancer minus Cancer Treatment Period Start Date minus Waiting Time Adjustment (Treatment).
Numerator: Number of patients treated within 31 days within the period.
Denominator: Total number of patients treated within the period.
Patients to be included
Any patient record with:
- (Cancer Treatment Event Type IN (01,07, 12) AND Cancer Treatment Modality <> 98)
OR
- (Cancer Treatment Event Type IN (02, 03, 04, 05, 06, 08, 09, 10, 11) AND Cancer Treatment Modality NOT IN (07, 08, 09, 98))
- Primary Diagnosis <> BLANK
- Cancer Treatment Period Start Date <> BLANK
- Treatment Start Date for Cancer <> BLANK
Cancer Treatment event type along with Cancer Treatment Modality in the above criteria helps identify whether the patient is under First Treatment or Subsequent Treatment:
- if Cancer Treatment event type IN (01, 07, 12) then irrespective of Cancer Treatment Modality, the patient is under First Treatment
- if Cancer Treatment Event Type IN (02, 03, 04, 05, 06, 08, 09, 10, 11) in combination with Cancer Treatment Modality NOT IN (07, 08, 09, 98) then the patient is under Subsequent Treatment
Note: Patients included in All Treatment are combination of First treatment and Subsequent treatment.
Report 25.4 - 31 Day General Treatment Standard (Tumour) with GP registered.
This report is based on Tumour
This report mirrors Report 25.1, so refer the same.
Report 25.5 - 31 Day General Treatment Standard (Treatment Group) with GP registered.
This report is based on Treatment Group
This report mirrors Report 25.2, so refer the same.
Report 25.6 - 31 Day General Treatment Standard (Treatment) with GP registered.
This report is based on Treatment.
This report mirrors Report 25.3, so refer the same.
Report 26.1 - 62 Day General Standard (Tumour) Report
Calculated period
Treatment Start Date for Cancer minus Cancer Referral to Treatment Period Start Date minus Waiting Time Adjustment (First Seen) minus Waiting Time Adjustment (Treatment)
Numerator: Number of patients treated within 62 days within the period following an urgent GP/GDP referral for suspected cancer
Denominator: Total number of patients treated within the period following an urgent GP/GDP referral for suspected cancer.
All percentage performances are given with 1 decimal place (i.e., xx.x%)
Patients to be included by referral source
Patients referred by GP have
- PRIORITY TYPE of 3
- Source of Referral for Outpatient <> 17
- Cancer Referral to Treatment Period Start Date is not BLANK.
- Consultant Upgrade Date is Blank.
Patients treated following an “urgent referral from an NHS Cancer Screening Service” are to be identified by having:
- PRIORITY TYPE of 2 (urgent)
- Source of Referral for Outpatient = 17
- Cancer Referral to Treatment Period Start Date is not BLANK.
Patients treated following an “Consultant upgrade” are to be identified by having: -
- PRIORITY TYPE of 2
- Source of Referral for Outpatient <> 17
- Consultant Upgrade Date is not BLANK.
Report 26.4 - 62 Day General Standard (Tumour) Report with GP registered.
This report mirrors Report 26,1 so refer the same.
Commissioner reports
Report 6.1 - Cancer Two Week Wait
The Commissioner Based Cancer Two Week Wait (see Report 1.1)
Report 6.2 - Breast Symptom Two Week Wait
The Commissioner Based Breast Symptom Two Week Wait (see Report 1.2)
Report 24.1 - 28 Day General FDS
The Commissioner Based 28 Day General FDS report (see Report 19.1)
Report 24.3- 28 Day General FDS Incomplete Pathway
The Commissioner Based 28 Day General FDS Incomplete Pathway report (see Report 19.3)
Report 27.1 - 31 Day General Treatment Standard (Tumour) Report
The Commissioner Based 31 Day General Treatment Standard (Tumour) Report (see Report 25.1)
Report 27.2 - 31 Day General Treatment Standard (Treatment Group)
The Commissioner Based 31 Day General Treatment Standard (Treatment Group) (see Report 25.2)
Report 27.3 - 31 Day General Treatment Standard (Treatment)
The Commissioner Based 31 Day General Treatment Standard (Treatment) (see Report 25.3)
Report 27.4 - 31 Day General Treatment Standard (Tumour) Report with GP registered
The Commissioner Based 31 Day General Treatment Standard (Tumour) Report (see Report 25.4)
Report 27.5 - 31 Day General Treatment Standard (Treatment Group) with GP registered
The Commissioner Based 31 Day General Treatment Standard (Treatment Group) (see Report 25.5)
Report 27.6 - 31 Day General Treatment Standard (Treatment) with GP registered
The Commissioner Based 31 Day General Treatment Standard (Treatment) (see Report 25.6)
Report 28.1 - 62 Day General Standard (Tumour)
The Commissioner Based 28.1 - 62 Day General Standard (Tumour) (see Report 25.3)
Report 28.4 - 62 Day General Standard (Tumour) Report with GP registered
This report mirrors Report 28.1 so refer the same
Last edited: 11 November 2026 9:06 am