If I want to know how to fab an item I ask and will usually receive
numerous responses. If I have a clinical question again the list comes
to the rescue. This list helps us the educate ourselves to the most
efficient methods for performing our jobs. I love it. I’m sure you do
to. Thanks to all.
Joe on soap box:
…our industry is littered with fees and dues and costs for the
simplest of things. Shame on those that keep the snowball rolling
dollars out of our pockets.
Joe off soap box.
Go to HTTP://cms.hhs.gov/providers/pufdownload/#dme and get it free. It
will unzip into multiple usable files. Once unzipped
follow these instructions if you want to insert the document into an
Access database file. Or use as is for Excel.
Open access database, table, new, import table. The table is called
d04_jan.cvs. Use the import table wizard.
Click the Show Worksheet radio button
click Next
click Next
click the in a new table button
Rename fields appropriately. For instance Field1 should be HCPCS. Skip
the states you are not interested in. I name the single state I want
“Allowable”. You can include them all now and delete some later.
Let access add the primary key
Rename file to a name the makes sense
The new file will have A, E, L, K, V codes. Delete the ones you are not
interested in.
Delete the top 7 rows if they contain first row header information.
Delete columns you are not interested in.
Now you can use the database.
enjoy
Joe
