pm = CreateObject("Component", "Menu"); myArgument = 'Orphansymptoms'; pm.MenuFunction(myArgument,#getP.Patient_Id#,'','','',''); request.pat = CreateObject("component","components.general.patients").init(); getadmit = request.pat.get_admissions(#session.cs.patientid#); SELECT p.*, pt.*,a.AutoAssmt_ID,a.Admit_ID,a.Assmt_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 = '#session.cs.patientid#' AND pPathway.Agency_ID IS NULL AND p.M0_No like 'M102%' GROUP BY p.Problem_ID,p.Assmt_ID ORDER BY a.F177 DESC, p.dx_order ASC SELECT CommSub_Id, Subject FROM #Request.prefix_db_agency#.CommunicationSubjects WHERE Agency_Id = #session.AgencyId# AND active = 'Y' AND Subject like 'dispute orphan symptom report' ORDER BY Subject
Unstable Symptoms with no Diagnosis and Treatment

Dispute Findings 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 pPathwayReview.*,pProblem.Description As prodescription, pProblem.Problem_ID FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.pPathwayReview ON pProblem.Assmt_ID = pPathwayReview.Assmt_ID AND pProblem.Description LIKE CONCAT('%', pPathwayReview.Description ,'%') WHERE pPathwayReview.Type = AND pPathwayReview.Assmt_ID = #Assmt_ID# GROUP BY pPathwayReview.Description ORDER BY pPathwayReview.Type_Order,pPathwayReview.Order_ID ASC 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
#DateFormat(F176,"yyyymmdd")# #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 SELECT pProblem.Description As prodescription, pProblem.Problem_ID FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.CW_Coding_Class_PDGM ON CW_Coding_Class_PDGM.System = pProblem.M0_No WHERE pProblem.status = 0 AND pProblem.Assmt_ID = #Assmt_ID# AND CW_Coding_Class_PDGM.Pathway_ID = '#GtDX.Path_ID#' AND pProblem.Problem_ID IN (#customproblems_ids#) #GtDX.Description# (0 - stable)(1 - stable)(2 - controlled with difficulty)(3 - poorly controlled)(4 - hx hospitalizations) #GtDX.Assmt_ID#
  • #getdiagsymp.Description#
  • #getdiagsymp.Description#
  • unstable #getvitals.Description#
  • unstable #getvitals.Description#
    • no symptomsno symptoms

    #getPDGM.prodescription#

style="background-color:pink;">#Description# - #Getorphansymptoms.Path_ID# - #Request.dxpath_ids# - #M0_No# - #request.pathids#

  • unstable #getvitals.Description#
    • no symptoms
outside vitals parametter END --->

#Description#

  • #Answer#

    		•