SELECT IFNULL(MAX(Auth_ID),0)+1 As pAuth_ID FROM #Request.prefix_db_agency#.pAuths UPDATE #Request.prefix_db_agency#.pAuths SET Status = , Status = , Date_Change = , Change_by = WHERE Patient_ID = AND AutoAuth_ID = SELECT * FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Rev_CodeID = SELECT a.*, vf.Frequency FROM #Request.prefix_db_agency#.pAuths a LEFT JOIN #Request.prefix_db_lookup#.pVisit_Frequency vf ON a.visit_freq = vf.Visit_No WHERE a.Auth_ID = SELECT Frequency FROM #Request.prefix_db_lookup#.pVisit_Frequency WHERE Visit_No = " /> " /> request.ass = CreateObject("component","components.general.assessments").init(); getgoalsuccess = request.ass.updategoals_visit(#form.Assmt_ID#); INSERT INTO #Request.prefix_db_agency#.pAuths (Auth_ID, Patient_ID, Assmt_ID, PtPayer_ID, Elig_ID,CMSOrder_ID, Status, Auth_No, Authno_Placeholder,Visitfreq_Placeholder, Date_Start, Date_End, Rev_ID, Skill, Total_Visits, visit_freq, Set_1_visits, Set_1_weeks, Set_2_visits, Set_2_weeks, Set_3_visits, Set_3_weeks, Set_4_visits, Set_4_weeks, prn_visits, Notes, updating_reason, visit_withoutorders, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , "#form.Auth_No#", , , , , , , , , 0, 0, 0, 0, 0, 0, 0, 0, 0 , , , 0, , , , ) SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status < 2 ORDER BY AutoAssmt_ID DESC

Authorization Updated!

Authorizations successfully updated.

Add Visit

Add Schedule

Go to Chart