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.Street_Address, Patient.City, Patient.State_M0050, Patient.Zip_M0060, 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.Assessment_Reason_M0100, Assessment_New.Start_of_Care_M0030, Assessment_New.Date_Discharge_M0906, Assessment_New.Discharged_From_M0175, Assessment_New.HHRG_175_Score, Assessment_New.HHRG_230_Score, Assessment_New.HHRG_250_Score, Assessment_New.HHRG_390_Score, Assessment_New.HHRG_420_Score, Assessment_New.HHRG_440_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