Frequently Asked Questions

The UPL demonstration year is defined according to the last year encompassed by the demonstration. For example, a UPL covering the period 07/01/2016 to 06/30/2017 is defined as the 2017 UPL.

FAQ ID:92231

Yes, a state should submit multiple workbooks to CMS to provide a complete UPL demonstration for each service category subject to the UPL (Inpatient Hospital services (IPH), Outpatient Hospital services (OPH), Nursing Facility services (NF), Clinic, Institutions for Mental Disease (IMD), Intermediate Care Facilities for Individuals with Intellectual Disabilities (ICF/IID), Psychiatric Residential Treatment Facility (PRTF), and Qualified Practitioner supplemental payments). When submitting UPL demonstrations, the state should use the following naming convention: UPL_<UPL Demo Date Range>_<Service Type Abbreviation>_R<Region Number>_<State Abbreviation>_<Workbook Number>.xls. Here is an example of the naming convention: UPL_20170701-20180630_IP_R01_CT_01.xls.As well, states may submit one separate workbook for each ownership category (state government owned, non-state government owned, and private).

FAQ ID:92241

Per the state drug utilization data table, the "Dataset Views" dropdown selections available are:

• State: State-specific data at the NDC-11 level, for a quarter/year.
• Full Dataset (States + National Totals): A compilation of all the individual state utilization data (50 states plus Washington D.C.) and the National Totals at the NDC-11 level, for a selected year.
• All States: Includes data for all states but does not include the National Totals
• National Totals: Data are aggregated for all 50 states and Washington, D.C. at the NDC-11 level, for a quarter/year.

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

Users can also generate his or her own views of the dataset on data.medicaid.gov.

FAQ ID:91786

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

Amounts reimbursed by Medicaid are pre-rebate, not net of rebates.

FAQ ID:92001

"Units Reimbursed" are the number of units (based on Unit Type) of the drug (11-digit NDC level) reimbursed by the state or, for MCO drugs, the number of units dispensed during the Quarter/Year. For more specific information, you may contact either the Drug Manufacturer or State via the contact lists.

FAQ ID:92016

States are required to submit their utilization data to CMS within 60 days of the end of the rebate period.

FAQ ID:92026