SELECT Count(ScheduleItems.Employee_ID) as Count, ScheduleItems.ScheduleItems_ID, 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() Group by ScheduleItems.Employee_ID ORDER BY Employee.Last_Name ASC, Employee.First_Name ASC

Progress Notes that need to be Reviewed

--->

	Employee	Total Notes
	#Last_Name#, #First_Name#	#Count#

--->