| Literature DB >> 34255059 |
Amy Downing1, Peter Hall2,3, Rebecca Birch1, Elizabeth Lemmon3, Paul Affleck1, Hannah Rossington1, Emily Boldison1, Paul Ewart1, Eva J A Morris4.
Abstract
Entities:
Mesh:
Year: 2021 PMID: 34255059 PMCID: PMC8580263 DOI: 10.1093/ije/dyab122
Source DB: PubMed Journal: Int J Epidemiol ISSN: 0300-5771 Impact factor: 7.196
Figure 1Types of data available within CORECT-R.
Variables in the National Colorectal Cancer Dataset within CORECT-R. Currently, these relate to the English population but work is underway to expand to cover the UK
| Data item | Description of field content | Format | Source of information |
|---|---|---|---|
| Pseudonymized person ID | Unique study specific identifier for each patient | Number | Derived by the UK Colorectal Cancer Intelligence Hub |
| Pseudonymised tumour ID | Unique study specific identifier for each tumour | Number | Derived by the UK Colorectal Cancer Intelligence Hub |
| Age | Option to derive age information in a format suitable for the research project needs. Can be single age or summarized in age bands (e.g. 5-year) and can also include month and year of birth | Number | Cancer registration dataset |
| Sex | 0 = not known, 1 = male, 2 = female, 9 = not specified | Number | Cancer registration dataset |
| Ethnic group | Option to group ethnicities (e.g White/non-White/unknown). Several methods of deriving ethnicity information have been used previously and can be derived as per user requirements | Text | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registration and hospital discharge datasets |
| Socioeconomic status | Option to include an appropriate indicator of socioeconomic status such as the Index of Multiple Deprivation | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
| Vital status of the patient | A, alive; D, dead; X, exit posting | Char(1) | Cancer registration dataset |
| Days from diagnosis to death | Time in days between specified colorectal cancer diagnosis and death or censoring | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registration dataset |
| Days from another event to date of death | Option to provide number of days from another event to death (e.g. days from diagnosis to death). Derived as per user requirements | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in key events from different datasets |
| Cause of death | Option to derive summary cause of death information based on the causes of death listed on death certificates or coded by former regional registries. Derived as per user requirements | Text | Cancer registration dataset |
| Place of death | Option to derive place of death based on information recorded on death certificates or from Hospital Episode Statistics Derived as per user requirements | Cancer registration dataset | |
| Diagnosis date | Option to derive diagnosis date in a format suitable for the research project needs. This is likely to be in the format MM/YYYY unless permissions for access to identifiable data have been granted | Cancer registration dataset | |
| Days from another event to date to diagnosis | Option to provide number of days from another event to diagnosis (e.g. days from birth to diagnosis). Derived as per user requirements | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
| Basis of diagnosis of the tumour | 0 = death certificate, 1 = clinical diagnosis made before death without (2-7), 2 = clinical investigation, 4 = specific tumour markers, 5 = cytology, 6 = histology of metastases, 7 = histology of a primary tumour, 9 = unknown | Number | Cancer registration dataset |
| Route to diagnosis | 1 = GP referral, 2 = 2-week wait pathway, 3= emergency presentation, 4 = other outpatient, 5 = screen detected, 6 = inpatient elective, 7 = death certificate only, 9 = unknown | Number | Cancer registration dataset |
| Site of neoplasm (4-character code) | Valid 4-digit ICD-10 codes in the range C180 to C20 | Char(4) | Cancer registration dataset |
| Site of neoplasm (3-character code) | Valid 3-digit ICD-10 codes in the range C18 to C20 | Char(4) | Cancer registration dataset |
| Site of neoplasm (coded) | 1 = right colon, 2 = left colon, 3 = colon, unspecified, 4= rectosigmoid, 5= rectum | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registration dataset |
| Morphology | The original 5-digit ICD-03 morphology information captured by NCRAS | Char(5) | Cancer registration dataset |
| Morphology group | A grouped morphology variable derived by grouping the detailed morphology information available in NCRAS to provide the more useable histology types of adenocarcinoma etc. For many analyses it may be appropriate to limit cases to exclude rare morphological subtypes with non-standard treatment or unusual behaviour | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registration dataset |
| Summary stage | A summary stage, that combines information from the multiple staging variables available in NCRAS to maximize the number of cases with a stage classification | Number | Cancer registration dataset |
| Staging information | Option to derive staging information from any of the data items available in the CORECT-R tables (likely to be predominantly NCRAS Tumour table). This can include individual components of TNM or any other information that can be reported alone or combined as demanded by the research project. Derived as per user requirements | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registration dataset | |
| Comorbidity scores | Option to access a number of different comorbidity scores (such as Charlson, Elixhauser, C3) created as per user requirements. This could include using a previously published application of these scores or bespoke algorithms as demanded by the research project | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
| Primary procedure | Primary procedure for this individual, 1 = major resection, 2 = minor resection, 3 = bypass, 4 = stoma, 5 = stent, 6 = no surgery, 7= no link to HES so no information available | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registry and relevant hospital discharge dataset |
| Primary procedure OPCS4 code | The OPCS4 code indicating the exact procedure determined as the primary event | Char(4) | Hospital discharge dataset |
| Date of primary procedure | MM/YYYY | Number | Hospital discharge dataset |
| Method of admission to hospital for primary procedure | Derived from the HES variable admission method, 0 = elective, 1 = emergency, 99 = unknown | Number | Hospital discharge dataset |
| Location patient admitted from | 1 = Unsupervised accommodation, no care provided, 2 = hospital, 3 = supervised accommodation, health care is provided, 4 = supervised accommodation, no care provided, 99 = unknown | Number | Hospital discharge dataset |
| Urgency of surgery | 0 = elective 1 = emergency | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Destination patient discharged to after primary procedure | 1 = unsupervised accommodation, no care provided, 2 = hospital, 3 = supervised accommodation, health care is provided, 4 = supervised accommodation, no care provided, 9 = patient died, 99 = unknown | Number | Hospital discharge dataset |
| Days between diagnosis and primary procedure | Option to provide number of days from another event to diagnosis (e.g. days from birth to diagnosis). Derived as per user requirements | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registry and relevant hospital discharge dataset |
| Interval between primary procedure and death or when censored | Option to provide number of days from another event to date of death (e.g. days from birth to diagnosis). Derived as per user requirements | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registry and relevant hospital discharge dataset |
| Length of stay in days in the spell of care associated with the primary procedure | Total length of stay in hospital associated with the primary procedure | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Length of postoperative stay in hospital | Length of post-primary procedure stay in hospital in days | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Emergency readmission within 30 days of discharge following primary procedure | 0 = no, 1 = yes | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Death within 30 days of primary procedure | 0 = alive 1 = dead | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registry and relevant hospital discharge dataset |
| Death within 90 days of primary procedure | 0 = alive, 1 = dead | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registry and relevant hospital discharge dataset |
| Death during hospital stay of primary procedure | 0 = no 1 = yes | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| NHS Trust for primary procedure | Char(5) | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset | |
| Multidisciplinary team for primary procedure | Char(5) | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registry and relevant hospital discharge dataset | |
| Stoma opened at major resection | 0 = no, 1 = yes | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Stoma still open at 18 months following major resection | 0 = closed, 1 = open | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registry and relevant hospital discharge dataset |
| Approach to major resection | 0 = open, 1 = laparoscopic | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Converted laparoscopic procedures | 0 = not converted, 1 = converted, 9 = not laparoscopic | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Type of laparoscopic procedure | 0 = standard laparoscopic, 1 = robotic laparoscopic | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Return to theatre | Indicator of whether an individual had an emergency return to theatre following their major resection within 30 days of surgery | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Reason for return to theatre | Reason for the return to theatre | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset | |
| Failure to rescue | Death within 30 days of the return to theatre | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Consultant listed as overseeing the episode of care associated with the major resection | Char(9) | ||
| Specialty of overseeing consultant | 1 = colorectal 2 = vascular 3 = breast/endocrine | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| 4 = upper gastrointestinal/hepatobiliary/bariatric | |||
| 5 = transplant | |||
| 6 = general surgery 9 = other/unknown | |||
| ACPGBI membership status of consultant | 0 = non-member of the ACPGBI 1 = member of the ACPGBI | Char(1) | Derived by the UK Colorectal Cancer Intelligence Hub from information in the relevant hospital discharge dataset |
| Geography of diagnosis | Option to provide any geography listed at LOCATION based on the postcode of residence of the patient at the time of diagnosis of the colorectal tumour Derived as per user requirements | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets | |
| Geography of diagnosis and treatment | Option to provide any geography listed at LOCATION based on the hospitals of diagnosis and treatment of the patient at any time in their pathway of care. Derived as per user requirements | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets | |
| Travel time | Option to provide road travel time for each patient between their home and relevant hospitals they attended at any point across the care pathway. Derived as per user requirements | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets | |
| Travel distance | Option to provide road travel distance for each patient between their home and relevant hospitals they attended at any point across the care pathway. Derived as per user requirements | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets | |
| Neoadjuvant rectal cancer treatment | 0 = no radiotherapy 1 = short course radiotherapy with immediate surgery | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
| 2 = short course radiotherapy with delayed surgery | |||
| 3 = long course chemoradiotherapy | |||
| 4 = postoperative radiotherapy | |||
| 5 = other radiotherapy | |||
| Adjuvant chemotherapy | 0 = no 1 = yes | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
| Type of chemotherapy | 1 = single agent, 2 = combination agent | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
| Linkages | Flags to indicate whether the person or tumour links to other datasets available in CORECT-R | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
ICD, International Classification of Diseases; NCRAS, National Cancer Registration and Analysis Service; CORECT-R, COloRECTal cancer data Repository; TNM, Cancer staging system (T = Tumour, N = Nodes, M = Metastases); HES, Hospital Episodes Statistics; OPCS4, Classification of Interventions and Procedures version 4; ACPGBI, Association of Coloproctologists of Great Britain and Ireland.
Variables in the National Anal Cancer Dataset within CORECT-R. Currently these relate to the English population, but work is under way to expand to cover the UK
| Data item | Description of field content | Format | Source of information |
|---|---|---|---|
| Pseudonymized person ID | Unique study specific identifier for each patient. | Number | Derived by the UK Colorectal Cancer Intelligence Hub |
| Pseudonymized tumour ID | Unique study specific identifier for each tumour | Number | Derived by the UK Colorectal Cancer Intelligence Hub |
| Age | Option to derive age information in a format suitable for the research project needs. Can be single age or summarized in age bands (e.g. 5-year) and can could also include month and year of birth | Number | Cancer registration dataset |
| Sex | 0 = not known, 1 = male, 2 = female, 9 = not specified | Number | Cancer registration dataset |
| Ethnic group | Option to group ethnicities (e.g. White/non-White/unknown). Several methods of deriving ethnicity information have been used previously and can be derived as per user requirements | Text | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registration and hospital discharge datasets |
| Socioeconomic status | Option to include an appropriate indicator of socioeconomic status such as the Index of Multiple Deprivation | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
| Vital status of the patient | A = alive, D = dead, X = exit posting | Char(1) | Cancer registration dataset |
| Days from diagnosis to death | Time in days between specified anal cancer diagnosis and death or censoring | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registration dataset |
| Days from another event to date of death | Option to provide number of days from another event to death (e.g. days from diagnosis to death). Derived as per user requirements | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in key events from different datasets |
| Cause of death | Option to derive summary cause of death information based on the causes of death listed on death certificates or coded by former regional registries. Derived as per user requirements | Text | Cancer registration dataset |
| Place of death | Option to derive place of death based on information recorded on death certificates or from Hospital Episode Statistics. Derived as per user requirements | Cancer registration dataset | |
| Diagnosis date | Option to derive diagnosis date in a format suitable for the research project needs. This is likely to be in the format MM/YYYY unless permissions for access to identifiable data have been granted | Cancer registration dataset | |
| Days from another event to date to diagnosis | Option to provide number of days from another event to diagnosis (e.g. days from birth to diagnosis). Derived as per user requirements | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
| Basis of diagnosis of the tumour | 0 = death certificate, 1 = clinical, diagnosis made before death without (2-7), 2 = clinical investigation, 4 = specific tumour markers, 5 = cytology, 6 = histology of metastases, 7 = histology of primary tumour, 9 = unknown | Number | Cancer registration dataset |
| Route to diagnosis | 1 = GP referral, 2 = 2-week wait pathway, 3 = emergency presentation, 4 = other outpatient, 5 = screen detected, 6 = inpatient elective, 7 = death certificate only, 9 = unknown | Number | Cancer registration dataset |
| Site of neoplasm (4-character code) | Valid 4-digit ICD-10 codes in the range C21 | Char(4) | Cancer registration dataset |
| Morphology | The original 5-digit ICD03 morphology information captured by NCRAS | Char(5) | Cancer registration dataset |
| Morphology group | A grouped morphology variable derived by grouping the detailed morphology information available in NCRAS to provide the more useable histology types. For many analyses it may be appropriate to limit cases to exclude rare morphological sub types with non-standard treatment or unusual behaviour. | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registration dataset |
| Summary stage | A summary stage that combines information from the multiple staging variables available in NCRAS to maximize the number of cases with a stage classification | Number | Cancer registration dataset |
| Staging information | Option to derive staging information from any of the data items available in the CORECT-R tables (likely to be predominantly NCRAS Tumour table). This can include individual components of TNM or any other information that can be reported alone or combined as demanded by the research project. Derived as per user requirements | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registration dataset | |
| Comorbidity scores | Option to access a number of different comorbidity scores (such as Charlson, Elixhauser, C3) created as per user requirements. This could include using a previously published application of these scores or bespoke algorithms as demanded by the research project | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
| Abdominoperineal excision (APE) | 1 = APE, 0 = no APE | Char(1) | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registry and relevant hospital discharge dataset |
| Days from diagnosis to APE | Time in days between specified anal cancer diagnosis and APE | Number | Derived by the UK Colorectal Cancer Intelligence Hub from information in the cancer registry and relevant hospital discharge dataset |
| Surgical information | Option to provide surgical treatment information. Derived as per user requirements | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets | |
| Radiotherapy information | Option to provide radiotherapy treatment information. Derived as per user requirements | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets | |
| Chemotherapy information | Option to provide chemotherapy treatment information. Derived as per user requirements | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets | |
| Linkages | Flags to indicate whether the person or tumour links to other datasets available in CORECT-R | Derived by the UK Colorectal Cancer Intelligence Hub from information in multiple datasets |
ICD, International Classification of Diseases; NCRAS, National Cancer Registration and Analysis Service; CORECT-R, COloRECTal cancer data Repository; TNM, cancer staging system (T = Tumour, N = Nodes, M = Metastases); APE, abdominoperineal excision.