SELECT Event.Event_ID, Event.EventSub_ID, Event.Event_Date, Event.Patient_ID, pPatients.Pt_Last, pEmployee.Emp_ID, pEmployee.Emp_Last, EventSubjects.EventSub_ID, EventSubjects.Subject,Event.Resolved,Event_to.Date_Sent,pPatients.Pt_First,pPatients.Patient_ID FROM #Request.prefix_db_agency#.Event LEFT OUTER JOIN #Request.prefix_db_agency#.Event_to ON Event_to.Event_ID = Event.Event_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = Event_to.Emp_ID JOIN #Request.prefix_db_agency#.pPatients ON Event.Patient_ID = pPatients.Patient_ID AND pPatients.status IN (0,1,4) JOIN #Request.prefix_db_agency#.EventSubjects ON Event.EventSub_ID = EventSubjects.EventSub_ID WHERE Event.Agency_ID = #session.AgencyID# And Event.Resolved = '#url.res#' AND Event.EventSub_ID = #form.EventSub_ID# AND Event.status = 0 AND Event.Event_Date BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND Event_to.Emp_ID = '#session.EmployeeId#' ORDER BY Event_Date DESC, Event.Event_ID SELECT EventSub_ID, Subject FROM #Request.prefix_db_agency#.EventSubjects WHERE Agency_ID = #session.AgencyID# ORDER BY Subject
Unresolved Incident Log Resolved Incident Log
to
Date Format: mm/dd/yyyy
Unresolved Incident Log Resolved Incident Log
New Incident Resolved Incident Log Un-Resolved Incident Log Print Incident History Print Incident History Print Incident History
Date Patient Employee Subject Physician Fax Date Print
#DateFormat(GetEvent.Event_Date,"mm/dd/yyyy")# #GetEvent.Pt_Last#, #GetEvent.Pt_First# #GetEvent.Emp_Last#
 #Subject# #DateFormat(GetEvent.Date_Sent,"mm/dd/yyyy")# Print
Unresolved Incident Log Resolved Incident Log
New Incident Resolved Incident Log Un-Resolved Incident Log Print Incident History Print Incident History Print Incident History
Date Patient Employee Subject Print
No data was found. Please try a different search.