HHS Logo: bird/facesU.S. Department of Health and Human Services

Using MSIS Data to Analyze Medicaid Eligibility and Managed Care Enrollment Patterns in 1999

Marilyn Ellwood and Megan Kell

Mathematica Policy Research, Inc.

August 2003

Full PDF Report | File Listing


This report was prepared under contract #HHS-100-97-0013 between the U.S. Department of Health and Human Services (HHS), Office of Disability, Aging and Long-Term Care Policy (DALTCP) and Mathematica Policy Research, Inc. For additional information about the study, you may visit the DALTCP home page at http://aspe.hhs.gov/daltcp/home.htm or contact the ASPE Project Officer, John Drabek, at HHS/ASPE/DALTCP, Room 424E, H.H. Humphrey Building, 200 Independence Avenue, SW, Washington, DC 20201. His e-mail address is: jdrabek@osaspe.dhhs.gov.



USING MSIS DATA TO ANALYZE MEDICAID ELIGIBILITY AND MANAGED CARE ENROLLMENT PATTERNS IN 1999

In 1999, for the first time, nationwide person-level electronic Medicaid data became available from the Centers for Medicare & Medicaid Services (CMS). Previously, routine Medicaid data on enrollment, utilization and expenditures were based on a combination of aggregate manual and electronic reports submitted by the states as part of form 2082. Although useful, the 2082 data were limited in scope, and had recurring issues of data quality. To address the need for more accurate, consistent and complete Medicaid data, the Balanced Budget Act of 1997 mandated that all states submit detailed, automated enrollment and claims data effective January 1, 1999 to the Medicaid Statistical Information System (MSIS) maintained by CMS. This new reporting requirement greatly expanded the information available for Medicaid analysis and research. In 1999, CMS also implemented stringent editing and data validation procedures to improve the quality of Medicaid data submitted to the MSIS system. Appendix A provides an overview of MSIS reporting requirements and information submitted by states.

In this report, the new MSIS enrollment data are utilized to provide detailed information on Medicaid eligibility patterns and managed care participation in calendar year 1999. A series of 14 tables were constructed for each of the 50 states and the District of Columbia, and then summarized at the national level. Key findings from the national tables for 1999 include:

Exhibit 1 lists the 14 tables developed for each state which were then compiled at the national level (the county information could not be presented at the national level). For all 52 sets of tables, the first five show annual counts for 1999, and Tables 6-14 present data for December 1999. Many tables have more than one version to show, for example, percent distributions or enrollment for different subpopulations by eligibility group, age or sex. Such "families" of tables are numbered 1A, 1B, and so on.

Exhibit 2 describes the population reported into each of the major Medicaid eligibility groups used throughout the tables. Exhibit 3 describes the Medicaid managed care plan types for which MSIS data are reported.

This document presents the national level tables along with a description of each and a discussion of the findings. Generally, the national level tables do not present state-by-state results. However, in a couple of instances, special national tables with state-by-state results are included. As mentioned earlier, Appendix A provides an overview of MSIS reporting requirements and Medicaid information submitted by states. Appendix B addresses data quality, based on comparisons of the MSIS results to other data sources on Medicaid managed care enrollment. Generally, aggregate totals of MSIS Medicaid managed care enrollment corresponded well with those from CMS surveys of managed care plans. Appendix C includes footnotes for each state that provide state-specific detail on unusual patterns or shortcomings in the data. The state-level tables will be available at the website for the Office of the Assistant Secretary for Planning and Evaluation of the Department of Health and Human Services.

