SELECT Employee.Employee_ID, Last_Name, First_Name, Password
FROM #Request.prefix_db_lookup#.Employee
WHERE Employee.Agency_ID = #session.AgencyID#
AND Employee.status = '#url.status#'
AND Employee.EmployeeType != 'Physician'
and Employee.Password <> ''
ORDER BY Last_Name