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.Assmt_ID = #Assmt_ID# AND p.Skill NOT IN ('HHA') AND p.Item_ID < 1100 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 p.* FROM #Request.prefix_db_agency#.pCareplan p WHERE p.status = 0 AND p.Assmt_ID = #Assmt_ID# AND p.Skill NOT IN ('HHA') AND p.Item_ID NOT IN (SELECT Item_ID FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID IN (#Request.dxpath_ids#) AND Type IN ('symptom','procedure') AND Agency_ID IS NULL) GROUP BY p.Careplan_ID ORDER BY p.Order_ID ASC SELECT * FROM Getorphancareplans WHERE Type = 'symptom' ORDER BY Order_ID ASC SELECT * FROM Getorphancareplans WHERE Type = 'procedure' ORDER BY Order_ID ASC SELECT * FROM getcareorphan_procedure WHERE Skill = 'PT' ORDER BY Order_ID ASC SELECT * FROM getcareorphan_procedure WHERE Skill = 'OT' ORDER BY Order_ID ASC SELECT ptmeds.*,mp.* FROM #Request.prefix_db_lookup#.meds_pathway_lookup mp JOIN #Request.prefix_db_agency#.pPtmeds ptmeds ON ptmeds.Drug_ID = mp.Trade_Num WHERE ptmeds.Patient_ID = #session.cs.patientid# AND mp.Patient_ID = ptmeds.Patient_ID AND mp.Approved != "Yes" AND Approved IS NOT NULL AND mp.Path_ID NOT IN (#Request.dxpathids#) AND ptmeds.status =0 GROUP BY mp.Trade_Num, ptmeds.Drug_Name 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	Functional	Case Management	Orphans
#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, p.Path_ID as symppath_id 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 SELECT ptmeds.* FROM #Request.prefix_db_lookup#.meds_pathway_lookup mp JOIN #Request.prefix_db_agency#.pPtmeds ptmeds ON ptmeds.Drug_ID = mp.Trade_Num WHERE ptmeds.Patient_ID = #session.cs.patientid# AND mp.Approved = "Yes" AND ptmeds.status =0 AND mp.Path_ID = '#GtDX.Path_ID#' GROUP BY mp.Trade_Num, ptmeds.Drug_Name SELECT DISTINCT p.* FROM #Request.prefix_db_agency#.pCareplan p JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = p.Item_ID AND p.type = pPathway.Type JOIN #Request.prefix_db_agency#.pProblem ON pPathway.Pathway_ID = pProblem.Path_ID WHERE p.status = 0 AND pProblem.Path_ID = '#GtDX.Path_ID#' AND p.Description != 'symptoms are controlled' AND p.Description != 'patient/caregiver recalls related medication(s) purpose and schedule' AND p.Skill = '#Skill#' AND p.Assmt_ID = #Assmt_ID# GROUP BY p.Careplan_ID UNION SELECT DISTINCT p.* FROM #Request.prefix_db_agency#.pCareplan p WHERE p.status = 0 AND p.Description != 'symptoms are controlled' AND p.Description != 'patient/caregiver recalls related medication(s) purpose and schedule' AND p.Skill = '#Skill#' AND (p.Item_ID IN (SELECT Item_ID FROM #Request.prefix_db_lookup#.pPathwayReview WHERE Pathway_ID IN ('#GtDX.Path_ID#') AND (Patient_ID = '#session.cs.patientid#' OR Approved IS NULL) )) AND p.Assmt_ID = #Assmt_ID# GROUP BY p.Careplan_ID SELECT DISTINCT pProblem.* FROM #Request.prefix_db_agency#.pProblem JOIN hhapowerpath.pPathwayReview ON pPathwayReview.Item_ID = pProblem.Item_ID AND pProblem.M0_No = pPathwayReview.Type WHERE pProblem.status = 0 AND pProblem.Path_ID = '#GtDX.Path_ID#' AND pProblem.Skill = '#Skill#' AND pProblem.Assmt_ID = #Assmt_ID# GROUP BY pProblem.Problem_ID SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.status = 0 AND pProblem.Skill = 'PT' AND pProblem.Assmt_ID = #Assmt_ID# GROUP BY pProblem.Problem_ID SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.status = 0 AND pProblem.Skill = 'OT' AND pProblem.Assmt_ID = #Assmt_ID# GROUP BY pProblem.Problem_ID SELECT * FROM getcareplanspathways WHERE type = 'goal' SELECT * FROM getcareplanspathways WHERE type = 'teach' SELECT * FROM getcareplanspathways WHERE type = 'procedure' #GtDX.Description# (0 - stable)(1 - stable)(2 - controlled with difficulty)(3 - poorly controlled)(4 - hx hospitalizations) PROCEDURE #replace(Description, "patient/caregiver recalls ","", "ALL")# NO TEACHING TEACHING #replace(Description, "patient/caregiver recalls ","", "ALL")# NO TEACHING GOALS #replace(Description, "patient/caregiver recalls ","", "ALL")# NO GOALS SYMPTOMS #getdiagsymp.Description# #getdiagsymp.Description# #Drug_Name# #Dose# #Dose_Units# #Route# #Freq# CUSTOM SYMPTOMS #getcareplansymptoms.Description# #getcareplansymptoms.Description# unstable #getvitals.Description# unstable #getvitals.Description# no symptomsno symptoms #Drug_Name# #Dose# #Dose_Units# #Route# #Freq#	Physical Therapy #F78# #F80# #F81# PT Procedures: #Description# Occupational Therapy #F74# #F75# #F76# #F79# #F156# OT Procedures: #Description# unstable #getvitals.Description# no symptoms outside vitals parametter END --->	#Description# #Answer#	Symptoms: #Description# Procedure: #Description# Medications: #getallorphansmeds.Drug_Name#