SELECT * FROM #Request.prefix_db_agency#.pPatients LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = pPatients.Patient_ID AND pAdmit.status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pAdmit.Case_Manager LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pPatients.Patient_ID = pAssessments.Patient_ID WHERE pPatients.Patient_ID = '#url.ID#' AND pPatients.status = 0 GROUP BY pPatients.Patient_ID SELECT * FROM #Request.prefix_db_agency#.pAdmit JOIN #Request.prefix_db_agency#.pPatients ON pAdmit.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pAdmit.Case_Manager LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAdmit.Admit_ID = pAssessments.Admit_ID WHERE pAdmit.Admit_ID = '#url.admitid#' AND pAdmit.Status = 0 AND pPatients.status = 0 GROUP BY pAdmit.Admit_ID

Teaching Plan for

#getadmit.Pt_First# #getadmit.Pt_Last#

Prepared by #getadmit.Emp_First# #getadmit.Emp_Last#

SELECT *, Type AS Pathway_Type FROM #Request.prefix_db_lookup#.Teaching_Symptoms_1 WHERE Teaching_Symptoms_1.Path_ID = '#path_type#' ORDER BY Step_ID ASC SELECT *, Type AS Pathway_Type FROM #Request.prefix_db_lookup#.Teaching_Prevention WHERE Pathway_ID = '#path_type#' ORDER BY Type DESC, Step_ID ASC

Confusion/Cognition Deficit mild Confusion/Cognition Deficit severe Wound Cancer Depression Anxiety Vision Deficit Hearing Deficit Communication Deficit Urinary Catheter Diabetes Infection Hypertension Cardiac Condition Respiratory Condition UTI

#UCase(getsymptoms.Explanation)#

#getsymptoms.Explanation#

#UCase(getteachings.Explanation)#

#getteachings.Explanation#

Teaching Plan for #getadmit.Pt_First# #getadmit.Pt_Last#

prepared by #getadmit.Emp_First# #getadmit.Emp_Last#

page #cfdocument.currentpagenumber#

Cannot be reloaded. Please close it and try to print report once again