ICD, rxNorm and Snomed data loads

OpenEMR Development
141

bradymiller wrote on Wednesday, July 18, 2012:

Hi,

Just committed the database import stuff to sourceforge:
http://github.com/openemr/openemr/commit/82354e7eb85d9938adb32b517297d4875a077f53

Thank you Mac for this awesome contribution.

-brady
OpenEMR

142

bradymiller wrote on Wednesday, July 18, 2012:

Hi,

Here is one last commit related to supporting flexible code types that I am submitting for review:
http://github.com/bradymiller/openemr/commit/fbff201fbce7069fffc3e609675bdcf3db3d850d
Even more improvements to make code types flexible:
-Added a procedure flag (ct_proc) in code_types table
-Further organized documentation of custom/code_types.inc.php
-Modularized function used to specify categories of code types,
such as diagnosis and procedure codes for the code type selector
popup
-Removed hard-coding of the CPT/ICD codetypes
in Reports->Financial->Pmt Method and Cash Rec
reports.
-Added mechanism for the find_code_popup.php
popup script to support multiple form fields
on the same target script.

Please feel free to review/test. thanks,
-brady
OpenEMR

143

bradymiller wrote on Wednesday, July 18, 2012:

Hi,

Threw together some quick documentation for using the ICD9/ICD10/SNOMED import tool and using the code type configuration editor:
http://www.open-emr.org/wiki/index.php/Code_Types
(please feel free to improve)

-brady
OpenEMR

144

bradymiller wrote on Friday, July 20, 2012:

Hi,

Committed the above commit (“Even more improvements to make code types flexible:”) to sourceforge yesterday. This pretty much concludes the project to support flexible code types in a modular fashion (along with a mechanism to import code sets).

-brady
OpenEMR

145

pillguy wrote on Friday, September 14, 2012:

Anyone seen an RXNorm to SNOMED or ICD9-CM map?  I was not sure if OpenEMR does this when the databases are loaded, but I am looking for a map.  If anyone has ideas please shoot me an email.  jchpharmd@gmail.com  Thank a bunch. 

146

mcaloon wrote on Friday, September 14, 2012:

Hey Jeff,
    In my poking around on the net I think I remember the term “code walking” that had some details on this. Correlating among codesets is going to become more prevalent as peeps want to do more robust analysis.

Mac

147

fndtn357 wrote on Saturday, September 15, 2012:

http://www.nlm.nih.gov/research/umls/mapping_projects/icd9cm_to_snomedct.html

148

pillguy wrote on Saturday, September 15, 2012:

Thanks for the link, but I am looking for RXNorm to snomed  or RXNorm to ICD9.

149

juggernautsei wrote on Monday, January 14, 2013:

Hi,

I am trying to load the ICD10 from the External Data Loads and I am getting this error:

ERROR: query failed: LOAD DATA LOCAL INFILE ‘C:/WINDOWS/TEMP//ICD10/2012_I10gem.txt’ INTO TABLE icd10_gem_dx_10_9 FIELDS TERMINATED BY ‘’ (@var) SET revision = 0, dx_icd10_source = trim(Substring(@var, 1, 7)),dx_icd9_target = trim(Substring(@var, 9, 5)),flags = trim(Substring(@var, 15, 5))

I have installed all the patches and this is a clean install.  The panel shows me this

Staged Releases
2012_PCS_long_and_abbreviated_titles.zip
DiagnosisGEMs_2012.zip
ICD10OrderFiles_2012.zip
ProcedureGEMs_2012.zip
ReimbursementMapping_2012.zip

Are there new copies of these files that I need to download? Or was the fix contained in the patch. I was not quite able to pick that out of the conversation above. 

Thanks
Sherwin
OpenMedPractice.com

150

juggernautsei wrote on Monday, January 14, 2013:

It is 4.1.1 (9). I did not have to do an import of the ICD9 because this is a clean copy of the code on an existing database.

There is some data in the ICD10 tables. I started a manual installation but then didn’t feel like it was everything pretaining to the IDC10. So to get the installer, I loaded a clean unmodified copy of the code and pointed it to the exiting database. 

Should I truncate the data that is in there and start over?

Thanks Brady!
OpenMedPractice.com

151

mcaloon wrote on Monday, January 14, 2013:

Hey Juggernautsei,
   It is safe to purge the ICD10 table and rerun the import from the Uzi.
Mac

152

juggernautsei wrote on Monday, January 14, 2013:

Mac,

thanks I tried it and it did not solve my problem. I still get the same error messag when trying to load the codes. I guess should have left well enough alone.

Sherwin

153

juggernautsei wrote on Wednesday, January 16, 2013:

Brady,

I the system has installed everything but the ICD10. I am still getting the LOAD DATA error. I thought I saw a fix on one of the boards for this problem but I can’t seem to find it now. Do you know how to find it?

Thanks
Sherwin

154

bradymiller wrote on Wednesday, January 16, 2013:

Hi Sherwin,

As a work-around for the “Error: The used command is not allowed with this MySQL version”(because some servers do not allow use of the LOAD DATA LOCAL INFILE command which is perhaps why the query is not working) note there is a manual way to bring in the ICD10 codes, which is basically done by importing the sql file link found in the instructions:
http://www.open-emr.org/wiki/index.php/Import_Standard_Tables#Import.2FUpgrade_and_activate_ICD10
(the link titled ‘this file’ in the instruction set)
(note these will truncate the tables before loading them, so shouldn’t need to truncate before using it)

-brady
OpenEMR