National Registry for Orthopaedics Offers More Medical Data to Improve Patient Outcomes

AAOS engaged Analytics8 to build an Operational Data Store to expedite the data collection process. We first migrated all Registry data from various sources, including SQL servers, mySQL databases, Excel files, and industry-specific tools. We then developed a solution that automates the processing, auditing, and storage of incoming data from two major file sources: Procedure and Assessment. The new solution handles peak days where AAOS receives up to 40+ files containing 10,000+ records! This data store feeds the portal solution that is used by AAOS’s internal team and all Registry members.

We then automated the manual process of checking files for correct field formatting and then sorting them into proper folders for processing. We developed internal reports with clear messages that indicate all errors associated with a record to help quickly identify and fix rejected records. And, the AAOS IT staff can now access in-depth detail reports for all jobs run, which include run times and number of records processed/updated/rejected.

Besides relieving an overburdened IT staff, the new data automation capabilities allows AAOS to focus its efforts on expanding the Registry and attracting more users.

For the IT staff, automated data prep and staging has vastly improved their efficiency

• File reviews that initially took 2-6 hours can now be completed in 15-30 minutes.
• Data processing that initially took 4-8 hours to complete at night now take 30 – 60 minutes.
• Manual review process of rejected records was eliminated.
• Instead of being restricted to nightly loads, AAOS staff can now process files multiple times a day.
• Records can be fixed in minutes versus days.

The Registry itself has become more beneficial to its members because it contains more patient and procedural information, giving medical providers enhanced benchmarking data to measure their own performance and identify areas for improvement. Additionally, administratively, it’s easier for medical providers to review and validate the data they upload which creates a more reliable Registry.

Overall, there are now over 1,000 participating institutions in the Registry, which is a 13% year-over-year increase over 2016 and a 58% increase over 2015. With this increased participation, AAOS is achieving their mission to improve orthopaedic care through the collection, analysis, and reporting of actionable data.