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,
Assessment_Forms.Addendum_Details_21,
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, Employee, #Request.prefix_db_agency#.Assessment_New
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.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID
AND Assessment_New.Deleted <> 1
and Employee.Employee_ID = Physician.Employee_ID
AND Assessment_Forms.Form_Status NOT IN ('Signed','Delete')
AND Assessment_Forms.Date_Sent is null
Group by Assessment_Forms.Date_Sent, patient.Patient_ID, Assessment_Forms.Assessment_Forms_ID
ORDER BY Assessment_Forms.Date_Sent, patient.Last_Name_M0040, patient.First_Name_M0040, Assessment_Forms.Cert_End_Item_3b
Un-Signed Orders (by Date Mailed to Physician)
___________________________________________
#DateFormat(Date_Sent,"mm/dd/yyyy")#
NO DATE SENT
#PatientLast#, #PatientFirst#
#status#
#Form_Type#
#Form_Type#
#DateFormat(Cert_Start_Item_3a,"mm/dd/yy")#-#DateFormat(Cert_End_Item_3b,"mm/dd/yy")#
Print
mailed #DateFormat(Date_Sent,"mm/dd/yyyy")#
NOT MAILED