SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE Emp_ID IN (#FORM.Emp_ID#) AND status =0 SELECT c.Comm_Id, c.CommSub_Id, c.Patient_Id, c.Employee_Id ,c.Comm_Date, c.Memo, c.Resolved, c.Record_Created_By ,c.Followup_Desc, c.Followup_Memo ,cs.CommSub_Id, cs.Subject ,e.Emp_Id, e.Emp_Last AS Last_Name, e.Emp_First AS First_Name ,a.Agency_Id, a.Agency_Name, a.Agency_Contact_Phone FROM #Request.prefix_db_agency#.Communication c JOIN #Request.prefix_db_agency#.CommunicationSubjects cs ON cs.CommSub_Id = c.CommSub_Id JOIN #Request.prefix_db_lookup#.Agency a ON a.Agency_Id = c.Agency_Id LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee e ON e.Emp_Id = c.Employee_Id WHERE c.Comm_Id = '#FORM.comm_id#' AND c.Agency_Id = '#session.AgencyId#' SELECT p.Patient_ID, p.Pt_Last AS Last_Name_M0040, p.Pt_First AS First_Name_M0040, p.Pt_DOB FROM #Request.prefix_db_agency#.pPatients p WHERE p.Patient_Id = '#GetComm.Patient_Id#' SELECT py.Phys_ID ,e.Emp_Last AS DocLName, e.Emp_First AS DocFName ,e.Emp_Street1 AS Address1, e.Emp_City AS City, e.Emp_State AS State, e.Emp_Zip AS Zip, e.Emp_Telephone as phone FROM #Request.prefix_db_lookup#.pPhysicians py, #Request.prefix_db_lookup#.pEmployee e WHERE py.Emp_ID = '#GetComm.Employee_Id#' AND e.Emp_ID = py.Emp_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'

#getComm.Agency_Name# memo...


Patient:	#getPatient.First_Name_M0040# #getPatient.Last_Name_M0040# DOB: #DateFormat(getPatient.Pt_DOB,"mm/dd/yyyy")#

Subject:	#GetComm.Subject#

Submitted By:	#GetI.FIRST# #GetI.LAST#

Date:	#DateFormat(GetComm.Comm_Date,"mm/dd/yyyy")#

Physician:	#GetDoc.DocFName# #GetDoc.DocLName# #GetDoc.Address1# #GetDoc.City#, #GetDoc.State# #GetDoc.Zip# #GetDoc.phone#

Agency Rep:	#GetComm.First_Name# #GetComm.Last_Name# Rep Phone: #GetComm.Agency_Contact_Phone#

Memo:	#GetComm.Memo#

Follow-up Action:	#GetComm.Followup_Desc#

Follow-up Memo:	#GetComm.Followup_Memo#

This memo is for your records.

//request.myPdf = fileReadBinary(getfilename); // request.myPdf = toBase64( request.myPdf ); //request.myPdf = toBinary( request.myPdf ); request.myPdf = toBase64( gettingfile ); UPDATE #Request.prefix_db_agency#.Communication SET send_fax = 1, fax_sent_date = #now()# WHERE Comm_ID =