EXHIBIT 1. State- and National-Level Tables
  1. Medicaid Enrollment by Eligibility Group and Month in 1999

  2. Duration of Medicaid Enrollment (in Months) for Persons Ever Enrolled in 1999 by Eligibility Group

  3. Medicaid Managed Care Enrollment by Plan Type and Month in 1999

  4. Medicaid Managed Care Enrollment by Plan Type Combination and Month in 1999

  5. Duration of HMO and PCCM Enrollment (in Months) for Persons Continuously Enrolled 12 Months in Medicaid in 1999

  6. Medicaid Managed Care Enrollment by Plan Type and Age Group in December, 1999

  7. Medicaid Managed Care Enrollment by Plan Type Combination and Age Group in December, 1999

  8. Medicaid Managed Care Enrollment by Plan Type and Eligibility Group in December, 1999

  9. Medicaid Managed Care Enrollment by Plan Type Combination and Eligibility Group in December, 1999

  10. Medicaid Managed Care Enrollment for Disabled Persons and Children in Foster Care by Age Cohort, Gender and Plan Type in December, 1999

  11. Medicaid Managed Care Enrollment for Disabled Persons and Children in Foster Care by Age Cohort, Gender and Plan Type Combination in December, 1999

  12. Medicaid Managed Care Enrollment for Persons in Aged and Disabled Eligibility Groups by Dual Eligible Status and Plan Type in December, 1999

  13. Medicaid Managed Care Enrollment for Persons in Aged and Disabled Eligibility Groups by Dual Eligible Status and Plan Type Combination in December, 1999

  14. Medicaid Managed Care Enrollment by Plan Type and County in December, 1999


EXHIBIT 2. Medicaid Eligibility Groups
Cash Assistance Groups. Eligibility groups 11-17 include persons qualifying for Medicaid because they either receive Supplemental Security Income (SSI) benefits, or they would have qualified under the pre-welfare reform Aid to Families with Dependent Children (AFDC) rules, hence the name "cash assistance groups." Although the 1996 welfare reform legislation replaced AFDC with the Temporary Assistance to Needy Families (TANF) program, state Medicaid programs continue to use 1996 AFDC rules to determine eligibility for Medicaid. Sometimes the AFDC groups 14-17 are referred to as the Section 1931 groups, after the section of the Social Security Act providing the rules for Medicaid AFDC-related eligibility after welfare reform.
Medically Needy Groups. Eligibility groups 21-25 include aged and disabled individuals, as well as children and adults qualifying for Medicaid through the medically needy provisions. Providing coverage for the medically needy is optional, and 37 states in 1999 extended Medicaid eligibility to some or all of the medically needy groups. States that cover medically needy groups use a higher income threshold than the AFDC cash assistance level to determine eligibility. In addition, applicants with income above the medically needy thresholds must be allowed to qualify for Medicaid by "spending down," a provision that allows applicants to deduct incurred medical expenses from their income to determine financial eligibility for Medicaid.
Poverty-related Groups. Eligibility groups 31-35 include persons who qualify for Medicaid through any of the poverty-related expansions enacted from 1988 on. States must cover certain groups under the poverty-related provisions, while coverage for others is optional. For instance, states are required to extend limited Medicaid coverage related to some or all of the Medicare cost-sharing (premiums, copayments and deductibles) to Medicare-eligible aged and disabled enrollees whose income is below 100 to 175 percent of the federal poverty level (FPL). Included in the aged and disabled poverty-related groups are Qualified Medicare Beneficiaries (QMBs), Specified Low-Income Medicaid Beneficiaries (SLMBs), and Qualified Individuals (QI-I and II). States also have the option to extend full Medicaid benefits to all aged and disabled persons with income under 100 percent of the FPL. In 1999, 12 states elected this option. Providing coverage for children and adults in poverty-related eligibility groups 34-35 is also part mandatory, part optional. States must extend full Medicaid benefits to all children under 6 years of age and to all pregnant women with family income below 133 percent of the FPL. In addition, states are required to cover all children born after September 30, 1983, with family income below 100 percent of the FPL. At their option, most states have elected to use considerably higher income thresholds for their poverty-related child and adult coverage. In particular, many states have used the enhanced federal matching available through the State Child Health Insurance Program (SCHIP) to establish higher poverty-related income thresholds in Medicaid for children.
Other Groups. Eligibility groups 41-48 include individuals who qualify for Medicaid through a mixture of mandatory and optional coverage not reported under the other eligibility groups. Groups 41 and 42 include many institutionalized aged and disabled persons, as well as those qualifying for Medicaid through hospice and home- and community-based care waivers. These groups also include special subgroups of aged and disabled individuals who lost SSI benefits due to increases in Old-Age, Survivors and Disability Insurance (OASDI) benefits or other changes. Groups 44 and 45 include children and adults qualifying for up to 12 months of transitional medical assistance because family earnings caused them to lose AFDC eligibility. States that offer presumptive Medicaid eligibility and/or a guarantee of continuous Medicaid eligibility usually report this coverage in groups 44 and 45, although in a few states, these individuals are reported in groups 34 and 35. States are required to extend emergency Medicaid benefits to immigrants, including undocumented individuals, who would otherwise qualify for Medicaid except for their immigrant status. These immigrants are part of groups 41 through 45. Finally, group 48 includes children in foster care and adopted children.
1115 Groups. Eligibility groups 51-55 include persons qualifying for Medicaid under an 1115 waiver demonstration, an optional coverage provision for states. In some states, individuals in the 1115 groups only qualify for limited Medicaid benefits. For example, some states provide only limited family planning benefits to 1115 adults, while others provide only pharmaceutical benefits to 1115 aged and disabled enrollees. However, a few states provide full Medicaid benefits to persons qualifying through 1115 provisions.


