Long description of diagnosis codes

system · February 25, 2014, 10:11pm

cyprol wrote on Tuesday, February 25, 2014:

Is there any long description for the diagnosis codes? I know there is a short description but I don’t know if there is for long too.In case that there is long description,where can I find it so I can use it for my functionalities?

system · February 26, 2014, 2:56am

cmswest wrote on Wednesday, February 26, 2014:

sure, there’s a mysql table called icd9_dx_long_code and there’also icd10_dx_order_code that is the subject of all of those emails from cms that are sent out everyday, are you ready?

system · February 26, 2014, 9:08am

antiael7 wrote on Wednesday, February 26, 2014:

I have the same question with phil.
Basically, how can I must do the sql query so that if I give as parameter the codetext of a diagnosis, it will give to me the long description of this.

system · February 26, 2014, 12:54pm

cmswest wrote on Wednesday, February 26, 2014:

well you could use the icd code as the key to the other file but field 5 in icd9_dx_code is the long_desc too

see attachment

system · February 26, 2014, 9:40pm

antiael7 wrote on Wednesday, February 26, 2014:

Actually I have this code from the add_edit_issue.php :

$search_term = $_REQUEST[‘search_term’];
$res = code_set_search($form_code_type,$search_term);
while ($row = sqlFetchArray($res)) {
$itercode = addslashes($row[‘code’]);
$itertext = addslashes(trim($row[‘code_text’]));
…
}

How can I get the long description of the specific diagnosis code? If anyone can help me, I would appreciate it.

system · February 27, 2014, 12:03am

cmswest wrote on Thursday, February 27, 2014:

do you mean openemr/find_code_popup.php at master · openemr/openemr · GitHub ?

system · February 27, 2014, 7:50am

antiael7 wrote on Thursday, February 27, 2014:

system · February 27, 2014, 7:50am

antiael7 wrote on Thursday, February 27, 2014:

Yes Stephen Waite.

system · February 27, 2014, 2:01pm

cmswest wrote on Thursday, February 27, 2014:

looks like you’re getting it in code_text as code_text_short would be the alternative

github.com

openemr/openemr/blob/master/custom/code_types.inc.php#L634


        $query .= " ORDER BY ".$table_dot.$code_col."+0,".$table_dot.$code_col;


        if ($return_query) {
            // Just returning the actual query without the LIMIT information in it. This
            // information can then be used to combine queries of different code types
            // via the mysql UNION command. Returning an array to contain the query string
            // and the binding parameters.
            return array('query'=>$query,'binds'=>$sql_bind_array);
        }


        $query .= $limit_query;


        $res = sqlStatement($query, $sql_bind_array);
    } else {
        HelpfulDie("Code type not active or not defined:".$join_info[JOIN_TABLE]);
    }
} // End specific code type search


if (isset($res)) {
    if ($count) {
        // just return the count

system · February 27, 2014, 3:45pm

antiael7 wrote on Thursday, February 27, 2014:

I am confused.Finally,there is no long_descr to use or I can use only the short descr?

system · February 27, 2014, 4:12pm

antiael7 wrote on Thursday, February 27, 2014:

For example this diagnosis code -> ICD9:851.45 with description: Cerebellar or brain stem contusion without mention of open intracranial wound, with prolonged [more than 24 hours] loss of consciousness without return to pre-existing conscious level is a short description?? Actually, I believe that this not a short description because from the table of icd9_dx_code that you send to me above, the short description is varchar(60), and the specific description has more characters than 60.

system · February 27, 2014, 7:56pm

cmswest wrote on Thursday, February 27, 2014:

use the javascript that was built into find_code_popup.php by kevin yeh i believe:

github.com

openemr/openemr/blob/master/interface/patient_file/encounter/find_code_popup.php#L180


 </td>
</tr>


<tr>
 <td height="1">
 </td>
</tr>


</table>


<?php
if ($_REQUEST['bn_search'] || $_REQUEST['search_term']) {
   if (!$form_code_type) {
       $form_code_type = $codetype;
   }
?>


<table border='0'>
<tr>
<td><b><?php echo xlt('Code'); ?></b></td>
<td><b><?php echo xlt('Description'); ?></b></td>

system · February 27, 2014, 9:03pm

cmswest wrote on Thursday, February 27, 2014:

thought this seemed familiar, please see this thread:

https://sourceforge.net/p/openemr/discussion/202506/thread/2705ed6b/?limit=50#91ac

system · February 27, 2014, 9:05pm

antiael7 wrote on Thursday, February 27, 2014:

How and where can I use the $itertext = trim($row[‘code_text’]); so that I will get the long description of the diagnosis code?

system · February 28, 2014, 1:35am

cmswest wrote on Friday, February 28, 2014:

as Rod said in another post “if you are not familiar with PHP you’ll probably need to get another developer involved”