Jacobs Journal of Radiation Oncology

Database Verification Using Cryptographic Secure Hash Algorithm following Eclipse/Aria Version Upgrade and Database Migration

Published on: 2018-11-17


Software upgrades of Aria Electronic Medical Record (EMR) and Eclipse Treatment Planning System (TPS) require that all data be migrated from one version of the database to another. It is necessary to verify that the data is correctly migrated to assure patient safety. Traditionally Quality Assurance (QA) checks of a patient’s radiation therapy plan and dose information involve printing out treatment parameters of each patient from the Eclipse TPS and Aria EMR system and visually checking the information for one-to-one correspondence. These QA checks performed to detect errors that are introduced during the migration can be time-consuming and inadequate especially in a paperless environment. In this work, we developed an automatic verification method to make sure that patient data has been correctly migrated. The auto verification method utilizes Eclipse Scripting Application Programming Interface (ESAPI), Cryptographic Hash Algorithm SHA-256 and Microsoft Excel. This method was used as part of our software upgrade and database migration from Varian’s Aria/Eclipse 11 to 13. Plan parameters and dose records were verified for 73 active patients in 60 minutes. Compared to manual line-by-line checking, this direct comparison resulted in time savings and reduced potential human errors. The scripts can be integrated into Eclipse or can be run as a stand-alone executable program for a more automated process.


Database migration; Eclipse Scripting Application Programming Interface; Electronic Medical Record