SELECT e.*, employee_auth.eaRole, employee_auth.eaType, Agency.Agency_Name
FROM #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_lookup#.Agency, #Request.prefix_db_agency#.employee_auth
WHERE e.Agency_ID = Agency.Agency_ID
and e.Employee_ID = employee_auth.eaID
AND Agency.Status = 'active'
AND e.Status = 'active'
AND e.Password is not null
AND e.Password != ''
AND e.M0104 != 0
AND e.M0104 != ''
AND e.EmployeeType = 'Employee'
ORDER BY Agency.Agency_Name ASC, e.Agency_ID, e.Last_Name
HHA System Administration