SELECT Agency_Name
FROM #Request.prefix_db_lookup#.Agency
WHERE Agency_ID = #url.ID#
SELECT e.Employee_ID, e.Agency_ID, e.Last_Name, e.First_Name, e.Email, ea.eaRole
FROM #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_agency#.employee_auth ea
WHERE e.Agency_ID = #url.ID#
and e.Employee_ID = ea.eaID
AND e.EmployeeType != 'Physician'
AND ea.eaRole like '%Project Manager%'
AND e.Status = 'active'
SELECT e.Employee_ID, e.Last_Name, e.First_Name, e.Email, ea.eaRole, e.SendCrons
FROM #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_agency#.employee_auth ea
WHERE e.Agency_ID = #url.ID#
and e.Employee_ID = ea.eaID
AND e.EmployeeType != 'Physician'
AND e.Status = 'active'
order by e.Last_Name, e.First_Name
HHA System Administration -