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

Active Employee Process Outcomes

Agency

Last, First

M0104

M1041

M1051

M1510

M2250_b

M2250_e

M2250_f

M2250_g

M2300_1

M2410_1

M2420

#Left(Agency_Name,25)#

#Last_Name#, #Left(First_Name,1)#

#M0104#

#M1041#

#M1051#

#M1510#

#M2250_b#

#M2250_e#

#M2250_f#

#M2250_g#

#M2300_1#

#M2410_1#

#M2420#

Total Users

#total_emps# - #Agency_ID# #Agency_Name# Portal QB Scanning Telephony Billing Coding

Total Active Users: #GetEmps.RecordCount#

--->