pm = CreateObject("Component", "Menu"); myArgument = 'VBPanalysis'; pm.MenuFunction(myArgument,#getP.Patient_Id#,'','','',''); request.pat = CreateObject("component","components.general.patients").init(); getadmit = request.pat.get_admissions(#session.cs.patientid#);
VBP Analysis
Back

#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, pAssessments.Admit_ID, F26, F34, F81, F37, F38, F240, F82, F138, F83, F139, F73, F72, F140, F143, F223,F296,pAssessments.Record_Created_By,F40, CASE WHEN LEFT(F26,1) = '4' THEN IFNULL(LEFT(F40,1),0) ELSE IFNULL(LEFT(F34,1),0) END AS M1700, CASE WHEN (F26 = '1 - Start of care - further visits planned - Physical Therapy' OR LEFT(F26,1) = '4') THEN IFNULL(LEFT(F72,1),0) ELSE IFNULL(LEFT(F73,1),0) END AS M2102d, IFNULL(LEFT(F82,1),0) AS GG0100A, IFNULL(LEFT(F83,1),0) AS GG0100B, pAdmit.M1100_PTNT_LVG_STUTN, pAdmit.problem_Intake, pAdmit.Caregiver_commitment, pAdmit.Caregiver_competency 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.Patient_ID = '#session.cs.patientid#' AND pAssessments.Admit_ID = AND LEFT(pAssessments.F26,1) IN ('1','4') AND pAssessments.status = 0 ORDER BY pAssessments.F177 DESC SELECT Assmt_ID, Admit_ID, F37,F34, F38, F240, F82, F138, F83, F139, F73, F102, F111,F112,F113,F114,F115,F116,F117,F118, 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, F103,F104,F105,F106,F107,F108,F109,F110,F113,F114,F119,F120, 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 SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis3 WHERE LEFT(SOC_M1700,1) = AND LEFT(SOC_M2102D,1) = SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis3 WHERE LEFT(SOC_M1700,1) = AND LEFT(SOC_M2102D,1) = SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis3 WHERE LEFT(SOC_M1700,1) = AND LEFT(SOC_M2102D,1) = SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis2 WHERE LEFT(SOC,1) = AND (LEFT(PT_Eval,1) = OR PT_Eval IS NULL) AND (LEFT(OT_Eval,1) = OR OT_Eval IS NULL) AND M0_Item = 'M1700' SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis2 WHERE LEFT(SOC,1) = AND (LEFT(PT_Eval,1) = OR PT_Eval IS NULL) AND (LEFT(OT_Eval,1) = OR OT_Eval IS NULL) AND M0_Item = 'M2102d'

VBP Risk Analysis

style="background-color:##FFFFCC" > 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 (pProblem.Answer IS NULL or pProblem.Answer like '2%' or pProblem.Answer like '3%' or pProblem.Answer like '4%') AND Skill = 'SN' AND CW_Coding_Class_PDGM.System IS NULL 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 Skill = 'SN' AND pProblem.status = 0 and (pProblem.Answer IS NULL or pProblem.Answer like '2%' or pProblem.Answer like '3%' or pProblem.Answer like '4%') AND CW_Coding_Class_PDGM.System IS NULL GROUP BY CW_Coding_Class_PDGM.ID SELECT DISTINCT Pathway_ID FROM getrecommgoals SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis1 WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND Wound = '#vbp_nursing#' SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis1 WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND Wound = '#vbp_nursing#' SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis1 WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND Wound = '#vbp_nursing#' 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' 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 ='BH' 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 ='CG' GROUP BY CW_Coding_Class_PDGM.ID 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 SELECT * FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_lookup#.VBP_Visits ON VBP_Visits.HIPPS_Code = pAssessments.F297 WHERE Assmt_ID = AND status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_lookup#.VBP_Visits ON VBP_Visits.HIPPS_Code = pAssessments.F300 WHERE Assmt_ID = AND status = 0 SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis1 WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND Wound = '#vbp_nursing#' SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis1 WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND Wound = '#vbp_nursing#' SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis1 WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND Wound = '#vbp_nursing#'
Admission Form Start of CareRecertification PT Evaluation OT Evaluation
Admission Form #getStartofCare.M1100_PTNT_LVG_STUTN#
M1700 Cognitive Functioning #getSOCVBP_1700.Alert# #getStartofCare.F40##getStartofCare.F34# #getPTEvaluation.F34# #getOTEvaluation.F38#
M2102d Assistance for Procedures & Treatments #getSOCVBP_M2102d.Alert# #getStartofCare.F72# #getStartofCare.F73# #getPTEvaluation.F240# #getOTEvaluation.F240#
Careplan #F296# #getsocVBP.V_or_M#
  		#getsocVBP.V_or_M# #getptVBP.V_or_M# #getotVBP.V_or_M#
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#
 		improvement in toilet transferring
improvement in transferring
improvement in mobility
" /> " /> " /> " /> " /> #Request.PTcurrentgoals#
Recommended Goals #Goal#
 		improvement in toilet transferring
 improvement in transferring
improvement in ambulation
 		#Request.PTcurrentgoals# improvement in bathing
Patient Safety #Goal#
Behavioral #Goal#
Case Management #Goal#
Total Visits

#Total_Visits# #Total_Visits#

#Total_Visits# #Total_Visits#

#Total_Visits# #Total_Visits#

Recommended Visits 1st 30 days HIPPS : #getrecommvisits1.F297#
1st 30 days Recommended: #getrecommvisits1.Total_Skilled#
1st 30 days LUPA : #getrecommvisits1.LUPA#
2nd 30 days HIPPS : #getrecommvisits2.F300#
2nd 30 days Recommended: #getrecommvisits2.Total_Skilled#
2nd 30 days LUPA : #getrecommvisits2.LUPA#
1st 30 days #getrecommvisits1.Visits_Therapy# Therapy visits
 2nd 30 days #getrecommvisits2.Visits_Therapy# Therapy visits
 1st 30 days #getrecommvisits1.Visits_HHA# HHA visits
2nd 30 days #getrecommvisits2.Visits_HHA# HHA visits
#getDistinctSch.Visit_Date#
--->

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
#DateFormat(Visit_Date,"mm/dd/yyyy")#
#getvitalwounds.Description# #Value_Sum# #getvitalwounds.WoundType# #getvitalwounds.Reading1#