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#'); request.ass = CreateObject("component","components.general.assessments").init(); parent_OASIS = request.ass.getParentOASIS('#getadmit.Admit_ID#'); SELECT p.*, pt.*,a.AutoAssmt_ID,a.Admit_ID,a.Assmt_ID,a.F26,a.F176,a.F27, a.F320 AS QA_View,a.Orphan_Field FROM #Request.prefix_db_agency#.pProblem p LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Pathway_ID = p.Path_ID AND pPathway.Agency_ID IS NULL 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 JOIN ( SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = '#session.cs.patientid#' AND Status = 0 ORDER BY M0030_START_CARE_DT DESC LIMIT 1 ) AS latest_admit ON latest_admit.Admit_ID = a.Admit_ID WHERE ad.status = 0 AND pt.status IN (0,1,4) AND a.status = 0 AND p.status = 0 AND pt.Patient_ID = '#session.cs.patientid#' AND (a.F26 like '1%' OR a.F26 like '4%' or F26 like 'Hospice a%' OR a.Assmt_ID = '#parent_OASIS.Assmt_ID#' ) AND a.f25 = 1 AND a.Assmt_ID IN ( SELECT latest_assmt.Assmt_ID FROM ( SELECT a10.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments a10 JOIN #Request.prefix_db_agency#.pAdmit ad10 ON ad10.Admit_ID = a10.Admit_ID JOIN ( SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = '#session.cs.patientid#' AND Status = 0 ORDER BY M0030_START_CARE_DT DESC LIMIT 1 ) AS latest_admit_10 ON latest_admit_10.Admit_ID = a10.Admit_ID WHERE ad10.Status = 0 AND a10.Status = 0 AND ad10.Patient_ID = '#session.cs.patientid#' AND (a10.F26 like '1%' OR a10.F26 like '4%' OR a10.F26 like 'Hospice a%' OR a10.Assmt_ID = '#parent_OASIS.Assmt_ID#') AND a10.f25 = 1 ORDER BY a10.F177 DESC, a10.Assmt_ID DESC LIMIT 10 ) latest_assmt ) AND p.M0_No like 'M102%' GROUP BY p.Problem_ID, p.Item_ID ,p.Assmt_ID ORDER BY a.F177 DESC,a.Assmt_ID ASC, p.dx_order ASC SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.status = 0 AND pProblem.Assmt_ID IN (#ValueList(GtDX.Assmt_ID)#) GROUP BY pProblem.Problem_ID UPDATE #Request.prefix_db_agency#.pOrphan SET status = 1 WHERE Problem_Dx_ID NOT IN (#active_diag#) AND Assmt_ID IN (#ValueList(GtDX.Assmt_ID)#) AND status = 0 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.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.Description NOT LIKE 'GG0%' AND Trim(p.Description) NOT LIKE '(%' AND p.M0_No NOT like 'M102%' GROUP BY p.Problem_ID, p.Item_ID ORDER BY pg.Progress_ID DESC 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, p.Item_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 (, , , , , , , , , ) , UPDATE #Request.prefix_db_agency#.pAssessments SET F320 = 0, Orphan_Field = 0 WHERE Status = 0 AND Assmt_ID IN () SELECT pProblem.*,pAssessments.F27, pProblem.Assmt_ID FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pProblem.Assmt_ID AND pAssessments.Status= 0 WHERE pProblem.status = 0 AND pProblem.Assmt_ID IN () AND pProblem.Skill NOT IN ('HHA') AND pProblem.M0_No NOT like 'CM%' AND pProblem.M0_No NOT like 'M102%' AND pProblem.Description NOT LIKE 'GG0%' AND Trim(pProblem.Description) NOT LIKE '(%' GROUP BY pProblem.Description, pProblem.Assmt_ID SELECT pProblem.*,pAssessments.F27, pProblem.Assmt_ID FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pProblem.Assmt_ID AND pAssessments.Status= 0 WHERE pProblem.status = 0 AND pProblem.Assmt_ID IN () AND pProblem.Skill NOT IN ('HHA') AND pProblem.M0_No NOT like 'CM%' AND pProblem.M0_No like 'M102%' GROUP BY pProblem.Description, pProblem.Assmt_ID SELECT * FROM #Request.prefix_db_agency#.pOrphan WHERE status = 0 AND Assmt_ID IN () SELECT * FROM getsallproblems_batch WHERE Assmt_ID = #geticds_batch.Assmt_ID# SELECT * FROM getorphans_batch WHERE Problem_ID = #getunpairsproblems.Problem_ID# AND Assmt_ID = #geticds_batch.Assmt_ID# AND Problem_Dx_ID = #geticds_batch.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 (, , , , , , , , , ) , UPDATE #Request.prefix_db_agency#.pAssessments SET F320 = 0, Orphan_Field = 0 WHERE Status = 0 AND Assmt_ID IN () SELECT * FROM #Request.prefix_db_agency#.pOrphan WHERE status = 0 AND Assmt_ID IN () GROUP by Orphan_ID ORDER BY Orphan_Auto_ID DESC UPDATE #Request.prefix_db_agency#.pOrphan SET pOrphan.status = 2 WHERE pOrphan.Orphan_ID IN () AND Orphan_Auto_ID NOT IN () AND pOrphan.status = 0
Unstable Symptoms with no Diagnosis and Treatment
Report Orphan Symptoms Dashboard Orphan Symptoms

