“All I had to do was ask. After a bit of back and forth, they put the PECOS physician list in a .csv format for everyone to download.” – Maureen Bacon, Controller, ClaraVista.
That’s right. Problem solved! CMS has finally uploaded a list of PECOS enrolled physicians in a useable .csv format. Unlike the previous .pdf version, the .csv file will open in Excel or Notepad and can be easily imported into Access. This allows users to quickly sort, filter and search the data with a click of the mouse.
“This is a huge breakthrough,” said Bacon, “We tried to convert the massive .pdf to a .csv file on our own, but even with dual core processors and a T3 internet connection, it proved to be painfully slow and my computer system all but grinded to a halt during the process.”
Bacon said the final straw came after she converted 3,700 of the 13-some-odd-thousand .pdf pages, and then lost it all to a system error.
“I waited 3 hours to get less than a third of the way through and then lost everything,” said Bacon. “I knew I wasn’t the only one having this problem, and I wanted to find a solution that would help us, our billing clients and anyone else who needed a better way to search for physicians in PECOS.”
Thanks to Google and a bit of ingenuity, Bacon located an early transmittal issued by CMS that parsed out responsibilities for implementing the PECOS edits.
“I found a release that contained the names and e-mail address of two of the people put in charge of creating the PECOS file,” said Bacon. “I sent them an e-mail explaining the problems I was having with the .pdf and asked them if they could convert the file into a more user friendly spreadsheet.”
Believe it or not, Bacon received a response just thirty minutes later.
Initially, Bacon was advised to independently convert the .pdf to text or use the search function to look up the physician’s NPI.
“It was clear to me that they didn’t fully understand how long it takes to search 13,000 pages for hundreds of physicians in a .pdf file,” said Bacon. “So I gave them an NPI from the last page and asked them to start at page one and search for it; just so they could see how long it takes for themselves.”
And it looks like that did the trick!
Less than 24 hours after her last correspondence with CMS officials, a new Zip file was posted for download at:
http://www.cms.gov/MedicareProviderSupEnroll/06_MedicareOrderingandReferring.asp.
The Zip contains a .csv version of the PECOS file, which lists all 687,819 physicians currently enrolled in the system.
But Bacon doesn’t credit herself alone for the breakthrough.
“I didn’t do this one on my own,” said Bacon. “There have been many people before me, including Medicare contractors and industry organizations, who have asked CMS to put the .pdf in a better format. I guess I just happened to contact the right people at the right time.”
Lucky us.
We’d like to offer a special thanks to CMS for listening to our concerns and being so responsive on this issue.