Health Professions Data Warehouse (HPDW)


The MEDTAPP Health Professions Data Warehouse (HPDW) will provide an accurate snapshot of Ohio’s current healthcare professional workforce status and capacity, identifying both barriers and solutions to improve recruitment and retention of providers serving Ohio’s Medicaid population. HPDW acts as an analytical engine to enhance state agency capacity in healthcare workforce forecasting, policy development, and research. HPDW will also provide Ohio’s state agencies, policymakers, academic medical centers, and health sciences colleges and universities with immediate, reliable, useable results.

Ohio has a critical need for a comprehensive data system and state-of-the-art tools to better collect, aggregate, and analyze healthcare workforce data. HPDW results allow the Ohio Governor’s Office of Health Transformation, Ohio Department of Medicaid, Ohio Department of Health, other state agencies, and policymakers to better plan and execute Ohio’s healthcare workforce development strategies

HPDW will support the accountability, research, and analysis of healthcare providers needed for the state of Ohio by:

  • Incorporating health professions data warehouse best practices from around the country;
  • Encouraging collaboration across stakeholders to determine the Minimum Data Set (MDS) elements and technical infrastructure components necessary to ensure consistent data is collected across all health professions;
  • Integrating historical and current health professions licensure board and commissions data from the Ohio Department of Administrative Services;
  • Augmenting Ohio’s health professions licensure board and commissions data with available geographic area based population counts, estimates, projections and shape files using supplemental data from the U.S. Census, HRSA, and private sector research firms; and
  • Including additional data sources to identify Medicaid providers, medical residents, and Ohio medical school graduates and their practice locations.

HPDW is a multi-phase project that extends into December of 2016. The Ohio Colleges of Medicine Government Resource Center is currently in the design phase, which includes identifying and obtaining the appropriate data sources and software packages to create a user-friendly warehouse that is efficient in health workforce forecasting and analysis.