NASCIO Awards

AWARDS & RECOGNITION

2002 Awards: Enterprise Information Architecture

RECIPIENT:
Michigan
Using the Enterprise Data Warehouse to Improve Delivery of Health Care Services


First row, L to R: Dan Homer, Dave McLaury, Marilynn Kenyon, Larry Ruble, Chris Days, Laura Olson, Bruce Grant, Sue Moran Second Row, L to R: Ken Seka, Tom Patrick, Dan McCandless, Steve Karczewski, Tom McRae

First row, L to R: Dan Homer, Dave McLaury, Marilynn Kenyon, Larry Ruble, Chris Days, Laura Olson, Bruce Grant, Sue Moran
Second Row, L to R: Ken Seka, Tom Patrick, Dan McCandless, Steve Karczewski, Tom McRae

As the largest department in the State of Michigan, the Michigan Department of Community Health (MDCH) is responsible for managing the delivery of health care services to more than 1.2 million clients and overseeing an annual budget of $9.5 billion.

MDCH administers many of the state's most critical programs, including: Medicaid (fee for service and health plans), the Women, Infant, and Children (WIC) assistance program, the state's Childhood Lead Poisoning Prevention program, and the Michigan Child Immunization Registry (MCIR).

"Michigan is extremely grateful to be recognized by NASCIO for this prestigious award for achievement in the field of information technology. The Enterprise Data Warehouse has allowed us to improve the way we manage an array of health care programs, thereby improving the way we deliver services to Michigan citizens."
Governor John Engler, State of Michigan

"Michigan is extremely grateful to be recognized by NASCIO for this prestigious award for achievement in the field of information technology. The Enterprise Data Warehouse has allowed us to improve the way we manage an array of health care programs, thereby improving the way we deliver services to Michigan citizens." Governor John Engler, State of Michigan

Many of MDCH's clients are enrolled in multiple programs supported by the department. However, up until now, it has been virtually impossible to track and monitor services and costs associated with a single client through these separate health-related agencies included under the MDCH umbrella. Each agency administers state and/or federally mandated programs with overlapping client bases in an environment of expanding populations, increasing costs, and an ever-changing set of complex regulations.

MDCH has implemented a data warehouse solution to meet the challenge of tracking individual clients and expand its decision support capability. It began with a Medicaid-only database in 1994, expanded into managed care by utilizing the warehouse in an operational way, and has incrementally expanded its capabilities through a series of targeted project implementations. Most recently, MDCH embarked on and completed a major project of integrating nine separate health-related agencies and data sources into a single integrated environment.

MDCH is using the enterprise data warehouse as the foundation for tying related program data together and for conducting advanced data analysis. In so doing, MDCH is able to interpret patterns and gain insights into outcomes, or put another way, determine what has happened and why, and most importantly, what will happen in the future.

MDCH has developed a unique client identifier that enables it to track individuals across multiple agency programs - in a secure and confidential manner - to analyze services and costs. The warehouse also enables the department to conduct advanced health-care analyses - including geographic analysis, cost and benefit analysis, service pattern analysis, and cost and use measures.

In short, the data warehouse has become the critical tool to help MDCH improve its delivery of health care services, determine which programs are most effective, detect fraud and abuse, reduce overall costs to taxpayers, and predict the state's health care needs and priorities in the years to come.

In addition to broadened data analysis, the integrated data warehouse improves the security of MDCH's data. The data warehouse is a central point of control that defines and limits access to data. Access can be limited to specific data elements or levels of aggregation for specific users.

Contact Information: David McLaury, Director, Project Development & Implementation, Michigan Department of Community Health, 400 S. Pine Street, Lansing, Michigan 48933, (517) 241-7135, Fax: (517) 335-5007, McLauryd@michigan.gov

SECOND PLACE:
Wisconsin
WISDOM Data Warehouse

THIRD PLACE:
Florida
Enterprise Integration

Washington
Washington State Applications Template and Outfitting Model