SELECT Communication.Comm_ID, Communication.CommSub_ID, Communication.Patient_ID, Communication.Employee_ID, Communication.Comm_Date, Communication.Memo, Communication.Resolved, Communication.Record_Created_By, Communication.Followup_Desc, Communication.Followup_Memo, pEmployee.Emp_ID, pEmployee.Emp_Last, pEmployee.Emp_First, CommunicationSubjects.CommSub_ID, CommunicationSubjects.Subject, pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First, pAdmit.Refer_Phys_ID AS Primary_ReferringPhys_ID_M0072, pPhysicians.Phys_ID, pEmployee.Emp_Last as LastName, pEmployee.Emp_First as FirstName, pEmployee.Emp_Street1 AS Address1, pEmployee.Emp_City AS City, pEmployee.Emp_State AS State, pEmployee.Emp_Zip AS Zip, pEmployee.Emp_Telephone as Telephone1,pPhysicians.Phys_Fax as Fax, Agency.Agency_ID, Agency.Agency_Name, Agency.Agency_Contact_Phone FROM #Request.prefix_db_agency#.Communication JOIN #Request.prefix_db_agency#.CommunicationSubjects ON CommunicationSubjects.CommSub_Id = Communication.CommSub_Id JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = Communication.Patient_ID AND pPatients.Status < 2 JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = pPatients.Patient_ID AND pAdmit.Status = 0 JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_Id = Communication.Agency_Id LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_Id = Communication.Employee_Id LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Emp_ID = pEmployee.Emp_ID WHERE Communication.Comm_ID = #url.Comm_ID# GROUP BY Communication.Comm_ID SELECT Emp_First AS FIRST, Emp_Last AS LAST FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = '#GetComm.Record_Created_By#' AND Emp_Type != 'Physician'

Memo regarding #Pt_First# #Pt_Last# from #Agency_Name#

Re: #Subject#

Submitted by: #FIRST# #LAST#
Physician #FirstName# #LastName#
#Address1#
#City#, #State# #Zip#
#Telephone1# Tele
#Fax#No Fax
Date #DateFormat(Comm_Date,"mm/dd/yyyy")#
Memo #Replace(Memo, CrLf, "
", "ALL")#
Follow-Up #Followup_Desc#: #Followup_Memo#
Agency Representative #Emp_First# #Emp_Last#
#Agency_Contact_Phone#

This memo is for your records.

 Please assign an employee to the communication.