SELECT Agency.* FROM #Request.prefix_db_lookup#.Agency WHERE Agency.Status = 'active' ORDER BY Agency.OMWorse DESC SELECT Agency.* FROM #Request.prefix_db_lookup#.Agency WHERE Agency.Status = 'active' SELECT a.Agency_ID,a.Agency_Name, a.Agency_Login, a.Agency_Contact, a.Agency_Contact_Phone, a.Agency_Contact_Email, c.TextField1, c.TextField51 FROM #Request.prefix_db_lookup#.Agency a, #Request.prefix_db_lookup#.cron_AgencyUse c where a.Agency_ID = c.NumField1 AND a.status = 'active' AND c.TextField2 = 'Agency' AND DATEDIFF(Now(),c.TextField1) <= 7 and c.TextField51 is not null GROUP by c.TextField1 Order by c.TextField1 HHA System Administration

Active Agency Outcome Measures

Agency Contact Phone Email Worse Same Better
#Agency_Name# #Agency_Contact# #Agency_Contact_Phone# #Agency_Contact_Email# #OMWorse# #OMSame# #OMBetter#
> SELECT c.TextField1, c.TextField51 FROM #Request.prefix_db_lookup#.cron_AgencyUse c where c.NumField1 = #Agency_ID# AND c.TextField2 = 'Agency' AND DATEDIFF(Now(),c.TextField1) <= 7 and c.TextField51 is not null Order by c.TextField1

Total Users

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

Total Active Users: #GetEmps.RecordCount#

--->
Agency Login Contact Phone Email #DateFormat(TextField1,"yyyy-mm-dd")#
#Agency_Name# #Agency_Login# #Agency_Contact# #Agency_Contact_Phone# #Agency_Contact_Email# #TextField51#