Diagnostic Codes Development

From OpenEMR Project Wiki

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.
  • 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"
  • Modularize functions and place these functions in the custom/code_types.inc.php script.
  • The TODO list can be found in the Common Issues section below.
  • Plan to import codes via the UI mechanism (like SNOMED and RXNORM)
  • The latest raw data file packages can be downloaded from
  • See the following forum threads for ongoing progress on this project:

SNOMED

Can currently import the SNOMED datasets into the OpenEMR databasae, however it is currently not integrated with the OpenEMR codebase.
  • 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
  • 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

The TODO list:
  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 (COMPLETED 7/17/12)
  11. Fix hard-coding of ICD/CPT4 related stuff throughout codebase (Submitted For Review 7/17/12)
  12. 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)
  13. Add pertinent codes to the CDR engine (plan to do this for the next release - not planned for the 4.1.1 release)