SELECT patient.Patient_ID, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst,
ScheduleItems.ScheduleItems_ID, ScheduleItems.Visit_Date, ScheduleItems.Visit_Type AS Type, ScheduleItems.Note_QA, ScheduleItems.Progress_Note, ScheduleItems.EmpPay_ID,
Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, Assessment_New.Assessment_ID, Assessment_New.Admission_Status
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.Deleted IS Null OR Assessment_New.Deleted = '0')
AND patient.Patient_ID = ScheduleItems.Patient_ID
AND patient.Status != 'deleted'
AND patient.Agency_ID = #session.AgencyID#
AND (ScheduleItems.EClaimed <> 1)
AND ScheduleItems.Deleted <> 1
AND (ScheduleItems.Progress_Note = 'No')
AND ScheduleItems.Missed = 'No'
AND ScheduleItems.Visit_Date <= NOW()
AND ScheduleItems.Employee_ID = Employee.Employee_ID
AND ScheduleItems.Employee_ID = '#session.EmployeeId#'
AND
(
patient.Employee_ID = '#session.EmployeeID#'
OR
'#session.EmployeeId#'
IN (
select distinct employee_id from #Request.prefix_db_agency#.ScheduleItems where patient_id = patient.Patient_Id and deleted <> 1
)
)
ORDER BY ScheduleItems.Visit_Date ASC, Employee.Last_Name ASC, Employee.First_Name ASC, patient.Last_Name_M0040 ASC, ScheduleItems.Visit_Type ASC