MDW - Discover Metadata Catalogue

MDW Discover  > National Cancer Registration and Analysis Service (NCRAS) @ 1344

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

https://digital.nhs.uk/data-and-information/keeping-data-safe-and-benefitting-the-public/gdpr/gdpr-register/national-cancer-registration-dataset

Number of distinct individuals in the dataset

HDR UK

Project specific ID for each patient-event, unique to the rapid pathway data.

AVP_ID

Flag to indicate record PCD in the wrong data item which will have been stripped.

Der_PCD

Flag to indicate we have found sensitive codes within the data so patient identifiers have been redacted.

Der_SC

EVENT_DATE

End date of event (if event is a span of time such as a hospital admission)

EVENT_END

EVENT_PROPERTY_1

EVENT_PROPERTY_2

EVENT_PROPERTY_3

Number that identifies the type of event (see EventsLookUp tab)

EVENT_TYPE

Internal field to identify individual loads.

NCRAS_CP_Audit_ID

Internal field to identify individual records loaded.

NCRAS_CP_Ident

AGEM Derived: Internal field to identify individual loads.

NCRAS_CR_Audit_ID

AGEM Derived: Internal field to identify individual records loaded.

NCRAS_CR_Ident

Project specific identifier for each patient. It is possible for patients to have multiple PATIENTIDs.

PATIENT_ID

This is the customer specific pseudo NHS Number. This can be named slightly different depending on customer. If no NHS Number is present or the NHS Number is invalid then this data item will be empty.

Pseudo_NHS_Number

AGEM Derived: This is the customer specific pseudo NHS Number. This can be named slightly different depending on customer. If no NHS Number is present or the NHS Number is invalid then this data item will be empty.

Pseudo_NHS_Number (or client equivalent)

Field to identify which snapshot the data came from e.g. yyyy for annual snapshot. YYYY = latest signed off diagnosis year available

Snapshot

Three digit ODS code identifying the trust code at which the event occurred

TRUST_CODE

Project specific identifier for each tumour. It is possible for patients to have multiple unique TUMOURIDs.

TUMOUR_ID

NW_DME.NCRAS.CancerPathways

Age of the patient at diagnosis, in years.

Basis of diagnosis of the tumour according to all the data received by the registry.
Non-microscopic: 
0 = Death certificate. 
1 = Clinical: Diagnosis made before death without (2-7). 
2 = Clinical investigation: Includes all diagnostic techniques without a tissue diagnosis. 
4 = Specific tumour markers: Includes biochemical and/or immunological markers which are site specific. 
Microscopic:
5 = Cytology: Examination of cells whether from a primary or secondary site, including fluids aspirated using endoscopes or needles. Also including microscopic examination of peripheral blood films and trephine bone marrow aspirates. 
6 = Histology of a metastases: Includes autopsy specimens. 
7 = Histology of a primary tumour: Includes all cutting and bone marrow biopsies. Also includes autopsy specimens of a primary tumour. 
9 = Unknown, e.g. PAS or HISS record only.

BASISOFDIAGNOSIS

Behaviour of the cancer, in the ICD-10-O2 system [0 = Benign, 1 = Uncertain, 2 = In Situ, 3 = Malignant, 5 = Micro-Invasive, 6 = Malignant, Metastatic / Secondary Site, 9 = Malignant, Uncertain whether primary or metastatic, X = Unknown / Inapplicable.]

BEHAVIOUR_ICD10_O2

Behaviour of the cancer, in the ICD-10-O3 rev2011 system

BEHAVIOUR_ICDO3REV2011

Breslow thickness is used in staging melanoma of the skin and is related to thickness of the tumour.
Measured in millimetres to the nearest 0.01mm. Can be a number or range, x, or blank (e.g. ?1mm, 1-2mm).

BRESLOW

England Code Format: E56000000 or E57000000.

CANALLIANCE_CODE

CANALLIANCE_NAME

The cancercareplanintent  value chosen by order of importance, and the date closest to diagnosis that value appears on.

CANCERCAREPLANINTENT

CCG_CODE

CCG_NAME

Lookback of 27 to 3 months prior to diagnosis

CHRL_TOT_27_03

Lookback of 78 to 6 months prior to diagnosis,

CHRL_TOT_78_06

The CNS indicator value chosen by order of importance, and the date closest to diagnosis that value appears on.

CLINICALNURSESPECIALIST

1 = Had chemotherapy; 0 = No recorded chemotherapy

CT_FLAG

Extended ICCC-3 tumour classification for children, teenagers and young adults (primary)

CTYA_CLASSIFICATION_PRIMARY

Extended ICCC-3 tumour classification for children, teenagers and young adults (quaternary)

CTYA_CLASSIFICATION_QUATERNARY

Extended ICCC-3 tumour classification for children, teenagers and young adults (secondary)

CTYA_CLASSIFICATION_SECONDARY

Extended ICCC-3 tumour classification for children, teenagers and young adults (tertiary)

CTYA_CLASSIFICATION_TERTIARY

Whether the tumour was registered from a death certificate only: Y = Yes, N = No

