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 Coding_Request.Completed_Date = '#DATEFORMAT(now(),"yy-mm-dd")#' AND Coding_Request.Completed_Date = '#DATEFORMAT(yesterday,"yy-mm-dd")#' AND Coding_Request.Completed_Date < '#DATEFORMAT(now(),"yy-mm-dd")#' AND Coding_Request.Completed_Date >= '#DATEFORMAT(sevenday,"yy-mm-dd")#' ORDER BY Coding_Request.Created_Date DESC SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Natl_Provider_ID = '#Natl_Provider_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 3 month AND Coding_status like '%waiting%' AND Coding_status like '%Error%' or Coding_status like '%Unable%' AND Coding_status NOT like '%Error%' AND Coding_status NOT like '%waiting%' and Coding_status NOT like '%Unable%' ORDER BY Coding_Request.Created_Date DESC 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 (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 3 month AND (Coding_status like 'coding' OR Coding_status like 'completed_H_P_Review' ) AND (Coding_status like 'completed_EMR_update' OR Coding_status like 'waiting_for_OASIS') AND (Coding_status like 'completed_coding' ) AND (Coding_status like 'completed_OASIS' OR Coding_status like 'coding_review' ) AND (Coding_status like 'completed_coding_review' ) AND (Coding_status like 'completed_initial_OASIS_review' ) AND ( Coding_status like 'Waiting_for_PT_OT_Eval' OR Coding_status like 'completed_update_485') AND ( Coding_status like 'completed_send_1st_approval') AND (Coding_status like 'completed_Med_Recon' ) AND ( Coding_status like 'approval_received' ) AND (Coding_status like 'completed_1st_approval' OR Coding_status like 'completed_OASIS_Review' ) AND ( Coding_status like 'approval_received') AND (Coding_status like 'completed_update_OASIS' ) AND (Coding_status like 'completed_final_reports_send' ) AND (Coding_status like 'error' OR Coding_status like 'unable_to_complete' ) AND (Coding_status like 'unable_to_complete_coding') AND (Coding_status like 'unable_to_complete_H_P_Review') AND (Coding_status like 'unable_to_complete_OASIS' ) AND (Coding_status like 'unable_to_send_1st_approval' ) AND (Coding_status like 'unable_to_complete_OASIS_Review' ) AND (Coding_status like 'unable_to_update_OASIS' ) AND (Coding_status like 'unable_to_update_485' ) AND (Coding_status = 'Medication_Review' ) AND (Coding_status like 'H_P_Review' OR Coding_status like 'completed_Med_Review' ) ORDER BY Coding_Request.Created_Date DESC 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 LEFT OUTER JOIN #Request.prefix_db_lookup#.SuperUsers on SuperUsers.User_ID = Coding_Request.Updated_by LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee on pEmployee.Emp_ID = Coding_Request.Updated_by Where Coding_Request.Deleted <> 1 and Coding_Request.Coding_status != 'Complete' AND Coding_Request.Agency_ID = '#arguments.Agency_ID#' AND Agency.svc_coding = 1 AND Agency.Status = 'active' -- 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 3 month AND ((svc_soc = 1 AND LEFT(Assessment_Type,1) = '1') OR (svc_resumption = 1 AND LEFT(Assessment_Type,1) = '3') OR (svc_recertification = 1 AND LEFT(Assessment_Type,1) = '4')) AND (Assessment_Type like '1%' OR Assessment_Type like '3%' OR Assessment_Type like '4%') AND Agency.svc_eligibility = 1 AND Agency.svc_authorization = 1 AND Agency.svc_intake_dataentry = 1 AND Agency.svc_QA = 1 AND Agency.meds_dataentry = 1 AND (Coding_status like 'coding') AND (Coding_status like 'completed_EMR_update' OR Coding_status like 'waiting_for_OASIS') AND (Coding_status like 'completed_coding' ) AND (Coding_status like 'completed_OASIS' OR Coding_status like 'coding_review' ) AND (Coding_status like 'completed_coding_review' ) AND (Coding_status like 'completed_initial_OASIS_review' ) AND ( Coding_status like 'Waiting_for_PT_OT_Eval' OR Coding_status like 'completed_update_485') AND ( Coding_status like 'completed_send_1st_approval') AND (Coding_status like 'completed_Med_Recon' ) AND ( Coding_status like 'approval_received' ) AND (Coding_status like 'completed_1st_approval' OR Coding_status like 'completed_OASIS_Review' ) AND ( Coding_status like 'approval_received') AND (Coding_status like 'completed_update_OASIS' ) AND (Coding_status like 'completed_final_reports_send' ) AND (Coding_status like 'error' OR Coding_status like 'unable_to_complete' ) AND (Coding_status like 'unable_to_complete_coding') AND (Coding_status like 'unable_to_complete_H_P_Review') AND (Coding_status like 'unable_to_complete_OASIS' ) AND (Coding_status like 'unable_to_send_1st_approval' ) AND (Coding_status like 'unable_to_complete_OASIS_Review' ) AND (Coding_status like 'unable_to_update_OASIS' ) AND (Coding_status like 'unable_to_update_485' ) AND (Coding_status = 'Medication_Review' ) AND (Coding_status = 'meds_dataentry' ) AND (Coding_status = 'unable_to_complete_meds_dataentry' ) AND (Coding_status like 'H_P_Review' OR Coding_status like 'completed_Med_Review' OR Coding_status like 'completed_meds_dataentry' ) AND (Coding_status like 'eligibility' ) AND ( Coding_status like 'unable_to_complete_eligibility') AND ( Coding_status like 'unable_to_complete_authorization') AND (Coding_status like 'authorization' OR Coding_status like 'Authorization_Required' OR Coding_status like 'completed_eligibility_require_auth' ) AND (Coding_status like 'intake_dataentry' OR Coding_status like 'intake_dataentry_transition') AND (Coding_status like 'unable_to_complete_intake_dataentry' ) AND (Coding_status like 'unable_to_complete_intake_dataentry_transition' ) ORDER BY Coding_Request.Created_Date DESC SELECT * FROM #Request.prefix_db_lookup#.codingusers_lookup WHERE deleted <> 1 ORDER BY name ASC SELECT * FROM #Request.prefix_db_lookup#.cod_status_lookup WHERE deleted <> 1 AND ( status like 'coding' OR status like 'completed_coding' ) AND ( status like 'H_P_Review' OR status like 'completed_H_P_Review' ) AND ( status like 'eligibility' OR status like 'completed_eligibility' OR status like 'completed_eligibility_require_auth' OR status like 'Authorization_Required' OR status like 'unable_to_complete_eligibility') AND ( status like 'authorization' OR status like 'unable_to_complete_authorization' OR status like 'completed_authorization' ) AND (status like 'completed_coding' OR status like 'unable_to_complete_coding') AND ( status like 'completed_EMR_update') AND ( status like 'completed_OASIS' OR status like 'unable_to_complete_OASIS') AND (status like 'completed_coding_review') AND ( status like 'completed_initial_OASIS_review') AND (status like 'completed_send_1st_approval' OR status like 'unable_to_send_1st_approval') AND (status like 'completed_OASIS_Review' OR status like 'unable_to_complete_OASIS_Review') AND (status like 'completed_Med_Recon') AND (status like 'approval_received') AND (status like 'approval_received' OR status like 'error' OR status like 'unable_to_complete') AND (status like 'completed_update_OASIS' OR status like 'unable_to_update_OASIS') AND (status like 'completed_update_485' OR status like 'unable_to_update_485') AND (status like 'completed_final_reports_send' OR status like 'error') AND (status like 'completed_final_reports_send' OR status like 'error' OR status like 'unable_to_complete') AND ( status like 'completed_OASIS' OR status like 'unable_to_complete_OASIS') AND ( status like 'completed_OASIS_Review' OR status like 'unable_to_complete_OASIS_Review') AND ( status like 'completed_update_OASIS' OR status like 'unable_to_update_OASIS') AND ( status like 'completed_update_485' OR status like 'unable_to_update_485') AND ( status like 'completed_Med_Review' OR status like 'unable_to_complete_Med_Review') AND ( status like 'completed_H_P_Review' OR status like 'unable_to_complete_H_P_Review') ORDER BY list_order ASC UPDATE #Request.prefix_db_lookup#.Coding_Request SET Coding_status = , completed_coding = #now()# , unable_to_complete_coding = #now()# , completed_H_P_Review = #now()# , unable_to_complete_H_P_Review = #now()# , completed_eligibility = #now()# , unable_to_complete_eligibility = #now()# , completed_authorization = #now()# , unable_to_complete_authorization = #now()# , completed_oasis = #now()# , completed_1st_message_send = #now()# , completed_Med_Recon_send = #now()# , completed_OASIS_review = #now()# , approval_received = #now()# , completed_1st_approval = #now()# , completed_OASIS_update = #now()# , completed_485_update = #now()# , completed_final_send = #now()# , Updated_by = WHERE ID = SELECT * FROM #Request.prefix_db_lookup#.Coding_Request WHERE ID = UPDATE #Request.prefix_db_lookup#.Coding_Request SET completed_coding_elapsed = , completed_oasis_elapsed = , completed_1st_message_send_elapsed = , completed_Med_Recon_send_elapsed = , completed_OASIS_review_elapsed = , approval_received_elapsed = , completed_1st_approval_elapsed = , completed_OASIS_update_elapsed = , completed_485_update_elapsed = , completed_final_send_elapsed = , Updated_by = WHERE ID =