HSM Excels at High Stakes Data Management
Imagine hospital staff being told their order for an oncology drug was denied due to a data quality issue. In that case, an incorrectly programmed data rule could cost hundreds of thousands of dollars for the manufacturer, not to mention the loss of therapeutic benefit for the patients. If the data had been checked using an analysis program written independently from the database, such errors could be avoided.
This situation could arise in a variety of health care delivery contexts. In this particular case, a large national company manages a Risk Evaluation and Mitigation Strategy (REMS) for a manufacturer, as mandated by the FDA. The backbone of the program is a large SQL database, through which new data flows in and data output is generated. The HSM Group performs regular and critical data quality checks on both the incoming and outgoing data files.
The database includes contact information, identifiers, relationships, application information, and enrollment information for physicians, hospitals, and clinics. To ensure data quality, HSM runs pre-defined quality checks to spot data errors and call out data fields that should be cleansed. Because the database is continually evolving, HSM performs data quality checks every other week as well as additional quality checks on an ad hoc basis.
To perform the quality checks, HSM uses powerful SAS data management and statistical software. More than 150 data checks are performed each time a new dataset is created. The data quality checks are important since a missing value or a wrong format may cause an entire hospital to receive drugs for which it is not approved. Some of the common data checks performed include:
You probably know HSM as an exceptional partner for providing high quality, custom quantitative and qualitative research. For more information about our strategies for managing “failed” quality checks, data quality plans for Excel files, tracking errors and call-outs, and tips for optimal communications and data/process organization, please contact HSM’s project leader Brett Plummer, PhD, at firstname.lastname@example.org or 480-947-8078, extension 313.