MDW - Discover Metadata Catalogue

MDW Discover  > Cancer Waiting Times Data Collection (CWT) @ 1346

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

https://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-collections/cancerwaitingtimescwt

HDR UK

Provider Submitted: The AccountableInvestigatingProvider has been created using logic that assigns the Accountable Investigating Provider and allow activity to be split. As an example 0.5 of a patients treatment can be allocated to one provider whilst 0.5 of the same patients treatment can be allocated to a different provider

ACCOUNTABLEINVESTIGATINGPROVIDER

AGEM Derived: Internal field to identify individual data loads.

AuditId

Provider Submitted: The type of care setting where the cancer care relating to the Treatment Start Date (Cancer) took place. Where the care is delivered during a Hospital Provider Spell, distinction is made between care delivered as part of an ordinary admission (where the PATIENT CLASSIFICATION is National Code &#039;Ordinary Admission&#039;) and a day case admission (where PATIENT CLASSIFICATION is National Code &#039;Day case admission&#039;).

CANCERCARESETTINGTREATMENT

Provider Submitted: The diagnostic referral route for PATIENTS for the National Cancer Waiting Times Monitoring Data Set.

CANCERDIAGNOSTICREFERRALROUTE

Provider Submitted: Either the date when the PATIENT is informed either &#039;Diagnosis of cancer&#039; or? &#039;Ruling out of cancer&#039; or is excluded from the Cancer Faster Diagnosis Pathway.?

CANCERFASTERDIAGNOSISPATHWAYENDDATE

Provider Submitted: The treatment event reached during a Cancer Pathway.?

CANCERTREATMENTEVENTTYPE

Provider Submitted: The type of treatment or care which was delivered during a Cancer Treatment Period. Represented by a national code.

CANCERTREATMENTMODALITY

Provider Submitted: A CANCER TREATMENT PERIOD START DATE will be either the DECISION TO TREAT DATE or the EARLIEST CLINICALLY APPROPRIATE DATE

CANCERTREATMENTPERIODSTARTDATE

NHSE Derived: The Clinical Commissioning Group code of the GP Practice the subject is registered

CCG_OF_REGISTRATION

NHSE Derived: The Clinical Commissioning Group code of the address of the subject

CCG_OF_RESIDENCE

NHSE Derived: Boolean flag to indicate whether patient was aged 16 or under on the date? of referral onto cancer pathway. Determined by CWT system using PDS and patient NHS Number

CHILDFLAG

Provider Submitted: For the Systemic Anti-Cancer Therapy Data Set, this identifies if a PATIENT&#039;s Chemotherapy treatment is within a CLINICAL TRIAL. Note: * For the National Cancer Waiting Times Monitoring Data Set, default code &#039;99 - Unknown&#039; indicates &quot;Not Recorded&quot;.

CLINICALTRIALINDICATOR

Provider Submitted: The DATE of the Consultant Upgrade

CONSULTANTUPGRADEDATE

Provider Submitted: The Start Date of a Cancer Referral To Treatment Period

CRTPDATE

AGEM Derived: Internal processing data item to identify customers data disseminated to.

CustomerAll

NHSE Derived: Patient pseudonym generated by the CWT system

CWTPATIENTID

Provider Submitted: The date that the PATIENT is first seen in the Trust that receives the first referral.

DATEFIRSTSEEN

Provider Submitted: The DATE?on which: a GENERAL MEDICAL PRACTITIONER, GENERAL DENTAL PRACTITIONER or OPTOMETRIST decides to refer a PATIENT urgently to secondary care with suspected cancer. Any CARE PROFESSIONAL decides to make a referral to secondary care for breast symptoms where cancer is not suspected. Any CARE PROFESSIONAL decides to make a referral to secondary care for breast symptoms where cancer is not suspected. A screening Service decides to urgently refer a PATIENT with suspected cancer. A consultant Upgrade takes place.

DECTOREFDATE

Provider Submitted: The reason why a Cancer Care Spell Delay occurred?when a Consultant Upgrade?took place.

DELAYCONSTREATREASON

Provider Submitted: The reason why a Cancer Care Spell Delay occurred?between the DECISION TO TREAT DATE and Treatment Start Date (Cancer).

DELAYDTTTREATREASON

Provider Submitted: The reason why a Cancer Care Spell Delay occurred, where the Health Care Provider was unable to communicate the outcome of the Cancer Faster Diagnosis Pathway within 28 days.

DELAYFDPREASON

Provider Submitted: The reason why a Cancer Care Spell Delay occurred between the Cancer Referral To Treatment Period Start Date and the Date First Seen, when the PRIORITY TYPE is National Code &#039;Two Week Wait&#039;.

DELAYREFFSREASON

Provider Submitted: The reason why?a Cancer Care Spell Delay occurred between the Cancer Referral To Treatment Period Start Date and the Start Date of the first, second or subsequent cancer treatment given to a PATIENT who is receiving care for a cancer condition.

DELAYREFTREATREASON

AGEM Derived: Derived age in years using PDS_DATE_OF_BIRTH and CRTPDATE.

Der_Age_At_CRTP_Date

AGEM Derived: Derived age using PDS_DATE_OF_BIRTH and PDS_DATE_OF_DEATH.

Der_Age_At_Death

AGEM Derived: Country code when a default postcode is supplied in PDS_POSTCODE e.g. postcodes that start with ZZ99. ODS postcode reference data sourced from UKHD is used for postcode lookups. PDS_POSTCODE is removed from outputs before dissemination. This is a legacy derivation requested by NHSE.

Der_default_country_code

AGEM Derived: Postcode type when a default postcode is supplied in PDS_POSTCODE e.g. postcodes that start with ZZ99. ODS postcode reference data sourced from UKHD is used for postcode lookups. PDS_POSTCODE is removed from outputs before dissemination. This is a legacy derivation requested by NHSE. Values are normally &#039;UK&#039; or Non-UK&#039;

Der_default_postcode_type

AGEM Derived: Reciprocal agreement when a default postcode is supplied in PDS_POSTCODE e.g. postcodes that start with ZZ99. ODS postcode reference data sourced from UKHD is used for postcode lookups. PDS_POSTCODE is removed from outputs before dissemination. This is a legacy derivation requested by NHSE. Will indicate if a reciprocal agreement is in place with that country code.

Der_default_reciprocal_agreement

AGEM Derived: Derived activity month value based on CRTPDATE in Header Table (MHS000Header).

Der_Financial_Month

AGEM Derived: Financial year of the activity, e.g. 2021/22, 2022/23 etc. Derived financial year value based on CRTPDATE.

Der_Financial_Year

AGEM Derived: The code of the CCG (now SUB ICB) where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination.

Der_Postcode_CCG_Code

AGEM Derived: Derived postcode constituency code where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination.

Der_Postcode_Constituency_Code

AGEM Derived: Derived district unitary authority code where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination.

Der_Postcode_Dist_Unitary_Auth

AGEM Derived: Derived electoral ward where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination.

Der_Postcode_Electoral_Ward

AGEM Derived: Derived local authority where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination.

Der_Postcode_Local_Auth

AGEM Derived: Derived Lower Layer Super Output Area (LSOA) where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination. Uses the list of LSOAs as of the 2001 census.

Der_Postcode_LSOA_Code

AGEM Derived: Derived Middle Layer Super Output Area (MSOA) where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination. Uses the list of MSOAs as of the 2001 census.

Der_Postcode_MSOA_Code

AGEM Derived: Derived code of the primary care trust (PCT) where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination. Uses the list of PCT geographies as of closure date (31st March 2013). This is a legacy derivation requested by NHSE

Der_Postcode_PCT_Code

AGEM Derived: Derived postcode sector from the submitted postcode comprised of all characters to the left of the space in a full 8 character postcode and first character to the right of the space. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination.

Der_Postcode_Sector

AGEM Derived: Derived Lower Layer Super Output Area (LSOA) where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination. Uses the list of LSOAs as of the 2011 census.

Der_Postcode_yr2011_LSOA

AGEM Derived: Derived Middle Layer Super Output Area (MSOA) where the patient&#039;s PDS_POSTCODE is based. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination. Uses the list of MSOAs as of the 2011 census.

Der_Postcode_yr2011_MSOA

AGEM Derived: Derived Commissioning Hub code if prison postcode supplied. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination. This is a legacy derivation requested by NHSE

Der_prisons_CommHub_Code

AGEM Derived: Derived Postcode type code if prison postcode supplied. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination. This is a legacy derivation requested by NHSE. Values will be &#039;NULL&#039;, &#039;Unknown&#039;, &#039;Unique&#039; and &#039;Non-unique&#039;

Der_prisons_postcode_type

AGEM Derived: Derived Justice facility code if prison postcode supplied. Derived by linking PDS_POSTCODE to ODS reference data sourced from UKHD. PDS_POSTCODE is removed from outputs before dissemination. This is a legacy derivation requested by NHSE.

Der_prisons_YDE_code

AGEM Derived: Internal processing data item to identify reason for access.

DerRfaRecipientAll

Provider Submitted: The primary cancer site communicated to the PATIENT on the CANCER FASTER DIAGNOSIS PATHWAY END DATE where patient has diagnosis of cancer.

FDPDIAGSITE

Provider Submitted: The reason for the end of the Cancer Faster Diagnosis Pathway.

FDPENDREASON

Provider Submitted: The reason for excluding the PATIENT from the Cancer Faster Diagnosis Pathway.

FDPEXCLUSIONREASON

Provider Submitted: The method of communication used to inform the PATIENT of the CANCER FASTER DIAGNOSIS PATHWAY END REASON.

FDPOUTCOMEMETHOD

Provider Submitted: The CARE PROFESSIONAL TYPE of the CARE PROFESSIONAL communicating the cancer diagnosis outcome to the PATIENT.

FDPOUTCOMEPROFTYPE

NHSE Derived: The Integrated Care System of the GP Practice the subject is registered

ICS_OF_REGISTRATION

NHSE Derived: The Integrated Care System of the address of the subject

ICS_OF_RESIDENCE

Provider Submitted: The DATE the Organisation where the PATIENT is being transferred to, received the SERVICE REQUEST from the referring Organisation.

IPTRECEIVEDDATE1

IPTRECEIVEDDATE10

IPTRECEIVEDDATE2

IPTRECEIVEDDATE3

IPTRECEIVEDDATE4

IPTRECEIVEDDATE5

IPTRECEIVEDDATE6

IPTRECEIVEDDATE7

IPTRECEIVEDDATE8

IPTRECEIVEDDATE9

Provider Submitted: Transfer Reason for the ORGANISATION that is receiving the PATIENT from another Health Care Provider as part of the inter-provider transfer during a Cancer Care Spell.

IPTRECEIVINGREASON1

IPTRECEIVINGREASON10

IPTRECEIVINGREASON2

IPTRECEIVINGREASON3

IPTRECEIVINGREASON4

IPTRECEIVINGREASON5

IPTRECEIVINGREASON6

IPTRECEIVINGREASON7

IPTRECEIVINGREASON8

IPTRECEIVINGREASON9

Provider Submitted: Transfer Reason for the ORGANISATION that is referring the PATIENT to another Health Care Provider as part of the inter-provider transfer during a Cancer Care Spell.

IPTREFERRINGREASON1

IPTREFERRINGREASON10

IPTREFERRINGREASON2

IPTREFERRINGREASON3

IPTREFERRINGREASON4

IPTREFERRINGREASON5

IPTREFERRINGREASON6

IPTREFERRINGREASON7

IPTREFERRINGREASON8

IPTREFERRINGREASON9

Provider Submitted: The SERVICE REQUEST DATE for an inter-provider transfer of a PATIENT from one Health Care Provider to another.

IPTREQUESTDATE1

IPTREQUESTDATE10

IPTREQUESTDATE2

IPTREQUESTDATE3

IPTREQUESTDATE4

IPTREQUESTDATE5

IPTREQUESTDATE6

IPTREQUESTDATE7

IPTREQUESTDATE8

IPTREQUESTDATE9

NHSE Derived: The Local Authority district of the GP Practice the subject is registered

LA_OF_REGISTRATION

NHSE Derived: The Local Authority district of the address of the subject

LA_OF_RESIDENCE

NHSE Derived: Lowest geographical Area identified without showing the specific GP practice&#039;s postcode location

LSOA_OF_REGISTRATION

NHSE Derived: Lowest geographical Area identified without showing the specific postcode location

LSOA_OF_RESIDENCE

Provider Submitted: A Multidisciplinary Team Discussion Date (Cancer) is the date on which the PATIENT&#039;s Cancer Care Plan was discussed at a Multidisciplinary Team Meeting and a treatment planning decision was made.

MDTDATE

Provider Submitted: A flag which indicates that the PATIENT&#039;s Cancer Care Plan was discussed at a Multidisciplinary Team Meeting and a treatment planning decision was made.

MDTIND

Provider Submitted: The trace status of the NHS NUMBER.

NHSNUMBERSTATUSINDICATORCODE

NHSE Derived: ORGANISATION CODE?derived from the PATIENT&#039;s POSTCODE OF USUAL ADDRESS, where they reside within the boundary of an AT

Organisation_Code_Area_Team_of_Residence

NW_DME.CWT.CWT

The national Cancer Waiting Times (CWT) system allows NHS providers to record data derived from patient care activity. This data can be used to monitor cancer waiting times targets or plan service improvements. As a patient moves through the stages of their treatment pathway data on referrals, treatments and diagnosis are derived from care records locally (decisions on how to collect these data from local systems are made locally).

Cancer Waiting Times Data Collection (CWT)

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin