DOI: 10.5281/zenodo.11519029
title: CONCEPT-DIABETES DATA MODEL TO ANALYSE HEALTHCARE PATHWAYS OF TYPE 2 DIABETES

description: Technical notes and documentation on the common data model of the project CONCEPT-DM2. 

This publication corresponds to the Common Data Model (CDM) specification of the CONCEPT-DM2 project for the implementation of a federated network analysis of the healthcare pathway of type 2 diabetes, version v0.2.0.

Aims of the CONCEPT-DM2 project: 

General aim: To analyse chronic care effectiveness and efficiency of care pathways in diabetes, assuming the relevance of care pathways as independent factors of health outcomes using data from real life world (RWD) from five Spanish Regional Health Systems.

Main specific aims:



To characterize the care pathways in patients with diabetes through the whole care system in terms of process indicators and pharmacologic recommendations

To compare these observed care pathways with the theoretical clinical pathways derived from the clinical practice guidelines

To assess if the adherence to clinical guidelines influence on important health outcomes, such as cardiovascular hospitalizations.

To compare the traditional analytical methods with process mining methods in terms of modeling quality, prediction performance and information provided.


Study Design: It is a population-based retrospective observational study centered on all T2D patients diagnosed in five Regional Health Services within the Spanish National Health Service. We will include all the contacts of these patients with the health services using the electronic medical record systems including Primary Care data, Specialized Care data, Hospitalizations, Urgent Care data, Pharmacy Claims, and also other registers such as the mortality and the population register.

Cohort definition: All patients with code of Type 2 Diabetes in the clinical health records



Inclusion criteria: patients that, at 2017-01-01 or during the follow-up from 2017-01-01 to 2022-12-31 had active health card (active TIS - tarjeta sanitaria activa) and code of type 2 diabetes (T2D, DM2 in spanish) in the clinical records of primary care (CIAP2 T90 in case of using CIAP code system)

Exclusion criteria:



patients with no contact with the health system from 2017-01-01 to 2022-12-31

patients that had a T1D (DM1) code opened after the T2D code during the follow-up.



Study period. From 2017-01-01 to 2022-12-31


Files included in this publication: 



Datamodel_CONCEPT_DM2_diagram_v0.2.0.jpg

Common data model specification (Datamodel_CONCEPT_DM2_v.0.2.0.xlsx)

Synthetic datasets (Datamodel_CONCEPT_DM2_sample_data_v0.2.0)



sample_data1_dm_patient.csv

sample_data2_dm_param.csv

sample_data3_dm_patient.csv

sample_data4_dm_param.csv

sample_data5_dm_patient.csv

sample_data6_dm_param.csv

sample_data7_dm_param.csv

sample_data8_dm_param.csv



Datamodel_CONCEPT_DM2_explanation_v0.2.0.pptx


CHANGE-LOG from version v0.1.0 to v0.2.0.

The main changes are the following:



Missing data is now identified leaving the field empty



All ICD diagnosis given in the Datamodel refer to the root code, so that all codes and subcodes that start with the given codes need to be considered. For instance, if in the data model appears I21, then all codes I21.x should be included.




All admissions registered in the CMBD will be included to facilitate the extraction procedure (annex 8 disappears).




Three diagnosis codes and three procedure codes are now included in table dm_cmbd.



CHANGE-LOG from version v0.2.0 to v0.3.0.

The main changes are the following:



Variable 'copayment' (annex 2) change: cod 002.01 =>0; cod 002.02 =>1

Variable 'visit_service' (annex 8) change: APR refers to Primary Care and APA refers to Pathological Anatomy

Variable 'filglom' (annex 4) change:  non numerical values compatible with '> 60' => 999
description: CONCEPT-DM2 (PI19/00381) has been financed by the Instituto de Salud Carlos III (ISCIIII); (Spain) within the Health Research and Development Strategy (AES), and belongs to the CONCEPT project, which is a coordinated project led by the CONCEPT-STROKE project (PI19/00154). It was also financed by REDISSEC, grant Reference: RD16/0001/0014. It is now integrated within the initiatives supported by the Health Outcomes-Oriented Cooperative Research Networks (RICORS) on Research Networks in Chronicity, Primary Care, and Health Promotion (RICAPPS). Grant Reference: RD21/0016/0016.  Funding Entity: Instituto de Salud Carlos III (ISCIIII); Call 2021 of the Strategic Action in Health 2017-2020, charged to the European funds of the Recovery, Transformation and Resilience Plan.