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, Agency.Agency_Login, Agency.Agency_Medicare_ID, Agency.Agency_Contact_Phone, Agency.Avg5Star_DC
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.Employee_ID = employee_auth.eaID
and employee_auth.eaRole like '%project%'
and Employee.Status = 'active'
AND Employee.EmployeeType = 'Employee'
ORDER BY Agency.Agency_Name ASC, Employee.Agency_ID, Employee.Last_Name
HHA System Administration
GET ENDORSEMENTS #today#
#Agency_Name# #Agency_Login# #Agency_Contact#
SELECT * FROM #Request.prefix_db_agency#.Homework
Where Homework.Agency_ID = #Agency_ID#
AND Homework.Employee = #Employee_ID#
AND (Homework.TheirNotes like '%endorse%')
ORDER BY Homework.DateCreated DESC limit 1
SELECT * FROM #Request.prefix_db_lookup#.CMS_Outcomes
Where CMS_Outcomes.CCN = '#GetEmps.Agency_Medicare_ID#'