Medicaid Statistical Information System (MSIS) State
Summary Datamart
WELCOME TO THE
This page provides
background needed to take advantage of the capabilities of the
This page also links to
an MSIS Drug Utilization Datamart,
which provides high level Medicaid utilization statistics for selected groups
of drugs.
Note that this mart is licensed for use by registered users ONLY. If you are not a registered user but would
like access to this tool, please contact the MSIS e-mail box at msis@cms.hhs.gov.
It is critical that users have a fundamental understanding of basic
Medicaid program terminology and of the data coding captured by MSIS. This data is the source for ALL of the statistics
available in the datamart. MSIS data
definitions are available in the MSIS Data Dictionary . While we strive to make
this tool as useful as possible, please be aware that response time for tables
can
Since the implementation of the Balanced Budget Act of
1997, States have been submitting eligibility and claims program data to CMS
through the Medicaid Statistical Information System (MSIS). The five files, submitted quarterly, include
one file which contains eligibility and demographic characteristics for each
person enrolled in Medicaid at any time during the quarter, and four separate
files of claims adjudicated for payment during the quarter for long-term care
services, drugs, inpatient hospital stays and all other types of services. The
state-submitted data include over 40 million eligibility records and over 2
billion claims records per year. The
data are subject to validation edits which test whether individual data fields
are within appropriate ranges and then distributional quality checks to
evaluate the reasonableness of the information across data elements and
quarters.
After the edits are complete,
the files accepted by CMS are loaded into a granular data warehouse. The State Summary DataMart has been developed
to extract pre-aggregated data from the granular tables for pre-determined
dimensions and measures and display the aggregated statistics for
analysis. For each fiscal year (FY)
beginning with FY 1999 (October 1998-September 1999), quarterly and
monthly data cubes were built which contain measures and dimensions of the most
commonly asked statistical questions.
This mart was NOT developed to answer all research questions, but CMS believes that the mart
will provide much needed support to States and others who have a need to obtain
State-specific and/or national data quickly
and efficiently.
The quarterly data cube includes summary information on
Medicaid eligibility and utilization and contains the following
dimensions: State, period (quarterly or
annual), age group, race, sex, MAS (maintenance assistance status), BOE (basis
of eligibility), dual eligibility status, SCHIP status, program type, plan
type, service category, service type, claim type, and adjustment
indicator. The available measures
are: unique eligible count, unique
beneficiary count, total claims count, total Medicaid paid amount, encounter
total claims count, unique encounter beneficiaries count, unique enrollees,
total days of care count, and IP discharge total count.
The monthly data cube is restricted to eligibility
information and contains the following dimensions: State, period (fiscal month or year), age
group, race, sex, MAS (maintenance assistance status), BOE (basis of
eligibility), and SCHIP status. The
measures are: unique eligible count,
unique enrollees count, eligible full period count and total months eligible
count.
Before using: Read the MSIS State Summary Data Mart User Guide.
The guide is a concise explanation of how to
navigate the mart along with several suggestions to simplify the process. You may refer questions to the CMS help line
at msis@cms.hhs.gov or call
Bill Holland at 410-786-6443. In addition to the user guide, Cognos powerplay
web has an online help feature accessible through the “?” button on the bottom
toolbar.
Remember, the data is State reported and may contain some data errors not identified by the edit and data quality review processes. Review the data anomalies document to understand some of the idiosyncrasies of the overall and State-specific data.
Using the web-cubes:
The FYs 1999, 2000, 2001, 2002, 2003, 2004,2005 and 2006 are available both
quarterly and monthly. Currently data is
loaded to the mart after the full fiscal year’s files have been through the
data validation and quality review and were accepted by CMS. Missing States have either not
successfully completed their data submissions for the subject year, or are
waiting to be loaded.
|
Latest Update:06/11/08 44 States Loaded for FY 2006 |
Access the FY 2006 Quarterly Cube
Access the FY 2006 Monthly cube
Access the FY 2005 Quarterly Cube Access the FY 2005 Monthly cube
Access the FY 2004 Quarterly Cube Access the FY 2004 Monthly Cube
Access the FY 2003 Quarterly Cube Access the FY 2003 Monthly
Cube Access the FY 2002 Quarterly Cube Access the FY 2002 Monthly Cube Access the FY 2001 Quarterly Cube Access the FY 2001 Monthly Cube Access the FY 2000 Quarterly Cube Access the FY 2000 Monthly Cube