Frequently Asked Questions

You are likely running into a limitation of the program you are trying to use to analyze the data. Microsoft Excel allows 1,048,576 rows of data and many of our datasets exceed this limit.

We recommend users not use Excel for large datasets but instead use another application that can work with datasets of large size (e.g. Microsoft Access).

FAQ ID:91801

Since all of the states are combined in the National Totals, the state abbreviation will show on the "National Totals" and "Annual State Detail" option as "XX".

See Also:

• What are the data field descriptions for the State Drug Utilization Data (SDUD)?

FAQ ID:91811

As CMS is obligated by the Federal Privacy Act, 5 U.S.C. Section 552a and the HIPAA Privacy Rule, 45 C.F.R Parts 160 and 164, to protect the privacy of individual beneficiaries and other persons, all direct identifiers have been removed and data that are less than eleven (11) counts are suppressed. An asterisk (*) notes suppressed data. CMS applies counter or secondary suppression in cases where only one prescription is suppressed for primary reasons, e.g. one prescription in a state. Also, if one sub-group (e.g. number of prescription) is suppressed, then the other sub-group is suppressed.

See Also:

• What fields changed when CMS moved the State Drug Utilization Data (SDUD) to data.medicaid.gov?
• What are the data field descriptions for the State Drug Utilization Data (SDUD)?
• Is the redacted State Drug Utilization Data (SDUD) available to the public?

FAQ ID:91831

No. In accordance with federal laws, State Drug Utilization Data (SDUD) that has been suppressed is not available for public consumption.  As CMS is obligated by the Federal Privacy Act, 5 U.S.C. Section 552a and the HIPAA Privacy Rule, 45 C.F.R Parts 160 and 164, to protect the privacy of individual beneficiaries and other persons, all direct identifiers have been removed and data that are less than eleven (11) counts are suppressed. A checkmark in the "Suppression Used" column notes suppressed data. CMS applies counter or secondary suppression in cases where only one prescription is suppressed for primary reasons, (e.g., one prescription in a state). Also, if one sub-group (e.g., number of prescriptions) is suppressed, then the other sub-group is suppressed.

FAQ ID:91856

If the data arrives late, it may miss the quarterly posting. However, it will be included in the next quarter's web posting.

FAQ ID:91916

For current versions of MDRP File Formats/Data Definitions, please refer to: https://www.medicaid.gov/medicaid/prescription-drugs/medicaid-drug-rebate-program/medicaid-drug-rebate-program-mdrp-file-formats-data-definitions-and-medicaid-drug-programs-mdp-email-communications/index.html

See Also:

• What fields changed when CMS moved the State Drug Utilization Data (SDUD) to data.medicaid.gov?
• Is the redacted State Drug Utilization Data (SDUD) available to the public?

FAQ ID:91956

Preventive services include immunizations, screenings for common chronic and infectious diseases and cancers, clinical and behavioral interventions to manage chronic disease and reduce associated risks, and counseling to support healthy living and self-management of chronic conditions, such as those associated with obesity. A list of preventive health care services recommended as Grade A or B by the U.S. Preventive Services Task Force can be found at: https://www.uspreventiveservicestaskforce.org/Page/Name/uspstf-a-and-b-recommendations/.

Through Medicaid's children's benefit - Early and Periodic Screening, Diagnostic and Treatment (EPSDT) - children under age 21 enrolled in Medicaid are assured coverage for preventive and comprehensive health services. States cover adult preventive services within Medicaid through both mandatory and optional benefit categories. Some preventive services (such as those related to family planning) may be defined in a state's mandatory set of benefits while others may be included in the optional benefit category. As a result, Medicaid programs differ from state to state on the coverage of preventive services for adults.

Obesity-related services are those services that help prevent and manage unhealthy weight. Medicaid and CHIP programs can cover a range of services to prevent and reduce obesity including Body Mass Index (BMI) screening, education and counseling on nutrition and physical activity, prescription drugs that promote weight loss, and, as appropriate, bariatric surgery.

Supplemental Links:

• This FAQ was released as part of a larger set. View the full set. (PDF, 86.67 KB)

FAQ ID:92666

Affordable Care Act Section 4004(i)(2) calls for "state public awareness campaigns to educate Medicaid enrollees regarding availability and coverage of preventive and obesity related services with the goal of reducing incidences of obesity." The statute tasks states with designing the public awareness campaign because states have a better understanding of what outreach efforts will best meet the needs of their state Medicaid and CHIP population. Activities that provide information to beneficiaries about the preventive and obesity-related services covered in the state's Medicaid and CHIP programs will satisfy the requirement. Federal funding would be available for such activities as administrative costs of the Medicaid and CHIP programs.

Some resources that states may want to consider as they move forward with their activities include:

• Healthy Weight, Healthy People, Healthy Communities page on the Health Resources and Services Administration's website
• Centers for Disease Control and Prevention's Nutrition, Physical Activity and Obesity 
• "F as in Fat: How Obesity Threatens America's Future 2012," issued by the Trust for America's Health and the Robert Wood Johnson Foundation

States can receive the 50 percent Medicaid administrative matching rate for public awareness campaign activities, and will receive their existing Federal Medical Assistance Percentage (FMAP) rate for preventive services.

The Affordable Care Act includes additional funding for states that cover Grade A and B recommended services of the US Preventive Services Task Force (USPSTF) and all Advisory Committee on Immunization Practices (ACIP) recommended adult vaccines and their administration without cost sharing. CMS has released separate guidance on that provision which can be found at https://www.medicaid.gov/sites/default/files/Federal-Policy-Guidance/downloads/SMD-13-002.pdf (PDF, 138.73 KB).

In addition, CMS can provide technical assistance to states with reporting and interventions that they have in place to improve performance on the prevention core measures.

Supplemental Links:

• This FAQ was released as part of a larger set. View the full set. (PDF, 86.67 KB)

FAQ ID:92671

Yes, if a state has undertaken an initiative to provide information on Medicaid coverage of preventive services since the passage of the Affordable Care Act in March 2010 then they have met this requirement.

Supplemental Links:

• This FAQ was released as part of a larger set. View the full set. (PDF, 86.67 KB)

FAQ ID:92676