Data dictionary: Colon cancer - DCRA: Difference between revisions

From Beacon
(Created page with "Go back to Dutch Institute for Clinical Auditing Databases (DICA) (The Netherlands) page. This is a summary of the variables available in the database. You can download the complete data dictionary. [https://dica.nl/data-aanvragen/ Click here to learn more]. '''Healthcare Facility''' * Healthcare Facility '''Patient Identification''' * Unique Patient Number * Hospital Patient Number * Tumor Tracking Number '''Patient Demographics''' * Date of Birth * Gender *...")
 
No edit summary
Line 3: Line 3:
This is a summary of the variables available in the database. You can download the complete data dictionary. [https://dica.nl/data-aanvragen/ Click here to learn more].
This is a summary of the variables available in the database. You can download the complete data dictionary. [https://dica.nl/data-aanvragen/ Click here to learn more].


'''Healthcare Facility'''
'''Table 1:''' Healthcare Facility.
* Healthcare Facility
{| class="wikitable"
! Variables
|-
| Healthcare Facility
|}


'''Table 2:''' Patient Identification.
{| class="wikitable"
! Variables
|-
| Unique Patient Number
|-
| Hospital Patient Number
|-
| Tumor Tracking Number
|}


'''Patient Identification'''
'''Table 3:''' Patient Demographics.
* Unique Patient Number
{| class="wikitable"
* Hospital Patient Number
! Variables
* Tumor Tracking Number
|-
| Date of Birth
|-
| Gender
|-
| Date of Death (if applicable)
|}


'''Table 4:''' Comorbidities and Prior Conditions.
{| class="wikitable"
! Variables
|-
| Myocardial Infarction
|-
| Congestive Heart Failure
|-
| Peripheral Vascular Disease/Aortic Aneurysm
|-
| Cerebrovascular Disease (e.g., CVA/TIA)
|-
| Dementia
|-
| Chronic Lung Disease
|-
| Connective Tissue Disease (e.g., Rheumatoid Diseases)
|-
| Gastrointestinal Ulcer Disease
|-
| Liver Disease
|-
| Diabetes Mellitus
|-
| Paralysis/Hemiplegia
|-
| Kidney Disease
|-
| Cancer (excluding PCC or BCC of skin)
|-
| HIV/AIDS
|}


'''Patient Demographics'''
'''Table 5:''' Surgical and Medical History.
* Date of Birth
{| class="wikitable"
* Gender
! Variables
* Date of Death (if applicable)
|-
| Bowel Resection (Colon/Rectum) in History
|-
| Presence of Stoma before Treatment of Colorectal Carcinoma
|-
| Is this a First or Second Primary Tumor?
|-
| Number of Diagnosed Carcinomas
|-
| Date of Diagnosis 1st Colorectal Carcinoma
|-
| Reason for Diagnostics
|-
| Localization of 1st Colorectal Carcinoma
|-
| Histology Based on Biopsy/Polypectomy
|-
| Tumor-Related Complications?
|}




'''Comorbidities and Prior Conditions'''
'''Table 6:''' Surgical Procedures and Outcomes.
* Myocardial Infarction
{| class="wikitable"
* Congestive Heart Failure
! Variables
* Peripheral Vascular Disease/Aortic Aneurysm
|-
* Cerebrovascular Disease (e.g., CVA/TIA)
| Date of 1st and 2nd Surgical Procedure
* Dementia
|-
* Chronic Lung Disease
| Type of Surgery Performed
* Connective Tissue Disease (e.g., Rheumatoid Diseases)
|-
* Gastrointestinal Ulcer Disease
| Approach of 1st and 2nd Surgical Procedure
* Liver Disease
|-
* Diabetes Mellitus
| Conversion of Procedures
* Paralysis/Hemiplegia
|-
* Kidney Disease
| Additional Resection due to Tumor Growth
* Cancer (excluding PCC or BCC of skin)
|-
* HIV/AIDS
| Additional Resection due to Metastases
|-
| Was There Intraoperative Radiotherapy or Chemotherapy?
|-
| Was an Anastomosis of the Intestine Made after Resection of the Tumor?
|}


'''Table 7:''' Complications.
{| class="wikitable"
! Variables
|-
| Surgical Complications
|-
| General Complications
|-
| Pulmonary Complication
|-
| Cardiac Complication
|-
| Thromboembolic Complication
|-
| Infectious Complication
|-
| Neurological Complication
|-
| Other Complication
|}


'''Surgical and Medical History'''
'''Table 8:''' Pathology and Genetic Analysis.
* Bowel Resection (Colon/Rectum) in History
{| class="wikitable"
* Presence of Stoma before Treatment of Colorectal Carcinoma
! Variables
* Is this a First or Second Primary Tumor?
|-
* Number of Diagnosed Carcinomas
| Histological Type of 1st and 2nd Colorectal Carcinoma
* Date of Diagnosis 1st Colorectal Carcinoma
|-
* Reason for Diagnostics
| Pathological T/N Classification According to TNM System
* Localization of 1st Colorectal Carcinoma
|-
* Histology Based on Biopsy/Polypectomy
| M Stage
* Tumor-Related Complications?
|-
| Radicality of 1st and 2nd Tumor
|-
| Lymphangioinvasion Detected?
|-
| Extramural Venous Invasion
|-
| Differentiation Grade
|-
| BRAF Mutation Present
|-
| RAS Mutation Present
|-
| MSI Determination
|-
| Immunohistochemical Determination of Mismatch Repair Proteins
|-
| Mismatch Repair Proteins (MMR) Loss
|}


'''Table 9:''' Systemic and Radiation Therapy.
{| class="wikitable"
! Variables
|-
| Preoperative and Postoperative Systemic Therapy
|-
| Start and Stop Date of Systemic Therapy
|-
| Radiotherapy Administered
|-
| Start and Stop Date of Radiation
|}


'''Surgical Procedures and Outcomes'''
'''Table 10:''' General Patient Information.
* Date of 1st and 2nd Surgical Procedure
{| class="wikitable"
* Type of Surgery Performed
! Variables
* Approach of 1st and 2nd Surgical Procedure
|-
* Conversion of Procedures
| Length (in cm)
* Additional Resection due to Tumor Growth
|-
* Additional Resection due to Metastases
| Weight (in kg)
* Was There Intraoperative Radiotherapy or Chemotherapy?
|-
* Was an Anastomosis of the Intestine Made after Resection of the Tumor?
| Body Mass Index Calculator
 
|-
 
| Date of Initial Preoperative Visit (poli) Surgery
'''Complications'''
|-
* Surgical Complications
| Reason for (Extended) MC/IC Stay and/or Readmission
* General Complications
|-
* Pulmonary Complication
| Blood Transfusion during Admission
* Cardiac Complication
|-
* Thromboembolic Complication
| Patient Readmission < 90 Days After Discharge
* Infectious Complication
|-
* Neurological Complication
| Date of First Readmission
* Other Complication
|-
 
| Study Participation
 
|}
'''Pathology and Genetic Analysis'''
* Histological Type of 1st and 2nd Colorectal Carcinoma
* Pathological T/N Classification According to TNM System
* M Stage
* Radicality of 1st and 2nd Tumor
* Lymphangioinvasion Detected?
* Extramural Venous Invasion
* Differentiation Grade
* BRAF Mutation Present
* RAS Mutation Present
* MSI Determination
* Immunohistochemical Determination of Mismatch Repair Proteins
* Mismatch Repair Proteins (MMR) Loss
 
 
'''Systemic and Radiation Therapy'''
* Preoperative and Postoperative Systemic Therapy
* Start and Stop Date of Systemic Therapy
* Radiotherapy Administered
* Start and Stop Date of Radiation
 
 
'''General Patient Information'''
* Length (in cm)
* Weight (in kg)
* Body Mass Index Calculator
* Date of Initial Preoperative Visit (poli) Surgery
* Reason for (Extended) MC/IC Stay and/or Readmission
* Blood Transfusion during Admission
* Patient Readmission < 90 Days After Discharge
* Date of First Readmission
* Study Participation

Revision as of 11:47, 25 May 2024

Go back to Dutch Institute for Clinical Auditing Databases (DICA) (The Netherlands) page.

This is a summary of the variables available in the database. You can download the complete data dictionary. Click here to learn more.

Table 1: Healthcare Facility.

Variables
Healthcare Facility

Table 2: Patient Identification.

Variables
Unique Patient Number
Hospital Patient Number
Tumor Tracking Number

Table 3: Patient Demographics.

Variables
Date of Birth
Gender
Date of Death (if applicable)

Table 4: Comorbidities and Prior Conditions.

Variables
Myocardial Infarction
Congestive Heart Failure
Peripheral Vascular Disease/Aortic Aneurysm
Cerebrovascular Disease (e.g., CVA/TIA)
Dementia
Chronic Lung Disease
Connective Tissue Disease (e.g., Rheumatoid Diseases)
Gastrointestinal Ulcer Disease
Liver Disease
Diabetes Mellitus
Paralysis/Hemiplegia
Kidney Disease
Cancer (excluding PCC or BCC of skin)
HIV/AIDS

Table 5: Surgical and Medical History.

Variables
Bowel Resection (Colon/Rectum) in History
Presence of Stoma before Treatment of Colorectal Carcinoma
Is this a First or Second Primary Tumor?
Number of Diagnosed Carcinomas
Date of Diagnosis 1st Colorectal Carcinoma
Reason for Diagnostics
Localization of 1st Colorectal Carcinoma
Histology Based on Biopsy/Polypectomy
Tumor-Related Complications?


Table 6: Surgical Procedures and Outcomes.

Variables
Date of 1st and 2nd Surgical Procedure
Type of Surgery Performed
Approach of 1st and 2nd Surgical Procedure
Conversion of Procedures
Additional Resection due to Tumor Growth
Additional Resection due to Metastases
Was There Intraoperative Radiotherapy or Chemotherapy?
Was an Anastomosis of the Intestine Made after Resection of the Tumor?

Table 7: Complications.

Variables
Surgical Complications
General Complications
Pulmonary Complication
Cardiac Complication
Thromboembolic Complication
Infectious Complication
Neurological Complication
Other Complication

Table 8: Pathology and Genetic Analysis.

Variables
Histological Type of 1st and 2nd Colorectal Carcinoma
Pathological T/N Classification According to TNM System
M Stage
Radicality of 1st and 2nd Tumor
Lymphangioinvasion Detected?
Extramural Venous Invasion
Differentiation Grade
BRAF Mutation Present
RAS Mutation Present
MSI Determination
Immunohistochemical Determination of Mismatch Repair Proteins
Mismatch Repair Proteins (MMR) Loss

Table 9: Systemic and Radiation Therapy.

Variables
Preoperative and Postoperative Systemic Therapy
Start and Stop Date of Systemic Therapy
Radiotherapy Administered
Start and Stop Date of Radiation

Table 10: General Patient Information.

Variables
Length (in cm)
Weight (in kg)
Body Mass Index Calculator
Date of Initial Preoperative Visit (poli) Surgery
Reason for (Extended) MC/IC Stay and/or Readmission
Blood Transfusion during Admission
Patient Readmission < 90 Days After Discharge
Date of First Readmission
Study Participation