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 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 AND Coding_Request.Agency_ID = ORDER BY Coding_Request.Created_Date DESC coding_track = CreateObject("Component", "coding"); today_completed_list = coding_track.getCompletdcount('today'); yesterday_completed_list = coding_track.getCompletdcount('yesterday'); sevendays_completed_list = coding_track.getCompletdcount('sevendays'); tab1 = coding_track.GetCodingRequests(1); tab2 = coding_track.GetCodingRequests(2); tabuploadEMR = coding_track.GetCodingRequests('uploadEMR'); tabcodingreview = coding_track.GetCodingRequests('codingreview'); tabinitialoasis = coding_track.GetCodingRequests('initialoasis'); tab3 = coding_track.GetCodingRequests(3); tab_Med_recon = coding_track.GetCodingRequests('Med_Recon'); tab4 = coding_track.GetCodingRequests(4); OASIS_Review = coding_track.GetCodingRequests('completed_OASIS_Review'); appro_received = coding_track.GetCodingRequests('approval_received'); tab5 = coding_track.GetCodingRequests(5); tab6 = coding_track.GetCodingRequests(6); tab7 = coding_track.GetCodingRequests(7); tab8 = coding_track.GetCodingRequests(8); tabcodingdelay = coding_track.GetCodingRequests('codingdelay'); taboasisdelay = coding_track.GetCodingRequests('oasisdelay'); tabsend1stapprovaldelay = coding_track.GetCodingRequests('send1stapprovaldelay'); taboasisreviewdelay = coding_track.GetCodingRequests('oasisreviewdelay'); tabupdateOASISdelay = coding_track.GetCodingRequests('updateOASISdelay'); tabupdate485delay = coding_track.GetCodingRequests('update485delay'); get_users = coding_track.get_coding_users(); getcodingstatus =coding_track.get_codingstatus(1); getcodingstatus2 =coding_track.get_codingstatus(2); getstat_uploadEMR = coding_track.get_codingstatus('uploadEMR'); getstat_codingreview = coding_track.get_codingstatus('codingreview'); getstat_initialoasis = coding_track.get_codingstatus('initialoasis'); getcodingstatus3 =coding_track.get_codingstatus(3); getcodingstatusMed_Recon =coding_track.get_codingstatus('Med_Recon'); getcodingstatus4 =coding_track.get_codingstatus(4); getOASIS_Review = coding_track.get_codingstatus('completed_OASIS_Review'); getapprov_received =coding_track.get_codingstatus('approval_received'); getcodingstatus5 =coding_track.get_codingstatus(5); getcodingstatus6 =coding_track.get_codingstatus(6); getcodingstatus7 =coding_track.get_codingstatus(7); getcodingstatus8 =coding_track.get_codingstatus(8); getcodingstatus9 =coding_track.get_codingstatus('codingdelay'); getcodingstatus10 =coding_track.get_codingstatus('oasisdelay'); getstat_send1stapprovaldelay =coding_track.get_codingstatus('send1stapprovaldelay'); getstat_oasisreviewdelay =coding_track.get_codingstatus('oasisreviewdelay'); getstat_updateOASISdelay =coding_track.get_codingstatus('updateOASISdelay'); getstat_update485delay =coding_track.get_codingstatus('update485delay'); SELECT * FROM Coding_Request WHERE Agency_ID = 1040 ORDER BY Created_Date DESC LIMIT 1 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

#today_completed_list.recordcount#

Coding Reports Completed Today

#yesterday_completed_list.recordcount#

Coding Reports Completed Yesterday

#NumberFormat(average_days)#

Coding Reports Completed 7 Day Average


Home | New Coding Request | Back | Log Out
Coding Tracking List
Back Request All Download Account list

    Process 3 | Process 4 | Process 5 | If patient receives PT and/or OT after approval, add 'gross motor' teaching for PT, 'fine motor' teaching for OT