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 Employee_ID, First_Name, Last_Name FROM #Request.prefix_db_lookup#.Employee
WHERE Employee_ID = #GetComm.Initiator# AND EmployeeType != 'Physician'
SELECT Patient_ID, Last_Name_M0040, First_Name_M0040 FROM #Request.prefix_db_agency#.patient
WHERE Patient_ID = #GetComm.Patient_ID#
SELECT CommSub_ID, Subject FROM #Request.prefix_db_agency#.CommunicationSubjects
WHERE Agency_ID = #session.AgencyID# ORDER BY Subject
MyHomecareBiz.com
New Communication
#getP.Last_Name_M0040#, #getP.First_Name_M0040# - Update Communication