SELECT Agency_Name, Agency_Address1, Agency_City, Agency_State, Agency_Zip, Agency_Contact_Phone, Agency_Fax FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.AgencyID#' SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE Emp_ID = '#url.Emp_ID#' AND status =0 request.fax = CreateObject("component","components.general.fax").init();

Fax number is Invalid or not available for selected employee

UPDATE #Request.prefix_db_agency#.pCMS4857 SET Form_Status = 'Sent via Fax', Date_Sent = #now()#, fax_send_phys_id = #Get485_phys.Phys_ID#, fax_send_to = '#LOCAL.ToName#' WHERE Order_ID = '#url.afid#' UPDATE #Request.prefix_db_agency#.Event SET fax_send_to = , fax_sent_time = WHERE Event_ID = UPDATE #Request.prefix_db_agency#.Communication SET send_fax = 1, fax_sent_date = #now()# WHERE Comm_ID = SELECT files.*,pPatients.Pt_Last,pPatients.Pt_First FROM #Request.prefix_db_agency#.files JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = files.PatientId AND pPatients.status < 2 WHERE files.id IN (#url.file_id#) AND files.AgencyId = '#session.AgencyId#' SELECT pg_files.*,pPatients.Pt_Last,pPatients.Pt_First FROM #Request.prefix_db_agency#.pg_files JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pg_files.Patient_Id AND pPatients.status < 2 WHERE pg_files.id = #url.file_id# AND pg_files.Agency_Id = '#session.AgencyId#' UPDATE #Request.prefix_db_agency#.files #Request.prefix_db_agency#.pg_files SET faxsend_to = , faxsent_time = WHERE id IN ()