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

States wishing to continue the practice of disregarding parental income may do so by adopting coverage of a reasonable classification of individuals under age 21 under section 42 CFR 435.222. In this case, the "reasonable classification" would be pregnant individuals under age 21 (or under age 18, 19, or 20). The statutory income standard for this group would be based on the state's AFDC payment standard in effect in the state in July 1996. But if a state uses section 1902(r)(2) of the Act to disregard all income for this group, as has been done for other reasonable classifications of children (such as those in state foster care), there will be no determination of income required for eligibility, and MAGI-based income requirements will not apply.

To effectuate this option, states should submit a state plan amendment (SPA) to amend Attachment 2.2-A of the Medicaid state plan to cover a reasonable classification of pregnant individuals under age 21 under 42 CFR 435.222. The state should also amend Supplement 8a to Attachment 2.6-A to disregard all income for this new group.

Supplemental Links:

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

FAQ ID:92601