SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pEmployee.Emp_ID, pEmployee.Emp_Last, pEmployee.Emp_First, (SELECT py.Pay_Name FROM #Request.prefix_db_agency#.pPayer py JOIN #Request.prefix_db_agency#.pPtPayer ptpay ON py.Pay_ID = ptpay.Payer_ID AND ptpay.Status = 0 WHERE pPatients.Patient_ID = ptpay.Patient_ID ORDER BY ptpay.Payer_Responsibility ASC LIMIT 1) AS payername, ( SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = pAssessments.Patient_ID AND Status = 0 ORDER BY M0030_START_CARE_DT DESC LIMIT 1 ) AS latest_admit, pAssessments.Assmt_ID,pAssessments.* FROM #Request.prefix_db_agency#.pAssessments pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.Status = 0 AND pAdmit.Drafts = 0 JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAssessments.Patient_ID AND pPatients.Status IN (0) LEFT JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = pAssessments.Assmt_ID AND assessment_assign.F26 = pAssessments.F26 LEFT JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = assessment_assign.Emp_ID AND pEmployee.Status = 0 WHERE pAssessments.Status = 0 AND (pAssessments.F25 IS NULL OR pAssessments.F25 = '0') AND pAssessments.F176 < AND pEmployee.Emp_ID IS NOT NULL 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 AND pSchedules.Followup_visit = 1) AND assessment_assign.Emp_ID = GROUP BY pAssessments.Assmt_ID ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC, pEmployee.Emp_Last ASC, pEmployee.Emp_First ASC

Incomplete OASIS/Evaluations

Fetch latest report

Patient	Assessments	Payer	Employee	Days Late
#PatientLast#, #PatientFirst#	#F26# (#DateFormat(F177,"mm/dd/yyyy")# - #DateFormat(F178,"mm/dd/yyyy")#)	#payername#	#Emp_Last#, #Emp_First#	#elapsed_days#

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 Incomplete_OASIS = WHERE Agency_ID =