SELECT patient.Patient_ID, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, Assessment_New.Assessment_ID, Assessment_New.Assessment_Reason_M0100, ScheduleItems.Visit_Date, ScheduleItems.Visit_Type AS Type, ScheduleItems.Signature , ScheduleItems.ScheduleItems_ID, ScheduleItems.Note_QA, ScheduleItems.MR_490, ScheduleItems.MR_670, ScheduleItems.MR_690, Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, Employee.DE_Progress_Items FROM #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_lookup#.Employee WHERE ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID AND Assessment_New.Patient_ID = patient.Patient_ID AND ScheduleItems.Employee_ID = Employee.Employee_ID AND ScheduleItems.Agency_ID = #session.AgencyID# AND Assessment_New.Deleted = 0 AND patient.Status = 'active' AND ScheduleItems.Visit_Type Not in ('Assessment','Evaluation') AND (ScheduleItems.EClaimed != 1) AND ScheduleItems.Deleted != 1 AND ScheduleItems.Progress_Note = 'Yes' AND ScheduleItems.Note_QA != 'Approved' AND ScheduleItems.Missed = 'No' AND ScheduleItems.Visit_Date Between '2017-01-01' and NOW() AND ScheduleItems.Visit_Date <= NOW() AND ScheduleItems.Employee_Id = '#url.eid#' ORDER BY Employee.Last_Name ASC, Employee.First_Name ASC

Progress Notes that need to be Reviewed for #SN_pain.First_Name# #SN_pain.Last_Name#

	Patient	Assessment	Visit Date	Visit Type	patient sign	Missing Items	Action
	#PatientLast#, #PatientFirst#	#Assessment_Reason_M0100#	#DateFormat(Visit_Date,"mm/dd/yyyy")#	#Type#	YES	NO	#MR_690#	NOT APPROVED