SELECT *
FROM #Request.prefix_db_agency#.Event
WHERE Event_ID = #url.ID#
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 Patient_ID, Last_Name_M0040, First_Name_M0040
FROM #Request.prefix_db_agency#.patient
WHERE Patient_ID = #GetEvent.Patient_ID#
AND Status = 'active'
SELECT EventSub_ID, Subject
FROM #Request.prefix_db_agency#.EventSubjects
WHERE Agency_ID = #session.AgencyID#
ORDER BY Subject
New Incident
#GetPa.Last_Name_M0040#, #GetPa.First_Name_M0040# - Update Event
