Vital, Wound, Symptom & Lab Inquiry

SELECT Patient_Id, Last_Name_M0040, First_Name_M0040 FROM #Request.prefix_db_agency#.patient WHERE Agency_Id = '#session.AgencyId#' AND Status = 'active' ORDER BY 2, 3 " & getPatientList.Last_Name_M0040 & ", " & getPatientList.First_Name_M0040 & "" /> " /> /****************************************************** * SET VARIABLES * */ // formName variables.formName = formName; variables.navroot = navroot; // fieldName if (isDefined('fieldFromName')) { variables.fieldFromName = fieldFromName; } else { variables.fieldFromName = 'From_Date'; } // fieldName if (isDefined('fieldToName')) { variables.fieldToName = fieldToName; } else { variables.fieldToName = 'To_Date'; } variables.days = -1; if(isDefined("session.DateFromToDays")) { if(session.DateFromToDays gt 0) { variables.days = session.DateFromToDays; } } // fieldValue if (isDefined('fieldFromValue')) { variables.fieldFromValue = fieldFromValue; } else { // Changed by me to hold current date if(variables.days gt 0) { variables.fieldFromValue = DateFormat(dateadd('d', -#session.DateFromToDays#, Now()),'mm/dd/yyyy'); } else { variables.fieldFromValue = DateFormat(dateadd('m', -1, Now()),'mm/dd/yyyy'); } } if (isDefined('fieldToValue')) { variables.fieldToValue = fieldToValue; } else { // Changed by me to hold current date variables.fieldToValue = DateFormat(Now(),'mm/dd/yyyy'); } // Other Fields if (isDefined('OtherFields')) { variables.OtherFields = OtherFields; } else { variables.OtherFields = ''; } // Submit Button if (isDefined('ButtonText')) { variables.ButtonText = ButtonText; } else { variables.ButtonText = 'Submit'; } // back if (isDefined('back')) { variables.back = back; } else { variables.back = 'no'; } if (isDefined('action')) { variables.action = action; } else { variables.action = ''; } if (isDefined('title')) { variables.title = title; } else { variables.title = 'no'; } // scriptPath if (isDefined('scriptPath')) { variables.scriptPath = scriptPath; } else { variables.scriptPath = 'popDateTime/'; }

Vital, Wound, Symptom & Lab Inquiry

> SELECT p.Patient_Id, p.Last_Name_M0040, p.First_Name_M0040 FROM #Request.prefix_db_agency#.patient p WHERE p.Patient_Id = '#Form.PatientId#' SELECT pvd.Type, pvd.Description, pvd.Record_Creation_Date, pvd.Reading1, pvd.Notes, s.Visit_Date FROM #Request.prefix_db_lookup#.Agency a, #Request.prefix_db_agency#.PatientVisitDetails pvd, #Request.prefix_db_agency#.ScheduleItems s WHERE a.Agency_Id = '#session.AgencyId#' AND pvd.ScheduleItems_ID = s.ScheduleItems_ID AND (pvd.Agency_Id = a.Agency_Login or pvd.Agency_Id = a.Agency_Id) AND pvd.Patient_Id = '#Form.PatientId#' AND s.Visit_Date BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND pvd.Type IN ('Vital Sign', 'Laboratory', 'Wound', 'Symptom', 'symptom', 'vital sign', 'wound', 'laboratory') AND pvd.Notes != '' ORDER BY 1, 2, 3 SELECT pd.Type, pd.Description, pd.Record_Creation_Date,a.Agency_Name FROM #Request.prefix_db_lookup#.Agency a, #Request.prefix_db_agency#.Pathway_Details pd, #Request.prefix_db_agency#.Assessment_New an WHERE a.Agency_Id = '#session.AgencyId#' AND (pd.Agency_Id = a.Agency_Login or pd.Agency_Id = a.Agency_Id) AND pd.Assessment_ID = an.Assessment_ID AND pd.Patient_Id = '#Form.PatientId#' AND an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND pd.Type IN ('Vital Sign', 'Laboratory', 'Wound', 'Symptom', 'symptom', 'vital sign', 'wound', 'laboratory') AND (pd.Deleted <> 'Yes' OR pd.Deleted is null) ORDER BY 1, 2, 3 New Inquiry Physician Orders Turn-Around Performance Report

Patient: #pi.Last_Name_M0040#, #pi.First_Name_M0040# From: #Form.From_Date# To: #Form.To_Date#

Print as PDF

Type	Description	Reading/Notes
#REREPLACE(LCASE(pathway.Type), "((^\| )[a-z]{1})", "\U\1", 'ALL')#	#REREPLACE(LCASE(pathway.Description), "((^\| )[a-z]{1})", "\U\1", 'ALL')#	0#pd.Reading1# #pd.Notes#

Print as PDF

Type	Description	Visit Date	Reading/Notes
#REREPLACE(LCASE(pd.Type), "((^\| )[a-z]{1})", "\U\1", 'ALL')#	#REREPLACE(LCASE(pd.Description), "((^\| )[a-z]{1})", "\U\1", 'ALL')#	#DateFormat(pd.Visit_Date, 'mm/dd/yyyy')#	#pd.Reading1##pd.Notes#