penguin8r wrote on Wednesday, April 04, 2012:
Anybody else had any problems with load_icd_desc.plx not working anymore? It starts to run, gets to inserting code ‘001.9’, then stops, & eventually times out & fails. I’m guessing that they must have changed something on the icd9data.com site that’s causing this, but I just started looking into it.
bradymiller wrote on Thursday, April 05, 2012:
Hi,
Perhaps we should consider retiring the load_icd_desc.plx script, since there is now a set of sql scripts to import them:
sql/icd9-codes-insert.sql
or
sql/icd9-codes-replace.sql
-brady
OpenEMR
mike-h30 wrote on Thursday, April 05, 2012:
penguin8r,
Yes, I also had the same issue as you describe with the load_icd_desc.plx script for an installation a few weeks ago. I ended up importing the icd9 codes from the /sql directory.
Brady,
I don’t see a need for the load_icd_desc.plx script now that the icd9 codes are in the /sql directory.
Mike
yehster wrote on Thursday, April 05, 2012:
CMS does make annual changes:
http://www.cdc.gov/nchs/data/icd9/ICD-9-CMINDEXADDENDAfy12.pdf
So without the perl script working, there isn’t a simple way to keep the .sql up-to-date.
The current sql is almost certainly out of date, although the changes in it probably don’t matter to most people.
penguin8r wrote on Thursday, April 05, 2012:
Keeping it up to date will sooner or later become something that has to be done, especially as ICD10 phases in.
I ended up just pulling a copy from a server built a couple of months ago when the perl loader was still working.
Yet another little kink to work out.
tmccormi wrote on Friday, April 06, 2012:
Doing a pretty serious amount poking around I found this site which may be of help: http://aehrc.com/med_eval/
It has 2011 ICD9 code in comma delimited format separated into diseases.csv and procedures.csv. Even better there is a SNOMED to ICD9 mapping file called icd_snomed_mapping.txt which could be very helpful.
Tony
www.mi-squared.com / @tonymi2
oemr.org / @OEMR_org
tmccormi wrote on Friday, April 06, 2012:
I also found a post on stack overflow of someone that had written a parser in VB or maybe C# (I don’t speak those) that can parse the RTF files available for CMS.gov (DTab12.rtf) being the relevant one. This script cleans the code and produces a CSV file, so it says.
http://stackoverflow.com/questions/3653811/icd-9-code-list-in-xml-csv-or-database-format
Tony
www.mi-squared.com / @tonymi2
oemr.org / @OEMR_org
bradymiller wrote on Friday, April 06, 2012:
Hi,
Is there an official free site to download the ICD9 code set in a raw format? (for example, the SNOMED, RXNORM, and ICD10 sets are all available in a raw format from an official site, which then makes it rather straightforward to use these native pcakges to import into OpenEMR and track the date/version of the release). If not, then could consider just keeping the perl script up to date and if anybody has the time, to update the sql packaged codes in sql/ directory.
-brady
OpenEMR
tmccormi wrote on Friday, April 06, 2012:
Define ‘Raw’ format. I have not found ICD9 10 in anything but .rtf document format which is a complex construct. ICD9 is probably available in that same RTF format. I have not found any official free sites that proved delimited data files for either of these two code sets.
-Tony
yehster wrote on Friday, April 06, 2012:
Here is a recent extract I’ve created from icd9codes.com
https://raw.github.com/yehster/oemrdoc/master/sql/icd9.sql
It has two tables,
dct_icd9_codes, dct_icd9_definitions
the definitions table contains the additional descriptions for specific codes where they exist.
the codes table includes the hierarchical structure. The rows with “discr” column= “SP” (for specific) are the “terminal codes” which correspond to what is currently in the codes table. (Only stuff from the bottom of the hierarchy).
If someone wanted to update their codes table from these tables, the insert statement would be pretty straight forward.
bradymiller wrote on Friday, April 06, 2012:
Hi,
For ICD10, the official site to get the raw format of the codeset is discussed in the following thread (see post 14 and later):
http://sourceforge.net/projects/openemr/forums/forum/202506/topic/5065456
-brady
OpenEMR
bradymiller wrote on Friday, April 06, 2012:
Also,
Here’s a place on the wiki that is tracking the ICD10 project:
http://www.open-emr.org/wiki/index.php/Diagnostic_Codes_Development#ICD10
-brady
OpenEMR
ajperezcrespo wrote on Friday, April 20, 2012:
I think this is where CMS keeps the ICD9 code updates.
http://www.cms.gov/Medicare/Coding/ICD9ProviderDiagnosticCodes/codes.html
The Zip files contain space delimited text files and a couple of xls file. One actually has the codes with both long and short text (CMS29_DESC_LONG_SHORT_DX 101111u021012.xls). This file was updated in Feb of this year.
Thanks
bradymiller wrote on Saturday, April 21, 2012:
Hi,
We should consider implementing an import for this in the interface/code_systems/standard_tables_manage.php code. This is how SNOMED, RXNORM are imported and mcaloon is currently getting ICD10 to be imported there:
http://sourceforge.net/projects/openemr/forums/forum/202506/topic/5170598
I anybody wants to do this, suggest waiting until mcaloon is done getting ICD10 to work.
-brady
OpenEMR
bradymiller wrote on Saturday, April 21, 2012:
clarification for above:
If anybody wants to do this, suggest waiting until mcaloon is done getting ICD10 to work.
mcaloon wrote on Saturday, April 21, 2012:
Hello,
I read this ICD 9 post and thought of just adding it onto the way the new code works. The new code handles 1 or more zip files in a feed (i.e. RxNorm/Snomed have a single file and ICD 10 has multiple files). Either way ICD 9 raw feed will fit into this new model. The new code is somewhat generic but based on the original code. I will look for the raw ICD 9 feed on the CMS site unless someone already knows where it is (in that case please post the location of the file(s). I would prefer to use the CMS file as it is where we are basing all the other feeds on.
Mac
bradymiller wrote on Saturday, April 21, 2012:
Hi Mac,
Per ajperezcrespo, looks like codes are here:
http://www.cms.gov/Medicare/Coding/ICD9ProviderDiagnosticCodes/codes.html
(it appears the package titles by CMS are again not very standardized…)
-brady
OpenEMR