EXHIBIT 3. Types of Managed Care
Enrollment in eight types of managed care is reported in the MSIS data. In MSIS, managed care is defined as any program in which Medicaid makes a capitated payment, and some risk is assumed by the provider.
  • HMO. The label HMO (for health maintenance organizations) is used in the tables for comprehensive managed care plans, although some comprehensive managed care plans do not include dental or behavioral services.
  • Dental. Dental refers to dental managed care plans.
  • BHP. BHP refers to behavioral health plans.
  • Prenatal/Delivery. Prenatal/Delivery refers to specialized managed care plans targeted to pregnant women.
  • LTC. LTC refers to long-term care managed care plans.
  • PACE. PACE refers to Programs of All-Inclusive Care for the Elderly programs, available in some states.
  • PCCM. PCCM refers to primary care case management plans, in which states pay a relatively small capitation fee each month (usually $3) to fee-for-service physicians to coordinate primary and specialty care.
  • Other. "Other" plans include less widespread types of managed care, such as transportation plans, hybrid PCCM plans, and special pharmaceutical plans for residents of long-term care facilities. The footnotes for each state describe the type of plan reported into the "other" category.
  • FFS. Persons not enrolled in any type of managed care during the year were reported in MSIS as fee-for-service (FFS) enrollees. This approach understates the true number of FFS enrollees, since many were enrolled in a managed care plan providing only limited services (for example, a dental managed care plan). Individuals enrolled only in a managed care plan covering limited services would rely on FFS coverage for all their other service needs, but they would not be counted as FFS enrollees in the tables.


TABLES 1A-1B: Medicaid Enrollment by Eligibility Group and Month in 1999

Table 1A shows the distribution of Medicaid enrollment for each month of 1999 by the 23 eligibility groups used in CMS reporting. This is the first time national Medicaid enrollment data have been reported on a monthly basis. Before 1999, CMS was only able to report the number of people ever enrolled in Medicaid at some point during the year. However, the 1999 MSIS allows CMS to compile monthly enrollment information for Medicaid, both at the national and state levels, in addition to the annual data.

Monthly information greatly expands the analytic power of CMS Medicaid data. Enrollment patterns can now be tracked at a precise level. Exactly when changes in enrollment occur can now be pinpointed, as well as the groups that are affected. Monthly data also make it easier to compare CMS Medicaid data to existing state level data, since most state-generated Medicaid reports and statistics use monthly or average monthly data. Finally, the monthly enrollment data can be used in combination with the annual "ever enrolled" data to calculate a lower bound estimate of turnover in each state's Medicaid enrollment (this analysis follows in Table 2). Although not undertaken for this study, analysts can also use monthly MSIS data to track individual enrollment patterns over time.

In addition to the national level data in Table 1A, Table 1B shows monthly Medicaid enrollment during the first and last month of 1999 for each state, with separate columns for aged, disabled, child and adult enrollees. Table 1B shows which individual states experienced growth in monthly Medicaid enrollment during the year. However, these data should not be used without consulting the state specific footnotes, since the month-to-month enrollment data in some states have problems.

