& "," & """" & "Branch_ID" & """"
& chr(13)
& chr(10)
/>
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.Current_Payment_Sources_M0150
,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.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>
& "," & """" & #State_M0050# & """"
& "," & """" & #Zip_M0060# & """"
& "," & """" & #Replace(TelephoneNumber, ",", "", "ALL")# & """"
& "," & """" & #DateFormat(Start_of_Care_M0030,date4mat)# & """"
& "," & """" & #LEFT(Assessment_Reason_M0100, 1)# & """"
& "," & """" & #Agency_Assigned_ID#& """"
& "," & """" & #Medicaid_Number_M0065#& """"
& "," & """" & #SkilledVisitTotal#& """"
& "," & """" & #LookBack# & """"
& "," & """" & #PaySrc1# & """"
& "," & """" & #PaySrc3# & """"
& "," & """" & #Replace(HMO, ",", "", "ALL")#& """"
& "," & """" & #PaySrc8# & """"
& "," & """" & #PaySrc11# & """"
& "," & """" & #AdmissionSourceLTCH# & """"
& "," & """" & #AdmissionSourceIRF# & """"
& "," & """" & #AdmissionSourceSNF# & """"
& "," & """" & #AdmissionSourceNF# & """"
& "," & """" & #AdmissionSourceIPPS# & """"
& "," & """" & #AdmissionSourceNone# & """"
& "," & """" & #MedEligible# & """"
& "," & """" & #HHRG_175_Score# & """"
& "," & """" & #HHRG_230_Score# & """"
& "," & """" & #HHRG_250_Score# & """"
& "," & """" & #HHRG_390_Score# & """"
& "," & """" & #HHRG_420_Score# & """"
& "," & """" & #HHRG_440_Score# & """"
& "," & """" & #SurgicalDischarge# & """"
& "," & """" & """"
& "," & """" & #ADLDeficits# & """"
& "," & """" & #LEFT(Dress_Upper_M0650, 1)# & """"
& "," & """" & #LEFT(Dress_Lower_M0660, 1)# & """"
& "," & """" & #LEFT(Bathing_M0670, 1)# & """"
& "," & """" & #LEFT(M1840_Toilet, 1)# & """"
& "," & """" & #LEFT(Transferring_M0690, 1)# & """"
& "," & """" & #LEFT(Eating_M0710, 1)# & """"
& "," & """" & """"
& "," & """" & #LanguageNum#& """"
& "," & """" & """"
& "," & """" & #AgencyBranchID#& """"
& chr(13)
& chr(10)
/>
Please Right Click Here and choose "Save Target As..." to download the Exported data file and save it to your computer.