SELECT Payer.PayName, ScheduleItems.Visit_Type AS TYPE, ScheduleItems.Output_Type,
ScheduleItems.Visit_Date, ScheduleItems.Missed, ScheduleItems.Payer_ID, SUM(ScheduleItems.Total_Hours) as TotalHours, SUM(ScheduleItems.Total_EPay) as PAY,ScheduleItems.Payer_ID,
COUNT(ScheduleItems.Total_Hours) as TotalVisits, SUM(an.Homebound_Status) AS MCSUM, SUM(ScheduleItems.Total_EClaim) AS TotalBilled,
Payer.Output_Type AS OTYPE
FROM #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.Payer, #Request.prefix_db_agency#.Assessment_New an
WHERE ScheduleItems.Agency_ID = #session.AgencyID#
AND ScheduleItems.Assessment_ID = an.Assessment_ID
And ScheduleItems.Payer_ID = #url.ID#
AND ScheduleItems.Missed ="No"
And ScheduleItems.Deleted <> 1
AND ScheduleItems.Visit_Date BETWEEN '#Session.Start#' AND '#Session.End#'
AND ScheduleItems.Payer_ID = Payer.Payer_ID
AND ScheduleItems.Output_Type = '#url.out#'
GROUP BY TYPE
Order by TYPE
Lists Visit Type Export
Please Right Click Here and choose "Save Target As..." to download the Exported data file and save it to your computer.
No data could be found based on your search criteria.