SELECT Description FROM #Request.prefix_db_lookup#.EVV_Reason_Codes WHERE Reason_Code_ID = AND Status = 0 UPDATE #Request.prefix_db_lookup#.EVV_Update_Log SET Status = 1 WHERE Schedule_ID = AND Agency_ID = AND Status = 0 SELECT Update_Log_ID, Change_Memo, Reason_Code_ID, EVV_ID FROM #Request.prefix_db_lookup#.EVV_Update_Log WHERE Schedule_ID = AND Agency_ID = AND Status = 0 ORDER BY Update_Log_ID DESC LIMIT 1 UPDATE #Request.prefix_db_lookup#.EVV_Update_Log SET Status = 2 WHERE Schedule_ID = AND Agency_ID = AND Status = 0 AND Update_Log_ID <> UPDATE #Request.prefix_db_lookup#.EVV_Update_Log SET Change_Memo = , Reason_Code_ID = NULL, Date_Reason_Added = , Reason_Added_By = , EVV_ID = NULL WHERE Update_Log_ID = AND Status = 0 INSERT INTO #Request.prefix_db_lookup#.EVV_Update_Log ( Schedule_ID, Agency_ID, EVV_ID, Date_Updated, Change_Memo, Changed_By, Changed_By_Email, Reason_Code_ID, Date_Reason_Added, Reason_Added_By, Status ) VALUES ( , , NULL, , , NULL, , NULL, NULL, NULL, 0 ) SELECT pSchedules.Schedule_ID, pSchedules.Date_Change, pSchedules.Change_by, pPatients.Patient_ID, pEmployee.Emp_Email FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID LEFT JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Change_by WHERE pSchedules.Schedule_ID = AND pSchedules.status = 0 UPDATE #Request.prefix_db_agency#.pSchedules SET EVV_Reason_Code_ID = WHERE Schedule_ID = AND status = 0 SELECT Description FROM #Request.prefix_db_lookup#.EVV_Reason_Codes WHERE Reason_Code_ID = #buildSaveJsonResponse( success = true, message = "Reason code saved successfully", updateLogID = savedLog.update_log_id, reasonCodeID = val(FORM.reason_code_id), reasonCodeDescription = getReasonCode.Description, autoTransmit = autoTransmit )# SELECT Description FROM #Request.prefix_db_lookup#.EVV_Reason_Codes WHERE Reason_Code_ID = AND Status = 0 {"success": true, "encrypted_id": "#encrypted_id#", "reason_code_description": "#JSStringFormat(reasonDescription)#"} SELECT pSchedules.Schedule_ID, pSchedules.Date_Change, pSchedules.Change_by, pSchedules.EVV_Reason_Code_ID, pPatients.Patient_ID, pEmployee.Emp_Email FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID LEFT JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Change_by WHERE pSchedules.Schedule_ID = AND pSchedules.status = 0 UPDATE #Request.prefix_db_agency#.pSchedules SET EVV_Reason_Code_ID = WHERE Schedule_ID = AND status = 0 #buildSaveJsonResponse( success = true, message = "Change memo saved successfully", updateLogID = savedLog.update_log_id, reasonCodeID = val(savedLog.reason_code_id) )# {"success": false, "message": "#JSStringFormat(cfcatch.message)#", "detail": "#JSStringFormat(cfcatch.detail)#"}