Findings


TABLES 2A-2B: Duration of Medicaid Enrollment (in Months) for Persons Ever Enrolled in 1999 by Eligibility Group

Table 2A shows the number of persons ever enrolled in Medicaid during 1999 (column 13), and the duration of enrollment during 1999 (columns 1-12) by eligibility group. Individuals were included in the eligibility group under which they were enrolled for the longest time during the year. That is, if an individual was enrolled under the medically needy child group for three months and under the poverty-related child group for six months, the full nine months of enrollment for that individual was counted in the poverty-related child group. Table 2B converts the data in Table 2A to a percent distribution.

For many years, CMS has reported the number of persons ever enrolled during the year by Medicaid eligibility group (column 13), so this type of information is not new. However, using this information in conjunction with the monthly enrollment data in Table 1 is new and allows CMS to calculate a lower bound estimate of turnover in Medicaid enrollment across states and across eligibility groups.1 Enrollment at the end of the year in December (from Table 1) can be compared to the number of people ever enrolled during the year (column 13 of Table 2) to measure the rate at which people have departed the program and to determine the extent to which this rate varied by eligibility group and/or by state. In recent years, turnover has become a major concern, particularly for children. Research has shown that many uninsured children who appeared to be Medicaid eligible, were previously enrolled in Medicaid, but no longer are participating. With MSIS data, analysts now have some information for determining the extent to which turnover is occurring among eligibility groups across states.

Information on enrollment duration during the year is also new, but these data have to be interpreted with caution. The distribution of enrollment durations could be skewed if there was substantial growth in an eligibility group during the year. For example, a very low proportion of the 1115 adult group (group 55) was enrolled all 12 months of 1999 because the size of the group almost doubled at year end. It is also better to measure enrollment duration over a longer time period, since individuals can have enrollment spells that last many years. Nevertheless, these data provide useful information when used appropriately.

Findings


TABLES 3A-3B: Medicaid Managed Care Enrollment by Plan Type and Month in 1999

Tables 3A shows the number of Medicaid beneficiaries enrolled in any of the eight types of managed care plans during each month of 1999. The last column presents a monthly average for 1999. The state-specific footnotes describe the type of plan included in the "other" category. Persons could be counted in Table 3A more than once during a month if they were enrolled in more than one managed care plan. As a result, the table presents a "duplicated" count of enrollees. (An unduplicated count follows in Table 4.) Table 3B converts the data in Table 3A to a percent distribution by month; the percentages reflect the duplicated count in Table 3A.

Much of this information has not been available in the past. The number of persons enrolled in different types of Medicaid managed care each month was not reported in 2082 data. The only nationwide data on enrollment in Medicaid managed care from CMS has been the number of persons in different types of Medicaid managed care in June of each year (nationwide and at the state level). Since managed care enrollment levels can fluctuate during the year, this more comprehensive information in Table 3A is a useful addition. The MSIS data also provide enrollment for several types of managed care not explicitly reported in the other CMS data, including BHPs, dental plans, prenatal/delivery plans, LTC plans, and PACE plans.

Findings


TABLES 4A-4C: Medicaid Managed Care Enrollment by Plan Type Combination and Month in 1999

Table 4A presents an unduplicated count of Medicaid managed care enrollment nationwide, showing, for each month, the number of Medicaid enrollees in only one type of managed care plan as well as the number in more than one type of plan. Table 4B converts the data in Table 4A to a percent distribution by month. The last column of the tables presents average monthly data.

Table 4C provides state-by-state information, showing monthly Medicaid enrollment by plan type combination for each state during December 1999. This table indicates the extent to which individual states were using various types of managed care, including combinations with more than one plan.

This information on Medicaid managed care is completely new and confirms that a sizeable proportion of Medicaid eligibles participated in more than one type of managed care plan during 1999.

Findings


TABLE 5: Duration of HMO and PCCM Enrollment (in Months) for Persons Continuously Enrolled 12 Months in Medicaid in 1999

