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 SELECT c.Item_ID, c.Description, c.Skill, c.Type, a.Admit_ID FROM #Request.prefix_db_agency#.pCareplan c INNER JOIN #Request.prefix_db_agency#.pAssessments a ON a.Assmt_ID = c.Assmt_ID WHERE c.Assmt_ID = AND c.AutoCareplan_ID IN () AND c.Type = UPDATE #Request.prefix_db_agency#.pCareplan SET status = , Date_Change = , Change_by = WHERE Status = 0 AND Type = AND Skill = AND Item_ID = AND Description = AND Assmt_ID IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND Status = 0 ) 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 IN () 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 IN () 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 pAuths.Auth_ID FROM #Request.prefix_db_agency#.pAuths INNER JOIN #Request.prefix_db_agency#.pAssessments pa ON pa.Assmt_ID = pAuths.Assmt_ID AND pa.status = 0 INNER JOIN #Request.prefix_db_agency#.pAssessments cur ON cur.Admit_ID = pa.Admit_ID AND cur.status = 0 WHERE cur.Assmt_ID = AND pAuths.Status = 0 AND IFNULL(pAuths.Visitfreq_Placeholder, 0) = 0 AND pAuths.Skill IN ('OT','OTA','COTA') LIMIT 1 SELECT p.Problem_ID, p.Description AS ProblemDescription, p.Answer AS ProblemAnswer, p.Severity AS ProblemSeverity, p.Path_ID AS Pathway_ID, p.Item_ID AS Lookup_Item_ID, ( SELECT t.Item_ID_Goal FROM #Request.prefix_db_lookup#.Assmt_Update_Therapy1 t WHERE t.Pathway_ID = p.Path_ID AND t.Source = AND t.`Update` = AND ( t.Problem LIKE OR t.Problem LIKE ) AND ( p.Description = t.Problem OR p.Item_ID = t.Item_ID ) ORDER BY (p.Description = t.Problem) DESC, t.ID ASC LIMIT 1 ) AS Item_ID_Goal FROM #Request.prefix_db_agency#.pProblem p WHERE p.Assmt_ID = AND p.Status = AND p.Skill = AND p.M0_No NOT LIKE AND ( p.Description LIKE OR p.Description LIKE OR p.M0_No = ) ORDER BY p.Problem_ID DESC SELECT AutoCareplan_ID, Careplan_ID, Status, Description FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Skill = AND Type = AND Status = AND ( LCase(Trim(SUBSTRING_INDEX(Description, '-', 1))) = OR Description LIKE ) SELECT AutoCareplan_ID, Careplan_ID, Status FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Skill = AND Type = AND Description = AND Status IN () SELECT * FROM getExistingTherapyGoal WHERE Status = 0 SELECT Item_ID, Order_ID FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID = AND Type = LIMIT 1 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 * 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#.#Request.assessment_answers_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#) OR ( pProblem.Description LIKE 'GG%' AND pProblem.M0_No NOT LIKE 'M102%' ) ) 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 < SELECT MAX(CMSOrder_ID) AS CMSOrder_ID FROM getcareplans INSERT INTO #Request.prefix_db_agency#.pCareplan ( Careplan_ID, Assmt_ID,Incrmt1, Item_ID, Order_ID, Goal_ID, CMSOrder_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 SELECT IFNULL(MAX(CMSOrder_ID),0) AS CMSOrder_ID FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Skill = AND Type = AND Description = INSERT INTO #Request.prefix_db_agency#.pCareplan ( Careplan_ID, Assmt_ID, Item_ID, Order_ID, CMSOrder_ID, Status, Skill, Type, Description, Date_Target, Date_Create, Created_by, Date_Change, Change_by ) 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) 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_Resolve = NULL, Date_Change = , Change_by = WHERE Careplan_ID = AND Status = 0