SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, (SELECT count(pAssessments.Assmt_ID) FROM #Request.prefix_db_agency#.pAssessments WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.Status = 0 AND pAssessments.F26 = '1 - Start of care - further visits planned' ) AS SOC_count, (SELECT count(pAuths.Auth_ID) FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pAuths.Assmt_ID AND pAssessments.Status = 0 WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.F26 = '1 - Start of care - further visits planned' AND pAuths.Skill = 'SN' AND pAuths.Status = 0 ) AS SOCauth_count, (SELECT count(pSchedules.Schedule_ID) FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.Status = 0 WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.F26 = '1 - Start of care - further visits planned' AND pSchedules.Skill = 'SN' AND pSchedules.Status = 0 ) AS SOCschedule_count, (SELECT count(pAssessments.Assmt_ID) FROM #Request.prefix_db_agency#.pAssessments WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.Status = 0 AND pAssessments.F26 = '1 - Start of care - further visits planned - Physical Therapy' ) AS SOCPT_count, (SELECT count(pAuths.Auth_ID) FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pAuths.Assmt_ID AND pAssessments.Status = 0 WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.F26 = '1 - Start of care - further visits planned - Physical Therapy' AND pAuths.Skill = 'PT' AND pAuths.Status = 0 ) AS SOCPTauth_count, (SELECT count(pSchedules.Schedule_ID) FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.Status = 0 WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.F26 = '1 - Start of care - further visits planned - Physical Therapy' AND pSchedules.Skill = 'PT' AND pSchedules.Status = 0 ) AS SOCPTschedule_count, (SELECT count(pAssessments.Assmt_ID) FROM #Request.prefix_db_agency#.pAssessments WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.Status = 0 AND pAssessments.F26 = 'PT Adult Evaluation' ) AS PTAdult_count, (SELECT count(pAuths.Auth_ID) FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pAuths.Assmt_ID AND pAssessments.Status = 0 WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.F26 = 'PT Adult Evaluation' AND pAuths.Skill = 'PT' AND pAuths.Status = 0 ) AS PTAdultauth_count, (SELECT count(pSchedules.Schedule_ID) FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.Status = 0 WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.F26 = 'PT Adult Evaluation' AND pSchedules.Skill = 'PT' AND pSchedules.Status = 0 ) AS PTAdultschedule_count, (SELECT count(pAssessments.Assmt_ID) FROM #Request.prefix_db_agency#.pAssessments WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.Status = 0 AND pAssessments.F26 = 'OT Adult Evaluation' ) AS OTAdult_count, (SELECT count(pAuths.Auth_ID) FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pAuths.Assmt_ID AND pAssessments.Status = 0 WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.F26 = 'OT Adult Evaluation' AND pAuths.Skill = 'OT' AND pAuths.Status = 0 ) AS OTAdultauth_count, (SELECT count(pSchedules.Schedule_ID) FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.Status = 0 WHERE pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.F26 = 'OT Adult Evaluation' AND pSchedules.Skill = 'OT' AND pSchedules.Status = 0 ) AS OTAdultschedule_count, (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 "Discharge Summary - SN%" AND Communication.Comm_record_deleted <> 1 AND Communication.Status = 0 ) AS comm_SNdischarge, (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 "Discharge Summary - PT%" AND Communication.Comm_record_deleted <> 1 AND Communication.Status = 0 ) AS comm_PTdischarge, (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 "Discharge Summary - OT%" AND Communication.Comm_record_deleted <> 1 AND Communication.Status = 0 ) AS comm_OTdischarge FROM #Request.prefix_db_agency#.pPatients WHERE pPatients.Status < 2 AND pPatients.Patient_ID IN (SELECT pSchedules.Patient_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID WHERE pSchedules.Emp_ID = AND pSchedules.Status = 0 AND pAssessments.Status =0 ) ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC
Missing Authorizations
Patient Missing
#PatientLast# #PatientFirst# SN authorization missingSN schedule missing
#PatientLast# #PatientFirst# PT authorization missingPT schedule missing
#PatientLast# #PatientFirst# OT authorization missingOT schedule missing