From da142f2c6c2659aabb8d6d8c426b1d8373e44c5a Mon Sep 17 00:00:00 2001
From: ViCarePlus <visolve_emr@visolve.com>
Date: Mon, 28 Mar 2011 02:31:53 -0700
Subject: [PATCH] NIST compatible fix for CPOE

---
 interface/forms/procedure_order/report.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/interface/forms/procedure_order/report.php b/interface/forms/procedure_order/report.php
index 5cbf28775..c4c625f4a 100644
--- a/interface/forms/procedure_order/report.php
+++ b/interface/forms/procedure_order/report.php
@@ -13,9 +13,9 @@ include_once($GLOBALS["srcdir"] . "/options.inc.php");
 function procedure_order_report($pid, $encounter, $cols, $id) {
  $cols = 1; // force always 1 column
  $count = 0;
- $data = sqlQuery("SELECT * " .
-  "FROM procedure_order WHERE " .
-  "procedure_order_id = '$id' AND activity = '1'");
+ $data = sqlQuery("SELECT pt.name as Procedure_Order,po.* " .
+  "FROM procedure_order as po, procedure_type as pt WHERE " .
+  "po.procedure_type_id = pt.procedure_type_id AND po.procedure_order_id = '$id' AND po.activity = '1'");
  if ($data) {
   print "<table cellpadding='0' cellspacing='0'>\n<tr>\n";
   foreach($data as $key => $value) {
-- 
2.11.4.GIT