SELECT patient.patient_ID, patient.Status, patient.Last_Name_M0040 AS patientLast, patient.First_Name_M0040 AS patientFirst, Assessment_Forms.Assessment_Forms_ID, Assessment_Forms.Form_Type, Assessment_Forms.Date_Sent, Assessment_Forms.Cert_Start_Item_3a, Assessment_Forms.Cert_End_Item_3b, Assessment_Forms.Record_Mod_Date, Physician.Physician_ID, Employee.Last_Name as LastName, Employee.First_Name as FirstName FROM #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_Forms, #Request.prefix_db_lookup#.Physician,#Request.prefix_db_lookup#.Employee WHERE patient.patient_ID = Assessment_Forms.patient_ID AND Physician.Physician_ID = patient.Primary_ReferringPhys_ID_M0072 AND patient.Agency_ID = #session.AgencyID# AND Assessment_Forms.Form_Status NOT IN ('Signed','Delete') AND Employee.Employee_ID = Physician.Employee_ID ORDER BY Employee.Last_Name ASC, Employee.First_Name, patient.Last_Name_M0040 ASC, Assessment_Forms.Date_Sent MyHomecareBiz.com

Un-Signed Orders by Physician

New Order by Date Sent by patient

___________________________________________
#LastName#, #FirstName#

#patientLast#, #patientFirst# #Form_Type##Form_Type# #DateFormat(Cert_Start_Item_3a,"mm/dd/yy")# - #DateFormat(Cert_End_Item_3b,"mm/dd/yy")# PrintPrint mailed #DateFormat(Date_Sent,"mm/dd/yyyy")#