Garbage In, Garbage Out – The Challenges of Cleaning Up Your Data

The Challenges of Cleaning Up Your CMMS Data and Why Help May be Necessary 

Nuvolo clients are always excited about the new capabilities Nuvolo Connected Workplace solution offers them. Unfortunately, no matter how good the software tool is, if the data in it is “garbage”, the reports and analytics coming out of it will be, too. One large academic medical center based in New York City, NY knew this from experience and made the smart choice to get help choosing the right computerized maintenance management software (CMMS) and to clean up their legacy data before transitioning to it.

The Selection Process

With over 100,000 medical assets across six inpatient facilities and 300 locations, the health system prides itself on its innovation, performance, growth, and service to the community. Its clinical engineering department is key to that success, so when they realized their outdated computerized maintenance management software (CMMS) needed to be replaced to meet the current and future needs of the health system, they knew they had to get it right.

The clinical engineering department wanted all its hospitals on the same CMMS. Understanding that switching CMMS systems can be difficult and expensive, clinical engineering leadership wanted to make sure the process went as smooth as possible to avoid frustrating their technicians and optimize the functionality of their new CMMS.

The health system enlisted the help of ISS Solutions Inc. to help them with the CMMS selection process. ISS Solutions is owned by Geisinger health system and provides clinical equipment management services to all 10 Geisinger hospitals, as well as over 350 other commercial clients, making them undisputed healthcare technology management (HTM) experts.

The New York health system asked ISS to perform a market analysis of the top 5 CMMS products in the industry. ISS compared the CMMS vendors and key features of their products, met with the vendors to verify the capabilities of their products, and provided the health system with a detailed report for them to use in their selection process. Based on ISS Solutions’ analysis, the clinical engineering department chose Nuvolo Connected Workplace for Healthcare as its next CMMS.

The Clean-Up Process

Now the hard work began. Like most HTM organizations that have had multiple CMMS data migrations over the years, the client’s CMMS data was not as clean as they wanted it.

“They had a wide variety of names for the same manufacturers, models, device types. etc.,” says Barbara Maguire, vice president of Quality & Healthcare Technology Management at ISS Solutions. “This made it very difficult for them to search for equipment, run accurate reports, analyze data, and respond appropriately to alerts, recalls and cyber threats. In addition, planned maintenance (PM) schedules and workloads were no longer balanced and needed to be adjusted.”

Working with both the client’s clinical engineering and IT teams, ISS Solutions analyzed and scrubbed over 100,000 records to remove duplicate manufacturers and models, undesired prefixes and suffixes, standardize device types, and correct other anomalies. The project included mapping the legacy location information from both the clinical engineering and radiology departments – both of which used different location names – to standardized location names.

ISS Solutions also provided clinical engineering the means for them to use ECRI’s Universal Medical Device Nomenclature System (UMDNS) for recalls and alerts while giving them the flexibility to keep the device type names they were comfortable with. The ISS team added additional fields to the asset record that would contain the UMDNS information and mapped it to clinical engineering’s existing device type structure, so the techs wouldn’t have to learn all new device type names.

Adding to the complexity of the data clean-up project, the New York health system had acquired a new hospital and wanted it on the same Nuvolo instance, so ISS Solutions consultants cleaned and standardized the new hospital’s asset nomenclature to match the established standard. This required mapping thousands of manufacturers’ names, models and device types and then syncing PM schedules based on work order histories and prior PM frequencies.

The Data Migration Process

Once all the data clean-up was completed, the health system was ready to migrate to Nuvolo. ISS Solutions assisted with the import of all the newly scrubbed asset data into Nuvolo, conducted testing to ensure the quality of the imported data, and provided support to the clinical engineering team throughout the training phase.

Fortunately, the health system was well-advised at the start of their CMMS transition project to plan for significant clean-up before migrating to a new CMMS. A Nuvolo customer herself, Maguire knows this first-hand.

“No matter how functional the CMMS is, bringing non-standard data over will make its capabilities all but useless,” Maguire stresses. “You’ll still be basing your decisions and operations on bad data, so I can’t over-emphasize the importance of this exercise. It’s not an easy process, so if you don’t have the time or expertise to do it, be sure to get help and budget that into the project.”