SELECT (SELECT count(*) FROM #Request.prefix_db_agency#.pAssessments pa WHERE pa.Admit_ID = a.Admit_ID AND pa.status = 0 AND pa.F26 IN ('7 - Transferred to an inpatient facility - patient discharged from agency', '8 - Death at home','9 - Discharge from agency')) AS discharge, p.*, pt.*,a.AutoAssmt_ID,a.Admit_ID,a.F26,a.F176 FROM #Request.prefix_db_agency#.pProblem p JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Pathway_ID = p.Path_ID JOIN #Request.prefix_db_agency#.pAssessments a ON a.Assmt_ID = p.Assmt_ID JOIN #Request.prefix_db_agency#.pPatients pt ON pt.Patient_ID = a.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit ad ON ad.Admit_ID = a.Admit_ID WHERE ad.status = 0 AND pt.status = 0 AND a.status = 0 AND p.status = 0 AND pt.Patient_ID = AND pPathway.Agency_ID IS NULL AND p.M0_No like 'M102%' AND pt.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 ) GROUP BY p.Problem_ID,p.Assmt_ID ORDER BY pt.Pt_Last, a.Assmt_ID ASC, p.dx_order ASC
Unstable Symptoms with no Diagnosis and Treatment

SELECT p.*,pg.severity,pg.Progress_ID,IFNULL(Left(p.Answer,1),2) AS probSeverity FROM #Request.prefix_db_agency#.pProblem p LEFT OUTER JOIN #Request.prefix_db_agency#.pProgress pg ON p.Problem_ID = pg.Careplan_ID WHERE p.status = 0 AND p.Skill NOT IN ('HHA') AND p.Item_ID < 1100 AND p.Assmt_ID = #Assmt_ID# AND p.Item_ID NOT IN (SELECT Item_ID FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID IN (#Request.dxpath_ids#) AND Type= 'symptom' AND Agency_ID IS NULL) AND p.M0_No NOT like 'M102%' GROUP BY p.Problem_ID ORDER BY pg.Progress_ID DESC SELECT pWoundsVitals.*, CASE WHEN Item_ID = 9 THEN "9,73,74" WHEN Item_ID = 2 THEN "12,14" WHEN Item_ID = 4 THEN "12" WHEN Item_ID = 3 THEN "12,14" WHEN Item_ID = 1 THEN "18,19,49,50,57,64" WHEN Item_ID = 7 THEN "12,14" ELSE 0 END AS pathwayids FROM #Request.prefix_db_agency#.pWoundsVitals WHERE status = 0 AND Assmt_ID = #Assmt_ID# AND VitalOrWound = 'vital' AND Reading1 != 0 AND (CAST(Reading1 AS DECIMAL(5,2)) < CAST(Param_Lo AS DECIMAL(5,2)) OR CAST(Reading1 AS DECIMAL(5,2)) > CAST(Param_Hi AS DECIMAL(5,2)) ) GROUP BY ID ","all")> SELECT * FROM Getorphansymptoms WHERE M0_No IN ( 'CM')
Patient Diagnoses/Related Symptoms Orphan Symptoms Case Management
#Pt_Last#, #Pt_First#
#F26#
#DateFormat(F176,"mm/dd/yyyy")# 		SELECT p.* ,pg.severity,pg.Progress_ID,IFNULL(Left(p.Answer,1),2) AS probSeverity FROM #Request.prefix_db_agency#.pProblem p LEFT OUTER JOIN #Request.prefix_db_agency#.pProgress pg ON p.Problem_ID = pg.Careplan_ID WHERE p.status = 0 AND p.Skill NOT IN ('HHA') AND p.Item_ID < 1100 AND p.Assmt_ID = #Assmt_ID# AND ( p.Item_ID IN (SELECT Item_ID FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID IN (#Path_ID#) AND Type= 'symptom' AND (Approved != 'Not paired' OR Approved IS NULL) ) OR (p.Path_ID = #Path_ID# AND p.M0_No = 'SK' AND p.Path_ID IN (30,34,38,39,171,172,173,174,175,176,177,178,179,180,181,182,183,184) )) AND p.M0_No NOT like 'M102%' GROUP BY p.Problem_ID ORDER BY pg.Progress_ID DESC SELECT p.* FROM #Request.prefix_db_agency#.pProblem p WHERE p.status = 0 AND p.Skill NOT IN ('HHA') AND p.Item_ID < 1100 AND p.Assmt_ID = #Assmt_ID# AND p.Path_ID = #Path_ID# AND p.M0_No NOT like 'M102%' GROUP BY p.Problem_ID #GtDX.Description# (1 - stable)(2 - controlled with difficulty)(3 - poorly controlled)(4 - hx hospitalizations)
  • #getdiagsymp.Description#
    •
  • unstable #getvitals.Description#
    • no symptomsno symptoms

style="background-color:pink;">#Description# - #Getorphansymptoms.Path_ID# - #GtDX.Path_ID# - #M0_No#

#Description#