SELECT IFNULL(MAX(Auth_ID),0)+1 As pAuth_ID FROM #Request.prefix_db_agency#.pAuths SELECT PtPayer_ID FROM #Request.prefix_db_agency#.pAuths WHERE Auth_ID = AND Status = 0 ORDER BY Date_Create DESC LIMIT 1 UPDATE #Request.prefix_db_agency#.pAuths SET Status = , Status = , Date_Change = , Change_by = WHERE Patient_ID = AND AutoAuth_ID = SELECT pPayer.M0150, pPtPayer.Util_Force FROM #Request.prefix_db_agency#.pPtPayer pPtPayer JOIN #Request.prefix_db_agency#.pPayer pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 WHERE pPtPayer.PtPayer_ID = AND pPtPayer.Status = 0 LIMIT 1 SELECT F300, F297 FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = 0 LIMIT 1 SELECT IFNULL(Total_skilled, 0) AS Total_skilled FROM #Request.prefix_db_lookup#.CW_Visit_Utilization WHERE HIPPS_Code = LIMIT 1 SELECT IFNULL(Total_skilled, 0) AS Total_skilled FROM #Request.prefix_db_lookup#.CW_Visit_Utilization WHERE HIPPS_Code = LIMIT 1 SELECT IFNULL(SUM(Total_Visits), 0) AS total_visits FROM #Request.prefix_db_agency#.pAuths WHERE Assmt_ID = AND Status = 0 SELECT IFNULL(Total_Visits, 0) AS Total_Visits FROM #Request.prefix_db_agency#.pAuths WHERE Auth_ID = AND Status = 0 LIMIT 1

Authorization Not Saved

Visits exceeds average for this HIPPS Score. Contact Clinical Director.

SELECT * FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Rev_CodeID = SELECT * FROM #Request.prefix_db_agency#.pAuths WHERE AutoAuth_ID = " /> " /> 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, Description, Auth_No, Authno_Placeholder,Visitfreq_Placeholder,visits_track_auth, Date_Start, Date_End, Rev_ID, Skill, Total_Visits, visit_freq, prn_visits, Notes, updating_reason, visit_withoutorders, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , '#Trim(form.visits_track_auth)#'NULL, NULL, NULL, , , , , 0, , , 0, , , , ) SELECT Skill FROM #Request.prefix_db_agency#.pAuths WHERE Auth_ID = AND Status = 3 ORDER BY Date_Change DESC LIMIT 1 UPDATE #Request.prefix_db_agency#.pSchedules SET PtPayer_ID = , Skill = , Date_Change = , Change_by = WHERE Auth_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = 0 ORDER BY AutoAssmt_ID DESC

Authorization Updated!

Authorizations successfully updated.

Add Visit

Add Schedule

Go to Chart