Data Dictionary: Pancreatic cancer - DPCA
From Beacon
Go back to Dutch Institute for Clinical Auditing Databases (DICA) (The Netherlands) page.
You can download the complete data dictionary. [Click here to learn more.
Patient
| CATEGORY | LABEL / DESCRIPTION | VARIABLE NAME | TYPE | LENGTH | FORMAT | VARIABLE REQUIRED | OPTION CHOICE REQUIRED | OPTIONSET | DEFAULT VALUE | VISIBLE | CONDITION | CALCULATION | HELP TEXT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SECTION | Identification | ||||||||||||
| Patient identification | Health institution | id | integer | 4 | Yes | Yes | 1002 | organisationId() | read-only | ||||
| 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. | |||||||
| 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'. | |||||
| 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. | |||||||
| Germany: Ausweisnummer: must comply with the rules applicable to a German ausweisnummer. | |||||||||||||
| 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). | |||||||||||||
| 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). | |||||||||||||
| 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." | |||||||||||||
| 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. | ||||||||
| Name data | Last Name | naam | text (encrypted in Survey) | 40 | Yes | Last name (birth name) as stated on the patient's identity documents. | |||||||
| 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. | ||||||
| Personal data | Gender | geslacht | integer | 1 | Yes | Yes | 500 | Gender as listed in the municipal basic administration (GBA). | |||||
| Personal data | Country (Residence Address) | land-woon | integer | 4 | Yes | Yes | 34 | 6030 | |||||
| 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. | ||||||
| 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. | |||||||
| SECTION | Comorbidities | ||||||||||||
| 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 | ||||||
| "Comorbidities | |||||||||||||
| Click on add new record when: | |||||||||||||
| - You are registering the patient's comorbidity status for the first time; | |||||||||||||
| - The patient's comorbidities have changed; | |||||||||||||
| - 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). | |||||||||||||
| - The patient is being registered due to a suspicion of OR proven pancreatic/periampullary tumor or premalignant cyst OR | |||||||||||||
| - The patient is being registered due to chronic pancreatitis requiring pancreatic head or tail resection | |||||||||||||
| Click on the existing record when: | |||||||||||||
| - You want to correct a mistakenly entered value. | |||||||||||||
| Do not add a record: | |||||||||||||
| - If the patient was only discussed in the MDT" | comorbidities | dataset | |||||||||||
| SECTION | Procedures | ||||||||||||
| "Procedures. | |||||||||||||
| 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 | |||||||||||
| SECTION | COVID-19 module | false | |||||||||||
| "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. | |||||||||||||
| 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). | |||||||||||||
| 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 | |||||||||
| SECTION | Pathology variables from PALGA | ||||||||||||
| 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 |
Commorbidities
| CATEGORY | LABEL / DESCRIPTION | VARIABLE NAME | TYPE | LENGTH | FORMAT | VARIABLE REQUIRED | OPTION CHOICE REQUIRED | OPTIONSET | DEFAULT VALUE | VISIBLE | CONDITION | CALCULATION | HELP TEXT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SECTION | Comorbidities 1 | |||||||||||||
| General | "Date of comorbidities | |||||||||||||
| This concerns the date on which the determination of these comorbidities was established. This date is often the same as 'consultation date' or 'surgery date'. | ||||||||||||||
| N.B. If the patient's comorbidity status has changed since your last entry, create a new record for this patient." | datcom | date | 10 | yyyy-mm-dd | Yes | A current date is essential for linking comorbidities to a treatment/episode. | ||||||||
| Pulmonary | Chronic lung disease | comlong | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comlong'), null) | "Chronic lung disease (ICD-10): | ||||||
| I27.8: Other specified pulmonary heart diseases | ||||||||||||||
| I27.9: Pulmonary heart disease, unspecified | ||||||||||||||
| J40.x-J47.x: Chronic diseases of the lower airways | ||||||||||||||
| J60.x-J67.x: Lung diseases due to external agents | ||||||||||||||
| J68.4: Chronic respiratory conditions due to chemicals, gases, fumes, and vapors | ||||||||||||||
| J70.1: Chronic and other lung manifestations by (ra)diation | ||||||||||||||
| J70.3: Chronic drug-induced interstitial lung diseases" | ||||||||||||||
| Cardiac | Myocardial infarction | commyo | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','commyo'), null) | "Myocardial infarction (ICD-10): | ||||||
| I21.x: Acute myocardial infarction | ||||||||||||||
| I22.x: Recurrent myocardial infarction | ||||||||||||||
| I25.2: Former myocardial infarction" | ||||||||||||||
| Cardiac | Congestive heart failure | comhartfaal | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comhartfaal'), null) | "Congestive heart failure (ICD-10): | ||||||
| I09.9: Rheumatic heart disease | ||||||||||||||
| I11.0: Hypertensive heart disease with (congestive) heart decompensation | ||||||||||||||
| I13.0,I32.2: Hypertensive heart and kidney disease with (congestive) heart decompensation (and renal insufficiency) | ||||||||||||||
| I25.5: Ischemic cardiomyopathy | ||||||||||||||
| I42.0, I42.5-I42.9: Cardiomyopathy with or without heart dilatation (non-obstructive and/or caused by external agents) | ||||||||||||||
| I50.x: Heart decompensation | ||||||||||||||
| P29.0: Neonatal cardiac insufficiency" | ||||||||||||||
| Vascular | Peripheral vascular disease/aortic aneurysm | comperif | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comperif'), null) | "Peripheral vascular disease/aortic aneurysm (ICD-10): | ||||||
| I70.x: Atherosclerosis | ||||||||||||||
| I71.x: Aneurysm and dissection of aorta | ||||||||||||||
| I73.1, I173.8-I73.9: Other peripheral vascular diseases | ||||||||||||||
| I77.1: Stricture of artery | ||||||||||||||
| I79.0, I79.2: Aneurysm of aorta or peripheral angiopathy in diseases classified elsewhere | ||||||||||||||
| K55.1, K55.8-K55.9: Vascular disorders (chronic) of intestine | ||||||||||||||
| Z95.8-Z95.9: Presence of other specified cardiac and vascular implants and grafts" | ||||||||||||||
| Neurological | Cerebrovascular disease (including CVA/TIA) | comcva | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comcva'), null) | "Cerebrovascular disease (ICD-10): | ||||||
| G45.x: 'Transient (cerebral) ischaemic attacks' [TIA] and related syndromes | ||||||||||||||
| G46.x: Vascular syndromes of the brain in cerebrovascular diseases | ||||||||||||||
| H34.0: Transient occlusion of retinal arteries | ||||||||||||||
| I60.x-I69.x: Cerebrovascular diseases" | ||||||||||||||
| Neurological | Para-/hemiplegia | comparalys | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comparalys'), null) | "Para-/hemiplegia (ICD-10): | ||||||
| G04.1: Tropical spastic paraplegia | ||||||||||||||
| G11.4: Hereditary spastic paraplegia | ||||||||||||||
| G80.1-G80.2: Diplegic/Hemiplegic 'cerebral palsy', spastic | ||||||||||||||
| G81.x: Hemiplegia | ||||||||||||||
| G82.x: Paraplegia and tetraplegia | ||||||||||||||
| G83.0-G83.4, G83.9: Other paralytic syndromes" | ||||||||||||||
| Neurological | Dementia | comdem | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comdem'), null) | "Dementia (ICD-10): | ||||||
| F00.x-F03.x: Dementia further specified | ||||||||||||||
| F05.1: Delirium, superimposed on dementia | ||||||||||||||
| G30.x: Alzheimer's disease | ||||||||||||||
| G31.1: Senile brain degeneration, not elsewhere classified" | ||||||||||||||
| Endocrine | Diabetes mellitus | comdiam | integer | 1 | Yes | 707 | if([../comcopy]==1, plugin('FindLastCreatedValue','comdiam'), null) | "If desired, use external disease category (chapter E10-E14) to specifically identify diabetic disease type. The following subcategories are intended for use with categories E10-E14: | ||||||
| E10.x: Type-1-diabetes | ||||||||||||||
| E11.x: Type-2-diabetes | ||||||||||||||
| E12.x: Malnutrition-related diabetes mellitus | ||||||||||||||
| E13.x: Other specified forms of diabetes mellitus | ||||||||||||||
| E14.x: Unspecified diabetes mellitus | ||||||||||||||
| Without chronic complications (ICD-10): | ||||||||||||||
| XX.0: Diabetic coma with or without ketoacidosis | ||||||||||||||
| XX.1: Diabetic ketoacidosis | ||||||||||||||
| XX.6: Diabetes with other specified complications | ||||||||||||||
| XX.8: Diabetes with unspecified complications | ||||||||||||||
| XX.9: Diabetes without complications | ||||||||||||||
| With chronic complications (ICD-10): | ||||||||||||||
| XX.2: Diabetes with renal complications | ||||||||||||||
| XX.3: Diabetes with ophthalmic complications | ||||||||||||||
| XX.4: Diabetes with neurological complications | ||||||||||||||
| XX.5: Diabetes with peripheral vascular complications | ||||||||||||||
| XX.7: Diabetes with multiple complications" | ||||||||||||||
| Endocrine | Insulin dependent | comdiaminsu | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comdiaminsu'), null) | [comdiam]==1 | [comdiam]==2 | Note: this variable cannot be automatically filled and must be manually entered. | ||||
| Gastrointestinal | Gastrointestinal ulcer disease | comgiulcus | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comgiulcus'), null) | "Gastrointestinal ulcer disease (ICD-10): | ||||||
| K25.x: Ulcer ventriculi | ||||||||||||||
| K26.x: Ulcer duodeni | ||||||||||||||
| K27.x: Peptic ulcer, site unspecified | ||||||||||||||
| K28.x: Ulcer gastrojejunale" | ||||||||||||||
| Gastrointestinal | Liver disease | comlever | integer | 1 | Yes | 708 | if([../comcopy]==1, plugin('FindLastCreatedValue','comlever'), null) | "Mild liver disease (ICD-10): | ||||||
| B18.x: Chronic viral hepatitis | ||||||||||||||
| K70.0-K70.3, K70.9: Alcoholic liver diseases | ||||||||||||||
| K71.3-K71.5, K71.7: Toxic liver disease (mild) | ||||||||||||||
| K73.x: Chronic hepatitis, not elsewhere classified | ||||||||||||||
| K74.x: Liver fibrosis and cirrhosis | ||||||||||||||
| K76.0: Fatty liver degeneration, not elsewhere classified | ||||||||||||||
| K76.2: Central hemorrhagic liver necrosis | ||||||||||||||
| K76.3: Liver infarction | ||||||||||||||
| K76.4: Peliosis hepatis | ||||||||||||||
| K76.8: Other specified liver diseases | ||||||||||||||
| K76.9: Liver disease, unspecified | ||||||||||||||
| Z94.4: Presence of liver transplant | ||||||||||||||
| Severe liver disease (ICD-10): | ||||||||||||||
| I85.x: Esophageal varices | ||||||||||||||
| I86.4: Varices of stomach | ||||||||||||||
| I98.2: Esophageal varices without bleeding in diseases classified elsewhere | ||||||||||||||
| K70.4: Alcoholic liver insufficiency | ||||||||||||||
| K72.x: Liver insufficiency, not elsewhere classified | ||||||||||||||
| K76.7: Hepatorenal syndrome" | ||||||||||||||
| Gastrointestinal | Pancreatitis (acute or chronic) | compancr | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','compancr'), null) | "Pancreatitis (acute or chronic) (ICD-10): | ||||||
| B25.2†: Pancreatitis due to cytomegalovirus (K87.1*) | ||||||||||||||
| K85.x: Acute pancreatitis | ||||||||||||||
| K86.0: Chronic pancreatitis due to alcohol | ||||||||||||||
| K86.1: Other chronic pancreatitis" | ||||||||||||||
| Urogenital | Kidney disease | comnier | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comnier'), null) | "Kidney diseases (ICD-10): | ||||||
| I12.0: Hypertensive kidney disease with renal insufficiency | ||||||||||||||
| I13.1: Hypertensive heart and kidney disease with renal insufficiency | ||||||||||||||
| N03.2-N03.7: Chronic nephritic syndrome | ||||||||||||||
| N05.2-N05.7: Unspecified nephritic syndrome | ||||||||||||||
| N18.x: Chronic kidney disease | ||||||||||||||
| N19.x: Unspecified renal insufficiency | ||||||||||||||
| N25.0: Renal osteodystrophy | ||||||||||||||
| Z49.x: Care at dialysis | ||||||||||||||
| Z94.0: Presence of kidney transplant | ||||||||||||||
| Z99.2: Dependence on hemodialysis" | ||||||||||||||
| Musculoskeletal | Connective tissue disease (including rheumatoid diseases) | combind | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','combind'), null) | "Connective tissue disease (ICD-10): | ||||||
| M05.x: Seropositive rheumatoid arthritis | ||||||||||||||
| M06.x: Other rheumatoid arthritis | ||||||||||||||
| M31.5: Giant cell arteritis with 'polymyalgia rheumatica' | ||||||||||||||
| M32.x-M34.x: Systemic diseases of connective tissue | ||||||||||||||
| M35.1: Other transitional syndromes | ||||||||||||||
| M35.3: Polymyalgia rheumatica | ||||||||||||||
| M36.0: Systemic diseases of connective tissue in diseases classified elsewhere" | ||||||||||||||
| Infectious disease | HIV/AIDS | comhiv | integer | 1 | Yes | 524 | if([../comcopy]==1, plugin('FindLastCreatedValue','comhiv'), null) | "Human immunodeficiency virus (HIV) (ICD-10): | ||||||
| B20.x: Disease by human immunodeficiency virus [HIV] leading to infectious diseases and parasitic conditions | ||||||||||||||
| B21.x: Disease by human immunodeficiency virus [HIV] leading to malignant neoplasms | ||||||||||||||
| B22.x: Disease by human immunodeficiency virus [HIV] leading to other specified diseases | ||||||||||||||
| B24.x: Unspecified disease by human immunodeficiency virus [HIV]" | ||||||||||||||
| Malignancy | Malignancy (excl. PCC or BCC of the skin) | commalig | integer | 1 | Yes | 709 | if([../comcopy]==1, plugin('FindLastCreatedValue','commalig'), null) | "This is about comorbidities, not the condition for which the patient is now being registered | ||||||
| Non-metastasized (ICD-10): | ||||||||||||||
| C00.x-C14.x: Malignant neoplasms of the lip, oral cavity, and pharynx | ||||||||||||||
| C15.x-C26.x: Malignant neoplasms of the digestive system | ||||||||||||||
| C30.x-C39.x: Malignant neoplasms of the respiratory system and intrathoracic organs | ||||||||||||||
| C40.x-C41.x: Malignant neoplasms of bone and articular cartilage | ||||||||||||||
| C43.x: Malignant melanoma of the skin | ||||||||||||||
| C45.x-C49.x: Malignant neoplasms of mesothelium and soft tissue | ||||||||||||||
| C50.x: Malignant neoplasms of the breast | ||||||||||||||
| C51.x-C58.x: Malignant neoplasms of female genital organs | ||||||||||||||
| C60.x-C63.x: Malignant neoplasms of male genital organs | ||||||||||||||
| C64.x-C68.x: Malignant neoplasms of the kidney and urinary tract | ||||||||||||||
| C69.x-C72.x: Malignant neoplasms of the eye, brain, and other parts of the central nervous system | ||||||||||||||
| C73.x-C75.x: Malignant neoplasms of the thyroid and other endocrine glands | ||||||||||||||
| C76.x: Malignant neoplasm of other and ill-defined sites | ||||||||||||||
| C81.x-C96.x: Malignant neoplasms of lymphoid, hematopoietic, and related tissue | ||||||||||||||
| C97.x: Malignant neoplasms of independent (primary) multiple sites | ||||||||||||||
| Metastasized (ICD-10): | ||||||||||||||
| C77.x: Secondary and unspecified malignant neoplasms of lymph nodes | ||||||||||||||
| C78.x: Secondary malignant neoplasm of the respiratory and digestive tracts | ||||||||||||||
| C79.x: Secondary malignant neoplasm of other and unspecified sites | ||||||||||||||
| C80.x: Malignant neoplasm without specified site | ||||||||||||||
| Note: no squamous cell carcinoma (PCC) and basal cell carcinoma (BCC)." | ||||||||||||||
| Malignancy | - Current (yet to be treated) | commal1 | integer | 1 | Yes | 501 | if([../comcopy]==1, plugin('FindLastCreatedValue','commal1'), null) | |||||||
| Malignancy | - Curatively treated < 5 years ago | commal2 | integer | 1 | Yes | 501 | if([../comcopy]==1, plugin('FindLastCreatedValue','commal2'), null) | |||||||
| Malignancy | - Curatively treated > 5 years ago | commal3 | integer | 1 | Yes | 501 | if([../comcopy]==1, plugin('FindLastCreatedValue','commal3'), null) | |||||||
| Malignancy | - Palliatively treated and/or distant metastases | commal4 | integer | 1 | Yes | 501 | if([../comcopy]==1, plugin('FindLastCreatedValue','commal4'), null) |
