SELECT IFNULL(Careplan_ID,0) as pCareplan_ID, pCareplan.* FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Type = AND Skill = AND Status = AND Description = SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.Assmt_ID = AND pProblem.Skill = AND pProblem.Path_ID = Order by M0_No ASC UPDATE #Request.prefix_db_agency#.pCareplan SET status = , Date_Change = , Change_by = WHERE Assmt_ID = AND AutoCareplan_ID IN () UPDATE #Request.prefix_db_agency#.pCareplan SET status = , CMSOrder_ID = 0, Date_Change = , Change_by = WHERE Assmt_ID = AND AutoCareplan_ID IN () UPDATE #Request.prefix_db_agency#.pCareplan SET Specifics = , Date_Change = , Change_by = WHERE AutoCareplan_ID = AND Assmt_ID = UPDATE #Request.prefix_db_agency#.pCareplan SET Date_Resolve = , goal_met = , Date_Change = , Change_by = WHERE Assmt_ID = AND Careplan_ID = AND status = 0 UPDATE #Request.prefix_db_agency#.pCareplan SET status = , Date_Change = , Change_by = WHERE Assmt_ID = AND Item_ID = AND Skill = AND AutoCareplan_ID = SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID = AND status = AND Path_ID = AND Skill = '#arguments.Skill#' SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND status = ORDER BY F176 DESC SELECT * FROM #Request.prefix_db_lookup#.Assmt_Update_Therapy1 WHERE Source = AND Assmt_Update_Therapy1.Update = AND Pathway_ID = '#arguments.Pathway_ID#' AND Problem = '#getproblem.Description#' AND Severity = '#getproblem.Severity#' SELECT #FieldID1# AS Fieldanswer1,#FieldID2# AS Fieldanswer2 FROM getallOASIS WHERE F26 = '#assmnt_reason#' UPDATE #Request.prefix_db_agency#.pProblem SET problem_Incrmt1 = WHERE Problem_ID = AND status = SELECT IFNULL(Careplan_ID,0) as pCareplan_ID, pCareplan.* FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Type = arguments.Skill NEQ 0> AND Skill = AND Status = AND Description = AND pCareplan.CMSOrder_ID = 0 SELECT IFNULL(Careplan_ID,0) as pCareplan_ID, pCareplan.*,pPathway.Header FROM #Request.prefix_db_agency#.pCareplan LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pCareplan.Item_ID WHERE pCareplan.Assmt_ID = AND pCareplan.Type = AND pPathway.Approved = NULL AND pCareplan.Skill = AND pCareplan.Status = AND pCareplan.Description = ORDER BY pPathway.Type_Order,pPathway.Order_ID ASC SELECT IFNULL(Problem_ID,0) as pProblem_ID, pProblem.*, RIGHT(M0_No, 1) as proborder_id FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID = AND Path_ID = AND M0_No = AND M0_No like 'M102%' AND Skill = AND pProblem.CMSOrder_ID = 0 AND Status = ORDER BY dx_order,RIGHT(M0_No, 1) ASC SELECT pCareplan.*,pCareplan.Type AS careplantype, pPathway.Param,pPathway.Pathway_ID,pPathway.Type_Order,pPathway.Order_ID,pPathway.Type as pathwaytype , pPathway.Header, pPathway.Header_No ,(SELECT GROUP_CONCAT(RIGHT(pProblem.dx_order, 2)) as order_ids FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.Path_ID = pPathway.Pathway_ID AND pProblem.Assmt_ID= AND pProblem.Skill = AND pProblem.Status = ) AS order_ids FROM #Request.prefix_db_agency#.pCareplan LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pCareplan.Item_ID AND pPathway.Type = pCareplan.Type WHERE pCareplan.Assmt_ID = AND pCareplan.Skill = AND pPathway.pathway_ID IN () AND pCareplan.Status = AND pCareplan.CMSOrder_ID = 0 GROUP BY pCareplan.AutoCareplan_ID ORDER BY Header_No ASC, pPathway.Type_Order,pPathway.Order_ID ASC SELECT * FROM #Request.prefix_db_lookup#.pTherapyDx WHERE Skill = AND Path_ID = SELECT * FROM #Request.prefix_db_lookup#.pMessage WHERE form_name = AND deleted != 1 ORDER BY message_id SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE AutoCareplan_ID = INSERT INTO #Request.prefix_db_agency#.pCareplan ( Careplan_ID, Assmt_ID, Item_ID, Order_ID,Incrmt1,Goal_ID, Status, Skill, Type, Description,Param_Lo,Param_Hi,Param_Other,Notes, Date_Target,Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , , , , ) SELECT pCareplan.*,pPathway.Param,pPathway.Pathway_ID,pPathway.Type_Order,pPathway.Order_ID,pPathway.Type as pathwaytype , pPathway.Header, pPathway.Header_No ,pPathway.Value as Measurevalue FROM #Request.prefix_db_agency#.pCareplan JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pCareplan.Item_ID WHERE pCareplan.Assmt_ID = AND pCareplan.Skill = AND pCareplan.Status = AND pCareplan.Type = AND pCareplan.Description = 'add patient-stated goal' AND pCareplan.Description = 'add discharge plan' AND pPathway.Param = 'Lo-Hi' AND (pCareplan.Param_Lo ='' OR pCareplan.Param_Lo IS NULL OR pCareplan.Param_Hi IS NULL OR pCareplan.Param_Hi ='') GROUP BY pCareplan.AutoCareplan_ID SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE ID = UPDATE #Request.prefix_db_agency#.pWoundsVitals SET Param_Lo =, Param_Hi= , Date_Change = , Change_by = WHERE ID = SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = AND Status = 0 AND VitalOrWound = 'vital' AND (Param_Lo IS NULL OR Param_Hi IS NULL) SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE AutoProblem_ID = UPDATE #Request.prefix_db_agency#.pProblem SET status = , Date_Change = , Change_by = WHERE Assmt_ID = AND AutoProblem_ID IN () INSERT INTO #Request.prefix_db_agency#.pProblem ( Problem_ID, Assmt_ID, Status, Path_ID,Skill, M0_No, dx_order, Severity, Description, Notes,Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , ) UPDATE #Request.prefix_db_agency#.pProblem SET status = , Date_Change = , Change_by = WHERE Assmt_ID = AND AutoProblem_ID IN () UPDATE #Request.prefix_db_agency#.pProblem SET status = , Date_Change = , Change_by = WHERE Assmt_ID = AND AutoProblem_ID IN () SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.Assmt_ID = AND Skill = AND Status = ORDER BY RIGHT(M0_No, 1) ASC SELECT Patient_ID, Pt_Last AS Last_Name, Pt_First AS First_Name, Pt_Middle AS Middle ,pPatients.* FROM #Request.prefix_db_agency#.pPatients WHERE Patient_Id = SELECT * FROM #Request.prefix_db_agency#.pCMS4857 WHERE Assmt_ID IN () AND Status = 0 AND Form_Type like '%Form 485%' SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE status = AND Assmt_ID = SELECT * FROM #Request.prefix_db_agency#.pProgress WHERE Assmt_ID IN () AND Status = 0 AND Schedule_ID IN (SELECT Schedule_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Assmt_ID = "#getass.Assmt_ID#" AND status = 0 AND Missed =0 AND Skill = '#arguments.Skill#') AND getpgnotes.recordcount EQ 0 > UPDATE #Request.prefix_db_agency#.pCareplan SET Status = 2 WHERE Assmt_ID = AND Skill = AND status = AND Type IN () AND (Description like '%-%' OR Type ="procedure") AND pCareplan.Date_Create = pCareplan.Date_Change AND (Notes IS NULL OR length(Notes) =0 ) AND status = 0 AND Date_Resolve IS NULL SELECT (SELECT pa.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments pa WHERE pAssessments.Admit_ID = pa.Admit_ID AND pa.status = 0 AND pa.F26 like 'PT Adult%' ORDER BY pa.Assmt_ID DESC LIMIT 1) AS PT, (SELECT pa.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments pa WHERE pAssessments.Admit_ID = pa.Admit_ID AND pa.status = 0 AND pa.F26 like 'OT Adult%' ORDER BY pa.Assmt_ID DESC LIMIT 1) AS OT FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND status = SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = #get_OASIS.OT# AND status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = #get_OASIS.PT# AND status = 0 SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.status = AND (M0_No like 'M1021%' OR M0_No like 'M1023%') AND (pProblem.hospice = 1 OR pProblem.hospice IS NULL) AND pProblem.Assmt_ID = AND pProblem.Status = AND pProblem.Skill = AND LEFT(pProblem.Severity,1) > '1' ORDER BY RIGHT(M0_No, 1) ASC SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem LEFT OUTER JOIN #Request.prefix_db_lookup#.assessment_answers_lookup ON assessment_answers_lookup.Item_ID = pProblem.Item_ID AND assessment_answers_lookup.question_id = pProblem.ques_id WHERE Assmt_ID = AND status = GROUP BY Problem_ID SELECT p.* FROM #Request.prefix_db_agency#.pProblem p WHERE p.status = 0 AND p.Assmt_ID = AND p.Skill IN () 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.Problem_ID NOT IN (#Request.questions_problemids#) AND p.M0_No NOT like 'M102%' GROUP BY p.Problem_ID SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.status = AND pProblem.Problem_ID IN (#Request.questions_problemids#) AND pProblem.M0_No NOT like 'M1021%' AND pProblem.M0_No NOT like 'M1023%' AND pProblem.Assmt_ID = AND pProblem.Status = AND pProblem.Skill = ORDER BY RIGHT(M0_No, 1) ASC SELECT * FROM getDX WHERE Assmt_ID IN (#arguments.Assmt_ID#) AND (M0_No like 'M1021%' OR M0_No like 'M1023%') AND (Careplan = 0 OR Severity < 2) SELECT * FROM getDX WHERE AutoProblem_ID IN (#arguments.problem_id#) AND M0_No like 'M1021%' ORDER BY dx_order ASC SELECT * FROM getDX WHERE Assmt_ID IN (#arguments.Assmt_ID#) AND M0_No like 'M1023%' ORDER BY dx_order ASC SELECT *,n.Med_ID AS MedID from #Request.prefix_db_agency#.pPtmeds m, #Request.prefix_db_agency#.pProblem p, #Request.prefix_db_lookup#.meds_pathway_lookup l, #Request.prefix_db_lookup#.Meds_New n where m.Drug_ID = n.Trade_Num and n.Med_ID = l.Med_ID and l.Path_ID = p.Path_ID and m.Patient_ID = and p.Assmt_ID = and m.status = 0 and p.status = 0 GROUP BY PtMeds_ID SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND status = AND Admit_ID = AND LEFT(F26,1) IN ('1','4') AND F178 <= AND status = 0 ORDER BY F178 DESC SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Status = AND Assmt_ID = "#oldassementid#" AND Type = 'goal' AND Date_Resolve IS NOT NULL ORDER BY Careplan_ID ASC SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Type = "goal""#pathwaytype#" AND (Pathway_ID IN () AND Header = 'Vital Signs' OR pPathway.Patient_ID = #session.cs.patientid#) AND (Type_Order != '1' OR Type != 'symptom') AND (Pathway_ID IN () OR ( pPathway.Patient_ID = #session.cs.patientid# AND pPathway.Agency_ID = "#session.agencyid#")) AND pPathway.Item_ID NOT IN (#resolved_goals#) and (Severity NOT IN (0,1) OR Severity IS NULL) AND ( pPathway.Approved = 'Yes' OR ( pPathway.Patient_ID = #session.cs.patientid# AND pPathway.Agency_ID = "#session.agencyid#")) AND TRIM(SUBSTRING_INDEX(Description, '-', 1)) NOT IN (SELECT TRIM(SUBSTRING_INDEX(Description, '-', 1)) FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND status < 2 AND Skill = AND Type ="goal""#pathwaytype#") GROUP BY Description ORDER BY Order_ID SELECT IFNULL(Careplan_ID,0) as pCareplan_ID, pCareplan.* FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Type = AND Skill = AND Status = SELECT IFNULL(Careplan_ID,0) as pCareplan_ID, pCareplan.* FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Type = AND Status = AND Item_ID = AND Description = SELECT IFNULL(Careplan_ID,0) as pCareplan_ID, pCareplan.* FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Type = AND Skill = AND Item_ID = GROUP BY Careplan_ID ORDER BY Status ASC SELECT pPathway.Incrmt1,pProblem.Problem_ID FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Pathway_ID = pProblem.Path_ID AND pPathway.Description = CONCAT(pProblem.Description, ' - ', pProblem.Severity) WHERE pProblem.Assmt_ID = AND pProblem.status = AND pProblem.Path_ID = AND pProblem.Skill = '#arguments.Skill#' AND pProblem.Description like 'GG%' UPDATE #Request.prefix_db_agency#.pProblem SET problem_Incrmt1 = WHERE Problem_ID = AND status = SELECT * FROM getcareplans WHERE Status IN (0,1,3) Status < INSERT INTO #Request.prefix_db_agency#.pCareplan ( Careplan_ID, Assmt_ID,Incrmt1, Item_ID, Order_ID, Goal_ID, Status, Skill, Type, Description,Date_Target, Notes, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , ) SELECT LAST_INSERT_ID() as AutoCareplan_ID SELECT IFNULL(MAX(Careplan_ID),0)+1 As pCareplan_ID FROM #Request.prefix_db_agency#.pCareplan INSERT INTO #Request.prefix_db_agency#.pCareplan ( Careplan_ID, Assmt_ID,Incrmt1, Item_ID, Order_ID, Goal_ID, Status, Skill, Type, Description,Date_Target, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , ) SELECT LAST_INSERT_ID() as AutoCareplan_ID SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Type = 'standing_order' AND Skill = '#arguments.Skill#' AND Status = 0 SELECT * FROM #Request.prefix_db_lookup#.pStanding_Orders WHERE Agency_ID = AND Status = 0 SELECT * FROM getcareplans WHERE Status < 2 INSERT INTO #Request.prefix_db_agency#.pCareplan ( Careplan_ID, Assmt_ID, Item_ID, Order_ID, Status, Skill, Type, Description,Date_Target, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , ) SELECT LAST_INSERT_ID() as AutoCareplan_ID SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID IN () AND Type = AND (Approved IS NULL OR Approved = 'Yes') GROUP BY Description ORDER BY Order_ID SELECT IFNULL(MAX(Careplan_ID),0)+1 As pCareplan_ID FROM #Request.prefix_db_agency#.pCareplan INSERT INTO #Request.prefix_db_agency#.pCareplan ( Careplan_ID, Assmt_ID, Item_ID, Order_ID, Status, Skill, Type, Description,Date_Target, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , ) SELECT LAST_INSERT_ID() as AutoCareplan_ID UPDATE #Request.prefix_db_agency#.pCareplan pc, #Request.prefix_db_agency#.pVital_Param vp SET pc.Param_Lo = vp.Value_Low, pc.Param_Hi = vp.Value_High WHERE pc.Assmt_ID = AND pc.Skill = AND pc.status = AND pc.Type = AND pc.Item_ID = vp.Item_ID UPDATE #Request.prefix_db_agency#.pCareplan SET Status = 1 WHERE Assmt_ID = AND Skill = AND status = AND Type = AND Item_ID IN (SELECT Item_ID FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID IN (#disablepathwayids#) AND Type = 'goal' ) AND status = 0 UPDATE #Request.prefix_db_agency#.pCareplan SET Status = 0 WHERE Assmt_ID = AND Skill = AND status = AND Type = AND Item_ID NOT IN (SELECT Item_ID FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID IN (#disablepathwayids#) AND Type = 'goal' ) AND status = 1 request.ass = CreateObject("component","components.general.assessments").init(); getgoalsuccess = request.ass.updategoals_visit(#arguments.Assmt_ID#); SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID = AND status = 0 AND Skill = AND M0_No IN ('wound','SK') AND Description LIKE '##%' AND Description IS NOT NULL AND Description <> '' ORDER BY AutoProblem_ID ASC SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Skill = AND Type = AND Description = AND Status = 0 SELECT IFNULL(MAX(Careplan_ID),0)+1 As pCareplan_ID FROM #Request.prefix_db_agency#.pCareplan INSERT INTO #Request.prefix_db_agency#.pCareplan ( Careplan_ID, Assmt_ID, Item_ID, Order_ID, Status, Skill, Type, Description, Date_Target, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , ) SELECT *,n.Med_ID AS MedID FROM #Request.prefix_db_agency#.pPtmeds m JOIN #Request.prefix_db_lookup#.Meds_New n ON m.Drug_ID = n.Trade_Num WHERE m.Patient_ID = AND m.status = 0 AND m.PtMeds_ID IN () SELECT * FROM #Request.prefix_db_agency#.pCareplan_Meds WHERE Patient_ID = AND status = 0 SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE status = 0 AND Problem_ID IN () SELECT * FROM getcareplanmeds WHERE Patient_ID = AND Problem_ID = AND status = AND Pt_Meds_ID = INSERT INTO #Request.prefix_db_agency#.pCareplan_Meds ( Patient_ID, Problem_ID, Pt_Meds_ID, Med_ID, Description, Drug_Name ) VALUES ( , , , , , ) INSERT INTO #Request.prefix_db_lookup#.meds_pathway_lookup ( Med_ID, Trade_Num, Generic_Name, Path_ID, Agency_ID, Patient_ID, Emp_ID, Date_Created ) VALUES ( , , , , , , , ) SELECT *,IFNULL(n.Med_ID,0) AS MedID,IFNULL(n.Trade_Num,24000) AS Trade_Nums FROM #Request.prefix_db_agency#.pPtmeds m LEFT OUTER JOIN #Request.prefix_db_lookup#.Meds_New n ON m.Drug_ID = n.Trade_Num WHERE m.Patient_ID = AND m.status < 2 AND m.PtMeds_ID IN () SELECT * FROM #Request.prefix_db_agency#.pCareplan_Meds WHERE Patient_ID = AND status = 0 SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE status = 0 AND Problem_ID IN () SELECT * FROM getcareplanmeds WHERE Patient_ID = AND Problem_ID = AND status = AND Pt_Meds_ID = SELECT * FROM #Request.prefix_db_lookup#.meds_pathway_lookup WHERE Patient_ID = AND Med_ID = "#MedID#" AND Agency_ID = INSERT INTO #Request.prefix_db_agency#.pCareplan_Meds ( Patient_ID, Problem_ID, Pt_Meds_ID, Med_ID, Description, Drug_Name ) VALUES ( , , , , , ) SELECT LAST_INSERT_ID() as pCareplan_MedsID INSERT INTO #Request.prefix_db_lookup#.meds_pathway_lookup ( Med_ID, Trade_Num, Generic_Name, Path_ID, Agency_ID, Patient_ID,Approved, Emp_ID, Date_Created ) VALUES ( , , , , , , , , ) SELECT LAST_INSERT_ID() as pmeds_MedsID UPDATE #Request.prefix_db_agency#.pCareplan_Meds SET status = WHERE ID NOT IN () AND Patient_ID = DELETE FROM #Request.prefix_db_lookup#.meds_pathway_lookup WHERE ID NOT IN () AND Patient_ID = AND Agency_ID = SELECT * FROM #Request.prefix_db_agency#.pCareplan_Meds WHERE Patient_ID = AND Pt_Meds_ID IN () AND status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.vetted_190924 ON pProblem.Description = vetted_190924.Diagnosis WHERE pProblem.Assmt_ID = AND pProblem.Skill = AND pProblem.status = AND pProblem.M0_No like 'M102%' AND (pProblem.hospice = 1 OR pProblem.hospice IS NULL) AND (pProblem.Severity > 1 AND vetted_190924.ICD NOT like 'Z%') ORDER BY RIGHT(M0_No, 1) ASC SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.vetted_190924 ON pProblem.Description = vetted_190924.Diagnosis WHERE pProblem.Assmt_ID = AND pProblem.Skill = AND pProblem.status = AND pProblem.M0_No like 'M102%' AND (pProblem.hospice = 1 OR pProblem.hospice IS NULL) AND pProblem.Severity <= 1 ORDER BY RIGHT(M0_No, 1) ASC SELECT * FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.vetted_190924 ON pProblem.Description = vetted_190924.Diagnosis WHERE pProblem.Assmt_ID = AND pProblem.status = AND pProblem.M0_No like 'M1021%' AND vetted_190924.PDGM IS NOT NULL SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = ORDER BY Record_Creation_Date ASC ((assessment_reason EQ '1 - Start of care - further visits planned' AND arguments.Skill EQ 'SN') OR (assessment_reason EQ '1 - Start of care - further visits planned - Physical Therapy' AND arguments.Skill EQ 'PT') OR (assessment_reason EQ '1 - Start of care - further visits planned - Occupational Therapy' AND arguments.Skill EQ 'OT') OR (assessment_reason EQ 'PT Adult Evaluation' AND arguments.Skill EQ 'PT') OR (LEFT(assessment_reason,1) EQ '4' AND arguments.Skill EQ assessment_skill) ) > " /> Orphan Symptoms to view" > SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = AND Orphan_Field IN (0,2) 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 p.*, pt.*,a.AutoAssmt_ID,a.Admit_ID,a.Assmt_ID,a.F26,a.F176,a.F27, a.F320 AS QA_View 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 = 0 AND a.status = 0 AND p.status = 0 AND p.Assmt_ID = AND (a.F26 like '1%' OR a.F26 like '4%') AND a.f25 = 1 AND ad.M0030_START_CARE_DT >= '2024-10-01' AND p.M0_No like 'M102%' GROUP BY p.Problem_ID,p.Assmt_ID ORDER BY a.F177 DESC, p.dx_order ASC SELECT c.* , REPLACE(REPLACE(REPLACE(c.Memo, '&', ''), '<', ''), '>', '') AS comm_memo FROM #Request.prefix_db_agency#.Communication c JOIN #Request.prefix_db_agency#.CommunicationSubjects cs on cs.CommSub_Id = c.CommSub_Id WHERE c.Patient_ID = #session.cs.patientid# AND cs.Subject like 'symptoms with no related diagnosis' ORDER BY Subject select pOrphan.* 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.Problem_Dx_ID = '#Problem_ID#' AND pOrphan.Paired = 'Y' AND pProblem.M0_No NOT IN ('CM') GROUP BY Orphan_ID select * 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.Problem_Dx_ID = '#Problem_ID#' AND pOrphan.Assmt_ID = '#Assmt_ID#' and pOrphan.Paired='Y' AND pProblem.M0_No NOT IN ('CM') GROUP BY Orphan_ID SELECT pOrphan.*,REPLACE(REPLACE(REPLACE(pOrphan.Problem, '&', ''), '<', ''), '>', '') AS orphan_Problem 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 = '#Assmt_ID#' AND pProblem.M0_No NOT IN ('CM') AND pProblem.Description NOT LIKE 'GG0%' AND Trim(pProblem.Description) NOT LIKE '(%' ORDER BY pOrphan.Problem ASC SELECT * FROM getall_unpaired WHERE Problem = '#Problem#' AND Paired ='Y' ", "", "all") /> SELECT * FROM GetComms WHERE comm_memo like '%#tempDescription#%' SELECT * FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.vetted_190924 ON pProblem.Description = vetted_190924.Diagnosis WHERE pProblem.Assmt_ID = AND pProblem.status = AND pProblem.M0_No like 'M1021%' AND vetted_190924.PDGM IS NOT NULL SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Skill = AND Goal_ID = AND Status < 2 AND Goal_ID != 0 UPDATE #Request.prefix_db_agency#.pCareplan SET Goal_ID = , Date_Change = , Change_by = WHERE AutoCareplan_ID = AND Assmt_ID = AND Skill = AND Status = 0 UPDATE #Request.prefix_db_agency#.pCareplan SET goal_met = , Date_Resolve = , Date_Change = , Change_by = WHERE AutoCareplan_ID = AND Status = 0 UPDATE #Request.prefix_db_agency#.pCareplan SET goal_met = , Date_Resolve = , Date_Resolve = NULL, Date_Change = , Change_by = WHERE Careplan_ID = AND Status = 0