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 LIKE '%Identified%' HHA System Administration Superadmin Home | New Coding Request | Back

Coding Tracking List
Back

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 Identified the
source of Pain		 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")#