SELECT s.*, an.Freq_of_Pain_M0420, an.Pressure_Ulcer_Stage_M0460, an.Pressure_Ulcer_Status_M0464, an.Stasis_Ulcer_M0468, an.Surgical_Wound_M0482, an.Stasis_Ulcer_Hidden_M0474, an.Stasis_Ulcer_Status_M0476, an.Surgical_Wound_Status_M0488, an.Breathing_M0490, an.UTI_M0510, an.Urinary_INcont_M0520, an.Bathing_M0670, an.Transferring_M0690, an.Ambulation_M0700, an.Oral_Meds_M0780, an.Emergent_Care_M0830, an.Inpatient_Facility_M0855, an.Discharge_Disposition_M0870, an.SOC_420, an.SOC_490, an.SOC_520, an.SOC_680, an.SOC_690, an.SOC_700, an.SOC_780, an.MR_420, an.MR_488, an.MR_490, an.MR_670, an.MR_690, an.MR_700, an.MR_780, an.M0104_Date_of_Referral, an.M1032_Frailty, an.M1240_Pain_Assess, an.M1300_Pressure, an.M1730_Depression, an.M1845_Toilet, an.M2010_Med_Edu, an.M2015_Drug_Edu, an.M1840_Toilet, an.M2100a_Equip, an.M2100b_Equip, an.M2100c_Equip, an.M2100d_Equip, an.M2100e_Equip, an.M2100f_Equip, an.M2100g_Equip, an.M0102_Physician_SOC, an.M1040_Influ, an.M1045_Influ, an.M1050_Pneu, an.M1055_Pneu, an.M1500_Symptoms, an.M1510_Hrt_FU, an.M1910_Fall_Risk, an.Start_of_Care_M0030, p.Last_Name_M0040,p.First_Name_M0040 FROM #Request.prefix_db_agency#.Assessment_Score s JOIN #Request.prefix_db_agency#.Assessment_New an ON s.Assessment_ID = an.Parent_ID JOIN #Request.prefix_db_agency#.patient p ON p.Patient_ID = an.Patient_ID WHERE an.Parent_ID = '#url.Assessment_ID#' AND an.Certification_End > '2015-12-31' AND an.Deleted = 0 AND an.Admission_Status = 'complete' and an.Assessment_Reason_M0100 in ('7 - Transferred to an inpatient facility - patient discharged from agency') SELECT s.*, an.Freq_of_Pain_M0420, an.Pressure_Ulcer_Stage_M0460, an.Pressure_Ulcer_Status_M0464, an.Stasis_Ulcer_M0468, an.Stasis_Ulcer_Hidden_M0474, an.Stasis_Ulcer_Status_M0476, an.Surgical_Wound_Status_M0488, an.Breathing_M0490, an.Surgical_Wound_M0482, an.UTI_M0510, an.Urinary_INcont_M0520, an.Bathing_M0670, an.Transferring_M0690, an.Ambulation_M0700, an.Oral_Meds_M0780, an.Emergent_Care_M0830, an.Inpatient_Facility_M0855, an.Discharge_Disposition_M0870, an.SOC_420, an.SOC_490, an.SOC_520, an.SOC_680, an.SOC_690, an.SOC_700, an.SOC_780, an.MR_420, an.MR_488, an.MR_490, an.MR_670, an.MR_690, an.MR_700, an.MR_780, an.M0104_Date_of_Referral, an.M1032_Frailty, an.M1240_Pain_Assess, an.M1300_Pressure, an.M1730_Depression, an.M1845_Toilet, an.M2010_Med_Edu, an.M2015_Drug_Edu, an.M1840_Toilet, an.M2100a_Equip, an.M2100b_Equip, an.M2100c_Equip, an.M2100d_Equip, an.M2100e_Equip, an.M2100f_Equip, an.M2100g_Equip, an.M0102_Physician_SOC, an.M1040_Influ, an.M1045_Influ, an.M1050_Pneu, an.M2250b_Diabetic,an.M2250e_Pain,an.M2250f_PressUlc,an.M2250g_PressUlcMoist, an.M1055_Pneu, an.M1500_Symptoms, an.M1510_Hrt_FU, an.M1910_Fall_Risk, an.Start_of_Care_M0030, p.Last_Name_M0040,p.First_Name_M0040 FROM #Request.prefix_db_agency#.Assessment_Score s JOIN #Request.prefix_db_agency#.Assessment_New an ON s.Assessment_ID = an.Assessment_ID JOIN #Request.prefix_db_agency#.patient p ON p.Patient_ID = an.Patient_ID WHERE an.Assessment_ID = '#url.Assessment_ID#' AND an.Certification_End > '2015-12-31' AND an.Deleted = 0 AND an.Admission_Status = 'complete' AND an.Assessment_Reason_M0100 = '1 - Start of care - further visits planned'
REAL-TIME HOME HEALTH COMPARE SCORE FOR TRANSFER/DISCHARGED PATIENT #UCASE(GET_Score_DC.First_Name_M0040)# #UCASE(GET_Score_DC.Last_Name_M0040)# admitted #DateFormat(GET_Score_DC.Start_of_Care_M0030,"mm/dd/yyyy")#

