VBP Analysis

#DateFormat(M0030_START_CARE_DT,"mm/dd/yyyy")# #DateFormat(M0030_START_CARE_DT,"mm/dd/yyyy")#

VBP Risk Analysis Pressure Ulcer Risk Infection Risk Vitals & Wounds Fall Risk Hospitalization Risk

SELECT Assmt_ID, Admit_ID, F34, F81, F37, F38, F240, F82, F138, F83, F139, F73, F140, F143, F223, IFNULL(LEFT(F34,1),0) AS M1700, IFNULL(LEFT(F73,1),0) AS M2102d, IFNULL(LEFT(F82,1),0) AS GG0100A, IFNULL(LEFT(F83,1),0) AS GG0100B FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = '#session.cs.patientid#' AND Admit_ID = AND F26 like '1 - Start of care - further visits planned%' AND status = 0 SELECT Assmt_ID, Admit_ID, F37,F34, F38, F240, F82, F138, F83, F139, F73, F102, IFNULL(LEFT(F34,1),0) AS M1700, IFNULL(LEFT(F240,1),0) AS M2102d, IFNULL(LEFT(F138,1),0) AS GG0100A, IFNULL(LEFT(F139,1),0) AS GG0100B, IFNULL(LEFT(F102,1),0) AS GOAL FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = '#session.cs.patientid#' AND Admit_ID = AND F26 like 'PT Adult Evaluation%' AND Status = 0 SELECT Assmt_ID, Admit_ID, F37, F34, F38, F240, F82, F138, F83, F139, F73, F102, IFNULL(LEFT(F38,1),0) AS M1700, IFNULL(LEFT(F240,1),0) AS M2102d, IFNULL(LEFT(F138,1),0) AS GG0100A, IFNULL(LEFT(F139,1),0) AS GG0100B, IFNULL(LEFT(F102,1),0) AS GOAL FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = '#session.cs.patientid#' AND Admit_ID = AND F26 like 'OT Adult Evaluation%' AND status = 0 SELECT pSchedules.*,pEmployee.Emp_First,pEmployee.Emp_Last , CONCAT(pEmployee.Emp_Last , ", ", pEmployee.Emp_First) AS name_by ,pAuths.Auth_No, pAssessments.F26,pAssessments.F177,pAssessments.F178,pAssessments.Admit_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAuths ON pSchedules.Auth_ID = pAuths.Auth_ID JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID JOIN #Request.prefix_db_agency#.pPtPayer pPtPayer on pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID JOIN #Request.prefix_db_agency#.pPayer pp on pPtPayer.Payer_ID = pp.Pay_ID JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Emp_ID WHERE pSchedules.status = AND pAuths.status = AND pAssessments.status = AND pPatients.status = AND pEmployee.status = 0 AND pSchedules.Patient_ID = AND pAuths.Status = 0 AND pPtPayer.status = 0 AND pp.status = 0 AND pAssessments.Admit_ID = GROUP BY pSchedules.Schedule_ID ORDER BY pSchedules.Visit_Date ASC SELECT * FROM getDistinctSch WHERE Skill = 'SN' ORDER BY Visit_Date DESC

VBP Risk Analysis

style="background-color:##FFFFCC" > SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = '#getStartofCare.Assmt_ID#' AND VitalOrWound = 'wound' AND HealingStage like '3%' AND status = 0 SELECT * FROM #Request.prefix_db_lookup#.CW_Coding_Class_PDGM JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Path_ID = CW_Coding_Class_PDGM.Pathway_ID WHERE Assmt_ID = '#getStartofCare.Assmt_ID#' AND pProblem.status = 0 AND Skill = 'SN' GROUP BY CW_Coding_Class_PDGM.ID SELECT * FROM getcurrentgoals WHERE Skill = 'SN' SELECT * FROM #Request.prefix_db_lookup#.CW_Coding_Class_PDGM JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Path_ID = CW_Coding_Class_PDGM.Pathway_ID WHERE Assmt_ID = '#getStartofCare.Assmt_ID#' AND pProblem.status = 0 AND (CW_Coding_Class_PDGM.System !='CM' or CW_Coding_Class_PDGM.System != 'BH') AND CW_Coding_Class_PDGM.System !='CM' GROUP BY CW_Coding_Class_PDGM.ID SELECT * FROM #Request.prefix_db_lookup#.CW_Coding_Class_PDGM JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Path_ID = CW_Coding_Class_PDGM.Pathway_ID WHERE Assmt_ID = '#getStartofCare.Assmt_ID#' AND pProblem.status = 0 AND (CW_Coding_Class_PDGM.System !='CM' or CW_Coding_Class_PDGM.System != 'BH') AND CW_Coding_Class_PDGM.System !='CM' GROUP BY CW_Coding_Class_PDGM.ID SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND nursing = '#vbp_nursing#' SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND nursing = '#vbp_nursing#' SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND nursing = '#vbp_nursing#' request.authorization = CreateObject("component","components.general.authorization").init() getauthlist = request.authorization.getauthorizationslist(0,0); SELECT * FROM getauthlist WHERE STATUS IN (0) AND Assmt_ID = SELECT * FROM getauthlist WHERE STATUS IN (0) AND Assmt_ID = AND Assmt_ID = 0 SELECT * FROM getauthlist WHERE STATUS IN (0) AND Assmt_ID = AND Assmt_ID = 0

	Start of Care	PT Evaluation	OT Evaluation
