SELECT *
FROM #Request.prefix_db_agency#.Communication
WHERE Comm_ID = #url.Id#
SELECT Employee_ID, First_Name, Last_Name
FROM #Request.prefix_db_lookup#.Employee
WHERE Agency_ID = '#session.AgencyID#'
AND Status = 'active'
AND EmployeeType != 'Physician'
ORDER BY Last_Name
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 Last_Name_M0040
SELECT CommSub_Id, Subject
FROM #Request.prefix_db_agency#.CommunicationSubjects
WHERE Agency_Id = #session.AgencyId#
AND active = 'Y'
ORDER BY Subject
New Communication
#getP.Last_Name_M0040#, #getP.First_Name_M0040# - Update Communication
