Filtering the NCCI Data Tables
As we discussed earlier in the educational tool, you can access the Medicaid NCCI PTP and MUE tables from the Medicaid NCCI Edit Files webpage. Scroll down the webpage to find links to the most recently updated tables.
The filtering and download functions on the PTP and MUE tables operate in the same way. We will use an NCCI PTP table for Practitioner Services updated on 04/01/2022 for our filtering examples.
- Click the link of the PTP table you want to review. The table’s webpage will appear as shown in Figure 7.
Figure 7: Medicaid NCCI PTP Table Preview
- Click the Filter data button under the Create a filter heading as shown in Figure 8.
Figure 8: Filter Data Button
An Add filters column will appear on the right side of the page as shown in Figure 9.
Figure 9: Add Filters Column
How to Access the Files
This page provides links to NCCI Edit files, where you can filter, sort, share, and download the files. To download data as an Excel file, follow the links on this page to navigate to your file.
Note: Excel limits the number of rows that can be exported in a single CSV for Excel file to 1,048,576 rows. The Practitioner and Outpatient Hospital PTP edit files both contain significantly more rows than that.
To download the complete edit file as an CSV/TEXT file, click the file name from the list of Complete Medicaid NCCI Edit Files. From the new page, then select Download filtered view (CSV) link under the Access heading. The browser will start downloading the file. Once the downloading progress bar stops, drag the file into a desired created folder. Right click on the downloaded CSV file, and select Open with and then click on the Notepad.
Let’s take a closer look at the Add filters menu options. Figure 10 shows the filter options that appear on the right side of the page when you choose the Filter data button on the Dataset page.
You can filter by:
- Column name (Quarter Begin Date, Category, Column One, Column Two, Effective Date, Deletion Date, Modifier Indicator, and PTP Edit Rationale)
- Wording (This depends on the column name you choose.)
- Filter value (This depends on the column name and verb content you choose.)
Figure 10: Medicaid NCCI PTP Filter Option
This figure shows the options that appear at the top of the Add Filters column. You can filter by:
- Column name (Quarter Begin Date, Category, Column One, Column Two, Effective Date, Deletion Date, Modifier Indicator, and PTP Edit Rationale)
- Wording (This depends on the column name you choose.)
- Filter value (This depends on the column name and verb content you choose.)
To add more filter parameters, click the Add another filter link as shown in Figure 11.
Figure 11: Add Another Filter Link
Click the Update table button at the bottom of the Add filters column when you have completed your filter choices as shown in Figure 12.
Figure 12: Update Table Button
You can adjust spacing between rows in your table as shown in Figure 13 using the Display density links:
- Tight
- Normal
- Expanded
Figure 13: Display Density Links
To download data as an CSV/TEXT file, click the Download filtered view (CSV) link under the Access heading as shown in Figure 14 below. The browser will start working to download the file. Once the downloading progress bar stops, drag the file into a folder. Right click on the CSV file name and select Open with. Then click on the Notepad.
Figure 14: Download Filter View (CSV) Link
Figure 15 shows the filtering function using 2 conditions: Column One shows our example code 99215, and the Modifier Indicator column shows modifier 1. Figure 16 shows the results of that filter search.
Figure 15: Medicaid NCCI PTP Filter Conditions
Figure 16: Medicaid NCCI PTP Filter Results
Note: Send questions about the Medicaid NCCI program to NCCIPTPMUE@cms.hhs.gov.