SELECT s.Avg5Star_DC,s.Avg5Star_TDC,an.Assessment_ID,an.Medical_or_Treatment_Change_M0200, an.Start_of_Care_M0030,p.Last_Name_M0040,p.First_Name_M0040,e.Last_Name,e.First_Name,py.payname 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 JOIN #Request.prefix_db_lookup#.Employee e ON e.Employee_ID = an.Record_Created_By JOIN #Request.prefix_db_agency#.Payer py ON py.Payer_ID = an.Payer_ID WHERE an.Certification_End > '2015-12-31' and an.Deleted = 0 and an.Admission_Status = 'complete' AND (('transfer/discharged' = (select an.Medical_or_Treatment_Change_M0200 from #Request.prefix_db_agency#.Assessment_New an WHERE an.Assessment_ID = s.Assessment_ID)) OR ('discharged' = (select an.Medical_or_Treatment_Change_M0200 from #Request.prefix_db_agency#.Assessment_New an WHERE an.Assessment_ID = s.Assessment_ID))) and py.Track_Outcomes = 1 and py.payerstatus = 'active' and an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# and (s.Avg5Star_DC != '' or s.Avg5Star_TDC != '') GROUP BY s.Assessment_ID
#Session.AgencyName# 5-STAR SCORES FOR DISCHARGED PATIENTS
" /> to " />
Date Format: mm/dd/yyyy


Name Start of Care date Discharge Type Clinician Payer 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# #First_Name# #Last_Name# #payname# #Avg5Star_DC##Avg5Star_TDC#