Data Dictionary: Pancreatic cancer - DPCA: Difference between revisions

From Beacon
(Created page with "Go back to Dutch Institute for Clinical Auditing Databases (DICA) (The Netherlands) page. You can download the complete data dictionary. [[https://support.mrdm.com/nl/downloads/documenten/ Click here to learn more]. ==== PATIENT ==== {| class="wikitable" ! CATEGORY !! LABEL / DESCRIPTION !! VARIABLE NAME !! TYPE !! LENGTH !! FORMAT !! VARIABLE REQUIRED !! OPTION CHOICE REQUIRED !! OPTIONSET !! DEFAULT VALUE !! VISIBLE !! CONDITION !! CALCULATION !! HELP TEXT |- |...")
 
No edit summary
 
(15 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<span style="display:none">forresearchers</span>
<span style="display:none">thenetherlandscountry</span>
Go back to [[Dutch Institute for Clinical Auditing Databases (DICA) (The Netherlands)]] page.
Go back to [[Dutch Institute for Clinical Auditing Databases (DICA) (The Netherlands)]] page.


You can download the complete data dictionary. [[https://support.mrdm.com/nl/downloads/documenten/ Click here to learn more].
This is a summary of the variables available in the database. You can download the complete data dictionary here: [https://support.mrdm.com/nl/downloads/documenten/ Click here to learn more].


==== PATIENT ====
'''Table 1:''' Patient Demographics and Identification.
{| class="wikitable"
! Variables !! Description
|-
| Zorginstelling || Healthcare Institution
|-
| Uniek Patiëntnummer || Unique Patient Number
|-
| Burger Service Nummer || Social Security Number
|-
| Geslachtsnaam || Surname
|-
| Geboortedatum || Date of Birth
|-
| Geslacht || Gender
|-
| Land (Woonadres) || Country (Country of Residence)
|-
| Postcode || Postal Code
|-
| Datum overlijden (indien van toepassing) || Date of Death (if applicable)
|}
 
'''Table 2:''' Comorbidities.
{| class="wikitable"
! Variables !! Description
|-
| Comorbiditeiten || Comorbidities, with options to add a new record or update based on changes or previous registrations
|}
 
'''Table 3:''' Medical Procedures.
{| class="wikitable"
! Variables !! Description
|-
| Verrichtingen || Procedures, where multiple procedures per patient can be registered if applicable
|}
 
'''Table 4:''' COVID-19 Module.
{| class="wikitable"
! Variables !! Description
|-
| Deze generieke COVID-19 module || A generic COVID-19 module added due to the impact of the coronavirus crisis on the quality of care, allowing for the better interpretation of indicators during this period
|}
 
'''Table 5:''' Pathology Variables through PALGA.
{| class="wikitable"
! Variables !! Description
|-
| In het kader van de PALGA-koppeling worden pathologie variabelen || Pathology variables automatically structured and included in the registration via the PALGA-pathology module, requiring no additional data
|}
 
'''Table 6:''' Patient Identification and Treatment Timeline.
{| class="wikitable"
! Variables
|-
| Treatment start date
|-
| Reason for registration
|-
| Hospital patient number
|}
 
'''Table 7:''' Patient Physical and Performance Metrics.
{| class="wikitable"
! Variables
|-
| Height in cm
|-
| Preoperative weight in kg
|-
| Weight loss in kg and period in weeks
|-
| ECOG performance status (Eastern Cooperative Oncology Group)
|}
 
'''Table 8:'''  Laboratory Biomarkers.
{| class="wikitable"
! Variables
|-
| Bilirubine in µmol/l
|-
| Hemoglobine in mmol/l
|-
| Albumine in g/l
|-
| IgG4 in g/l
|-
| Carcinoembryonic antigen (CEA) in µg/l
|-
| CA19.9 in kU/l (Note: Last CA19.9 before the start of neoadjuvant treatment or surgery)
|}
 
'''Table 9:''' Imaging and Diagnostic Procedures.
{| class="wikitable"
! Variables
|-
| CT, MRI, or MRCP performed
|-
| Date of the last preoperative imaging
|-
| Presence of a tumour in the pancreas or periampullary on CT or MRI
|-
| Cystic features suggestive of malignancy
|-
| Involvement of vessels and other structures on imaging
|}
 
'''Table 10:''' Histology and Cytology.
{| class="wikitable"
! Variables
|-
| Preoperative PA number
|-
| Method and date of obtaining the first positive cytology or histology
|-
| Histological and cytological diagnoses
|}
 
'''Table 11:''' Multidisciplinary Team Consultations and Decisions.
{| class="wikitable"
! Variables
|-
| Date of the last MDT (Multidisciplinary Team) discussion before treatment
|-
| Working diagnosis and eligibility for surgical exploration
|}


'''Table 12:''' Treatment and Surgery Details.
{| class="wikitable"
{| class="wikitable"
! CATEGORY !! LABEL / DESCRIPTION !! VARIABLE NAME !! TYPE !! LENGTH !! FORMAT !! VARIABLE REQUIRED !! OPTION CHOICE REQUIRED !! OPTIONSET !! DEFAULT VALUE !! VISIBLE !! CONDITION !! CALCULATION !! HELP TEXT
! Variables
|-
|-
| || SECTION || Identification ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||
| Neo-adjuvant/induction treatment type and start date
|-
|-
| Patient identification || Health institution || id || integer || 4 ||  || Yes || Yes || 1002 || organisationId() || read-only ||  ||  ||  
| Operative details including ASA score, type of resection, and operative complications
|-
| Postoperative pathology including tumour origin, size, and grade
|}
 
'''Table 13:''' Postoperative Management and Follow-Up.
{| class="wikitable"
! Variables
|-
|-
| Patient identification || Unique Patient Number || upn || text (encrypted in Survey) || 15 ||  || Yes ||  ||  ||  ||  ||  ||  || The hospital patient number (UPN) as registered in the electronic patient record (EPR) of the respective hospital.
| Palliative treatments including chemotherapy and radiotherapy
|-
|-
| Patient identification || Citizen Service Number country || land || text || 10 ||  || Yes || Yes || countries ||  ||  ||  ||  || Choose here the country where the patient's identification number was issued. If nationality is other than Dutch, German, Belgian, or Swedish, choose 'Unknown'.
| Date of discharge and any readmissions within 30 days
|-
|-
| Patient identification || Citizen Service Number || idcode || text (encrypted in Survey) || 15 ||  || Yes ||  ||  ||  ||  ||  ||  || "Netherlands: Citizen Service Number: must consist of 9 digits and meet the eleven-test.
| Adjuvant therapy details and participation in oncological trials
|}
 
'''Table 14:''' SARS-CoV-2 Suspected or Confirmed Infection.
{| class="wikitable"
! Variables
|-
|-
|  
| Presence of a clinical suspicion or test for SARS-CoV-2 infection prior to and up to 30 days post-admission.
|-
|-
| Germany: Ausweisnummer: must comply with the rules applicable to a German ausweisnummer.
| Date of the first suspicion of SARS-CoV-2 infection.
|-
|-
|  
| Date of the first specific test for SARS-CoV-2 infection.
|-
|-
| Belgium: National Register Number: consists of 11 digits, composed of the birth date (year, month, day), series number (3 digits), and control number (2 digits).
| Date of the first positive laboratory test for SARS-CoV-2.
|-
|-
|  
| Final status regarding SARS-CoV-2 infection.
|}
 
'''Table 15:''' Preoperative and Postoperative COVID-19 Testing.
{| class="wikitable"
! Variables
|-
|-
| Sweden: Personal Number: consists of 10 digits, composed of the birth date (year, month, day), a dash or plus sign, a series number (3 digits), and a control number (1 digit).
| Number of preoperative RT-PCR tests and the date of the first test.
|-
|-
|  
| Date of the first preoperative CT thorax with COVID-19 concern and CORADS 4-5 score.
|-
|-
| Other or Unknown: if Other or Unknown, enter the hospital number followed by the patient number (UPN) as registered in the electronic patient record (EPR) of the respective hospital."
| Number of postoperative RT-PCR tests and the date of the first test.
|-
|-
| Name data || Prefixes || tussen || text (encrypted in Survey) || 8 ||  ||  ||  ||  ||  ||  ||  ||  || Prefixes belonging to the last name (birth name) as stated on the patient's identity documents.
| Date of the first postoperative CT thorax with COVID-19 concern and CORADS 4-5 score.
|-
|-
| Name data || Last Name || naam || text (encrypted in Survey) || 40 ||  || Yes ||  ||  ||  ||  ||  ||  || Last name (birth name) as stated on the patient's identity documents.
| Definitive preoperative and postoperative COVID-19 status.
|}
 
'''Table 16:''' Patient Characteristics.
{| class="wikitable"
! Variables
|-
|-
| Personal data || Birth Date || gebdat || date || 10 || yyyy-mm-dd || Yes ||  ||  ||  ||  ||  ||  || Birth date of the patient displayed in the Dutch date format. Example: 22-04-1999.
| Symptoms indicative of COVID-19 (e.g., cough, fever, dyspnea, loss of smell/taste).
|-
|-
| Personal data || Gender || geslacht || integer || 1 ||  || Yes || Yes || 500 ||  ||  ||  ||  || Gender as listed in the municipal basic administration (GBA).
| Patient's smoking status and pack-years.
|-
|-
| Personal data || Country (Residence Address) || land-woon || integer || 4 ||  || Yes || Yes || 34 || 6030 ||  ||  ||  ||
| Patient's height (in cm) and weight (in kg) at admission.
|}
 
'''Table 17:''' Surgical and Intensive Care Considerations.
{| class="wikitable"
! Variables
|-
|-
| Personal data || Postal Code || pcode || text (encrypted in Survey) || 7 ||  || Yes ||  ||  ||  ||  || [land-woon]==6030 ||  || Postal code at the time of first contact. Only fill in for a Dutch residential address! Preferably use the postal code from the Postal Code Table (OID: 2.16.840.1.113883.2.4.4.15). Dutch postal codes consist of 4 digits and two capital letters. Example: 1234AB.
| Presence of preoperative COVID-19 related complications (e.g., ARDS, acute renal failure, arrhythmias, thromboembolic events).
|-
|-
| Personal data || Date of Death (if applicable) || datovl || date || 10 || yyyy-mm-dd ||  ||  ||  ||  ||  ||  ||  || The date on which the patient died, in the Dutch date format. Example: 22-04-1999.
| Impact on neoadjuvant treatment and changes in treatment plans or schedules.
|-
|-
| || SECTION || Comorbidities ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||
| Impact on surgical approach (laparoscopic, robotic, open) due to COVID-19.
|-
|-
| Comorbidities || Click yes, to carry over previously registered comorbidities into the record you are about to add. || comcopy || integer || 1 ||  ||  || Yes || 524 ||  ||  || plugin('IknlCounter','comorbidities') >= 1 ||  ||
| Postoperative complaints consistent with COVID-19 and the number of days post-surgery they began.
|}
 
'''Table 18:'''ICU Admission Related to COVID-19.
{| class="wikitable"
! Variables
|-
|-
| || "Comorbidities
| Presence and type of ICU admission related to COVID-19.
|-
|-
|  
| Type of respiratory support during ICU stay (e.g., prone ventilation, ECMO).
|-
|-
| Click on add new record when:
| ICU admission and discharge dates and durations.
|-
|-
| - You are registering the patient's comorbidity status for the first time;
| Destination after ICU discharge.
|}
 
'''Table 19:''' Sample Information.
{| class="wikitable"
! Variables
|-
|-
| - The patient's comorbidities have changed;
| Date of tissue arrival at laboratory
|-
|-
| - The comorbidities were previously registered (> 1 year) and have not changed (in this case, you can use the above button to carry over previously registered values).
| Pathology laboratory
|-
|-
| - The patient is being registered due to a suspicion of OR proven pancreatic/periampullary tumor or premalignant cyst OR
| Pathology number (TJJ-CCCCCC)
|-
|-
| - The patient is being registered due to chronic pancreatitis requiring pancreatic head or tail resection
| Protocol
|-
|-
|  
| Sample number
|}
 
'''Table 20:'''Diagnostic Details.
{| class="wikitable"
! Variables
|-
|-
| Click on the existing record when:
| Is cytology or histology obtained during the diagnostic process?
|-
|-
| - You want to correct a mistakenly entered value.
| Most likely origin of the tumour
|-
|-
|  
| Histological diagnosis?
|}
 
'''Table 21:''' Tumour Characteristics.
{| class="wikitable"
! Variables
|-
|-
| Do not add a record:
| Largest tumour diameter in cm
|-
|-
| - If the patient was only discussed in the MDT" || comorbidities || dataset ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||
| Smallest margin in cm (radicality)
|-
|-
| || SECTION || Procedures ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||
| Tumour differentiation grade
|-
|-
| || "Procedures.
| Neuroendocrine tumour differentiation grade
|-
|-
| It is possible to register multiple procedures per patient if applicable. If you want to register the first procedure or a new procedure for this patient, click on “add”. If you want to add information to a procedure that was already created for this patient, click on the horizontal bar. If you want to create a new patient, click back to ""home"" at the top left." || procedure || dataset ||  ||  ||  ||  ||  ||  ||  ||  ||  ||
| pT-stage pancreatic carcinoma according to TNM8
|-
|-
| || SECTION || COVID-19 module ||  ||  ||  ||  ||  ||  ||  ||  || false ||  ||
| Papil of Vater carcinoma according to TNM8
|-
|-
| || "This generic COVID-19 module has been added to the DICA registrations 2020 due to the impact the corona crisis has had on the quality of care, as measured in the DICA registrations. With the data in this module, your indicator outcomes for this period can be better interpreted and possibly adjusted for the effects of SARS-CoV-2 infections of your patients and the measures that had to be taken in your hospital during the pandemic.
| Distal cholangiocarcinoma according to TNM8
|-
|-
| This module is aligned with previous data collections of COVID-19 patients in hospitals by the NICE Foundation. By requesting an export of your own data from NICE and supplying it to MRDM, this data can be reused. A large part of the generic module can therefore be pre-filled. Contact the MRDM service desk for more information about this supply (servicedesk@mrdm.nl).
| Duodenum carcinoma according to TNM8 small intestine
|}
 
'''Table 22:'''Lymph Node and Metastasis Information.
{| class="wikitable"
! Variables
|-
|-
|  
| Number of lymph nodes found
|-
|-
| If you are participating in the COVIDSURG II snapshot study for this registration, first fill in the generic module here and then you can complete the research module by answering the last question: 'Are you participating in the COVIDSURG-2 Snapshot?' with 'Yes' and the questions will then become visible. For information or participation, please contact covidsurg@dica.nl." || covid19 || dataset ||  ||  ||  ||  ||  ||  || not visible due to section condition || FALSE ||  ||
| Number of tumour-positive lymph nodes found
|-
|-
| || SECTION || Pathology variables from PALGA ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
| Distant metastases?
|}
 
'''Table 23:'''Response to Treatment.
{| class="wikitable"
! Variables
|-
|-
| || As part of the PALGA link, pathology variables from the PALGA Foundation are automatically and structuredly included in the registration. For this purpose, the PALGA pathology module has been added to the registration for which no additional data needs to be supplied || palga-pathology || dataset ||  ||  ||  ||  ||  ||  || read-only
| Pathological response after neoadjuvant therapy with Histological Tumour Regression Grading (HTRG)
|}
|}

Latest revision as of 17:42, 4 December 2025

forresearchers thenetherlandscountry 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 here: Click here to learn more.

Table 1: Patient Demographics and Identification.

Variables Description
Zorginstelling Healthcare Institution
Uniek Patiëntnummer Unique Patient Number
Burger Service Nummer Social Security Number
Geslachtsnaam Surname
Geboortedatum Date of Birth
Geslacht Gender
Land (Woonadres) Country (Country of Residence)
Postcode Postal Code
Datum overlijden (indien van toepassing) Date of Death (if applicable)

Table 2: Comorbidities.

Variables Description
Comorbiditeiten Comorbidities, with options to add a new record or update based on changes or previous registrations

Table 3: Medical Procedures.

Variables Description
Verrichtingen Procedures, where multiple procedures per patient can be registered if applicable

Table 4: COVID-19 Module.

Variables Description
Deze generieke COVID-19 module A generic COVID-19 module added due to the impact of the coronavirus crisis on the quality of care, allowing for the better interpretation of indicators during this period

Table 5: Pathology Variables through PALGA.

Variables Description
In het kader van de PALGA-koppeling worden pathologie variabelen Pathology variables automatically structured and included in the registration via the PALGA-pathology module, requiring no additional data

Table 6: Patient Identification and Treatment Timeline.

Variables
Treatment start date
Reason for registration
Hospital patient number

Table 7: Patient Physical and Performance Metrics.

Variables
Height in cm
Preoperative weight in kg
Weight loss in kg and period in weeks
ECOG performance status (Eastern Cooperative Oncology Group)

Table 8: Laboratory Biomarkers.

Variables
Bilirubine in µmol/l
Hemoglobine in mmol/l
Albumine in g/l
IgG4 in g/l
Carcinoembryonic antigen (CEA) in µg/l
CA19.9 in kU/l (Note: Last CA19.9 before the start of neoadjuvant treatment or surgery)

Table 9: Imaging and Diagnostic Procedures.

Variables
CT, MRI, or MRCP performed
Date of the last preoperative imaging
Presence of a tumour in the pancreas or periampullary on CT or MRI
Cystic features suggestive of malignancy
Involvement of vessels and other structures on imaging

Table 10: Histology and Cytology.

Variables
Preoperative PA number
Method and date of obtaining the first positive cytology or histology
Histological and cytological diagnoses

Table 11: Multidisciplinary Team Consultations and Decisions.

Variables
Date of the last MDT (Multidisciplinary Team) discussion before treatment
Working diagnosis and eligibility for surgical exploration

Table 12: Treatment and Surgery Details.

Variables
Neo-adjuvant/induction treatment type and start date
Operative details including ASA score, type of resection, and operative complications
Postoperative pathology including tumour origin, size, and grade

Table 13: Postoperative Management and Follow-Up.

Variables
Palliative treatments including chemotherapy and radiotherapy
Date of discharge and any readmissions within 30 days
Adjuvant therapy details and participation in oncological trials

Table 14: SARS-CoV-2 Suspected or Confirmed Infection.

Variables
Presence of a clinical suspicion or test for SARS-CoV-2 infection prior to and up to 30 days post-admission.
Date of the first suspicion of SARS-CoV-2 infection.
Date of the first specific test for SARS-CoV-2 infection.
Date of the first positive laboratory test for SARS-CoV-2.
Final status regarding SARS-CoV-2 infection.

Table 15: Preoperative and Postoperative COVID-19 Testing.

Variables
Number of preoperative RT-PCR tests and the date of the first test.
Date of the first preoperative CT thorax with COVID-19 concern and CORADS 4-5 score.
Number of postoperative RT-PCR tests and the date of the first test.
Date of the first postoperative CT thorax with COVID-19 concern and CORADS 4-5 score.
Definitive preoperative and postoperative COVID-19 status.

Table 16: Patient Characteristics.

Variables
Symptoms indicative of COVID-19 (e.g., cough, fever, dyspnea, loss of smell/taste).
Patient's smoking status and pack-years.
Patient's height (in cm) and weight (in kg) at admission.

Table 17: Surgical and Intensive Care Considerations.

Variables
Presence of preoperative COVID-19 related complications (e.g., ARDS, acute renal failure, arrhythmias, thromboembolic events).
Impact on neoadjuvant treatment and changes in treatment plans or schedules.
Impact on surgical approach (laparoscopic, robotic, open) due to COVID-19.
Postoperative complaints consistent with COVID-19 and the number of days post-surgery they began.

Table 18:ICU Admission Related to COVID-19.

Variables
Presence and type of ICU admission related to COVID-19.
Type of respiratory support during ICU stay (e.g., prone ventilation, ECMO).
ICU admission and discharge dates and durations.
Destination after ICU discharge.

Table 19: Sample Information.

Variables
Date of tissue arrival at laboratory
Pathology laboratory
Pathology number (TJJ-CCCCCC)
Protocol
Sample number

Table 20:Diagnostic Details.

Variables
Is cytology or histology obtained during the diagnostic process?
Most likely origin of the tumour
Histological diagnosis?

Table 21: Tumour Characteristics.

Variables
Largest tumour diameter in cm
Smallest margin in cm (radicality)
Tumour differentiation grade
Neuroendocrine tumour differentiation grade
pT-stage pancreatic carcinoma according to TNM8
Papil of Vater carcinoma according to TNM8
Distal cholangiocarcinoma according to TNM8
Duodenum carcinoma according to TNM8 small intestine

Table 22:Lymph Node and Metastasis Information.

Variables
Number of lymph nodes found
Number of tumour-positive lymph nodes found
Distant metastases?

Table 23:Response to Treatment.

Variables
Pathological response after neoadjuvant therapy with Histological Tumour Regression Grading (HTRG)