PT - JOURNAL ARTICLE AU - Schönthaler, Martin AU - Hempen, Noah AU - Weymann, Maria AU - von Bargen, Maximilian Ferry AU - Glienke, Maximilian AU - Elsässer, Antonia AU - Behrens, Max AU - Binder, Harald AU - Binder, Nadine TI - A case is not a case is not a case - challenges and solutions in determining urolithiasis caseloads using the digital infrastructure of a clinical data warehouse AID - 10.1101/2024.09.13.24313333 DP - 2024 Jan 01 TA - medRxiv PG - 2024.09.13.24313333 4099 - http://medrxiv.org/content/early/2024/09/14/2024.09.13.24313333.short 4100 - http://medrxiv.org/content/early/2024/09/14/2024.09.13.24313333.full AB - Background To provide more evidence in urolithiasis research, we have established the German Nationwide Register for RECurrent URolithiasis (RECUR) using local clinical data warehouses (CDWH). For RECUR and other registers relying on digitalized clinical data, it is crucial to ensure the data’s reliability for answering scientific questions. In this work, we aim to compare the results of different CDWH-based queries on urolithiasis cases next to manual case extraction from the primary source.Methods Sources for data extraction included the Medical Center University of Freiburg (MCUF) hospital information system (HIS), MCUF performance data (a clinical data set with merged data from patients including data from vari-ous time points throughout their treatment), and MCUF reimbursement data. We extracted data on caseloads in urolithiasis algorithmically (performance and reimbursement data) and compared those to a reference group compiled of man-ually extracted data from the local HIS and algorithmically extracted data.Results Algorithmic extraction based on performance data resulted in correct and complete case identification as compared to the reference group. The case numbers from manual extraction from HIS data and algorithmic extraction from reimbursement data differed by 14% and 12%, respectively. The reasons for devi-ations in HIS data included human errors and a lack of data availability from different wards. Deviations in reimbursement data arose primarily due to the merging of cases in the context of reimbursement mechanisms. As the CDWH at MCUF is part of the German Medical Informatics Initiative (MII), the results can be transferred to other medical centers with similar CDWH structure.Conclusions The current study provides firm evidence of the importance of clearly defining a study’s target variable, e.g., urolithiasis cases, and a thorough understanding of the data sources and modes used to extract the target data. Our work clearly shows that, depending on various data sources, a case is not a case is not a case.Competing Interest StatementThe authors have declared no competing interest.Funding StatementRECUR is funded by the German Federal Ministry of Education and Research (BMBF, FKZ 01GY1902). MIRACUM is funded by the German Federal Ministry of Education and Research (BMBF) within the "Medical Informatics Funding Scheme" (FKZ 01ZZ1606H). The work of N. Hempen and N. Binder has been funded in part by the Deutsche Forschungsgemeinschaft (DFG, German Research Foundation) Project IID 499552394 SFB 1597. The work was supported by the Department of Urology, the Institute of General Practice/Family Medicine, and the Institute of Medical Biometry and Statistics, Medical Center University of Freiburg, Freiburg, Germany.Author DeclarationsI confirm all relevant ethical guidelines have been followed, and any necessary IRB and/or ethics committee approvals have been obtained.YesThe details of the IRB/oversight body that provided approval or exemption for the research described are given below:The protocol for the collection and management of data was approved by Ethics Committee, Medical Center University of Freiburg, Freiburg, Germany (Reference number 40/20) and carried out according to the Declaration of Helsinki. The lack of need for informed consent was confirmed by the ethics committee named previously. Additional approval for data use was obtained by the Use Access Committee (UAC) of the Medical Center University of Freiburg.I confirm that all necessary patient/participant consent has been obtained and the appropriate institutional forms have been archived, and that any patient/participant/sample identifiers included were not known to anyone (e.g., hospital staff, patients or participants themselves) outside the research group so cannot be used to identify individuals.YesI understand that all clinical trials and any other prospective interventional studies must be registered with an ICMJE-approved registry, such as ClinicalTrials.gov. I confirm that any such study reported in the manuscript has been registered and the trial registration ID is provided (note: if posting a prospective study registered retrospectively, please provide a statement in the trial ID field explaining why the study was not registered in advance).YesI have followed all appropriate research reporting guidelines, such as any relevant EQUATOR Network research reporting checklist(s) and other pertinent material, if applicable.YesThe data that support the findings of this study are not openly available due to reasons of sensitivity.6 List of abbreviationsRECURRegister for RECurrent URolithiasisBMBFGerman Federal Ministry of Education and ResearchMIIGerman Medical Informatics InitiativeMCUFMedical Center University of FreiburgDICData Integration CentreCDWHClinical Data WarehouseHISHospital Information SystemCDRClinical Data RepositorySDRScientific Data RepositoryICDInternational Classification of DiseasesOPSOperation and Procedure Classification SystemDRGDiagnosis Related GroupsINEKInstitut für das Entgeltsystem im Krankenhaus GmbH, German DRG InsituteDESTATISDeutsches Statistisches Bundesamt, German Federal Statistical OfficeMIRACUMMedical Informatics in Research and Care in University MedicineDFGDeutsche Forschungsgemeinschaft, German Research Foundation