Development of a Web-Based Compliance Metrics Reporting Dashboard (CMR©) for Medical Information Inquiries

Abstract

The compliance-centric work environment for pharmaceutical industry medical information departments (PIMIDs) has led to the need for monitoring e-tools (software applications). Using contemporary programming methods and drawing data from a variety of relevant databases, we developed a web-based dashboard, known as CMR© (Compliance Metrics Reporting) Dashboard. Based on identified monitoring targets of interest, information is compiled from our inquiry management database (IRMS®), spreadsheet files, document reports, and zip-territory field management system. From these sources, data are extracted and updated weekly into CMR© Dashboard. The dashboard allows for instantaneous display and/or printing of 9 modules of information plus an ad-hoc query feature, each processed into stylized graphics from the aforementioned data sets. In its first year of operation, CMR© Dashboard has allowed for more comprehensive tracking of our PIMID metrics, including patterns of off-label inquiries and reporting of “signal alerts” to the corporate Compliance Committee.