SELECT s.AvgHHC_DC,s.AvgHHC_TDC,an.Assessment_ID,an.Medical_or_Treatment_Change_M0200, 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.Certification_End > '2015-12-31' and an.Deleted = 0 and an.Admission_Status = 'complete' and (an.Medical_or_Treatment_Change_M0200 = 'discharged' or an.Medical_or_Treatment_Change_M0200 = 'transfer/discharged') and (s.AvgHHC_DC != '') and an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# GROUP BY an.Assessment_ID
#Session.AgencyName# HOME HEALTH COMPARE SCORES FOR TRANSFER/DISCHARGED PATIENTS
" /> to " />
Date Format: mm/dd/yyyy


Name Start of Care date Discharge Type Score
#Last_Name_M0040#, #First_Name_M0040# #Last_Name_M0040#, #First_Name_M0040# #DateFormat(Start_of_Care_M0030,"mm/dd/yyyy")# #Medical_or_Treatment_Change_M0200# #AvgHHC_DC##AvgHHC_TDC#