Developing a Quality Improvement Database Using Health Insurance Data: A Guided Tour with Application to Medicare's National Claims History File

Health policy researchers are increasingly turning to insurance claims to provide timely information on cost, utilization, and quality trends in health care markets. This research offers an in-depth description of how to systematically transform raw inpatient and ambulatory claims data into useful information for health care management and research using the Health Care Financing Administration's National Claims History file as an example. The topics covered include: (a) understanding the contents and architecture of claims data, (b) creating analytic files from raw claims, (c) technical innovations for health policy studies, (d) assessing data accuracy, (d) the costs of using claims data, and (e) ensuring confidentiality. In summary, claims data are found to have great potential for quality of care analysis. As in any analysis, careful development of a database is required for scientific research. The methods outlined in this study offer health data novices as well as experienced analysts a series of strategies to maximize the value of claims data for health policy analysis.

Hornbrook MC , Hurtado AV , John RE Health care episodes: definition, measurement and use. Med Care Rev 1985;42:163-218.

Anderson G. , Steinberg EP , Whittle J. , et al. Development of clinical and economic prognoses from medical claims data. JAMA 1990;253:967-972.

Fisher ES , Malenka DJ , Wennberg JE , et al. Technology assessment using insurance claims: example of prostatectomy . Int J Technol Assess Health Care 1990;6:194-202.

Garnick DW , Hendricks AM , Comstock CB Measuring quality of care. Int J Qual Health Care 1994;6:163-177.

Jencks SF , Wilensky GR The health care quality improvement initiative. JAMA 1992;268:900-903.

Warren JL , Babish JD , Nicholson G. Use and linking of medicare data bases in creating episode of care file. Presented at the American Public Health Association 1990 Annual Meeting.

Weiner JP , Powe NR , Steinwachs DM , et al. Applying insurance claims data to assess quality of care: a compilation of potential indicators. Qual Rev Bull 1990;16:424-438.

Lohr KN Use of insurance claims data in measuring quality of care. Int J Technol Assess Health Care 1990:6:263-271

McDonald CJ , Hui SL The analysis of humongous databases: problems and pitfalls. Stat Med 1991;10:511-518.

Newhouse JP Medical effectiveness research data methods: summary and reactions. In: Grady ML , Schwartz HA , eds. Medical Effectiveness Research Data Methods . Rockville, MD: Agency for Health Care Policy Research, 1992.

Weiner JP , Starfield BH , Steinwachs DM , et al. Development of a population-oriented measure of ambulatory care case-mix. Med Care 1991;29:452-472.

Parente ST , Weiner JP , Fowles J. , et al. Incorporating primary care source (PCS) assignment into medical practice variations analysis. Med Decis Making, October-December, 1992, Abstract.

Garnick DW , Fowles F. , Lawthers A. , et al. Profiling physicians' practice patterns: a new approach to assessing quality of care for the 1990s. J Ambulatory Care Mgmt 1994;17:44-75.

Federal Register, June 1991. Washington DC: US Government Printing Office.

Fowles JB , Lawthers AG , Weiner JP , et al. Agreement between physicians' office records and Medicare Part B claims data. Health Care Finan Rev 1995;16:189-199.

Gostin LO , Turek-Brezina J. , Powers M. , et al. Privacy and security of personal information in a new health care system. JAMA 1993;270:2487-2493.

Minard B. Health care computer systems for the 1990s: critical executive decisions. Ann Arbor, MI: Health Administration Press, 1991.

Meux E. Encrypting personal identifiers. Health Serv Res 1994;29:247-256.

Berwick DM Continuous improvement as an ideal in health care. N Engl J Med 1989;320:53-56.

Lawthers AG , Palmer RH , Edwards JE , et al. Developing and evaluating performance measures for ambulatory care quality. Jt Comm J Qual Improv 1993;19:552-565.

U.S. Public Health Service. Health 1993. Washington, DC: U.S. Public Health Service, 1994.