CIE9 codes or ICD9 in spanish

jaimono wrote on Tuesday, May 01, 2012:

Hello there.

I have uploaded to my openemr database the CIE9 codes from http://www.cie9.com/Descargar_la_CIE9.html

As far as I know (I’m an engineer not a physician)  this is the ICD9 translated to spanish.

I have installed it as a separate code family.

I wan to share this for the benefit of all the users who, as me, need to run OpenEMR in spanish. And also 'cause I want it included on future versions so I don’t have to installed again :wink:

The SQL code to insert the codes on the database can be downloaded from:

http://sgautomatizacion.com/jaime/cie9-codes-insert.sql.gz

En español: El anterior enlace contiene el código SQL para activar los códigos CIE9 en OpenEMR.

Thanks a lot.

bradymiller wrote on Saturday, May 05, 2012:

Hi,

Best thing to do is to work these into the importing scheme that is currently being worked on for ICD9/ICD10 (now able to import SNOMED/RXNORM via this scheme):
http://sourceforge.net/projects/openemr/forums/forum/202506/topic/5170598

The tricky things about these codes is what you set the code_type to (fir example, setting it to 4 as you have done may cause problems from some OpenEMR users):
http://open-emr.org/wiki/index.php/Code_Types

There is now a better mechanism where we can add the code type in (will get a value of 100+) that is compatible with new and upgraded instance of OpenEMR. If you’re interested, I’l gladly add this CIE9 as a new code type. Then when import the codes in the mysql, can instead insert the id in the code_type table for CIE9 rather than hard-code in 4.

I also think that there is a good point about considering the inclusion of this set of codes (and ICD9 codes) on a new install now that we have a mechanism to easily turn on/off codesets in the next 4.1.1 release (via Administration->Lists->Code_Types.

-brady
OpenEMR

ajperezcrespo wrote on Saturday, May 05, 2012:

Hi All,
   I took a peek at these and they don’t seem to be up to date.  It looks like the last update took was 2008 info.  I will ask a few billers I know to take a look and give a more definitive answer.
In the mean time I did a quick google and found this link for an excel sheet with what they claim is 2012 CIE9 data.
https://sites.google.com/site/documentacionclinica/boletines/CIE9_2012.xls?attredirects=0&d=1

Thanks and will inform ya.