UPDATE IGNORE #Request.prefix_db_lookup#.Coding_Request
SET Assigned_to = '#url.assignee#',
Updated_by = '#Session.MM_USID#'
where ID = '#url.coding_id#'
SELECT * FROM #Request.prefix_db_lookup#.Coding_Request
JOIN #Request.prefix_db_lookup#.Agency on Agency.Agency_ID = Coding_Request.Agency_ID
Where Coding_Request.Deleted <> 1
and Coding_Request.Coding_status != 'Complete'
AND (message_indicate NOT LIKE '%Identified%' OR message_indicate is null)
AND Coding_Request.Agency_ID = #url.AID#
-- AND YEAR(Coding_Request.Request_Date) = YEAR(CURRENT_DATE)
-- AND (MONTH(Coding_Request.Request_Date) >= MONTH(CURRENT_DATE - INTERVAL 1 MONTH))
AND Coding_Request.Request_Date >= now() - INTERVAL 2 month
ORDER BY Coding_Request.Created_Date DESC
coding_track = CreateObject("Component", "coding");
tab1 = coding_track.GetpowerpathRequests(1,#url.AID#);
hpreview = coding_track.GetpowerpathRequests('H_P_Review',#url.AID#);
billings = coding_track.GetpowerpathRequests('billings',#url.AID#);
codingdelay = coding_track.GetpowerpathRequests('codingdelay',#url.AID#);
hpdelay = coding_track.GetpowerpathRequests('hpdelay',#url.AID#);
SELECT count(*) as reccount,MHCB_Entered,IFNULL(SUM(TIME_TO_SEC(TIMEDIFF(now(),MHCB_Entered))),0) as avg_elapse1,Request_Date,Request_Time,
requested_logged_elapsed ,MHCB_Entered,
IFNULL(SUM(ABS(TIME_TO_SEC(TIMEDIFF(MHCB_Entered,(TIMESTAMP(Request_Date,Request_Time)))))),0) as avg_elapse2 FROM #Request.prefix_db_lookup#.Coding_Request
WHERE Coding_Request.Deleted <> 1
AND Coding_Request.Coding_status != 'Complete' AND Coding_status like 'coding'
AND Coding_Request.Request_Date >= now() - INTERVAL 3 month
ORDER BY ID DESC
HHA System Administration
