A medical materials manufacturer who develops radioactive seed implants to fight prostate cancer needed to build a labeling system to meet the latest FDA labeling requirements. Having worked together for more than 15 years, they turned to SPR Consulting for a solution.
Every day, hospitals deal with inventory complications, tracking materials, and patient validation safety concerns. Not only is this time-consuming to perform manually, but it also allows for human error. 2D barcodes offer an easy-to-use and cost-effective solution to these problems, enabling quick, accurate data entry and verification.
The client had been using a Microsoft Access-based desktop application to print custom labels for many years. But adding 2D barcodes to it was beyond its capabilities. The new barcode requirements along with the need to modernize the existing desktop application spurred the decision to create a whole new version of the application.
The new application needed to meet certain client requirements, which included:
The solution SPR recommended: Redevelop the label and certificate (L&C) application as a web application using Microsoft technology.
While the initial request was for SPR to update the current labeling system to enable barcoding, SPR offered a better solution: creating a new web application. There were simply too many variables to take into consideration for a set-in-stone system to handle. Labels ranged from 1×1 inch to 5×5 inches and every configuration in between. The content that needed to be on each label was variable – for example, radioactive seed packaging needed to show the date of radioactive decay for the batch it was shipping. There were also many one-offs that needed to be accommodated.
The new system needed to allow end users to locate orders and generate labels for a multitude of packaging configurations. With the new dynamic barcoding system, every label would be unique, showing order #, lot #, expiration date, etc., contained within the barcode. A database would store all configuration and history data for the web application, and a printer service would manage the printing of the labels.
The new system architected by SPR Consulting made finding, selecting and printing orders of labels and certificates easier and more efficient. To begin with, the screen components were made larger and easier to read. A touchable interface with larger click targets helped improve productivity. The entire label layout was redesigned to improve readability and incorporate barcoding.
By taking the whole system from client executables to a web-based system, users could create labels in multiple environments with little or no downtime for updates or validation. SPR created a QA validation screen for order/barcode reconciliation. The improved overall label management reduced the need for additional validations on non-related product codes.
The new barcoding system was developed using these technologies:
Despite the challenges of developing an accurate labeling system with infinite scalability – and doing it within a radioactive environment, no less – SPR Consulting came through in the end with a proprietary labeling system that saved the client time and effort, and made the medical field a little safer.