SELECT *,now() as time_now,datediff(Request_Date,MHCB_Entered) as elspse FROM #Request.prefix_db_lookup#.Coding_Request JOIN #Request.prefix_db_lookup#.Agency on Agency.Agency_ID = Coding_Request.Agency_ID JOIN #Request.prefix_db_lookup#.SuperUsers on SuperUsers.User_ID = Coding_Request.Updated_by Where Coding_Request.Deleted <> 1 and Coding_Request.Coding_status != 'Complete' AND Coding_Request.Coding_status != 'completed_send_1st_approval' -- AND (message_indicate NOT LIKE '%Identified%' OR message_indicate is null) -- AND (MONTH(Coding_Request.Request_Date) >= MONTH(CURRENT_DATE - INTERVAL 1 MONTH)) AND Coding_Request.Request_Date >= now() - INTERVAL 3 month AND Coding_Request.Agency_ID = AND Coding_Request.Request_Date BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# ORDER BY Coding_Request.Created_Date DESC SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Status = 'active' AND Coding_Wizard = 1 ORDER BY Agency_Name ASC coding_track = CreateObject("Component", "coding"); getcodingstatus =coding_track.get_codingstatus(0);
HHA System Administration
ALL requested
Back coding tracking list
" /> to " />
Date Format: mm/dd/yyyy
Patient Name Assessment Type Current Status Requested Date/Time Logged Elapsed Coding Completed Elapsed update EMR Elapsed 1st reports sent Elapsed Approval received Elapsed Completed Review Elapsed 485 updated Elapsed Finals sent Elapsed
#Left(Assessment_Type,10)#
#getcodingstatus.description#
#DATEFORMAT(MHCB_Entered,"mm/dd/yy")# - #TimeFormat(MHCB_Entered)#
#requested_logged_elapsed#
#DATEFORMAT(completed_coding,"mm/dd/yy")#
#completed_coding_elapsed#
#DATEFORMAT(completed_oasis,"mm/dd/yy")#
#completed_oasis_elapsed#
#DATEFORMAT(completed_1st_message_send,"mm/dd/yy")#
#completed_1st_message_send_elapsed#
#DATEFORMAT(approval_received,"mm/dd/yy")#
#approval_received_elapsed#
#DATEFORMAT(completed_OASIS_review,"mm/dd/yy")#
#completed_OASIS_review_elapsed#
#DATEFORMAT(completed_485_update,"mm/dd/yy")#
#completed_485_update_elapsed#
#DATEFORMAT(completed_final_send,"mm/dd/yy")#
#completed_final_send_elapsed#
There are no records