M1700 Cognitive Functioning	#getStartofCare.F34#	#getPTEvaluation.F34#	#getOTEvaluation.F38#
M2102d Assistance for Procedures & Treatments	#getStartofCare.F73#	#getPTEvaluation.F240#	#getOTEvaluation.F240#
GG0100A Prior Function - Self Care	#getStartofCare.F82#	#getPTEvaluation.F138#	#getOTEvaluation.F138#
GG0100B Prior Function - Indoor Mobility (Ambulation)	#getStartofCare.F83#	#getPTEvaluation.F139#	#getOTEvaluation.F139#
Unhealed wounds	#WoundType#
Current Goals	#Goal#
Recommended Goals	#Goal#
Case Management	#Goal#
Therapy Goal		#getPTEvaluation.F102#	#getOTEvaluation.F102#
Explanation	#getsoc_VBP.VBP#	#getpt_VBP.VBP#	#getot_VBP.VBP#
Recommended Duration	#getsoc_VBP.duration_nsg#, #getsoc_VBP.duration_nsg_reason#	#getpt_VBP.duration_therapy#, #getpt_VBP.duration_therapy_reason#	#getot_VBP.duration_therapy#, #getot_VBP.duration_therapy_reason#
Recommended Frequency	#getsoc_VBP.visit_freq#	#getsoc_VBP.visit_freq#	#getot_VBP.visit_freq#
Frequency	#visit_freq# #visit_freq#	#visit_freq# #visit_freq#	#visit_freq# #visit_freq#

SELECT pSchedules.* FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Patient_ID = #session.cs.patientid# AND pSchedules.status= 0 AND pSchedules.Emp_ID != 0 AND pSchedules.pgnotesdraft > 0 AND pSchedules.Missed = '0' GROUP BY pSchedules.Skill ORDER BY pSchedules.Skill ASC, pSchedules.Visit_Date DESC

VisitDate	Skill	Result
#DateFormat(Visit_date,"mm/dd/yyyy")#	#Skill#	#display_value#

SELECT Schedule_ID,Description,YesOrNo ,severity FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID IN (#ValueList(getDistinctSch.Schedule_ID)#) AND Type = 'problem' SELECT Schedule_ID,Description, CAST(YesOrNo AS UNSIGNED) as YesOrNo ,severity FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID IN (#ValueList(getDistinctSch.Schedule_ID)#) AND Type = 'goal' SELECT Schedule_ID,Description,YesOrNo ,severity FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID IN (#ValueList(getDistinctSch.Schedule_ID)#) AND Type = 'discharge plan'

SELECT SUM(severity) as problemSum,Description,YesOrNo ,severity FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID = AND Type = 'problem' GROUP BY Description, YesOrNo,severity SELECT SUM(YesOrNo) as goalSum,Description,YesOrNo ,severity FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID = AND Type = 'goal' GROUP BY Description, YesOrNo,severity SELECT SUM(YesOrNo) as dischargeplanSum,Description,YesOrNo ,severity FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID = AND Type = 'discharge plan' GROUP BY Description, YesOrNo,severity #getDistinctSch.Visit_Date#

UNSTABLE SYMPTOMS	#getDistinctSch.Visit_Date#
#Description#	#getVal.severity#
	#getValSum.Total#
PATIENT/CAREGIVER RECALL
#Description#	#getVal.YesOrNo#
	#getValSum.Total#
Total	#val(getProblemSum.Total)+val(getGoalSum.Total)#

Pressure Ulcer Risk

	Start of Care
Mental Status	#getStartofCare.F34#
Mobility	#getStartofCare.F81#
Incontinence—Urine	#getStartofCare.F139#
Incontinence—Bowel	#getStartofCare.F140#
Unintentional weight loss of 10 or more lbs in the last 12 months	YES NO

Fall Risk

	Start of Care
Mental Status	#getStartofCare.F34#
2 or more falls – or any fall with an injury – in the past 12 months	YES NO
Mobility	#getStartofCare.F81#
Incontinence—Urine	#getStartofCare.F139#
Incontinence—Bowel	#getStartofCare.F140#
Vision	#getStartofCare.F223#
Orthostatic Blood Pressure
Home Safety Issues

Hospitalization Risk

	Start of Care
2 or more falls – or any fall with an injury – in the past 12 months	YES NO
Unintentional weight loss of a total of 10 pounds or more in the past 12 months	YES NO
Multiple hospitalizations (2 or more) in the past 6 months	#IIf(findNoCase('Multiple hospitalizations (2 or more) in the past 6 months', getStartofCare.F143,0), DE("YES"), DE("NO"))#
Multiple emergency department visits (2 or more) in the past 6 months	YES NO
Decline in mental, emotional, or behavioral status in the past 3 months	YES NO
Reported or observed history of difficulty complying with any medical instructions (for example, medications, diet, exercise) in the past 3 months	YES NO
Currently taking 5 or more medications	YES NO
Currently reports exhaustion	YES NO

SELECT * FROM getDistinctSch WHERE Status = 0 ORDER BY Visit_Date,Schedule_ID ASC SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = '#getStartofCare.Assmt_ID#' AND Status = 0 ORDER BY VitalOrWound ASC SELECT * FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pProgress ON pSchedules.Schedule_ID = pProgress.Schedule_ID WHERE pProgress.Schedule_ID IN (#Request.schedule_Ids#) AND pProgress.Type IN ('vital') AND pProgress.Status = 0 AND pSchedules.Status = 0 AND pProgress.Assmt_ID = '#getStartofCare.Assmt_ID#' GROUP BY pProgress.Progress_ID ORDER BY pSchedules.Visit_Date,pSchedules.Schedule_ID ASC SELECT DISTINCT Schedule_ID,Visit_Date FROM getallprogress WHERE Status = 0 ORDER BY Visit_Date,Schedule_ID ASC

Vital & Wounds

SELECT * FROM getallprogress WHERE Description = '#getvitalwounds.Description#' AND status = 0 ORDER BY Visit_Date,Schedule_ID ASC