SELECT pPatients.Pt_First, pPatients.Pt_Last, pAssessments.F26, pAssessments.F176, pPatients.Patient_ID, pAssessments.Assmt_ID, pAssessments.Admit_ID, pEmployee.Emp_First, pEmployee.Emp_Last, pEmployee.Emp_ID AS AssignedEmpID, (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 FROM #Request.prefix_db_agency#.pAssessments pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.Status = 0 JOIN #Request.prefix_db_agency#.pPatients pPatients ON pPatients.Patient_ID = pAssessments.Patient_ID AND pPatients.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = pAssessments.Assmt_ID AND assessment_assign.F26 = pAssessments.F26 LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = assessment_assign.Emp_ID WHERE pPatients.Loc_ID = '#session.agencyid#' AND pAssessments.Status = 0 AND (pAssessments.F26 LIKE '1%' OR pAssessments.F26 LIKE '4%') AND pAssessments.F26 NOT LIKE '3%' AND pAssessments.F25 = 1 AND pAssessments.Orphan_Field IN (0,2) AND pAssessments.Assmt_ID = ( SELECT a2.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments a2 WHERE a2.Admit_ID = pAssessments.Admit_ID AND a2.Status = 0 AND (a2.F26 LIKE '1%' OR a2.F26 LIKE '4%') AND a2.F26 NOT LIKE '3%' AND a2.F25 = 1 AND a2.Orphan_Field IN (0,2) ORDER BY a2.F177 DESC, a2.Assmt_ID DESC LIMIT 1 ) AND NOT EXISTS ( SELECT 1 FROM #Request.prefix_db_agency#.pCMS4857 p485 WHERE p485.Assmt_ID = pAssessments.Assmt_ID AND p485.Status = 0 AND (p485.Form_Type LIKE '%Form 485%' OR p485.Form_Type LIKE '%485%') ) AND pEmployee.Emp_ID = GROUP BY pAssessments.Assmt_ID ORDER BY pAssessments.F176 ASC
Incomplete Orphan Symptoms
Fetch latest report Back
Patient Name Assesments Reason Completed Date Employee Elapsed Days
#Pt_Last#, #Pt_First# #F26# #DateFormat(F176,"mm/dd/yyyy")# #Emp_First#, #Emp_Last# #diffdays#
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#.pEmployee SET Emp_orphans_symp_count = #Emp_orphans_symp_count# WHERE Emp_ID = #session.EmployeeID#