SELECT Agency_Name, CAHPS, Agency_Medicare_ID, Natl_Provider_ID, Agency_Branch_ID
,DATE_FORMAT('#FORM.monthYear#', "%m") AS trueMonth
FROM #Request.prefix_db_lookup#.Agency
WHERE Agency_ID = '#session.AgencyId#'
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
patient.First_Name_M0040
,patient.Middle_Initial_M0040
,patient.Last_Name_M0040
,patient.Suffix_M0040
,patient.Street_Address
,patient.Mailing_Address
,patient.City
,patient.State_M0050
,patient.Zip_M0060
,patient.Gender_M0069
,patient.DOB_M0066
,patient.Telephone
,patient.Agency_Assigned_ID
,patient.Current_Payment_Sources_M0150
,patient.Medicare_Number_M0063
,patient.Medicaid_Number_M0065
,patient.Financial_Factors_M0150
,ScheduleItems.Visit_Type
,Assessment_New.Source_of_Admission
,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
,Assessment_New.M1016_DX_NA
,Assessment_New.Grooming_M0640
,Assessment_New.Dress_Upper_M0650
,Assessment_New.Dress_Lower_M0660
,Assessment_New.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
,COUNT(*) as LookBack
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)
AND ScheduleItems.Visit_Type IN ('Assessment','Admission Visit','Re-Certification Visit','1 - Start of Care - further visits planned','4 - Recertification (follow-up) reassessment')
And Assessment_New.Assessment_Reason_M0100 IN ('1 - Start of Care - further visits planned','4 - Recertification (follow-up) reassessment')
AND Assessment_New.Deleted = 0
AND ScheduleItems.Deleted = 0
AND ScheduleItems.EClaimed = 0
GROUP BY patient.Patient_ID
SELECT
patient.First_Name_M0040
,patient.Middle_Initial_M0040
,patient.Last_Name_M0040
,patient.Suffix_M0040
,patient.Street_Address
,patient.Mailing_Address
,patient.City
,patient.State_M0050
,patient.Zip_M0060
,patient.Gender_M0069
,patient.DOB_M0066
,patient.Telephone
,patient.Agency_Assigned_ID
,patient.Current_Payment_Sources_M0150
,patient.Medicare_Number_M0063
,patient.Medicaid_Number_M0065
,patient.Financial_Factors_M0150
,ScheduleItems.Visit_Type
,Assessment_New.Source_of_Admission
,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
,Assessment_New.M1016_DX_NA
,Assessment_New.Grooming_M0640
,Assessment_New.Dress_Upper_M0650
,Assessment_New.Dress_Lower_M0660
,Assessment_New.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
,COUNT(*) as LookBack
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)
AND Assessment_New.Deleted = 0
AND ScheduleItems.Deleted = 0
GROUP BY patient.Patient_ID
0>
#cfcatch.Message# :: #cfcatch.Detail#
CAHPS
You reached this page by error. Plesae submit the CAHPS Form located Here