SELECT Employee_Id, First_Name, Last_Name FROM #Request.prefix_db_lookup#.Employee WHERE Agency_Id = '#session.AgencyId#' AND Status = 'active' AND EmployeeType != 'Physician' ORDER BY Last_Name SELECT Patient_Id, Last_Name_M0040, First_Name_M0040 FROM #Request.prefix_db_agency#.patient WHERE Agency_Id = '#session.AgencyId#' AND Status = 'active' ORDER BY Last_Name_M0040 SELECT Agency_Name, Agency_ID, ExportData, Agency_Contact_Email, TimeZone FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.AgencyID#'
#agency.Agency_name# Time & Attendance
Back
SELECT t.telephony_input_id, p.Patient_id, si.Visit_Date, p.last_name_m0040 as lastname, p.first_name_m0040 as firstname, si.Visit_Type, DATE_FORMAT(t.call_date,'%Y-%m-%d') as call_date, DATE_FORMAT(t.call_date,'%r') as call_time, t.call_type, t.call_telephonyid, e.last_name as emp_lastname, e.first_name as emp_firstname, t.call_callerid, replace(p.telephone, '-', '') as patient_tel, CASE WHEN t.call_callerid = replace(p.telephone, '-', '') THEN 1 ELSE 0 END as CalledFromPatient, CASE Lower(t.call_type) WHEN 'login' THEN si.StartTime WHEN 'logout' THEN si.EndTime ELSE si.EndTime END as sched_times, si.ScheduleItems_ID as si_id, a.telephony, si.Agency_ID FROM #Request.prefix_db_agency#.telephony_input t LEFT JOIN #Request.prefix_db_agency#.ScheduleItems si ON si.Telephony_ID = t.call_telephonyid LEFT JOIN #Request.prefix_db_agency#.patient p ON p.Patient_id = si.Patient_id LEFT JOIN #Request.prefix_db_lookup#.Employee e on si.Employee_ID = e.Employee_ID LEFT JOIN #Request.prefix_db_lookup#.Agency a on a.Agency_ID = t.agency_id WHERE t.agency_id = #session.AgencyID# AND call_date IS NOT NULL AND si.Telephony_Yes = 1 AND si.StartTime IS NOT NULL AND si.Deleted = 0 AND si.EndTime IS NOT NULL ORDER BY si.Visit_Date ASC, si.StartTime ASC SELECT t.telephony_input_id, p.Patient_id, si.Visit_Date, p.last_name_m0040 as lastname, p.first_name_m0040 as firstname, si.Visit_Type, DATE_FORMAT(t.call_date,'%Y-%m-%d') as call_date, DATE_FORMAT(t.call_date,'%r') as call_time, t.call_type, t.call_telephonyid, e.last_name as emp_lastname, e.first_name as emp_firstname, t.call_callerid, replace(p.telephone, '-', '') as patient_tel, CASE WHEN t.call_callerid = replace(p.telephone, '-', '') THEN 1 ELSE 0 END as CalledFromPatient, CASE Lower(t.call_type) WHEN 'login' THEN si.StartTime WHEN 'logout' THEN si.EndTime ELSE si.EndTime END as sched_times, si.ScheduleItems_ID as si_id, a.telephony, si.Agency_ID FROM #Request.prefix_db_agency#.telephony_input t LEFT JOIN #Request.prefix_db_agency#.ScheduleItems si ON si.Telephony_ID = t.call_telephonyid LEFT JOIN #Request.prefix_db_agency#.patient p ON p.Patient_id = si.Patient_id LEFT JOIN #Request.prefix_db_lookup#.Employee e on si.Employee_ID = e.Employee_ID LEFT JOIN #Request.prefix_db_lookup#.Agency a on a.Agency_ID = t.agency_id WHERE t.agency_id = #session.AgencyID# AND (si.Employee_ID = #form.Employee_ID# OR 0 = #form.Employee_ID#) AND (p.Patient_id = #form.Patient_ID# OR 0 = #form.Patient_ID#) AND si.Visit_Date BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND call_date IS NOT NULL AND si.Telephony_Yes = 1 AND si.StartTime IS NOT NULL AND si.EndTime IS NOT NULL AND si.Deleted = 0 ORDER BY si.Visit_Date ASC, e.Employee_Id, si.StartTime ASC

Create Incident Report  |  Create Communication Memo  |  Current Time & Attendance

Red Flag   Visit Date is incorrect OR Duration is > 15 minutes over the expected duration OR Arrived at least 15 minutes late OR Employee did not call from Patient's home

Date Format: mm/dd/yyyy
Date Format: mm/dd/yyyy
     



No data was found. Please try a different search.

Records
)>
Date Patient Type of Visit Employee Caller ID Actual Start Actual End Results
#DateFormat(Visit_Date, "YYYY-mm-dd")# #lastname#, #firstname# #Visit_Type# #emp_lastname#, #emp_firstname# #call_callerid# #NewTime# #NewTime# Print Print