SELECT *
FROM #Request.prefix_db_agency#.Communication
WHERE Comm_ID = #url.ID#
AND Record_Creation_Date <> '0000-00-00'
AND Record_Created_By <> '0000-00-00'
AND Record_Mod_Date <> '0000-00-00'
AND Record_Mod_By <> '0000-00-00'
SELECT Employee_ID, First_Name, Last_Name
FROM #Request.prefix_db_lookup#.Employee
WHERE Agency_ID = #session.AgencyID#
AND Status = 'active' AND EmployeeType != 'Physician'
AND Password <> ''
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#
ORDER BY Subject
New Communication
#getP.Last_Name_M0040#, #getP.First_Name_M0040# - Update Communication