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 CommSub_ID, Subject
FROM #Request.prefix_db_agency#.CommunicationSubjects
WHERE Agency_ID = #session.AgencyID#
ORDER BY Subject
StatusLists=StructNew();
StatusLists["Yes"] = "Resolved";
StatusLists["No"] = "Unresolved";
StatusLists["All"] = "All";
Communication Report #Form.From_Date# to #Form.To_Date#