SELECT p.*,pg.severity,pg.Progress_ID,IFNULL(Left(p.Answer,1),2) AS probSeverity, p.Assmt_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.Assmt_ID IN () AND p.Skill NOT IN ('HHA') AND p.Description NOT LIKE 'GG0%' AND Trim(p.Description) NOT LIKE '(%' AND p.M0_No NOT like 'M102%' GROUP BY p.Problem_ID, p.Item_ID, p.Assmt_ID ORDER BY pg.Progress_ID DESC SELECT (CASE WHEN (pSchedules.Visit_Type = "1 - SOC - SN" ) THEN '1 - Start of care - further visits planned' WHEN (pSchedules.Visit_Type = "1 - SOC - PT" ) THEN '1 - Start of care - further visits planned - Physical Therapy' WHEN (pSchedules.Visit_Type = "1 - SOC - OT" ) THEN '1 - Start of care - further visits planned - Occupational Therapy' WHEN (pSchedules.Visit_Type = "3 - ROC - SN" || pSchedules.Visit_Type = "3 - ROC - PT") THEN '3 - Resumption of care (after inpatient stay)' WHEN (pSchedules.Visit_Type = "PT Eval" ) THEN 'PT Adult Evaluation' WHEN (pSchedules.Visit_Type = "OT Eval" ) THEN 'OT Adult Evaluation' WHEN (pSchedules.Visit_Type = "ST Eval" ) THEN 'ST Adult Evaluation' WHEN (pSchedules.Visit_Type = "SN Eval" ) THEN 'SN Adult Evaluation' WHEN (pSchedules.Visit_Type = "MSW Eval" ) THEN 'MSW Evaluation' WHEN (pSchedules.Visit_Type = "PT FU Eval" ) THEN 'PT Followup' WHEN (pSchedules.Visit_Type = "OT FU Eval" ) THEN 'OT Followup' WHEN (pSchedules.Visit_Type = "ST FU Eval" ) THEN 'ST Followup' WHEN (pSchedules.Visit_Type = "MSW FU Eval" ) THEN 'MSW Followup' WHEN (pSchedules.Visit_Type = "SN FU Eval" ) THEN 'SN Followup' WHEN (pSchedules.Visit_Type = "Hospice Comprehensive" ) THEN 'Hospice Comprehensive' WHEN (pSchedules.Visit_Type = "SN Hospice" ) THEN 'SN Hospice' WHEN (pSchedules.Visit_Type = "Chaplain Comprehensive Evaluation" ) THEN 'Chaplain Comprehensive Evaluation' WHEN (pSchedules.Visit_Type = "Hospice Discharge" ) THEN 'Hospice Discharge' WHEN (pSchedules.Visit_Type = "4 - Recertification" ) THEN '4 - Recertification (follow-up) reassessment' WHEN (pSchedules.Visit_Type = "4 - Recertification PT" ) THEN '4 - Recertification (follow-up) reassessment - PT' WHEN (pSchedules.Visit_Type = "4 - Recertification OT" ) THEN '4 - Recertification (follow-up) reassessment - OT' WHEN (pSchedules.Visit_Type = "5 - Other follow-up" ) THEN '5 - Other follow-up' WHEN (pSchedules.Visit_Type = "6 - Transfer no discharge" ) THEN '6 - Transferred to an inpatient facility - patient not discharged from agency' WHEN (pSchedules.Visit_Type = "7 - Transfer discharged" ) THEN '7 - Transferred to an inpatient facility - patient discharged from agency' WHEN (pSchedules.Visit_Type = "8 - Death" ) THEN '8 - Death at home' WHEN (pSchedules.Visit_Type = "9 - Discharge from agency" ) THEN '9 - Discharge from agency' ELSE pSchedules.Visit_Type END ) AS scheduled_oasis,pSchedules.* FROM #Request.prefix_db_agency#.pSchedules WHERE Status = 0 AND pSchedules.Visit_Date IN () AND pSchedules.Patient_ID IN () AND pSchedules.Followup_visit = 1 AND pSchedules.Emp_ID = SELECT * FROM #Request.prefix_db_agency#.pOrphan WHERE status = 0 AND Assmt_ID IN () GROUP BY Problem_Dx_ID, Assmt_ID select pOrphan.*,pProblem.Description, pOrphan.Assmt_ID from #Request.prefix_db_agency#.pOrphan JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pOrphan.Problem_ID AND pProblem.status = 0 where pOrphan.status = 0 AND pOrphan.Assmt_ID IN () AND pProblem.M0_No NOT like 'CM%' AND pProblem.Description NOT like 'M18%' GROUP BY Orphan_ID SELECT pOrphan.*,pProblem.Description, pOrphan.Assmt_ID from #Request.prefix_db_agency#.pOrphan JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pOrphan.Problem_ID AND pProblem.status = 0 where pOrphan.status = 0 AND pOrphan.Assmt_ID IN () AND pProblem.M0_No NOT like 'CM%' AND pProblem.Description NOT like 'M18%' AND pProblem.Description NOT LIKE 'GG0%' AND Trim(pProblem.Description) NOT LIKE '(%' ORDER BY pProblem.Problem_ID ASC SELECT * FROM Getorphansymptoms_batch WHERE Assmt_ID = SELECT * FROM geassignedemployee_batch WHERE Visit_Date = AND Patient_ID = SELECT * FROM Getorphansymptoms WHERE M0_No like 'CM%' SELECT * FROM getOASISdiagnosis_batch WHERE Assmt_ID =
Patient Diagnoses with Symptoms Diagnoses without Symptoms Orphan Symptoms Case Management
#DateFormat(F176,"yyyymmdd")# #Pt_Last#, #Pt_First#
#F26#
#DateFormat(F176,"mm/dd/yyyy")#


  Submit
not approved

  Submit
not approved
SELECT * from getallPairedsymp_batch WHERE Assmt_ID = SELECT * from getallPairedsymp WHERE Problem_Dx_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;color:blue;" >#getPairedsymp.Description#
SELECT * from getallPairedsymp WHERE 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#

SELECT * from getall_unpaired_batch WHERE Assmt_ID = ORDER BY Problem_ID ASC SELECT * FROM getall_unpaired WHERE Problem = '#Problem#' AND Paired ='Y' ">

#getall_unpaired.Description#

#Description#