Skip to main content

Quality Issues in the Use of Administrative Data Records

  • Chapter
Actionable Intelligence

Abstract

This chapter examines the quality issues associated with employing administrative records from state and local agencies for use in monitoring, planning, evaluating, and integrating health and human services information for policy purposes. The goal is to provide a practical illustration of the key issues on data quality that are important in assembling and integrating administrative records for use in an integrated data system (IDS) as well as to describe the challenges of attaining quality data when tensions occur within different levels of a system and between systems themselves. Creating quality data requires a singleness of purpose in an agency regarding the use of the data from the top down and a willingness to provide the resources or funding to create and maintain the needed infrastructure. A concept of how data are to be used and for what purpose is essential to develop the necessary standards. Additionally, there must be a coordinated effort between the leadership of different agencies that provide services to the same type of individuals to link information for the production of actionable intelligence (AI) by policy makers. Both the within-system issues and the between-system issues must be resolved utilizing some type of coordination or steering-committee mechanism if data quality is to be achieved and maintained. This process should involve a clear agenda and regular meetings between policy makers, administrators, researchers, and technical staff to achieve goals and monitor progress.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 89.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 119.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  • Abowd, J. M., & Vilhuber, L. (2005). The sensitivity of economic statistics to coding errors in personal identifiers. Journal of Business & Economic Statistics, 23(2), 133–152.

    Article  Google Scholar 

  • Ballard, D. J., Duncan, P. W., US Department of Health and Human Services, & Agency for Health Care Policy and Research. (1994). Role of population-based epidemiological surveillance in clinical practice guideline development. US Department of Health and Human Services, Agency for Health Care Policy and Research. Clinical practice guideline development: methodology perspectives. AHCPR Pub (95-0009), 27–34.

    Google Scholar 

  • Bazelon, D. L. (2010). Community integration. Washington, DC: Judge David L. Bazelon Center for Mental Health Law. Retrieved from http://www.bazelon.org.

    Google Scholar 

  • Bell, R. M., Keesey, J., & Richards, T. (1994). The urge to merge: Linking vital statistics records and Medicaid claims. Medical Care, 32(10), 1004–1018.

    Article  Google Scholar 

  • Benson, P. (2009). ISO 8000 Data Quality: The fundamentals, part 1. Real-World Decision Support (RWDS) Journal, 3(4).

    Google Scholar 

  • Benson, P. (2008). NATO codification system as the foundation for ISO 8000, the international standard for data quality. Oil IT Journal. Retrieved from http://www.oilit.com/papers/Benson.pdf.

  • Billings, J. (2003). Using administrative data to monitor access, identify disparities, and assess performance of the safety net. In J. Billings & R. Weinick (Eds.), A tool kit for monitoring the local safety net. Rockville, MD: Agency for Health Care Research and Quality. Retrieved from http://archive.ahrq.gov/data/safetynet/billing2.htm.

    Google Scholar 

  • Boruch, R. F. (2012). Administrative record quality and integrated data systems. Actionable Intelligence for Social Policy (AISP), University of Pennsylvania.

    Google Scholar 

  • Bright, R. A., Avorn, J., & Everitt, D. E. (1989). Medicaid data as a resource for epidemiological studies: Strengths and limitations. Journal of Clinical Epidemiology, 42, 937–945.

    Article  Google Scholar 

  • Campbell, K. M. (2004). The link king. Olympia, Washington: Camelot Consulting. Retrieved from http://www.the-link-king.com/index.html.

    Google Scholar 

  • Coffey, R. M., Graver, L., Schroeder, D., Busch, J. D., Dilonardo, J., Chalk, M., & Buck, J. A. (2001). Mental health and substance abuse treatment: Results from a study integrating data from state mental health, substance abuse and Medicaid agencies. Rockville, MD: Center for Substance Abuse Treatment and Center for Mental Health Services, Substance Abuse and Mental Health Services Administration (SAMHSA Publication No. SMA-01-3528).

    Google Scholar 

  • Cooper, D. R., & Schindler, P. S. (2006). Business research methods (9th ed.). London: McGraw Hill.

    Google Scholar 

  • Culhane, D., Fantuzzo, J., Rouse, H. L., Tam, V., & Lukens, J. (2010). Connecting the dots: The promise of integrated data systems for policy analysis and systems reform. Actionable Intelligence for Social Policy. Retrieved from http://www.aisp.upenn.edu/wp-content/uploads/2013/05/Connecting-the-Dots-AISP-Version.pdf.

    Google Scholar 

  • Demlo, L. K., Campbell, P. M., & Brown, S. S. (1978). Reliability of information abstracted from patients’ medical records. Medical Care, 16(12), 995–1005.

    Article  Google Scholar 

  • Department of Justice. (2012). Participation by the United States in Olmstead cases. Retrieved from http://www.ada.gov/olmstead.

  • Fink, R. (1998). HMO data systems in population studies of access to care. Health Services Research, 33(3.2), 741–766.

    Google Scholar 

  • Garnick, D. W., Hendricks, A. M., & Comstock, C. B. (1994). Measuring quality of care: Fundamental information from administrative datasets. International Journal for Quality in Health Care, 6(2), 163–177.

    Article  Google Scholar 

  • Huang, K. T., Lee, Y. W., & Wang, R. Y. (1998). Quality information and knowledge. Upper Saddle River, NJ: Prentice Hall PTR.

    Google Scholar 

  • Iezzoni, L. I. (1997). Assessing quality using administrative data. Annals of Internal Medicine, 127(8), 666–674.

    Article  Google Scholar 

  • Iwig, W., Berning, M., Marck, P., & Prell, M. (2013). Data quality assessment tool for administrative data. Washington, DC: Federal Committee on Statistical Methodology.

    Google Scholar 

  • Juran, J. M., & Gryna, F. M. (1993). Quality planning and analysis (3rd ed.). New York: McGraw-Hill.

    Google Scholar 

  • Lee, Y. W., Pipino, L. L., Funk, J. D., & Wang, R. Y. (2006). Journey to data quality. Cambridge, MA: Massachusetts Institute of Technology Press.

    Google Scholar 

  • Lohr, K. N. (1990). Use of insurance claims data in measuring quality of care. International Journal of Technology Assessment in Health Care, 6, 263–271.

    Article  Google Scholar 

  • Lurie, N., Popkin, M., Dysken, M., Moscovice, I., & Finch, M. (1992). Accuracy of diagnoses of schizophrenia in Medicaid claims. Hospital and Community Psychiatry, 43(1), 69–71.

    Google Scholar 

  • McDonald, C. J., & Hui, S. L. (1991). The analysis of humongous databases: Problems and promises. Statistics in Medicine, 10, 511–518.

    Article  Google Scholar 

  • Motheral, B. R., & Fairman, K. A. (1997). The use of claims databases for outcomes research: Rationale, challenges, and strategies. Clinical Therapeutics, 19, 346–366.

    Article  Google Scholar 

  • Parente, S. T., Weiner, J. P., Garnick, D. W., Richards, T. M., Fowles, J., Lawthers, A. G., Chandler, P., & Palmer, R. H. (1995). Developing a quality improvement database using health insurance data: A guided tour with application to Medicare’s national claims history file. American Journal of Medical Quality, 10, 162–176.

    Article  Google Scholar 

  • Petrila, J. (2011). Legal issues in the use of electronic data systems for social science research. Actionable Intelligence for Social Policy (AISP), University of Pennsylvania. Retrieved from http://impact.sp2.upenn.edu/aisp_test/wp-content/uploads/2012/12/0033_12_SP2_Legal_Issues_Data_Systems_000.pdf.

    Google Scholar 

  • Pipino, L. L., Lee, Y. L., & Wang, R. Y. (2002). Data quality assessment. Communications of the ACM, 45(4), 211–218.

    Article  Google Scholar 

  • Potvin, L., & Champagne, F. (1986). Utilization of administrative files in health research. Social Indicators Research, 18, 409–423.

    Article  Google Scholar 

  • Quam, L., Ellis, L. B., Venus, P., Clouse, J., Taylor, C. G., & Leatherman, S. (1993). Using claims data for epidemiologic research: The concordance of claims-based criteria with the medical record and patient survey for identifying a hypertensive population. Medical Care, 31(6), 498–507.

    Article  Google Scholar 

  • Ray, W. A., & Griffin, M. R. (1989). Use of Medicaid data for pharma-coepidemiology. American Journal of Epidemiology, 129, 837–849.

    Article  Google Scholar 

  • Robinson, J. R., & Tataryn, D. J. (1997). Reliability of the Manitoba Mental Health Management Information System for Research. Canadian Journal of Psychiatry, 42, 744–749.

    Article  Google Scholar 

  • Rosko, M. D. (1988). DRGs and severity of illness measures: An analysis of patient classification systems. Journal of Medical Systems, 12, 257–274.

    Article  Google Scholar 

  • Rothbard, A. B., Schinnar, A. P., Hadley, T. R., & Rovi, J. I. (1990). Integration of mental health data on hospital and community services. Administration and Policy in Mental Health, 18, 91–99.

    Article  Google Scholar 

  • Sena, M. M., & Pashko, S. (1993). Drug utilization review using a Medicaid claims database. Clinical Therapeutics, 15, 900–904.

    Google Scholar 

  • Schwartz, A. H., Perlman, B. B., Paris, M., Schmidt, K., & Thornton, J. C. (1980). Psychiatric diagnoses as reported to Medicaid and as recorded in patient charts. American Journal of Public Health, 70, 406–408.

    Article  Google Scholar 

  • Stern, S., Mewin, E., & Holt, F. (2002). Survival models of community tenure and length of hospital stay for the seriously mentally ill: A 10-year perspective. Health Services & Outcomes Research Methodology, 2, 117–135.

    Article  Google Scholar 

  • Walkup, J. T., Boyer, C. A., & Kellerman, S. L. (2000). Reliability of Medicaid claims files for use in psychiatric diagnoses and service delivery. Administration and Policy in Mental Health, 27, 129–139.

    Article  Google Scholar 

  • Wang, R., Pierce, E., Madnick, S. E., & Fisher, C. (Eds.). (2005). Information Quality (Advances in Management Information Systems). Armonk, NY: M. E. Sharpe.

    Google Scholar 

  • Wang, R. Y., Ziad, M., & Lee, Y. (2001). Data Quality. London: Kluwer.

    Google Scholar 

Download references

Authors

Editor information

John Fantuzzo Dennis P. Culhane

Copyright information

© 2015 John Fantuzzo and Dennis P. Culhane

About this chapter

Cite this chapter

Rothbard, A. (2015). Quality Issues in the Use of Administrative Data Records. In: Fantuzzo, J., Culhane, D.P. (eds) Actionable Intelligence. Palgrave Macmillan, New York. https://doi.org/10.1057/9781137475114_3

Download citation

Publish with us

Policies and ethics