Sample HSI Data Projects
Title: Develop a DVD access to care database for health insurance claims for Medicaid Recipients.
Client: Health Resources Services Administration
The primary care analysis unit of the U.S. federal government's Health Resources Services Administration (HRSA) contracted with HSI on a sole-source basis to convert 3480 mainframe tapes of Medicaid claims data into a DVD database ready for analysis on a PC platform. HSI completed this task ahead of schedule and used the extra time within the scope of the project to assist the HRSA research staff with their application of the analytic files. The information was provided in an episode of care framework in SAS data formats to minimize the start-up costs by an analyst/programmer unfamiliar with the database structure.
Title: Point of Service Referral Patterns in a Managed Care Setting.
Client: The Johns Hopkins University
HSI is supplied a systems analyst to the Johns Hopkins University for expertise regarding the generation of an efficient structure of claims data to examine the results of the financial incentives of a point of service plan. This project involved working with claims data from three large private health insurance plan and the generation of analytic files stored on CD-ROM.
Title: Develop a DVD episode of care database for urological procedures received by all males in the Medicare population.
Client: University of Chicago - NORC
The Triangle Urological Group in Pittsburgh purchased three years of claims data representing all of the services provided to men who received a selected group of surgical procedures. HSI worked with the Project HOPE Center for Health Affairs to create a DVD database based on over 180 mainframe tapes of Medicare claims data. The information was provided in an episode of care framework that could be completed on a PC with very little start-up costs by an analyst/programmer.
Title: Developing Maryland Medicare Public Use File from the DEMPAQ Project.
Client: The Delmarva Foundation for Medical Care, Johns Hopkins University & Harvard University
The DEMPAQ project generated public use claims databases for the Medicare services provided in the States of Maryland, Iowa and Alabama. These databases were enhanced with the creation of patient-level case-mix groupings, usual primary care sources for beneficiaries and standardized resource use measure to compare efficiencies among providers. Working with the Delmarva Foundation for Medical Care HSI adapted the databases for PC network use and demonstrated that Medicare analyses could be entirely PC-based if appropriate computer equipment was used.