HOME HEALTH COMPARE MEASURE HOME HEALTH COMPARE
AS OF TRANSFER/DISCHARGE:  #GET_Score_DC.AvgHHC_TDC#		 START OF CARE > DISCHARGE LAST VISIT
M0102/M0104 Care initiated within 2 days #GET_Score_SOC.M0104# #DateFormat(GET_Score_SOC.M0104_Date_of_Referral,"mm/dd/yyyy")# #DateFormat(GET_Score_SOC.M0102_Physician_SOC,"mm/dd/yyyy")#  > #DateFormat(GET_Score_SOC.Start_of_Care_M0030,"mm/dd/yyyy")#
M1046 patient received flu vaccine* #GET_Score_DC.M1041# #GET_Score_DC.M1040_Influ# > #Left(GET_Score_DC.M1045_Influ,30)#...admission not during flu season#GET_Score_DC.M1040_Influ# > #Left(GET_Score_DC.M1045_Influ,30)#... *note flu season October > March
M1056 PPV received #GET_Score_DC.M1051# #GET_Score_DC.M1050_Pneu##GET_Score_DC.M1050_Pneu# > #Left(GET_Score_DC.M1055_Pneu,30)#...
M1240 pain assessment #GET_Score_SOC.M1240# #Left(GET_Score_SOC.M1240_Pain_Assess,35)#...
M1300 pressure ulcer risk assessment #GET_Score_SOC.M1300# #Left(GET_Score_SOC.M1300_Pressure,35)#...
M1400 dyspnea improved since admission #GET_Score_DC.M1400# #GET_Score_SOC.SOC_490# > #Left(GET_Score_DC.Breathing_M0490,1)# not tracked #GET_Score_SOC.MR_490# > different from last visit #GET_Score_SOC.MR_490#
M1510 heart failure symptoms #GET_Score_DC.M1510# #Left(GET_Score_DC.M1500_Symptoms,10)#...  > #Left(GET_Score_DC.M1500_Symptoms,10)#...
M1730 depression assessment #GET_Score_SOC.M1730# #Left(GET_Score_SOC.M1730_Depression,35)#...
M1910 fall risk assessment #GET_Score_SOC.M1910# #Left(GET_Score_SOC.M1910_Fall_Risk,35)#...
M2010 high-risk medication teaching performed #GET_Score_SOC.M2010# #Left(GET_Score_SOC.M2010_Med_Edu,35)#...
M2020 oral med mgmt improved since admission #GET_Score_DC.M2020# #GET_Score_SOC.SOC_780# > #Left(GET_Score_DC.Oral_Meds_M0780,1)# not tracked #GET_Score_SOC.MR_780# > different from last visit #GET_Score_SOC.MR_780#
M2250b diabetic foot care in careplan #GET_Score_SOC.M2250_b# #Left(GET_Score_SOC.M2250b_Diabetic,35)#...
M2250e pain intervention in careplan #GET_Score_SOC.M2250_e# #Left(GET_Score_SOC.M2250e_Pain,35)#...
M2250f pressure ulcer tx in careplan #GET_Score_SOC.M2250_f# #Left(GET_Score_SOC.M2250f_PressUlc,35)#...
M2250g moist pressure ulcer tx in careplan #GET_Score_SOC.M2250_g# #Left(GET_Score_SOC.M2250g_PressUlcMoist,35)#...
M2300 Emergent Care? #GET_Score_DC.M2300_1# #Left(GET_Score_DC.Emergent_Care_M0830,35)#...
M2410 Inpatient Facility? #GET_Score_DC.M2410_1# #Left(GET_Score_DC.Inpatient_Facility_M0855,35)#...