SELECT patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, patient.Patient_ID ,ScheduleItems.Visit_Date, ScheduleItems.Telephony_ID, ScheduleItems.ScheduleItems_ID, ScheduleItems.Telephony_Yes ,ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.EndTime, ScheduleItems.Visit_Type ,Employee.Employee_ID, Employee.Last_Name AS Last, Employee.First_Name AS First, Employee.Home_Phone, Employee.Cell_Phone ,Agency.Agency_ID, Agency.Telephony, Agency.timezone FROM #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.patient, #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_lookup#.Agency WHERE ScheduleItems.Agency_ID = '#session.AgencyID#' AND ScheduleItems.Telephony_Yes <> 0 AND ScheduleItems.Deleted = 0 AND ScheduleItems.Visit_Date <= NOW() AND ScheduleItems.Visit_Date BETWEEN #daterange# AND NOW() AND Assessment_New.Assessment_Tracker_ID = ScheduleItems.Assessment_Tracker_ID AND patient.Patient_ID = ScheduleItems.Patient_ID AND (Assessment_New.Deleted IS Null OR Assessment_New.Deleted = '0') AND (Assessment_New.Archive IS Null OR Assessment_New.Archive = '0') AND Employee.Employee_ID = ScheduleItems.Employee_ID AND Agency.Agency_ID = '#session.AgencyID#' AND NOT EXISTS ( SELECT telephony_input.call_telephonyid FROM #Request.prefix_db_agency#.telephony_input WHERE telephony_input.call_telephonyid = ScheduleItems.Telephony_ID ) ORDER BY ScheduleItems.Visit_Date DESC, ScheduleItems.StartTime, patient.Last_Name_M0040
Employees Not Arrived at Scheduled Visits Last 7 Days...
Telephony Log Limit to Last 7 Days View ALL Non-Arrival Info Current Date / Time is #DateFormat(myDateTime, 'mm/dd/yyyy')# #TimeFormat(myDateTime, 'HH:mm:ss')#
Responsive Flip Scroll Tables
Patient Visit Date Visit Type Employee Sched Start Sched End Empl Home Ph Empl Cell Ph
#PatientLast#, #PatientFirst# #DateFormat(Visit_Date, "mm/dd/yyyy")# #Visit_Type# #Last#, #First#
#TimeFormat(StartTime, "hh:mm:ss tt")#
#TimeFormat(EndTime, "hh:mm:ss tt")#
#Home_Phone#
#Cell_Phone#

All visits requiring login via telephony have been logged.