In 1999, about 23.5 million persons were enrolled in Medicaid all 12 months of the year. For these individuals, Table 5 shows the number who were enrolled in HMOs and PCCMs for the entire year and those who were enrolled in HMOs or PCCMs for 6 to 11 months. The count in this table is duplicated, since an individual could have been enrolled in an HMO for 6 months and then in a PCCM for 6 months, in which case he or she would have been counted twice.

This information was not previously available from CMS and sheds light on the extent to which persons on Medicaid participated in HMOs and PCCMs year round. Continuity in enrollment is a critical component for Medicaid managed care to work as expected.

Findings


TABLES 6A-6B: Medicaid Managed Care Enrollment by Plan Type and Age Group in December 1999

While Tables 1-5 provided annual information for 1999, Tables 6-14 provide information from MSIS for a one month time period. By limiting the time period to one month, more detailed information from the MSIS data base can be used. Table 6A shows the number of Medicaid enrollees in each type of managed care plan by age group in December 1999. The count is duplicated since individuals could have been enrolled in more than one type of managed care plan, in which case, they would have been counted more than once. It is important to note that the working-age adult group (21 to 64 years) includes both disabled enrollees and adult enrollees who are parents, caretaker relatives or pregnant women. Table 6B converts the data in Table 6A to a percent distribution by age cohort; percentages reflect the duplicated counts in Table 6A.

National data on Medicaid managed care participation by age cohort have not been available before. Thus, in the past, it was not possible to determine the extent to which age groups, such as infants or the very old, were participating in various types of managed care plans.

Findings


TABLES 7A-7B: Medicaid Managed Care Enrollment by Plan Type Combination and Age Group in December 1999

Table 7A shows the number of Medicaid beneficiaries, by age group, enrolled in one plan type or plan type combinations in December 1999. The count is unduplicated. Table 7B converts the data in Table 7A to a percent distribution by age cohort.

Findings


TABLES 8A-8B: Medicaid Managed Care Enrollment by Plan Type and Eligibility Group for December 1999

Table 8A shows the number of Medicaid enrollees, by eligibility group, in each of the eight types of managed care plans in December 1999 The count is duplicated because an individual could have been enrolled in more than one type of plan, in which case he or she would have been counted more than once. Table 8B converts the data in Table 8A to a percent distribution; the percentages reflect the duplicated counts in Table 8A.

Data have not been available in the past showing the differences in managed care enrollment across Medicaid eligibility groups. A priori, it seemed likely that all the medically needy groups, the poverty-related aged and disabled groups, and the other aged and other disabled groups would have relatively lower rates of managed care enrollment. The medically needy often have intermittent Medicaid eligibility due to the spend-down requirements, making it more difficult for them to have the continuity in enrollment important to managed care. The poverty-related aged and disabled would not be likely to enroll in managed care plans in many states, since their Medicaid benefits are limited to Medicare cost-sharing expenses. The other aged and other disabled groups include many of the institutionalized, making them less likely to enroll in managed care.

Although managed care enrollment numbers are reported for the 1115 eligibility groups in Table 8A, they are analyzed separately, since the 1115 demonstration programs across states vary considerably in their size and focus.

Findings


TABLES 9A-9B: Managed Care Enrollment by Plan Combination and Eligibility Group in December 1999

Table 9A shows the number of Medicaid beneficiaries, by eligibility group, enrolled in only one plan type or the various plan type combinations in December 1999. The counts in this table are unduplicated. Table 9B converts the data in Table 9A to a percent distribution by eligibility group.

As with Table 8, the findings for 1115 eligibles are analyzed separately.

Findings


TABLES 10A-10F: Managed Care Enrollment for Disabled Persons and Children in Foster Care by Age Cohort, Gender and Plan Type in December 1999

Table 10A shows managed care enrollment patterns for two groups of special interest to policymakers: disabled persons and children in foster care. For both groups, results are presented by age. For disabled persons, results are also stratified by eligibility group. Tables 10B and 10C present the same information for females and males, respectively. These special compilations of data on disabled and foster care enrollees were requested by OASPE staff. The counts in these three tables are duplicated, since an individual could have been enrolled in more than one type of managed care plan in December 1999, in which case he or she would have been counted more than once. Tables 10D-F convert the data in Tables 10A-C to a percent distribution; percentages reflect the duplicated counts in Tables 10A-C.

