SELECT s.AvgHHC_SOC,an.Assessment_ID,an.Start_of_Care_M0030,p.Last_Name_M0040,p.First_Name_M0040,e.Last_Name,e.First_Name 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 WHERE an.Certification_End > '2015-12-31' and an.Deleted = 0 and an.Admission_Status = 'complete' and an.Medical_or_Treatment_Change_M0200 = '' and an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# GROUP BY an.Assessment_ID
#Session.AgencyName# REAL-TIME HOME HEALTH COMPARE SCORES FOR ACTIVE PATIENTS
" /> to " />
Date Format: mm/dd/yyyy


Name Start of Care date Admitting Clinician Score
#Last_Name_M0040#, #First_Name_M0040# #DateFormat(Start_of_Care_M0030,"mm/dd/yyyy")# #First_Name# #Last_Name# #AvgHHC_SOC#