SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND Status = 0 SELECT IFNULL(SUM(Total_Visits),0) AS tot_visits, Skill FROM #Request.prefix_db_agency#.pAuths WHERE Assmt_ID IN () AND Skill = '#skilltype#' AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Assmt_ID IN () AND Status = AND Skill = '#skilltype#' AND Auth_ID > 0 SELECT * FROM getallschedule SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = AND status = 0 AND VitalOrWound = 'vital' AND Status = 0 SELECT SUM(CASE WHEN LEFT(Answer,2) > 2 THEN LEFT(Answer,2) ELSE '2' END ) as sev , Answer,Severity, pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID = AND status = 0 AND skill = '#skilltype#' AND M0_No NOT LIKE 'M102%' AND Description like 'GG%' SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Type like '%goal%' AND Status = 0 SELECT * FROM getallcareplans WHERE Skill = '#skilltype#' AND Type = 'goal' AND (Status = 0) SELECT IFNULL(SUM(Left(IFNULL(Severity,0),2)),0) AS total_goals, pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID = AND Skill = '#skilltype#' AND Status = 0 AND Description like 'GG%' SELECT * FROM getallcareplans WHERE Skill = '#skilltype#' AND Type = 'goal' AND Status = 0 SELECT * FROM getallcareplans WHERE Skill = '#skilltype#' AND Type = 'goal' SELECT SUM(CASE WHEN Description like '%- 01.%' THEN 1 WHEN Description like '%- 02.%' THEN 2 WHEN Description like '%- 03.%' THEN 3 WHEN Description like '%- 04.%' THEN 4 WHEN Description like '%- 05.%' THEN 5 WHEN Description like '%- 06.%' THEN 6 ELSE '4' END ) as goals, pCareplan.* FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND status = 0 AND skill = '#skilltype#' AND Type IN ('goal' ) AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Assmt_ID = AND Status = SELECT * FROM getallschedule WHERE Schedule_ID = '#Request.Schedule_ID#' SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Assmt_ID IN () AND Status = AND Skill = '#skilltype#' AND (Visit_Type not like '%9%' OR Visit_Type IS NULL) SELECT * FROM getallschedule WHERE Auth_ID = '#getallschedule.Auth_ID#' AND pgnotesdraft != 2 SELECT pAssessments.*,IFNULL(pAssessments.F305,0) AS answer_1 FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = 0 Total #getactive_auths.skill# Visits for Admit - #getactive_auths.tot_visits# (minus 1 for SOC/Eval) #getschedule.Schedule_ID#
This Visit -
Total goal value -
Per Visit -
Expected this visit -
SELECT p1.*,IFNULL(p1.F305,0) AS answer_1 FROM #Request.prefix_db_agency#.pAssessments p1 WHERE p1.status = 0 AND p1.Assmt_ID = AND p1.Admit_ID = SELECT COALESCE(SUM(CASE WHEN Description like '%- 0%' THEN Incrmt1 ELSE 4 END),0) as careplan_incrmt FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Type like 'goal%' AND skill = '#skilltype#' AND Status = 0 SELECT IFNULL(SUM(severity),0) as sev FROM #Request.prefix_db_agency#.pProgress WHERE Assmt_ID = AND status = 0 AND Schedule_ID = AND Type IN ('problem','symptom') SELECT IFNULL(SUM(Incrmt1),0) as incrmt1 FROM #Request.prefix_db_agency#.pProgress WHERE Assmt_ID = AND status = 0 AND Schedule_ID = SELECT COALESCE(SUM( CASE WHEN pProgress.severity > pProgress.Incrmt1 THEN pProgress.Incrmt1 ELSE pProgress.severity END ), 0) as sev 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 pPathway.Pathway_ID = pProblem.Path_ID AND pPathway.type = 'goal' AND pPathway.Header IS NOT NULL AND pPathway.Description like '% - 0%' JOIN #Request.prefix_db_agency#.pCareplan ON pPathway.Item_ID = pCareplan.Item_ID AND pCareplan.Status = 0 AND pCareplan.Assmt_ID = pProgress.Assmt_ID AND pCareplan.Skill = pProblem.Skill AND pCareplan.Type ='goal' WHERE pProgress.Assmt_ID = AND pProgress.status = 0 AND pProgress.Schedule_ID = AND pProgress.Type like '%problem%' AND pProgress.Description like 'GG%%' SELECT IFNULL(SUM(pProgress.YesOrNo),0) as sev 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.Assmt_ID = pProgress.Assmt_ID AND pCareplan.Skill = '#getschedule.Skill#' WHERE pProgress.Assmt_ID = AND pProgress.status = 0 AND pProgress.Schedule_ID = AND pProgress.Type like 'goal%' UPDATE #Request.prefix_db_agency#.pSchedules SET increment_goal_this_visit = #request.increment_goal_this_visit#, goal_result_this_visit = #request.goal_result_this_visit# WHERE Assmt_ID = AND Schedule_ID = AND Status = SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Assmt_ID = AND Schedule_ID = AND Status = Total #getactive_auths.skill# Visits for Admit - #getactive_auths.tot_visits# (minus 1 for SOC/Eval) #getschedule.Schedule_ID#
This Visit - #getschedulelist.Visit_no#
Total goal values - A -
Divide Visits into goal - B -
Expected this visit - C-
Result this visit - F -