CPT II code

jed1 wrote on Thursday, September 05, 2013:

I am Looking for Instructions on how to add the CPT II Codes into OpenEMR manually. We are running 4.1.2.1. I have read several of the other discussions regarding this. I understand that I may need to edit custom/code_types.inc.php script but I could not find any script information to add. I was hoping with the new version it would be setup under external data load (Administration > Other) similiar to SnowMed or RxNorm, however it was not. Any help in this matter would be greatly appreciated.

Thanks,
Steven

References:

https://sourceforge.net/p/openemr/discussion/202505/thread/d4983a5e?page=1
http://www.open-emr.org/wiki/index.php/Code_Types
https://sourceforge.net/p/openemr/code-review/189/

blankev wrote on Thursday, September 05, 2013:

Depending on the size of the CPT II file you could do several things. Make a Script to import (the most secure import method). Do a SQL file import, or the only one I can handle is a CSV-file.

If you can correct your CPT II file in MS-Excell or OpenOfficeCalc and convert this file into CSV (Comma Separated Values it is rather easy).

If you want instructions I could provide if needed, and the HOWTODO can not be re-traced in the OpenEMR-WIKI pages.

blankev wrote on Thursday, September 05, 2013:

Method 1. Activate the CPT II codes in Administration => Lists Code => Types

Go to Administration => Codes look into Codes => “CPT II Performance messages”.

or method 2. If you want to use other CPT II Codes you have to Add another CPT II in Lists, activate in Codes and fill in manually.

I just activated these steps in the Open-EMR V.4.1.2 Demo they will be gone after reset of the Demo tomorrow.

To use a batch type of import of Codes you have to access the MySQL database (Administration => Other => Database) through PhpMyAdmin. (I can only help with CSV-file import after making step 2)

fsgl wrote on Thursday, September 05, 2013:

Hi Steven,

I asked the same question in 2 other threads and awaiting a precise answer.

Ideally the CPT-4 import should be as simple as with the other data sets mentioned in your second reference. The CPT-4 section in that Wiki article needs updating.

If the purchased AMA data set has been unzipped, is it a .sql file that be imported into the tables? If it is, then one should be able to place the file into a contrib/cpt4 folder, go to Database and import into codes.

One reason why the External Database Import Utility was not constructed with CPT-4 as an option is because it is not free and therefore cannot be seamlessly imported like the other databases.

When I get the answer pinned down, I’ll post it here.

fsgl wrote on Thursday, September 05, 2013:

It seems that I’m behind the times because the latest edition of CPT is 2014, not CPT-4.

A very nice explanation of the 3 categories of CPT can be found here. CPT category II codes are basically the PQRS codes.

On the bottom of the page for the purchase of the CPT 2014 data set is this note: “There is no search application—data files are designed to be used in any database, spreadsheet or other application that accepts a text (.txt) file format; check with your data processing professional to ensure compatibility”.

That means that the .txt file has to be converted to a .sql file and then it is possible to import into the tables. So another reason why the CPT codes are not listed in the Import Utility.

What is a reliable open source or freeware Text to Sql converter? How good is OpenOffice Base and is it easy to use?

bradymiller wrote on Friday, September 06, 2013:

Hi,

There is no import method in Administration->Other->External Data Loads for CPT codes. Following wiki entry seems accurate:
http://www.open-emr.org/wiki/index.php/Code_Types#CPT4

Ideally, at some point somebody will code the method to import from the original package that you purchase/download into a separate mysql table (ie. external) which is how the ICD9/ICD10 new import mechanism works(so pretty much just need to replicate what was done for ICD9/ICD10). Somebody just needs to code/sponsor it. So, at this point, if want all the codes dumped into the codes table from the downloaded/purchased file, perl script (linked in above wiki article) is still the only current script that does this that I know of.

-brady
OpenEMR

fsgl wrote on Friday, September 06, 2013:

OK, if I understand Brady’s post correctly the steps are:

  1. Purchase and download the CPT data set.
  2. Convert .txt file to .sql file with something like OpenOffice Base.
  3. Put .sql file into contrib/cpt folder.
  4. Go to Database/codes, click Import.

Please correct any misunderstanding.

jed1 wrote on Friday, September 06, 2013:

