pathwaydash = CreateObject("Component", "pathway"); Visit_Count = pathwaydash.get_pAuth(#arguments.Assmt_ID#, #arguments.Skill#); UPDATE #Request.prefix_db_agency#.pProgress SET Status = WHERE Assmt_ID = AND Schedule_ID IN ( SELECT Schedule_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Patient_ID = AND Skill = ) SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Auth_ID = AND Skill = AND Status = ORDER BY Visit_no ASC INSERT IGNORE INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Description,Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , ) SELECT * FROM #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail CW LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules pS ON CW.goals = pS.Visit_no WHERE CW.problems = AND CW.total_visits = AND pS.Auth_ID = AND pS.Skill = AND pS.Status = ORDER BY CW.visit_no ASC INSERT IGNORE INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Description,Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , ) pathwaydash = CreateObject("Component", "pathway"); Visit_Count = pathwaydash.get_pAuth(#arguments.Assmt_ID#, #arguments.Skill#); UPDATE #Request.prefix_db_agency#.pProgress SET Status = WHERE Assmt_ID = AND Schedule_ID = AND Schedule_ID IN ( SELECT Schedule_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Patient_ID = AND Skill = ) AND Status = 0 SELECT pSchedules.*,pAssessments.F26,pAssessments.F27, pAssessments.Admit_ID FROM #Request.prefix_db_agency#.pSchedules LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.status = 0 WHERE pSchedules.Skill = AND pSchedules.Schedule_ID = AND pSchedules.Status = GROUP BY pSchedules.Schedule_ID ORDER BY pSchedules.Visit_no ASC INSERT IGNORE INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , ) Description DOES NOT CONTAIN '01.' AND Description DOES NOT CONTAIN '02.' AND Description DOES NOT CONTAIN '03.' AND Description DOES NOT CONTAIN '04.' AND Description DOES NOT CONTAIN '05.' AND Description DOES NOT CONTAIN '06.'> INSERT IGNORE INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , ) )> INSERT IGNORE INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Incrmt1, Type, Description,Status,Visit_no,YesOrNo, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , 40, , , , ) SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.Assmt_ID IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = '#getschedule.Admit_ID#' AND Status = 0) AND ( pProblem.Skill = OR (pProblem.Description like '##%' AND pProblem.Skill != 'HHA')) AND pProblem.Status = AND M0_No NOT lIKE 'M1021%' AND M0_No NOT lIKE 'M1023%' AND Description NOT LIKE '(%' AND Description NOT LIKE '##%' SELECT * FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID = AND (Description = ) AND Status = AND Assmt_ID = SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Description = INSERT INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , ) SELECT * FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID = AND Type = AND Status = AND Assmt_ID = INSERT INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , ) SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = AND VitalOrWound = AND Status = SELECT * FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID = AND Type = AND Status = AND Assmt_ID = AND ITem_ID = INSERT INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description, Value_1, Value_2, Value_Sum, Physician_alert, Notes, Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , , ) SELECT * FROM #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail CW LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules pS ON CW.visit_no = pS.Visit_no WHERE CW.problems = AND CW.total_visits = AND pS.Auth_ID = AND pS.Skill = AND pS.Status = AND pS.Schedule_ID = ORDER BY CW.visit_no ASC SELECT * FROM getproblem WHERE proborder_id = AND status = pathwaydash = CreateObject("Component", "pathway"); getpathway = pathwaydash.getspathway(#Path_ID#,#careplan_type#,#arguments.Assmt_ID#); SELECT * FROM getpathwaycareplans WHERE Item_ID IN () AND status = AND Type = AND pathwaytype = INSERT IGNORE INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , ) SELECT * FROM #Request.prefix_db_agency#.pProgress JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pProgress.Careplan_ID AND pProgress.Status = AND pProblem.Status = AND pProgress.Assmt_ID = pProblem.Assmt_ID AND pProgress.Assmt_ID = GROUP BY pProblem.M0_No SELECT * FROM #Request.prefix_db_lookup#.pProgress_Unstable pu WHERE pu.system NOT IN () INSERT INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , ) SELECT pSchedules.* FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Patient_ID = AND pSchedules.Visit_Date < '#getschedule.Visit_Date#' AND pSchedules.Visit_Type IS NULL AND pSchedules.Skill = '#getschedule.Skill#' AND pSchedules.Missed = 0 AND pSchedules.Status = AND pSchedules.Assmt_ID IN (SELECT pAssessments.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 WHERE pAssessments.Admit_ID = "#getschedule.Admit_ID#" AND pAssessments.status = 0 ) ORDER BY Visit_Date DESC SELECT pProgress.* FROM #Request.prefix_db_agency#.pProgress WHERE pProgress.Status = AND pProgress.Schedule_ID = AND (pProgress.Description like 'GG%' OR pProgress.Type = 'goal') SELECT SUBSTRING(REPLACE(SUBSTRING(SUBSTRING_INDEX(pCareplan.Description, '- 0', 2),LENGTH(SUBSTRING_INDEX(pCareplan.Description, '- 0', 1)) + 1), '- 0', ''),1,1) AS GG_severity,pProgress.* FROM #Request.prefix_db_agency#.pProgress JOIN #Request.prefix_db_agency#.pProblem ON pProgress.Careplan_ID = pProblem.Problem_ID AND pProblem.Status = 0 JOIN pPathway ON pPathway.Pathway_ID = pProblem.Path_ID AND pPathway.type = 'goal' AND pPathway.Header IS NOT NULL JOIN #Request.prefix_db_agency#.pCareplan ON pCareplan.Item_ID = pPathway.Item_ID AND pCareplan.Assmt_ID = pProgress.Assmt_ID AND pCareplan.status = 0 WHERE pProgress.Status = 0 AND pProgress.Schedule_ID = AND pProblem.Assmt_ID IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = '#getschedule.Admit_ID#' AND Status = 0) AND (pProgress.Description like 'GG%') GROUP BY pProgress.Progress_ID SELECT * FROM getcurrent_pgnotes WHERE (Careplan_ID = '#Careplan_ID#' OR Description = '#Description#') UPDATE #Request.prefix_db_agency#.pProgress SET severity = '#getlast_pgnotes.severity#', Physician_alert = '#getlast_pgnotes.Physician_alert#', YesOrNo = '#getlast_pgnotes.YesOrNo#', Notes = '#getlast_pgnotes.Notes#' WHERE Schedule_ID = #getcurrentpg.Schedule_ID# AND (Careplan_ID = '#getcurrentpg.Careplan_ID#' OR Description = '#getcurrentpg.Description#') AND status = 0 INSERT INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, severity, Physician_alert, YesOrNo,Notes, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , ) SELECT pProgress.* FROM #Request.prefix_db_agency#.pProgress WHERE pProgress.Status = AND pProgress.Schedule_ID = AND pProgress.Type = 'goal' ORDER BY Progress_ID ASC SELECT * FROM getlast_allpgnotesgoals WHERE (YesOrNo < '4' OR YesOrNo IS NULL) SELECT * FROM getcurrent_pgnotes WHERE (Careplan_ID = '#Careplan_ID#' OR Description = '#Description#') UPDATE #Request.prefix_db_agency#.pProgress SET severity = '#getlast_pgnotesgoals.severity#', activate = '#getlast_pgnotesgoals.activate#', Physician_alert = '#getlast_pgnotesgoals.Physician_alert#', YesOrNo = '#getlast_pgnotesgoals.YesOrNo#', Notes = '#getlast_pgnotesgoals.Notes#' WHERE Schedule_ID = #getcurrentpg.Schedule_ID# AND (Careplan_ID = '#getcurrentpg.Careplan_ID#' OR Description = '#getcurrentpg.Description#') AND status = 0 INSERT INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, severity, Physician_alert, YesOrNo,Notes, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , ) SELECT pProgress.*,pSchedules.QA_View FROM #Request.prefix_db_agency#.pProgress JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Schedule_ID = pProgress.Schedule_ID JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Assmt_ID = pSchedules.Assmt_ID AND pProblem.status =0 AND pSchedules.Status = 0 WHERE pProgress.Status = AND pProgress.Schedule_ID = AND pProgress.Type = 'problem' AND pProblem.Assmt_ID IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = '#getschedule.Admit_ID#' AND Status = 0) AND healing_stage is not null ORDER BY Progress_ID ASC SELECT pProgress.* FROM #Request.prefix_db_agency#.pProgress WHERE pProgress.Status = AND pProgress.Schedule_ID = AND (pProgress.Description like '##%' OR pProgress.Type = 'problem') SELECT * FROM getcurrent_woundsnotes WHERE (Careplan_ID = '#Careplan_ID#' OR Description = '#Description#') UPDATE #Request.prefix_db_agency#.pProgress SET Value_1 = '#getlast_pgnoteswounds.Value_1#', Value_2 = '#getlast_pgnoteswounds.Value_2#', Value_3 = '#getlast_pgnoteswounds.Value_3#', Value_Sum = '#getlast_pgnoteswounds.Value_Sum#', healing_stage = '#getlast_pgnoteswounds.healing_stage#', severity = '#getlast_pgnoteswounds.severity#', Date_Change = #now()# WHERE Schedule_ID = '#getcurrentpgwounds.Schedule_ID#' AND (Careplan_ID = '#getcurrentpgwounds.Careplan_ID#' OR Description = '#getcurrentpgwounds.Description#') AND status = 0 INSERT INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, Value_1,Value_2,Value_3,Value_Sum,healing_stage, severity,Physician_alert,Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , , , , ) SELECT pCareplan.* FROM #Request.prefix_db_agency#.pCareplan WHERE pCareplan.Status = AND pCareplan.Assmt_ID = AND Skill = '#getschedule.Skill#' AND pCareplan.Type = 'goal' AND Date_Resolve IS NOT NULL AND Description NOT like '%01.%' AND Description NOT like '%02.%' AND Description NOT like '%03.%' AND Description NOT like '%04.%' AND Description NOT like '%05.%' AND Description NOT like '%06.%' SELECT * FROM getcurrent_pgnotes WHERE (Careplan_ID = '#Careplan_ID#' OR Description = '#Description#') INSERT INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, YesOrNo,Notes, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , ) SELECT pProgress.* FROM #Request.prefix_db_agency#.pProgress JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pProgress.Careplan_ID AND pProblem.Status = 0 JOIN pPathway ON pPathway.Pathway_ID = pProblem.Path_ID AND pPathway.Type = 'goal' JOIN #Request.prefix_db_agency#.pCareplan ON pCareplan.Item_ID = pPathway.Item_ID AND pCareplan.Assmt_ID = pProgress.Assmt_ID AND pCareplan.status = 0 AND pCareplan.Date_Resolve IS NOT NULL WHERE pProgress.Status = AND pProgress.Schedule_ID = AND pProblem.Assmt_ID IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = '#getschedule.Admit_ID#' AND Status = 0) AND (pProgress.Description like 'GG%') SELECT pProgress.* FROM #Request.prefix_db_agency#.pProgress JOIN #Request.prefix_db_agency#.pCareplan ON pCareplan.Careplan_ID = pProgress.Careplan_ID AND pCareplan.status = 0 AND pCareplan.Date_Resolve IS NOT NULL WHERE pProgress.Status = AND pProgress.Schedule_ID = AND pProgress.Type = 'goal' AND (pProgress.Description NOT like 'GG%') SELECT pPathway.*,pCareplan.Date_Resolve FROM #Request.prefix_db_agency#.pCareplan JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pCareplan.Careplan_ID AND pProblem.Status = 0 JOIN pPathway ON pPathway.Pathway_ID = pProblem.Path_ID AND pPathway.Type = 'goal' WHERE pCareplan.Careplan_ID = #Careplan_ID# AND pCareplan.status = 0 UPDATE #Request.prefix_db_agency#.pProgress SET severity = '#GG_goals_severity#', Date_Change = #now()# WHERE Schedule_ID = '#getschedule.Schedule_ID#' AND (Progress_ID = '#Progress_ID#') AND status = 0 AND (severity IS NULL OR severity = '0') UPDATE #Request.prefix_db_agency#.pProgress SET YesOrNo = '4', Date_Change = #now()# WHERE Schedule_ID = '#getschedule.Schedule_ID#' AND (Progress_ID = '#Progress_ID#') AND status = 0 SELECT pPathway.Item_ID AS pathitem_id,pProgress.*,pProblem.Path_ID FROM #Request.prefix_db_agency#.pProgress JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pProgress.Careplan_ID AND pProblem.Status = 0 JOIN #Request.prefix_db_lookup#.pPathway ON pProblem.Path_ID = pPathway.Pathway_ID AND pPathway.type = 'goal' AND pPathway.Header IS NOT NULL AND pPathway.Description like '% - 0%' WHERE pProgress.Status = 0 AND pProgress.Schedule_ID = AND pProgress.Description like 'GG%' SELECT pCareplan.*, pCareplan.other, pCareplan.Skill FROm #Request.prefix_db_agency#.pCareplan WHERE pCareplan.Assmt_ID = AND pCareplan.Type = AND pCareplan.Skill = AND pCareplan.Status = SELECT * FROM getgoalscareplans WHERE Item_ID IN (#getGGquestions.pathitem_id#) SELECT * FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID = AND Careplan_ID = AND Status = AND Assmt_ID = SELECT *,pProgress.Type AS ptype FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Schedule_ID = pProgress.Schedule_ID WHERE pProgress.Assmt_ID = AND pProgress.Careplan_ID = AND pProgress.Schedule_ID = AND pSchedules.Status = AND pProgress.Status = ORDER BY pSchedules.Visit_no ASC SELECT pProgress.*, pCareplan.Type,pCareplan.Order_ID,pSchedules.* FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Schedule_ID = pProgress.Schedule_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pCareplan ON pCareplan.Careplan_ID = pProgress.Careplan_ID WHERE pProgress.Assmt_ID = AND pProgress.Careplan_ID = AND pProgress.Status = AND pCareplan.status = AND pSchedules.Status = AND pCareplan.Skill = GROUP BY pProgress.Progress_ID ORDER BY pCareplan.Order_ID ASC UPDATE #Request.prefix_db_agency#.pProgress SET Description = , Value_1 = , Value_2 = , Value_3 = , Notes = , Date_Change = , Change_by = WHERE Progress_ID = UPDATE #Request.prefix_db_agency#.pProgress SET Status = , Date_Change = , Change_by = WHERE Progress_ID = SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Skill = AND Status = AND Type = AND Date_Resolve IS NULL SELECT IFNULL( pCareplan.Careplan_ID,0) as pCareplan_ID,pCareplan.Date_Target,pCareplan.Param_Lo,pCareplan.Param_Hi,pCareplan.Item_ID ,pProgress.*,pPathway.Header, pPathway.Pathway_ID,pCareplan.Type FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_agency#.pCareplan ON pProgress.Careplan_ID = pCareplan.Careplan_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pCareplan.Item_ID WHERE pCareplan.Assmt_ID = AND pCareplan.Type = AND pPathway.Type = AND pCareplan.Skill = AND pCareplan.Status = AND pProgress.Status = AND pProgress.Visit_no = AND pProgress.Description = GROUP BY pProgress.Description ORDER BY pPathway.Type_Order,pPathway.Order_ID ASC SELECT IFNULL( pCareplan.Careplan_ID,0) as pCareplan_ID, pCareplan.other, pProgress.* FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_agency#.pCareplan ON pProgress.Careplan_ID = pCareplan.Careplan_ID WHERE pCareplan.Assmt_ID = AND pCareplan.Type = AND pProgress.Visit_no = AND pCareplan.Skill = AND pCareplan.Status = AND pProgress.Status = AND pProgress.Description = GROUP BY pProgress.Progress_ID ORDER BY MAX(pCareplan.Order_ID) ASC SELECT pProgress.* FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_agency#.pCareplan ON pProgress.Careplan_ID = pCareplan.Careplan_ID WHERE pCareplan.Assmt_ID = AND pCareplan.Type = AND pProgress.Schedule_ID = AND pCareplan.Skill = AND pCareplan.Status = AND pProgress.Status = AND pProgress.Description = GROUP BY pProgress.Progress_ID ORDER BY MAX(pCareplan.Order_ID) ASC UPDATE #Request.prefix_db_agency#.pProgress SET Notes = , YesOrNo = , severity = , Physician_alert = , Value_1 = , Value_2 = , Value_3 = , Date_Change = , Change_by = WHERE Progress_ID = UPDATE #Request.prefix_db_agency#.pProgress SET activate = , Date_Change = , Change_by = WHERE Progress_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pProgress WHERE activate = AND Schedule_ID = AND Type ='goal' AND (YesOrNo != 4 OR YesOrNo IS NULL) AND Status = 0 UPDATE #Request.prefix_db_agency#.pProgress SET severity = '#arguments.severity#', activate = , activate = , YesOrNo = , Date_Change = , Change_by = WHERE Progress_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pProgress WHERE activate = AND Schedule_ID = AND Type ='goal' AND (YesOrNo != 4 OR YesOrNo IS NULL) AND Status = 0 UPDATE #Request.prefix_db_agency#.pProgress SET wnd_bed = , wnd_margin = , wnd_exudate = , wnd_odor = , wnd_pain = , wnd_tunneling = , wnd_underm = , wnd_gran = , wnd_epith = , wnd_eschar = , wnd_slough = , wnd_fib = , Date_Change = , Change_by = WHERE Progress_ID = AND Status = 0