Three age groups are used for disabled persons: under age 21, age 21-64, and age 65 and older. Unlike other Medicaid eligibility groups, disabled persons can be any age. Children can qualify as disabled if they have medically determinable physical or mental impairment which result in marked and severe functional limitations that are expected to last for a continuous period of not less than 12 months, or to result in death.2 Low-income working age adults are considered disabled if they are unable to engage in substantial gainful activity by reason of any medically determinable mental or physical impairment which can be expected to result in death or can be expected to last for a continuous period of not less than 12 months. Finally, some (but not all) states report persons age 65 and over as disabled. Generally, disabled persons who are age 65 or over in Medicaid data are persons who initially qualified for Medicaid as disabled who continue to be reported in the disabled eligibility group when they turn age 65. Six age groups are used for foster care children: less than 1 year, 1 to 4 years, 5 to 9 years, 10 to 14 years, 15 to 18 years and over age 18.

Findings


TABLES 11A-11F: Managed Care Enrollment for Persons in Disabled and Foster Care Eligibility Groups by Age Cohort and Sex by Plan Type Combination in December 1999

Table 11A shows the number of individuals in the disabled and foster care groups by age cohort who were enrolled in more than one type of managed care plan. Tables 11B and 11C show the same information for females and males, respectively. Tables 11D-F convert the data in Tables 11A-C to a percent distribution. All counts are unduplicated.

Findings


TABLES 12A-12D: Managed Care Enrollment for Persons in Aged and Disabled Eligibility Groups by Dual Eligible Status by Plan Type in December 1999

Tables 12A and 12B show the number of aged and disabled persons, respectively, who were dually eligible for Medicaid and Medicare and enrolled in managed care plans in December 1999. The counts in these tables are duplicated, since an individual could have been enrolled in more than one type of plan, in which case he or she would have been counted twice. Tables 12C and 12D convert the data in Tables 12A and 12B to a percent distribution; the percentages reflect duplicated counts in Tables 12A and 12B.

Managed care programs for dual eligibles are complicated because Medicare is the first payor, and state Medicaid programs are generally responsible for Medicare copayments, deductibles and premiums. In addition, Medicaid programs have total responsibility for some services, such as prescription drugs and long-term care, which are not covered by Medicare.

Findings


TABLES 13A-13D: Managed Care Enrollment for Persons in Aged and Disabled Eligibility Groups by Dual Eligible Status by Plan Type Combination in December 1999

Tables 13A and 13B show the number of aged and disable dual eligibles enrolled in more than one type of managed care in December, 1999. Counts in these tables are unduplicated. Tables 13C and 13D convert the data in Tables 13A and 13B to a percent distribution.

Findings


TABLE 14: Persons with Managed Care Enrollment by Plan Type by County for December 1999

Each set of state tables also includes a final table, showing the number of enrollees in each type of managed care for each county in the state. It was not possible to summarize these county-based tables at the national level.

  1. A more complete measure of turnover would also count persons who disenrolled at any point earlier in the year, but had reenrolled before year end.

  2. SSI disability rules for children only apply to those under age 18. This age group includes persons ages 18 to 20 who would have to satisfy adult disability rules to qualify for Medicaid.

National tables can be viewed in PDF (http://aspe.hhs.gov/daltcp/reports/msisdata-natl.pdf) or as Microsoft Excel files (http://aspe.hhs.gov/daltcp/reports/msisdata-natl1.xls for tables 1-5 and http://aspe.hhs.gov/daltcp/reports/msisdata-natl2.xls for tables 6-13).


You can also advance to:
  • File Listing (List of all sections/tables and their links)
  • Appendix A. Overview of MSIS: Reporting Requirements and Information Submitted by States
  • Appendix B. Comparison of MSIS Managed Care Data to CMS Data
  • Appendix C. MSIS Managed Care Tables Footnotes