request.authorization = CreateObject("component","components.general.authorization").init() request.general = CreateObject("component","components.general.general").init() getmess = request.general.get_messages('auth_form'); getauth = request.authorization.getauthorizations(#url.AutoAuth_ID#); SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Status = AND Patient_ID = AND Admit_ID = AND (F26 like '1%' OR F26 like '4%' OR F26 like 'Hospice%' OR F26 = 'Palliative' ) ORDER BY F177 DESC SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Status = AND Patient_ID = AND Admit_ID = AND ( F26 like '%PT%' OR F26 like '%OT%' OR F26 like '%ST%' OR F26 like 'Hospice admission' OR F26 like '%SN%' ) AND (F26 like '1%' OR F26 like '4%' ) ORDER BY F177 DESC url.Auth_ID NEQ 0 > SELECT pAssessments.* ,pAdmit.Admit_Type FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 WHERE pAssessments.Patient_ID = AND pAssessments.status = 0 AND pAssessments.Admit_ID = GROUP BY pAssessments.Assmt_ID SELECT pAssessments.*,pAdmit.Admit_Type FROM #Request.prefix_db_agency#.pAssessments pAssessments JOIN #Request.prefix_db_agency#.pAdmit pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 AND pAssessments.Patient_ID = pAdmit.Patient_ID JOIN ( SELECT pa.Admit_ID FROM #Request.prefix_db_agency#.pAdmit pa WHERE pa.Status = 0 AND pa.Patient_ID = ORDER BY pa.M0030_START_CARE_DT DESC LIMIT 1 ) AS LatestAdmit ON pAdmit.Admit_ID = LatestAdmit.Admit_ID WHERE pAssessments.Patient_ID = AND pAssessments.status = 0 GROUP BY pAssessments.Assmt_ID SELECT * FROM getall_OASIS WHERE (F26 like '1%' OR F26 like '4%' OR F26 like 'Hospice%' OR F26 = 'Palliative') ORDER BY Assmt_ID ASC SELECT * FROM getall_OASIS WHERE (F26 like '1%' OR F26 like '4%') (F26 like 'Hospice%') (F26 = 'Palliative' OR F26 like 'Palliative%') (F26 like '%Pediatric%' ) Assmt_ID IN ('#getParentEval.Assmt_ID#','#url.assid#') Assmt_ID = '#getParentEval.Assmt_ID#' ORDER BY Assmt_ID ASC SELECT pAuths.Assmt_ID, SUM(IFNULL(pAuths.Total_Visits, 0)) AS total_auth_visits FROM #Request.prefix_db_agency#.pAuths WHERE pAuths.Patient_ID = AND pAuths.Status = 0 AND pAuths.Assmt_ID > 0 GROUP BY pAuths.Assmt_ID SELECT Distinct pPtPayer.PtPayer_ID AS Pay_ID, pPtPayer.Sub_First ,pPayer.Pay_Name,pPtPayer.PtPayer_ID,pPayer.Pay_ID AS Payer_ID, pPayer.Output, pPayer.Auth_Req, pPayer.visits_track, pPayer.auth_measure, pPayer.M0150, pPayer.bypass_compliance, pPtPayer.Util_Force FROM #Request.prefix_db_agency#.pPtPayer JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.status=0 WHERE pPtPayer.Patient_ID = AND pPtPayer.Status = ORDER BY Pay_Name SELECT pAdmit.Admit_Type FROM #Request.prefix_db_agency#.pAdmit WHERE pAdmit.Patient_ID = AND pAdmit.Status = 0 AND pAdmit.Admit_ID = ORDER BY pAdmit.M0030_START_CARE_DT DESC LIMIT 1 SELECT * FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID IN ( SELECT pSchedules.Schedule_ID FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Auth_ID = "#Auth_ID#" AND status = AND Progress_Note = ) SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Auth_ID = "#Auth_ID#" AND status = and Missed = 0 SELECT * FROM getSchedules WHERE Progress_Note = SELECT MIN(pSchedules.Visit_Date) AS startvisitdate, MAX(pSchedules.Visit_Date) AS endvisitdate FROM #Request.prefix_db_agency#.pSchedules WHERE Auth_ID = "#Auth_ID#" AND status = 0 and Missed = 0 AND Assmt_ID IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Status = 0 AND pAssessments.Admit_ID = '#URL.Admit_ID#') SELECT * FROM getpayer WHERE PtPayer_ID = SELECT pPtPayer.Util_Force, pPayer.M0150 FROM #Request.prefix_db_agency#.pPtPayer JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 WHERE pPtPayer.PtPayer_ID = AND pPtPayer.Status = 0 LIMIT 1 SELECT * FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Agency_ID = AND Status = AND Payer_ID = order by Rev_Code SELECT * FROM #Request.prefix_db_lookup#.pVisit_Frequency ORDER BY Visit_No ASC SELECT * FROM #Request.prefix_db_agency#.pAuths_weeks WHERE Auth_ID = '#Auth_ID#' AND status = 0 SELECT * FROM getvisitfreq pm = CreateObject("Component", "Menu"); if (Session.CS.AssessmentID != '' && val(Session.CS.AssessmentID)) { pm.MenuFunction('authorization',#session.cs.patientid#,#Session.CS.AssessmentID#,'','',''); } else { pm.MenuFunction('authorization',#session.cs.patientid#,'','','',''); }
Add New Edit Authorization
close
>Inactive
checked> No assessment
style="display:none;"> class="text-danger"class="text-danger hide" id="authplaceholderrequired" >checked> PLACEHOLDER
style="display:none;">
style="display:none;">
style="display:none;">
style="display:none;"> checked> PLACEHOLDER
if placeholder is checked visit frequency compliance is not tracked
style="display:none;">
style="display:none;">
style="display:none;">

Hello #session.display#, You don’t have the access to add/edit authorizations.So please contact you administrator.