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]. | ||
''' | '''Table 1:''' Healthcare Facility. | ||
{| class="wikitable" | |||
! Variables | |||
|- | |||
| Healthcare Facility | |||
|} | |||
'''Table 2:''' Patient Identification. | |||
{| class="wikitable" | |||
! Variables | |||
|- | |||
| Unique Patient Number | |||
|- | |||
| Hospital Patient Number | |||
|- | |||
| Tumor Tracking Number | |||
|} | |||
''' | '''Table 3:''' Patient Demographics. | ||
{| class="wikitable" | |||
! Variables | |||
|- | |||
| 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 | |||
|} | |||
''' | '''Table 5:''' Surgical and Medical History. | ||
{| class="wikitable" | |||
! 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. | ||
{| class="wikitable" | |||
! 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. | |||
{| class="wikitable" | |||
! Variables | |||
|- | |||
| Surgical Complications | |||
|- | |||
| General Complications | |||
|- | |||
| Pulmonary Complication | |||
|- | |||
| Cardiac Complication | |||
|- | |||
| Thromboembolic Complication | |||
|- | |||
| Infectious Complication | |||
|- | |||
| Neurological Complication | |||
|- | |||
| Other Complication | |||
|} | |||
''' | '''Table 8:''' Pathology and Genetic Analysis. | ||
{| class="wikitable" | |||
! 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. | |||
{| class="wikitable" | |||
! 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. | ||
{| class="wikitable" | |||
! 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 | |||
|} | |||
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 |