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 (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)) coding_track = CreateObject("Component", "coding"); get_users = coding_track.get_coding_users(); HHA System Administration Superadmin Home | New Coding Request | Back

Coding Tracking List

CR means Coding Report   CP means Careplan   TP means Teaching Plan  

Requested Last First Type Date Agency EMR Login Contacts Assigned to Coding Status             Reports to Upload Send Memo
to Agency
Patient Notes Agency Notes Completed
#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)#
#DATEFORMAT(Completed_Date,"mm/dd/yy")#
> Request Date Last Name First Name Assessment Type Assessment Date Agency Name Agency Assigned to Coding Status    Reports to Upload Patient Notes Agency Notes Completed Date
#Last_Name#
#First_Name#
#Assessment_Type#
#DATEFORMAT(Assessment_Date,"mm/dd/yy")#
#Agency_Name#
#Agency_Login#
CR-Coding Report, CP-Careplan,TP-Teaching Plan,CODE-Do Coding
#Left(Notes,30)#
#Left(Coding_request_Note,30)#
#DATEFORMAT(Completed_Date,"mm/dd/yy")#
There is no records
--->