Modernizing Registry Operations: Implementing File*Pro Automation with Groovy Scripting to Streamline Data Processing...

Processing out-of-state (OOS) cancer registry files has historically required time-consuming manual work and programmer intervention. At the Missouri Cancer Registry and Research Center (MCR), File*Pro was integrated into our process at MCR with state-specific groovy configuration files to streamline file preparation, reduce turnaround time, and empower oncology data specialists (ODS) to work independently. This report evaluates the effectiveness of this approach and shares adaptable templates for replication by other registries.

Custom groovy scripts were developed to align OOS files with PrepPlus requirements. These scripts automated default value population, corrected state-specific fields (e.g., county codes), and provided reusable templates. Evaluation metrics included pre- and post-implementation processing times, staff independence, and QA dashboard indicators.

From January to April 2025, 180 cases across 9 OOS files were processed with minimal programmer support. County code corrections applied to 3,476 cases from 31 files using the same workflow. ODS staff independently processed up to 13 OOS files in 4 months, saving ~5 days per file by avoiding programmer delays. QA metrics showed a 5-day improvement in turnaround times.

File*Pro with groovy configurations offer a scalable, adaptable solution for registries. By reducing reliance on programmers, empowering staff, and accelerating workflows, this approach enhances efficiency and can be replicated in other central registries with minimal training.