A numeric code listed as &#039;Death cause code underlying (1C)&#039; on the ONS death certificate. Comma separated when multiple codes are recorded.

DEATHCAUSECODE_UNDERLYING

The date the patient died. Usually a patient&#039;s correct date of death, when date of death is defined by a range the average of the two dates is taken. Patients with only their year of death recorded have a date of either 1st or 2nd July recorded as a halfway point. If a patient has a month and a year of death the date is recorded as either the 15th or 16th as the halfway point of the month.

DEATHDATEBEST

Indicates completeness of DEATHDATEBEST: 0 = Date fully specified, 1 = Month and year specified, 2 = Year specified, 3 = Date less specific than any of above.

DEATHDATEFLAG

Location type code at death: 1 = Hospital, 2 = Hospice NOS, NHS hospice / specialist palliative care unit, 3 = Voluntary hospice / specialist palliative care unit, 4 = Other private residence (e.g. relatives home, carers home, patient&#039;s own home, private home). 5 = Care home, care home with nursing, nursing home. 6 = Other. X = Unknown.

DEATHLOCATIONCODE

Location type name at death: 1 = Hospital, 2 = Hospice NOS, NHS hospice / specialist palliative care unit, 3 = Voluntary hospice / specialist palliative care unit, 4 = Other private residence (e.g. relatives home, carers home, patient&#039;s own home, private home). 5 = Care home, care home with nursing, nursing home. 6 = Other. X = Unknown.

DEATHLOCATIONDESC

Derived ODS CCG code using CCG_CODE in data. Source data contains ONS codes so using [ONS_Codes].[Equivalents] in UKHD to map.

Der_CCG_Code_Mapping

Derived ODS ENG LOC code using ENG_LOC_CODE in data. Source data contains ONS codes so using [ONS_Codes].[Equivalents] in UKHD to map.

Der_ENG_LOC_Code_Mapping

Derived ODS ICB code using ICB_CODE in data. Source data contains ONS codes so using [ONS_Codes].[Equivalents] in UKHD to map.

Der_ICB_CODE_Mapping

DIAG_TRUST

DIAG_TRUST_NAME

Mid-point between diagnosisdate1 and diagnosisdate2 (DDMMYYYY)

DIAGNOSISDATEBEST

Indicates completeness of DIAGNOSISDATEBEST: 0 = Date fully specified, 1 = Month and year specified, 2 = Year specified, 3 = Date less specific than any of above.

DIAGNOSISDATEFLAG

DIAGNOSISYEAR

The diffusion_capacity_date closest to diagnosis

DIFFUSION_CAPACITY_DATE

The highest diffusion_capacity_result found on the diffusion_capacity_date closest to diagnosis

DIFFUSION_CAPACITY_RESULT

Dukes stage of disease at diagnosis, based on pathological evidence but upgraded to Dukes D if clinical evidence of metastasis. 
A = Dukes? A: Tumour confined to wall of bowel, nodes negative. 
B = Dukes? B: Tumour penetrates through the muscularis propria to involve extramural tissues, nodes negative. 
C1 = Dukes? C1: Metastases confined to regional lymph nodes (node/s positive but apical node negative). 
C2 = Dukes? C2: Metastases present in nodes at mesenteric artery ligature (apical node positive). 
D = Dukes D: Metastatic spread outside the operative field. 99 = Not Known.

DUKES

Whether there is a record of the patient leaving the UK, this is set by the vitalstatus having a value of X (exit posting): Blank or Y (Yes).

EMBARKATION

Date the patient is recorded as leaving the UK. This is taken as the average of vitalstatusdate1 and vitalstatusdate2 when vitalstatus = X.

EMBARKATIONDATE

ENG_LOC_CODE

ENG_LOC_NAME

ER_SCORE

N = Negative,
P = Positive,
X = Not Performed.

ER_STATUS

One of the 17 ethnic categories defined in the 2001 census (code).

ETHNICITY

One of the 17 ethnic categories defined in the 2001 census (Name).

ETHNICITYNAME

Date when Cancer Care Plan Intent was recorded

EVENTDATE_CCP

EVENTDATE_CNS

Date when FEV1 Absolute Value was recorded

EVENTDATE_FEV1A

EVENTDATE_FEV1P

Date when Performance Status was recorded

EVENTDATE_PS

EVENTDATE_PSA

EVENTDATE_SMOKE

An indication of whether the surgical excision margin finding was clear of the tumour and if so, by how much. 
01 = Excision margins are clear (distance from margin not stated). 
02 = Excision margins are clear (tumour &gt;5mm from the margin). 
03 = Excision margins are clear (tumour &gt;1mm but less than or equal to 5mm from the margin. 
04 = Tumour is less than or equal to 1mm from excision margin, but does not reach margin. 
05 = Tumour reaches excision margin. 
06 = Uncertain. 
07 = Margin not involved ?1mm. 
08 = Margin not involved &lt;1mm. 
09 = Margin not involved 1-5mm. 
98 = Not applicable. 
99 = Not Known.

EXCISIONMARGIN

The highest FEV1absolute value found on the date closest to diagnosis

FEV1ABSOLUTEVALUE

The highest FEV1percentage value found on the date closest to diagnosis

FEV1PERCENTAGE

Staging system for tumours of the female reproductive system.

Stage 1 ? Confined,
Stage 2 ? Local,
Stage 3 ? Distant,
Stage 4 ? Involving other organs.

Large number of codes used:
0, 1, 1a, 1a1, 1a2, 1b, 1b1, 1b2, 1c, 1c1, 1c2, 1c3, 2, 2a, 2a1, 2a2, 2b, 2c, 3, 3a, 3b, 3c, 3c1, 3c2, 4, 4a, 4b, I, IA, IA1, IA2, IB, IB1, IB2, IC, II, IIA, IIA2, IIB, IIC, III, IIIA, IIIB, IIIC, IIIC1, IIIC2, IV, IVA, IVB, blank.

FIGO

The code assigned to a Route for the purpose of the algorithm.

FINAL_ROUTE

Financial year of diagnosis based on DIAGNOSISDATEBEST. Prefixed &quot;FY&quot; and takes the form of most financial date expression e.g. FY2019/20.

FINANCIALYEAR

The first MDT meeting date found between diagnosisdate -92days and diagnosisdate +183 days

FIRSTMDTMEETINGDATE

0-4 | 5-9 | 10-14 | 15-19  | 20-24  | 25-29  | 30-34  | 35-39  | 40-44  | 45-49  | 50-54 | 55-59 | 60-64  | 65-69 | 70?74 | 75-79 | 80-84 | 85-89 | 90+

FIVEYEARAGEBAND

Self-stated gender of patient at diagnosis (not sex assigned at birth)

GENDER

GEOG_BOUNDARY_YEAR

Combined Gleason primary and secondary scores (+/- tertiary). The worst score is recorded, if both scores are the same but have different primary and secondary grades, the score with the highest primary grade is recorded first, i.e. 4+3=7 would be recorded over 3+4=7.

2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, blank.

GLEASON_COMBINED

The primary pattern is the grade that comprises most of the tumour volume. 

1-5, 8 = not applicable.

GLEASON_PRIMARY

If additional grades are present, what is the highest grade (biopsy) or the second most extensive grade (TURP and radicals). If no additional grades are present, primary and secondary grades are the same. 

1-5, 8 = not applicable.

GLEASON_SECONDARY

Is there a different third grade in addition to the primary and secondary grades and what is the value? 

1-5, 8 = not applicable.

GLEASON_TERTIARY

N = Negative,
P = Positive,
B = Borderline,
X = Not Performed.

HER2_STATUS

ICB_CODE

ICB_NAME

1 (most deprived),2,3,4,5,6,7,8,9 and 10 (least deprived)

IMD_DECILE

1 (most deprived),2,3,4 and 5 (least deprived)

IMD_QUINTILE

IMD_YEAR

Identifies the side of the body for a tumour relating to paired organs within a patient, based on the evidence from a pathological examination. The data field is used to differentiate tumours in paired organs (and define the site of the pathology/cytology specimen).

L = Left,
R = Right,
M = Midline,
B = Bilateral,
8 = Not applicable,
9 = Not Known.

LATERALITY

Describes the presence or otherwise of distant metastatic spread to other organs (UICC code).

M_BEST

Morphology of the cancer, in the ICD-10-O2 system [Number 8000-9990 or blank.]

MORPH_ICD10_O2

Morphology of the cancer, in the ICD-10-O3 rev2011 system

MORPH_ICDO3REV2011

Describes the regional lymph node involvement i.e. how far the tumour has grown through local tissues (UICC code).

N_BEST

E40000003 = London.
E40000005 = South East.
E40000006 = South West.
 E40000007 = East of England.
 E40000008 = Midlands.
E40000009 = North East and Yorkshire.
, E40000010 = North West.
Pseudo codes for Wales, Scotland, Northern Ireland, Channel Islands and Isle of Man.

NHS_REGION_CODE

NHS_REGION_NAME

The number of local and regional nodes reported as being positive.

NODESEXCISED

The number of local and regional nodes examined.

NODESINVOLVED

Calculated from tumour size, grade and lymph node involvement. 
Values &gt;2 and &lt;20 are accepted as valid

The lowest performance status found on the date closest to diagnosis

PERFORMANCESTATUS

Indication on the ONS death card of whether a postmortem took place.
Y = Yes,
N = No,
8 = N/A,
9 = Unknown.

POSTMORTEM

PR_SCORE

PR_STATUS

The highest psa_diagnosis value found on the date closest to diagnosis

PSA_DIAGNOSIS

1 = Had radiotherapy; 0 = No recorded radiotherapy

RT_FLAG

RURAL_URBAN_IND_CODE

RURAL_URBAN_IND_NAME

Whether or not the tumour was detected by a screening programme. 
N = No, Y = Yes, 8 = Not applicable, 9 = Not known.

SCREENDETECTED

1 = Screen-detected,
2 = Interval Cancer,
4 = Lapsed Attender,
5 = Never Attended,
6 = Never Invited,
7 = Other,
9 = Not Known, 
NM = Not Mapped.

National Cancer Registration and Analysis Service (NCRAS)

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin