UPDATE IGNORE #Request.prefix_db_lookup#.Coding_Request SET Coding_status = '#url.status#', Completed_Date = '#DATEFORMAT(now(),"yy-mm-dd")#', Updated_by = '#Session.MM_USID#' where ID = '#url.coding_id#' 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)) 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'); GetwaitingRequest = coding_track.GetCodingRequest(1); get_error = coding_track.GetCodingRequest(2); get_other = coding_track.GetCodingRequest(3); HHA System Administration


Superadmin Home | New Coding Request | Back

#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
Coding Tracking List
Back

Requested Last First Type Date Agency EMR Login Contacts Assigned to Coding Status             Reports to Upload Send Memo
to Agency		 Patient Notes Agency Notes
#Last_Name#
#First_Name#
#Left(Assessment_Type,10)#
#DATEFORMAT(Assessment_Date,"mm/dd/yy")#
#Left(Agency_Name,10)#
#EMR_software#
#Agency_Login#
#Coding_contacts#
CR, CP, TP, Do Coding
YES
#Left(Notes,30)#
#Left(Coding_request_Note,30)#
There are no records
Requested Last First Type Date Agency EMR Login Contacts Assigned to Coding Status             Reports to Upload Send Memo
to Agency		 Patient Notes Agency Notes
#Last_Name#
#First_Name#
#Left(Assessment_Type,10)#
#DATEFORMAT(Assessment_Date,"mm/dd/yy")#
#Left(Agency_Name,10)#
#EMR_software#
#Agency_Login#
#Coding_contacts#
CR, CP, TP, Do Coding
YES
#Left(Notes,30)#
#Left(Coding_request_Note,30)#
Requested Last First Type Date Agency EMR Login Contacts Assigned to Coding Status             Reports to Upload Send Memo
to Agency		 Patient Notes Agency Notes
#Last_Name#
#First_Name#
#Left(Assessment_Type,10)#
#DATEFORMAT(Assessment_Date,"mm/dd/yy")#
#Left(Agency_Name,10)#
#EMR_software#
#Agency_Login#
#Coding_contacts#
CR, CP, TP, Do Coding
YES
#Left(Notes,30)#
#Left(Coding_request_Note,30)#