SELECT Communication.Comm_ID, Communication.CommSub_ID, Communication.Patient_ID, Communication.Employee_ID, Communication.Initiator AS Initiator, Communication.Comm_Date, Communication.Memo, Communication.Resolved, Communication.Followup_desc, Communication.Followup_memo, Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, CommunicationSubjects.CommSub_ID, CommunicationSubjects.Subject, patient.Patient_ID, patient.Last_Name_M0040, patient.First_Name_M0040, patient.Primary_ReferringPhys_ID_M0072, Physician.Physician_ID, Employee.LastName, Employee.FirstName, Employee.Address1, Employee.City, Employee.State, Employee.Zip, Employee.Home_Phone as Telephone1, Agency.Agency_ID, Agency.Agency_Name, Agency.Agency_Contact_Phone FROM #Request.prefix_db_agency#.Communication, #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.CommunicationSubjects, #Request.prefix_db_lookup#.Agency, #Request.prefix_db_lookup#.Physician WHERE Communication.Comm_ID = #url.ID# And Communication.Employee_ID = Employee.Employee_ID And Communication.Patient_ID = patient.Patient_ID And Communication.CommSub_ID = CommunicationSubjects.CommSub_ID AND Communication.Agency_ID = Agency.Agency_ID AND patient.Primary_ReferringPhys_ID_M0072 = Physician.Physician_ID SELECT Employee_ID, First_Name, Last_Name FROM #Request.prefix_db_lookup#.Employee WHERE Employee_ID = #GetComm.Initiator# AND EmployeeType != 'Physician' Myhomecarebiz.com



Memo regarding #First_Name_M0040# #Last_Name_M0040# from #Agency_Name#

Re: #Subject#

Submitted by: #First_Name# #Last_Name#
Physician #FirstName# #LastName#
#Address1#
#City#, #State# #Zip#
#Telephone1#
Date #DateFormat(Comm_Date,"mm/dd/yyyy")#
Memo #Replace(Memo, CrLf, "
", "ALL")#
Agency Representative #First_Name# #Last_Name#
#Agency_Contact_Phone#

This memo is for your records.