SELECT Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, Employee.Email, Employee.Status, Employee.Cell_Phone, Employee.Agency_ID, Agency.Agency_Name,
Agency.Agency_Contact_Phone, Agency.D_Order_TA
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_auth.eaRole like '%project%'
and Employee.Status = 'active'
and Employee.Password != ''
AND Employee.EmployeeType = 'Employee'
ORDER BY Agency.Agency_Name ASC, Employee.Agency_ID, Employee.Last_Name
HHA System Administration
SELECT * FROM #Request.prefix_db_agency#.Homework
Where Homework.Agency_ID = #Agency_ID#
AND Homework.Employee = #Employee_ID#
AND (Homework.TheirNotes like '%Portal%')
ORDER BY Homework.DateCreated DESC limit 1
SELECT * FROM #Request.prefix_db_lookup#.Training_Log
Where Training_Log.Agency_ID = #Agency_ID#
AND Training_Log.Employee = #Employee_ID#
AND (Training_Log.Train_Step like '%portal%')
ORDER BY Training_Log.Train_Date DESC limit 1