Automated data extraction tool (DET) for external applications in radiotherapy.

Abstract

We used OIS data from a nine-linac RT department in Sweden (70weeks, 2015-16). Extracted data included patients' referrals and appointments with details for RT sub-tasks. The data extraction tool to prepare the data for external use was built in C# programming language. It used excel-automation queries to remove unassigned/duplicated values, substitute missing data and perform application-specific calculations. Descriptive statistics were used to verify the output with the manually prepared dataset from the corresponding time period. From the initial raw data, 2030 (51%)/907 (23%) patients had known curative and palliative treatment intent for 84 different cancer diagnoses. After removal of incomplete entries, 373 (10%) patients had unknown treatment intents which were substituted based on the known curative/palliative ratio. Automatically- and manuallyprepared datasets differed<1% for Mould, Treatment planning, Quality assurance and±5% for Fractions and Magnetic resonance imaging with overestimations in 80/140 (57%) entries by the tool. We successfully implemented a software tool to prepare ready-to-use OIS datasets for external applications. Our evaluations showed overall results close to the manually-prepared dataset. The time taken to prepare the dataset using our automated strategy can reduce the time for manual preparation from weeks to seconds.