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, Employee.Username, Employee.Password, cron_AgencyUse.TextField11, cron_AgencyUse.TextField13
FROM #Request.prefix_db_lookup#.Employee, #Request.prefix_db_lookup#.Agency, #Request.prefix_db_lookup#.cron_AgencyUse
WHERE Employee.Agency_ID = Agency.Agency_ID
and Employee.Employee_ID = cron_AgencyUse.NumField3
AND Agency.Status = 'active'
AND Employee.EmployeeType = 'Employee'
and cron_AgencyUse.TextField1 = '#today#'
and cron_AgencyUse.TextField11 != ''
ORDER BY Agency.Agency_Name ASC, Employee.Agency_ID, Employee.Last_Name
HHA System Administration
CLINICAL TRAINING #today#
#Agency_Name#
SELECT * FROM #Request.prefix_db_agency#.Homework
Where Homework.Agency_ID = #Agency_ID#
AND Homework.Employee = #Employee_ID#
ORDER BY Homework.DateCreated DESC limit 1
SELECT * FROM #Request.prefix_db_agency#.Homework
Where Homework.Agency_ID = #Agency_ID#
AND Homework.Employee = #Employee_ID#
AND (Homework.TheirNotes like '%admin%')
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#
ORDER BY Training_Log.Train_Date DESC limit 1