pm = CreateObject("Component", "Menu"); myArgument = 'orphansymptoms_new'; 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 'symptoms with no related diagnosis' ORDER BY Subject SELECT IFNULL(MAX(Orphan_ID),0) AS Max_Orphan_ID FROm #Request.prefix_db_agency#.pOrphan SELECT * FROm #Request.prefix_db_agency#.pOrphan WHERE Assmt_ID = '#Assmt_ID#' AND status = 0 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 select * from #Request.prefix_db_agency#.pOrphan where status = 0 and Problem_Dx_ID = '#Problem_ID#' AND Paired = 'Y' SELECT p.Problem_ID AS problems_ID,po.*,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 LEFT OUTER JOIN #Request.prefix_db_agency#.pOrphan po ON p.Problem_ID = po.Problem_ID and po.Status = 0 AND po.Problem_Dx_ID = #Problem_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#) INSERT INTO #Request.prefix_db_agency#.pOrphan ( Orphan_ID, Assmt_ID, Problem_ID, Problem, Problem_Dx_ID, Diagnosis, Paired,automatic_paired, Date_Created, Created_By) VALUES (, , , , , , , , , ) , SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE status = 0 AND Assmt_ID IN (#GtDX.Assmt_ID#) AND Skill NOT IN ('HHA') AND Item_ID < 1100 AND M0_No NOT like 'M102%' GROUP BY Problem_ID SELECT * FROM #Request.prefix_db_agency#.pOrphan WHERE status = 0 AND Assmt_ID IN (#ValueList(GtDX.Assmt_ID)#) SELECT * FROM getorphans WHERE Problem_ID = #getunpairsproblems.Problem_ID# AND Assmt_ID IN (#GtDX.Assmt_ID#) AND Problem_Dx_ID = #GtDX.Problem_ID# INSERT INTO #Request.prefix_db_agency#.pOrphan ( Orphan_ID, Assmt_ID, Problem_ID, Problem, Problem_Dx_ID, Diagnosis, Paired,automatic_paired, Date_Created, Created_By) VALUES ( , , , , , , , , , )

Unstable Symptoms with no Diagnosis and Treatment

Report Orphan Symptoms 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 * FROM #Request.prefix_db_agency#.pOrphan WHERE status = 0 AND Assmt_ID = '#Assmt_ID#' GROUP BY Problem_Dx_ID

Patient	Diagnoses with Symptoms	Diagnose without Symptoms	Symptoms without Diagnoses	Case Management
#DateFormat(F176,"yyyymmdd")# #Pt_Last#, #Pt_First# #F26# #DateFormat(F176,"mm/dd/yyyy")#	select * from #Request.prefix_db_agency#.pOrphan where status = 0 and Problem_Dx_ID = '#Problem_ID#' AND Paired = 'Y' #GtDX.Description#(0 - stable)(1 - stable)(2 - controlled with difficulty)(3 - poorly controlled)(4 - hx hospitalizations) #GtDX.Assmt_ID# style="text-decoration: underline;" >#getPairedsymp.Problem#	select * from #Request.prefix_db_agency#.pOrphan where status = 0 and Problem_Dx_ID = '#Problem_ID#' AND Assmt_ID = '#Assmt_ID#' and Paired='Y' #GtDX.Description#(0 - stable)(1 - stable)(2 - controlled with difficulty)(3 - poorly controlled)(4 - hx hospitalizations) #GtDX.Assmt_ID#	SELECT * FROM Getorphansymptoms WHERE M0_No IN ('CM') SELECT * from #Request.prefix_db_agency#.pOrphan where status = 0 AND Assmt_ID = '#Assmt_ID#' AND Paired ='N' AND Problem_ID NOT IN (#ValueList(getBH_CM.Problem_ID)#) ORDER BY Problem ASC SELECT * FROM getall_unpaired where Problem_ID = '#Problem_ID#' "> #getall_unpaired.Problem#	SELECT * FROM Getorphansymptoms WHERE M0_No IN ('CM') #Description# #Answer#