Thanks to you We have resolved this issue with manual entry. We Appreciated all the suggestions provided.

Steven

blankev wrote on Friday, September 06, 2013:

Can you make a small effort to explain what you had to do to include CP-4 or whatever codes?

Buy, change file, import etc. so we can use your experience to make the WIKI page more clear and to the point for most recent Version…

Tnx in advance.

fsgl wrote on Friday, September 06, 2013:

Hi Pimm,

A number of practices in the U.S. don’t import the entire data set because a lot of the codes are not revelant to our specialty. Cverk, who is in Internal Medicine/Family Practice, didn’t either. I also dislike the idea of data occupying space and doing nothing.

Folks in the professional support community provide the data set as a service to their clients and then it is up to the clients to pick and choose the codes to use.

I have never done a CPT import but thought, like you, that this knowledge would be a helpful addition to Brady’s article, because this is a recurring topic in the Forums and the replies have been rather nebulous. I’ll do the addition as soon as I get some more info from Steven.

Hi Steven,

Kindly recount in detail how you import the CPT data set into Administration/ Other/Database.

Did you use OpenOffice Base as the .sql converter? If you did, was it easy? If not, what did you use?

jed1 wrote on Monday, September 09, 2013:

Hello,
The Method I used was provide by the user Pieter W.
Activate the CPT II codes in Administration => Lists Code => Code Types

To use a batch type of import of Codes you have to access the MySQL database (Administration => Other => Database) through PhpMyAdmin. => Import

Unfortunately the .sql that I mentioned in Reference #3 was incomplete and placed into a different CPTII database set. So I deactivated that database set in Code Types.

I then manually entered each one under Administration => Codes
I set the Type to CPTII. I Then Entered the Procedure Code followed by the brief description and clicked add as new.

fsgl wrote on Monday, September 09, 2013:

Thanks, Steven, for the followup.

Kim Weesner’s .sql file covered only the Category II codes, which is something that I just realized. He would not be able to post the entire set because it would represent a copyright infringement. But calling attention to that file gives me the idea of experimenting with it in one of the Demo and see how the Import function in Database works.

The Category I codes are rather extensive and it is not something one would want to undertake manually, unless one is content with just the codes specific for one’s specialty.

I am working on how to import the entire data set, after purchase from the AMA, in this thread. Once I get it sorted out, hopefully I will be able to insert it in the Wiki.

weesnerkim wrote on Monday, September 09, 2013:

I only covered the Category II codes that the HMO’s I deal with wanted. I use these codes everyday and has allowed me to report screenings, blood pressure, LDL, etc. to the HMO’s for pay-for-performance and PQRS measures sent with my encounter data. I send through Office Ally and all codes are passed through to the payor.
If you need more help just post.

Kim Weesner

fsgl wrote on Monday, September 09, 2013:

Hi Kim,

Thanks for posting the file. It was invaluable in learning how to set up same and how to import it via phpMyAdmin.

ahmed159 wrote on Wednesday, February 11, 2015:

Hello Team,

I have few diagnosis code Which i give Patient most of the time ex: Sugar Test, Blood Pressure,LDL,FSH, i have list of 20 to 30 Test. Its take lot of time to search for Code from ICD.

Can u pls tell me the procedure how to upload Manually step by step, so i can use in my daily bases.

I have my own laboratory for 20 to 30 Test available, I dont want to send the Test Manually. I am using 4.2.0

Help me pls

blankev wrote on Wednesday, February 11, 2015:

Please give some more info:

  1. do you want to connect a Diagnose code with Procedure test?
  2. do you want to do the procedure test with implementation of result afterwards and get a warning it the results of the tests are out of range?
  3. do you want to have a printed piece of paper with the test to be done?

Or is it even something else you want to accomplish…

Please make an attachment with the 30 tests, preferably as a spreadsheet. Importing the tests into Procedures is easy. Follow the relues stipulated above on importing.

fsgl wrote on Wednesday, February 11, 2015:

It is unclear if the question is about adding ICD codes to Administration or have them available in the Procedures module.

Would suggest starting a new thread because the question(s) has nothing to do with CPT II codes.

ahmed159 wrote on Wednesday, February 11, 2015:

Hi Pieter,

I want to add procedure test manually, Can you please tell me easy step by step.

Thanking you,