SELECT Agency.Agency_Name, Agency.Agency_Medicare_ID, Agency.Natl_Provider_ID, Agency.CAHPS, DATE_FORMAT('#FORM.monthYear#', "%m") AS trueMonth FROM #Request.prefix_db_agency#.ScheduleItems INNER JOIN #Request.prefix_db_agency#.patient ON ScheduleItems.Patient_ID = patient.Patient_ID INNER JOIN #Request.prefix_db_lookup#.Employee ON ScheduleItems.Employee_ID = Employee.Employee_ID INNER JOIN #Request.prefix_db_agency#.Assessment_New ON ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID INNER JOIN #Request.prefix_db_lookup#.Agency ON ScheduleItems.Agency_ID = Agency.Agency_ID WHERE ScheduleItems.Agency_ID = #session.AgencyID# AND patient.Patient_ID = #ListItem# SELECT COUNT(*) as SkilledVisitsTotalCount FROM #Request.prefix_db_agency#.ScheduleItems INNER JOIN #Request.prefix_db_agency#.patient ON ScheduleItems.Patient_ID = patient.Patient_ID INNER JOIN #Request.prefix_db_lookup#.Employee ON ScheduleItems.Employee_ID = Employee.Employee_ID INNER JOIN #Request.prefix_db_agency#.Assessment_New ON ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID INNER JOIN #Request.prefix_db_lookup#.Agency ON ScheduleItems.Agency_ID = Agency.Agency_ID WHERE ScheduleItems.Agency_ID = #session.AgencyID# AND patient.Patient_ID = #ListItem# AND ScheduleItems.Visit_Date > '#FORM.monthYear#' AND ScheduleItems.Visit_Date < DATE_ADD('#FORM.monthYear#', INTERVAL 1 MONTH) GROUP BY patient.Patient_ID SELECT COUNT(*) as LookBack, patient.First_Name_M0040, patient.Middle_Initial_M0040, patient.Last_Name_M0040, patient.Gender_M0069, patient.DOB_M0066, patient.Telephone, patient.Agency_Assigned_ID, ScheduleItems.Visit_Type, Assessment_New.Source_of_Admission, patient.Current_Payment_Sources_M0150, Assessment_New.HHRG_175_Score, Assessment_New.HHRG_230_Score, Assessment_New.Dress_Upper_M0650, Assessment_New.Dress_Lower_M0660, Assessment_New.Bathing_M0670, Assessment_New.M1840_Toilet, Assessment_New.Transferring_M0690, Assessment_New.Eating_M0710, patient.Financial_Factors_M0150, Assessment_New.M1016_DX_NA, Assessment_New.Grooming_M0640, Assessment_New.Dress_Upper_M0650, Assessment_New.Dress_Lower_M0660, Bathing_M0670, Assessment_New.Toileting_M0680, Assessment_New.Transferring_M0690, Assessment_New.Ambulation_M0700, Assessment_New.Eating_M0710, Assessment_New.Meal_Prep_M0720, Assessment_New.Transport_M0730, Assessment_New.Laundry_M0740, Assessment_New.Shopping_M0760, Assessment_New.Housekeeping_M0750, Assessment_New.Use_Phone_M0770, Assessment_New.M1845_Toilet FROM #Request.prefix_db_agency#.ScheduleItems INNER JOIN #Request.prefix_db_agency#.patient ON ScheduleItems.Patient_ID = patient.Patient_ID INNER JOIN #Request.prefix_db_lookup#.Employee ON ScheduleItems.Employee_ID = Employee.Employee_ID INNER JOIN #Request.prefix_db_agency#.Assessment_New ON ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID INNER JOIN #Request.prefix_db_lookup#.Agency ON ScheduleItems.Agency_ID = Agency.Agency_ID WHERE ScheduleItems.Agency_ID = #session.AgencyID# AND patient.Patient_ID = #ListItem# AND ScheduleItems.Visit_Date > DATE_SUB('#FORM.monthYear#', INTERVAL 1 MONTH) AND ScheduleItems.Visit_Date < DATE_ADD('#FORM.monthYear#', INTERVAL 1 MONTH) GROUP BY patient.Patient_ID 0>

CAHPS

You reached this page by error. Plesae submit the CAHPS Form located Here