SELECT Received_faxes.ID, Received_faxes.fax_id, Received_faxes.Order_ID, Received_faxes.Date_Change, Received_faxes.completed_timestamp, Received_faxes.originating_fax_number, pCMS4857.Order_ID AS Found_Order_ID, pCMS4857.Form_Type, pCMS4857.Form_Status, LEFT(pCMS4857.Order_description, 60) AS Order_Desc, COALESCE(pPatients.Patient_ID, 0) AS Patient_ID, COALESCE(pPatients.Pt_Last, pCMS4857.Pt_Last, '') AS Pt_Last, COALESCE(pPatients.Pt_First, pCMS4857.Pt_First, '') AS Pt_First FROM #Request.prefix_db_lookup#.Received_faxes LEFT OUTER JOIN #Request.prefix_db_agency#.pCMS4857 ON pCMS4857.Order_ID = Received_faxes.Order_ID AND pCMS4857.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pCMS4857.Assmt_ID AND pAssessments.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAssessments.Patient_ID WHERE Received_faxes.Agency_ID = AND Received_faxes.Order_ID > 0 AND Received_faxes.status = 0 AND Received_faxes.Change_by = 2 AND IFNULL(Received_faxes.Patient_ID, 0) = 0 GROUP BY Received_faxes.ID ORDER BY Received_faxes.Date_Change DESC

Orders Paired Automatically from Incoming Fax

Received FAX List

Patient Name	Order	Order Type	Order Status	Paired On	Fax Received	From Fax Number	Action
#EncodeForHTML(Pt_Last)#, #EncodeForHTML(Pt_First)# Not found	###Order_ID# Order not found in this agency #EncodeForHTML(Order_Desc)#	#EncodeForHTML(Form_Type)#	#EncodeForHTML(Form_Status)#	#DateTimeFormat(Date_Change, "mm/dd/yyyy hh:nn tt")#	#DateTimeFormat(completed_timestamp, "mm/dd/yyyy hh:nn tt")#	#EncodeForHTML(originating_fax_number)#	View Fax