SELECT Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, Employee.Email, Employee.Agency_ID, Agency.Agency_Name,
Agency.PPInUse, Agency.QBInUse, Agency.PatientFileManagerInUse, Agency.telephony, Agency.BillingSvcs, Agency.CodingSvcs,
Employee.Username, Employee.Password, employee_auth.eaRole, employee_auth.eaType
FROM #Request.prefix_db_lookup#.Employee, #Request.prefix_db_lookup#.Agency, #Request.prefix_db_agency#.employee_auth
WHERE Employee.Agency_ID = Agency.Agency_ID
and Employee.Employee_ID = employee_auth.eaID
AND Agency.Status = 'active'
AND Employee.Status = 'active'
AND Employee.Password is not null
AND Employee.Password != ''
AND Employee.EmployeeType = 'Employee'
ORDER BY Agency.Agency_Name ASC, Employee.Agency_ID, Employee.Last_Name
HHA System Administration