Data Set Structure

Rating

1 = Mandatory

2 = Optional

3 =

Mandatory where 'Reason for Pathway Close' is 'Treated' 

Data Items Relating to Patient Sensitive Data

Column Header

Format

1

Patient’s Name (Surname)

Surname

35 character alpha-numeric 

1

Patient’s Name (Forename)

Forename

35 character alpha-numeric 

1

NHS Number

NHSNumber

10 digit numeric

1

NHS Number Status Indicator

NHSNumberStatusIndicator

2 digit numeric

1

Local Patient Identifier

LocalPatientIdentifier

10 character alpha- numeric

1

Patient’s Address

Address

175 character alpha- numeric

1

Patient’s Postcode

Postcode

8 character alpha- numeric

1

Code of Registered GP Practice

GPPracticeCode

6 character alpha- numeric

1

Birth Date

BirthDate

8 digit numeric (ccyymmdd)

2

Death Date

DeathDate

8 digit numeric (ccyymmdd)

1

Sex (at birth)

Sex

1 digit numeric

1

Ethnic Group

EthnicGroup

2 character alpha- numeric

 

Data Items Relating to Local Health Board Data

 

 

1

Organisation Code (Code of Provider)

ProviderOrgCode

5 character alpha- numeric

 

Data Items Relating to Pathway Type

 

 

1

Unique Pathway Identifier

UniquePathwayIdentifier

24 character alpha- numeric

1

Pathway Start Date (Point of Suspicion of Cancer)

PathwayStartDate

8 digit numeric (ccyymmdd)

1

Source of Suspicion

SuspicionSource

2 character alpha- numeric

1

Source of Cancer Referral

ReferralSource

2 character alpha- numeric

 

Data Items Relating to Tumour Identification

 

 

1

Primary Cancer Site Description

PrimaryCancerSiteDescription

2 character alpha-numeric

2

Primary Cancer Site Description (Sub Site)

PrimaryCancerSubSiteDescription

3 digit numeric

 

Data Items Relating to Component Waits

 

 

1

Date of Receipt of Cancer Referral

CancerReferralReceiptDate

8 digit numeric (ccyymmdd)

2

Date of First Appointment Taken

FirstAppointmentTakenDate

8 digit numeric (ccyymmdd)

2

Date of First Diagnostic Test Undertaken

FirstDiagnosticTestUndertakenDate

8 digit numeric (ccyymmdd)

2

Date of First Diagnostic Test Reported

FirstDiagnosticTestReportedDate

8 digit numeric (ccyymmdd)

2

Date of Last Diagnostic Test Undertaken before Date of Decision to Treat (DDTT)

LastDiagnosticTestBeforeDDTTDate

8 digit numeric (ccyymmdd)

2

Date of Last Diagnostic Test Reported before Date of Decision to Treat (DDTT) or Treatment Start

LastDiagnosticTestBeforeDDTTorTreatmentStartDate

8 digit numeric (ccyymmdd)

3

Date Patient Informed of Diagnosis

PatientInformedofDiagnosisDate

8 digit numeric (ccyymmdd)

2

Multi Disciplinary Team (MDT) Meeting Date (First Meeting)

MDTFirstMeetingDate

8 digit numeric (ccyymmdd)

2

Multi Disciplinary Team (MDT) Meeting Date (Last Meeting)

MDTLastMeetingDate

8 digit numeric (ccyymmdd)

3

Date of Primary Diagnosis – Clinically Agreed

PrimaryCancerDiagnosisDate

8 digit numeric (ccyymmdd)

1

Outcome of Investigations

InvestigationsOutcome

1 digit numeric

3

Date of Decision to Treat CWT (DDTT)

DDTTDecisionDate

8 digit numeric (ccyymmdd)

2

Date Referred to Tertiary Centre

TertiaryCentreReferralDate

8 digit numeric (ccyymmdd)

2

Tertiary Centre of Treatment

TreatmentTertiaryCentre

5 character alpha-numeric

 

Data Items Relating to End Point

 

 

1

Date of SCP Clock Stop

SCPClockStopDate

8 digit numeric (ccyymmdd)

3

Cancer Treatment Modality

CancerTreatmentModality

2 character alpha- numeric

1

SCP Target Date

SCPTargetDate

8 digit numeric (ccyymmdd)

1

Pathway Status

PathwayStatus

1 digit numeric