SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pAdmit.*, latest_assmt.Assmt_ID, latest_assmt.F26 AS Assessment_Reason, pEmployee.Emp_ID AS AssignedEmpID, pEmployee.Emp_First, pEmployee.Emp_Last, pAuths.Auth_ID FROM ( SELECT pAssessments.Admit_ID, pAssessments.Assmt_ID, pAssessments.Patient_ID, pAssessments.F26, pAssessments.F27, pAssessments.Record_Creation_Date 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 LEFT OUTER JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Assmt_ID = latest_assmt.Assmt_ID AND pAuths.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = latest_assmt.Assmt_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = assessment_assign.Emp_ID AND pEmployee.Status = 0 JOIN #Request.prefix_db_agency#.employee_auth ON pEmployee.Emp_ID = employee_auth.eaID AND employee_auth.r_Auth = 3 WHERE pAuths.Auth_ID IS NULL AND pAdmit.Admit_ID NOT IN ( SELECT pAssessments.Admit_ID FROM #Request.prefix_db_agency#.pAssessments WHERE (pAssessments.F26 like '9%' OR pAssessments.F26 like '7%' OR pAssessments.F26 like '8%') AND pAssessments.Status = 0 ) AND NOT EXISTS ( SELECT 1 FROM #Request.prefix_db_agency#.Communication JOIN #Request.prefix_db_agency#.CommunicationSubjects ON CommunicationSubjects.CommSub_ID = Communication.CommSub_ID WHERE Communication.Status = 0 AND Communication.Patient_ID = pPatients.Patient_ID AND latest_assmt.Record_Creation_Date < Communication.Comm_Date AND ( (LEFT(latest_assmt.F27, 2) = 'SN' AND CommunicationSubjects.Subject LIKE 'Discharge Summary - SN%') OR (LEFT(latest_assmt.F27, 2) = 'PT' AND CommunicationSubjects.Subject LIKE 'Discharge Summary - PT%') OR (LEFT(latest_assmt.F27, 2) = 'OT' AND CommunicationSubjects.Subject LIKE 'Discharge Summary - OT%') OR (LEFT(latest_assmt.F27, 2) = 'ST' AND CommunicationSubjects.Subject LIKE 'Discharge Summary - ST%') OR (LEFT(latest_assmt.F27, 3) = 'MSW' AND CommunicationSubjects.Subject LIKE 'Discharge Summary - MSW%') OR CommunicationSubjects.Subject LIKE '%Agency Transfer%' ) ) AND assessment_assign.Emp_ID = ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC
Missing Authorizations
Patient Missing
#PatientLast#, #PatientFirst# Authorization missing for #Assessment_Reason#
UPDATE #Request.prefix_db_agency#.Dash_emp_count SET status = 1 WHERE status = 0 AND Header = AND Emp_ID = INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status) VALUES ( , , , , , ) UPDATE #Request.prefix_db_agency#.Dash_emp_count SET status = 1 WHERE status = 0 AND Header = INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status) VALUES ( , , , , , )
UPDATE #Request.prefix_db_lookup#.Agency SET missing_auth_count = WHERE Agency_ID = UPDATE #Request.prefix_db_lookup#.pEmployee SET Emp_missing_auth_count = #Emp_missing_auth_count# WHERE Emp_ID = #session.EmployeeID#