Forms in encounter order

crlsgzmn · April 17, 2017, 8:21pm

Good afternoon to you all.

I’ve been trying to reorganize how the order that the forms are generated in the encounter form and the patient reports.

Problem is that most of the time the order is inverse, the encounter summary and the forms that you are editing appear last, and the last form appears first.

To no avail I have tried to reorganize them by changing the priority,but this apparently only modifies the order in which the list is generated on the drop down menus.

Any suggestions?

stephenwaite · April 18, 2017, 8:52pm

hi @crlsgzmn, it’s set here:

github.com

openemr/openemr/blob/4fb238630eab9b1c0bc47afd09c0c561f12b3445/library/forms.inc#L50


		$sql .= "and form_name=? ";
		array_push($arraySqlBind,$name);
	}
	if($attendant_type == 'pid'){
		$sql .= " and pid=? and therapy_group_id IS NULL ";
	}
	else{
		$sql .= " and therapy_group_id = ? and pid IS NULL ";
	}
	array_push($arraySqlBind,$attendant_id);
// This puts vitals first in the list, and newpatient last:
$sql .= "ORDER BY FIND_IN_SET(formdir,'vitals') DESC, date DESC";


	$res = sqlStatement($sql,$arraySqlBind);


	for($iter=0; $row=sqlFetchArray($res); $iter++)
	{
		$all[$iter] = $row;
	}
	return $all;
}

stephenwaite · April 18, 2017, 8:55pm

having a configurable list in the list_options table sounds ideal

crlsgzmn · April 19, 2017, 12:58pm

This would be Ideal. Having worked as an MD for 10 years, in places like Best Doctors I have to give my input to the Developers of Openemr, as the order in which a note is done is something standard among doctors.

A example of this would be this forms / order (and some of them are missing among the standard forms included in Openemr):

Case overview / Brief consultation note / Summary
History of present illness / HPI (With a graphic pain map)
Past Medical History (Is included in demographics, but not on the actual note, a duplication of this info would be ideal)
Past Surgical History (Same as above)
Current medication (Same as #3)
Allergies (Same as #3)
Family History (Sames as #3)
Social History (Same as #3)
Physical Exam
Lab testing (In current encounter)
Imaging studies / Diagnostic reports
Treating physician Assessment and plan
Surgical Recommendations

I will try to make this php forms and sql data to be added to the standard forms in Openemr, with some camos functionality like what ZH healthcare has would be ideal.

Regards,

brady.miller · April 20, 2017, 9:36am

Hi @crlsgzmn and @stephenwaite ,

A very nice feature here would be the following in the Administration->Other->Forms:

Another setting to set the priority of how forms are displayed (would have it be a separate setting from what is currently used to decide how it is ordered in the select menu).
Work LBF forms into this interface to allow setting category and these priority settings thus making the forms not appear different to the end user.

And would be nice to have a camos companion template system that is more user friendly and more tied into OpenEMR. For example, clicking on a button would bring in elements such as past medical history etc. Then when this is well featured, could actually start building note templates (ie. user could create a note that brings in all the elements automatically). This would then address a lot of the forms listed above.

-brady

crlsgzmn · April 20, 2017, 2:17pm

Then Mr. Miller,

This should be a feature request?

If so, are there any updated programming guidelines available?

Regards,

brady.miller · April 21, 2017, 12:49am

Hi @crlsgzmn ,

Check out here for guidelines (note we are very flexible and happy to provide guidance along the way):
http://www.open-emr.org/wiki/index.php/Development_Policies

-brady

crlsgzmn · April 21, 2017, 2:29pm

Good morning Mr. Brady,

I think that using ORDER BY FIELD works better than find in set. I set the line to:

$sql .= “ORDER BY FIELD(formdir,‘newpatient’,‘LBFCC’,‘LBFHPI’,‘vitals’,‘physical_exam’,‘reviewofs’,‘ros’,‘soap’,‘LBFA’,‘LBFP’,‘CAMOS’)”;

And now it works perfectly.

Ideally this should come from a list, or from the priority that forms/lists already have.

crlsgzmn · April 26, 2017, 1:20pm

Hi Mr. Stephen,

I’m trying to find how is the order made when looking at a patient report for printing purposes?. Any suggestions on what file to look for?

stephenwaite · April 26, 2017, 1:46pm

hi @crlsgzmn, i think it’s here:

github.com

stephenwaite/openemr/blob/master/interface/patient_file/report/custom_report.php#L302


  }


  //echo json_encode(json_encode($array_key_id));
  if (sizeof($form_id_arr)>0) {
      $query = "SELECT DISTINCT(form_name),formdir FROM forms WHERE form_id IN ( '".implode("','", $form_id_arr)."') AND formdir IN ( '".implode("','", $form_dir_arr)."')";
      $arr = sqlStatement($query);
      echo "<select multiple size='4' style='width:300px;' id='forms_to_search' onchange='clear_last_visit();remove_mark_all();find_all();' >";
      while ($res_forms_ids = sqlFetchArray($arr)) {
          echo "<option value='".attr($res_forms_ids['formdir'])."' selected>".text($res_forms_ids['form_name'])."</option>";
      }


      echo "</select>";
  }
  ?>
    </td>
    <td style="padding-left: 10px;; width: 30%;">
  <span id ='alert_msg' style='color: red;'></span>
    </td>
  </tr>
</table>
  </div>

crlsgzmn · May 31, 2017, 3:10pm

Hi Mr. Stephen,

I can confirm that I have 3 denied claims because of alleged out of order notes.

I tried adding the following code to the file but it didnt work
Line 292

$inclookupres = sqlStatement("select distinct formdir from forms where pid = '$pid' AND deleted=0 order by field(formdir,'newpatient','LBFCC','LBFHPI','vitals','reviewofs','physical_exam','ros','soap','LBFA','LBFP','CAMOS')");

stephenwaite · May 31, 2017, 4:27pm

hi @crlsgzmn, that seems odd, are the denied claims paper claims?

crlsgzmn · May 31, 2017, 4:30pm

No,

The claims were denied because of legibility once submitted to the insurance as per their request (They argue that they can’t be billed as level 3 or 5).

I think that this should be filled as a bug or maximum priority feature request…

Medica, Coventry and Humana are the insurance companies that I’m referring to.

I’m currently trying to figure this out, but the order of the notes is set independantly from LBF forms and formdir related reports.

stephenwaite · May 31, 2017, 4:34pm

so after you sent an electronic claim they wanted the corresponding notes? then after receiving your printed report they state that it’s illegible?

crlsgzmn · May 31, 2017, 4:35pm

Illegible and difficult to read as they don’t have a proper order regarding a standard medical note…

That’s what they argued.

crlsgzmn · May 31, 2017, 5:56pm

Yes.

Illegible and not professional as a matter of fact one of the insurances alleged.