SELECT s.Avg5Star_SOC,an.Assessment_ID,an.Start_of_Care_M0030,p.Last_Name_M0040,p.First_Name_M0040,e.Last_Name,e.First_Name, an.Certification_Start,an.Certification_End,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 p.status = 'active' and an.Admission_Status = 'complete' and s.Avg5Star_SOC != '' and s.Avg5Star_SOC is not null and py.Track_Outcomes = 1 and py.payerstatus = 'active' and an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# GROUP BY an.Assessment_ID

#Session.AgencyName# REAL-TIME 5-STAR SCORES FOR ACTIVE PATIENTS

Start Of Care Date

" /> to " />

Date Format: mm/dd/yyyy

	Name	Start of Care date	Certification Start - End	Admitting Clinician	Payer	Score
	#Last_Name_M0040#, #First_Name_M0040#	#DateFormat(Start_of_Care_M0030,"mm/dd/yyyy")#	#DateFormat(Certification_Start,"mm/dd/yyyy")# - #DateFormat(Certification_End,"mm/dd/yyyy")#	#First_Name# #Last_Name#	#payname#	#Avg5Star_SOC#