Diagnostic Codes Development

Overview

OpenEMR currently supports ICD9 diagnostic codes by default (although the codes need to be imported via phpmyadmin). It is also important to support ICD10 and SNOMED as an option; this wiki page will track the development of this. This was started after active discussion in the icd10 sourceforge forum thread.

The vital pieces here are the 'codes' and 'code_type' sql tables. It seems a lot of the codebase relies on hard-coded 'ct_id' elements in the 'codes' table to identify the code set. However, to get things to work smoothly, one option is to consider refactoring the code to instead use join in the mysql queries in order to instead use the 'ct_key' elements in the 'code_type' table to identify the code set and is discussed on the Code Types wiki page.

ICD9

Already integrated and working on a default OpenEMR installation(although the codes need to be imported via phpmyadmin).

• For ease of use, could consider mechanism that has these codes installed by default, but that needs to be turned "on" to use.
• Create a mechanism to search for ICD9 codes by category.

ICD10

Article on transition from ICD9 to ICD10 in the US: Guest Article: Actionable advice on how to make tangible progress in ICD-9 to ICD-10 migration

Appears that some users have got this working.

• For standardization, propose following: (THIS PART IS DONE)

• Add following sql columns to the code_types tables: (THIS PART IS DONE)

• active (will allow placing multiple code sets without them being used unless chosen)
• external (0 for using the codes tables to hold codeset and then 1 or greater to use an external table(s) mechanism)
• label (for displaying the code set name"

• Create an entry in code_types table(with id of 100+). See Code Types wiki page for details. (THIS PART IS DONE)
• Support this in the codebase (THIS PART IS ALMOST DONE)

• Modularize functions and place these functions in the custom/code_types.inc.php script.
• Things that still need to be done can be found in the Common Issues section below.

• Importing codes THIS PART IS ALMOST DONE

• Plan to import codes via the UI mechanism (like SNOMED and RXNORM)

• The latest raw data file packages can be downloaded from

• DIAGNOSTIC CODES: https://www.cms.gov/Medicare/Coding/ICD10/2012-ICD-10-CM-and-GEMs.html
• PROCEDURE CODES: https://www.cms.gov/Medicare/Coding/ICD10/2012-ICD-10-PCS.html

• See the following forum threads for ongoing progress on this project:

• ICD10 code
• ICD, rxNorm and Snomed data loads

• Analysis of the ICD10 codeset is done and was reported by a developer (mcaloon) here: http://sourceforge.net/u/mcaloon/wiki/ICD%2010%20Home/

SNOMED

Can currently import the SNOMED datasets into the OpenEMR databasae, however it is currently not integrated with the OpenEMR codebase.

• For standardization, propose following: (THIS IS DONE)

• Create an entry in code_types table(with id of 100+). See Code Types wiki page for details.
• Support this in the codebase

DSMIV

Appears that some users are working on this

• For standardization, propose following: (THIS IS DONE)

• Create an entry in code_types table(with id of 100+). See Code Types wiki page for details.
• Support this in the codebase

• Importing of codes

• Suggest using same mechanism as the ICD10/SNOMED (and soon to be ICD9)

Common Issues

Still things left to do are:

1. The fee sheet only shows the code (and not the code type) when selecting a justification code. Will also show the code type (ie. ICD9:258.12 rather than 258.12). (COMPLETED 6/19/12)
2. The justify sql column in the billing table will also include the code types of the codes (ie. ICD9:258.12 rather than 258.12) (COMPLETED 6/19/12)
3. The ar_activity table will have a code_type column since it has a code column (akin to the billing table), otherwise not clear what code set the code is actually from. This will also be fixed in Z&H's recent code submission that placed the COPAY from billing table into the ar_activity/ar_session tables. (COMPLETED 7/3/12)
4. Deal with hard-coding of ICD9, CPT4, HCPCS in the claims code (COMPLETED 7/3/12)
5. Have the CDR diagnosis searching in rule edit use the modular code search function (COMPLETED 6/16/12)
6. Place an index on the code_type column in the codes table (COMPLETED 7/5/12)
7. Increase size of code_type column in the billing table (varchar(15)) (COMPLETED 7/5/12)
8. Increase size of modifier column in the codes and ar_activity table (varchar(12)) (COMPLETED 7/5/12)
9. Place code_types (inactive) for CPTII, ICD9-SG, and ICD10-PCS (Change the labels of the ICD/SNOMED dx code types and External methods to make it clear) (COMPLETED 7/5/12)
10. Importing mechanism for ICD9/ICD10 codes (AWAITING 4TH CODE REVISION)
11. Change ICD/CPT labels in the financial reports to Diagnosis/Procedure-Service
12. Grep ICD9/HCPCS/CPT4 and where a code_type int (from codes table) is hard-coded in queries to deal with some miscellaneous stuff
13. The syndromic surveillance only works with ICD9 codes. I modified the Administration->Fees to allow setting any code as reportable, however the Syndromic Surveillance report will still only show the ICD9 ones(because is involved in HL7 creation, so need to ensure it tests well with other code types before implementing). So, will need to get the report to support other code sets(and ensure it tests well since this module is needed for meaningful use).(may do this for the next release instead of 4.1.1)
14. Add pertinent codes to the CDR engine (plan to do this for the next release - not planned for the 4.1.1 release)