HHA System Administration

SELECT e.*, a.Agency_Name, p.Last_Name_M0040, p.First_Name_M0040 FROM #Request.prefix_db_agency#.Eligibility e, #Request.prefix_db_agency#.patient p, #Request.prefix_db_lookup#.Agency a Where e.Verification_Date = '2013-01-01' and e.Patient_ID = p.Patient_ID and a.Agency_ID = p.Agency_ID and e.Start_Date = '2013-01-01' and e.Expiration_Date = '2013-01-01'' SELECT e.Agency_ID, e.First_Name, e.Email FROM #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_lookup#.cron_GetTotals c, #Request.prefix_db_agency#.employee_auth ea, #Request.prefix_db_lookup#.Agency a where e.Agency_ID = c.NumField3 and e.Agency_ID = a.Agency_ID and e.Employee_ID = ea.eaID and e.Status = 'active' and e.Email <> '' and (ea.eaRole like '%billing%' or ea.eaRole like '%project%') and a.BillingSvcs = 0 group by e.Email HHA System Administration Superadmin Home

Elgibilities to Verify Today

Agency Name	Last Name	First Name	Update
#Agency_Name#	#Last_Name_M0040#	#First_Name_M0040#	Mark Resolved