SELECT pAuths.*, (SELECT count(*) FROM #Request.prefix_db_agency#.Communication, #Request.prefix_db_agency#.CommunicationSubjects WHERE Communication.Patient_ID = pPatients.Patient_ID AND CommunicationSubjects.CommSub_ID = Communication.CommSub_ID AND (CommunicationSubjects.Subject like CONCAT("Discharge Summary - ",pAuths.Skill) OR CommunicationSubjects.Subject like 'Agency Transfer/Discharge Summary') AND Communication.Comm_record_deleted <> 1 AND Communication.Status = 0) AS communication_discharge, pRevenue_Code.Visit_Type, pRevenue_Code.Rev_Code, pRevenue_Code.HCPCS, pPtPayer.Sub_First, pPayer.Pay_Name, pEmployee.Emp_Last, pEmployee.Emp_First, CONCAT(pEmployee.Emp_First, ", ", pEmployee.Emp_Last) AS name_by, pPatients.Pt_First, pPatients.Pt_Last, latest_assmt.Assmt_ID FROM ( SELECT pAssessments.Admit_ID, pAssessments.Assmt_ID, pAssessments.Patient_ID 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.Status = 0 AND (LEFT(pAssessments.F26, 1) = '1' OR LEFT(pAssessments.F26, 1) = '4') AND pAssessments.F178 = ( SELECT MAX(ass.F178) FROM #Request.prefix_db_agency#.pAssessments ass WHERE ass.Admit_ID = pAssessments.Admit_ID AND ass.Status = 0 AND (LEFT(ass.F26, 1) = '1' OR LEFT(ass.F26, 1) = '4') ) ) AS latest_assmt JOIN #Request.prefix_db_agency#.pAdmit pAdmit ON pAdmit.Admit_ID = latest_assmt.Admit_ID AND pAdmit.Status = 0 JOIN #Request.prefix_db_agency#.pPatients pPatients ON pPatients.Patient_ID = latest_assmt.Patient_ID AND pPatients.Status = 0 JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Assmt_ID = latest_assmt.Assmt_ID AND pAuths.Status = 0 JOIN #Request.prefix_db_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = pAuths.Rev_ID AND pRevenue_Code.Status = 0 JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pAuths.PtPayer_ID AND pPtPayer.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = latest_assmt.Assmt_ID LEFT JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = COALESCE(NULLIF(assessment_assign.Emp_ID, 0), 2) AND pEmployee.Status = 0 WHERE pPatients.Loc_ID = '#session.agencyid#' AND pAuths.Date_End >= AND DATEDIFF(pAuths.Date_End, ) <= 14 AND pAuths.Date_End BETWEEN AND AND COALESCE(NULLIF(assessment_assign.Emp_ID, 0), 2) = GROUP BY pAuths.AutoAuth_ID ORDER BY pAuths.Date_End ASC
Search Expiring Authorizations
Send a Communication
" /> to " />
Date Format: mm/dd/yyyy
Expiring Authorization List
Send a Communication
Authorization End Authorization Patient Payer Days Visit_Type
#DateFormat(Date_End, "mm/dd/yy")# #DateFormat(Date_Start, "mm/dd/yy")# #Pt_Last#, #Pt_First# #Pay_Name# #diffdays# #Skill#
UPDATE #Request.prefix_db_lookup#.pEmployee SET Emp_expiring_auth = #Emp_expiring_auth# WHERE Emp_ID = #session.EmployeeID#