Unresolved Incidents Log

Resolved Incidents Log

 SELECT Event.Event_ID, Event.EventSub_ID, Event.Event_Date ,EventSubjects.EventSub_ID, EventSubjects.Subject, Event.Resolved ,patient.Last_Name_M0040, patient.First_Name_M0040 ,Employee.Employee_ID, Employee.Last_Name, Employee.First_Name FROM #Request.prefix_db_agency#.Event,#Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.EventSubjects WHERE Event.Agency_ID = '#session.AgencyID#' AND Event.Resolved = '#url.res#' AND Employee.Employee_ID = Event.Employee_ID AND patient.Patient_ID = Event.Patient_ID AND EventSubjects.EventSub_ID = Event.EventSub_ID ORDER BY Event.Event_Date DESC
No UnresolvedResolved Incident Reports were found
Date Employee Patient Subject Action
#DateFormat(e.Event_Date,"mm/dd/yyyy")# #e.Last_Name#, #e.First_Name# #e.Last_Name_M0040#, #e.First_Name_M0040# #Subject#   Edit | Print