SELECT pUnstable.*,
0 AS No_Days_Progress,
"" AS Note_QA,
SUM(CASE WHEN pUnstable.Visit_Date >= '#Dateformat(sevenDaysAgo,"yyyy-mm-dd")#'
AND pAssessments.Patient_ID = pUnstable.Patient_ID THEN 1 ELSE 0 END) AS sevendays_count,
SUM(CASE WHEN pUnstable.Visit_Date >= '#Dateformat(fourteenDaysAgo,"yyyy-mm-dd")#'
AND pAssessments.Patient_ID = pUnstable.Patient_ID THEN 1 ELSE 0 END) AS fourteendays_count,
SUM(CASE WHEN pUnstable.Visit_Date >= '#Dateformat(twentyoneDaysAgo,"yyyy-mm-dd")#'
AND pAssessments.Patient_ID = pUnstable.Patient_ID THEN 1 ELSE 0 END) AS twentyonedays_count,
CASE
WHEN pUnstable.unstable_problems > 0
AND EXISTS (
SELECT 1 FROM #Request.prefix_db_agency#.pProgress
INNER JOIN #Request.prefix_db_agency#.pProblem
ON pProblem.Problem_ID = pProgress.Careplan_ID
WHERE pProgress.Assmt_ID = pUnstable.Assmt_ID
AND pProgress.Schedule_ID = pUnstable.Schedule_ID
AND pProgress.Status = 0
AND pProgress.Careplan_ID > 0
AND pProblem.Status = 0
AND pProblem.Description like '##%'
AND pProgress.Severity IN (2, 3, 4)
) THEN 'yellow'
WHEN LEFT(pAssessments.F34, 1) IN ('2', '3', '4') AND LEFT(pAssessments.F26, 1) = '1' THEN 'pink'
WHEN LEFT(pAssessments.F72, 1) IN ('3', '4') AND LEFT(pAssessments.F26, 1) = '1' THEN 'pink'
ELSE ''
END AS row_color
FROM #Request.prefix_db_agency#.pUnstable
JOIN #Request.prefix_db_agency#.pAssessments ON pUnstable.Assmt_ID = pAssessments.Assmt_ID
AND pAssessments.Status = 0
WHERE pUnstable.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 pSchedules.pgnotesdraft = 2 AND pAssessments.Status = 0)
AND pUnstable.Emp_ID =
GROUP BY pUnstable.Skill,pUnstable.Patient_ID
ORDER BY PatientLast ASC, PatientFirst ASC, Emp_Last ASC, Emp_First ASC,
Skill ASC, Visit_Date ASC
SELECT * FROM getunstablesymptomsall