SELECT si.Payer_Id, COUNT(si.ScheduleItems_Id) as TotalVisits, si.Visit_Date, SUM(si.Total_Hours) as TotalHours, si.Output_Type ,p.Payer_Id, p.PayerType, p.PayName, an.Assessment_Tracker_Id, an.Certification_Start AS CSTART, an.Certification_End AS CEND ,SUM(an.Homebound_Status) AS MCARE, an.Homebound_Status, SUM(si.Total_EClaim) AS TotalBilled FROM ScheduleItems si, Payer p, Assessment_New an WHERE si.Agency_ID = '#session.AgencyId#' AND si.Assessment_Tracker_ID = an.Assessment_Tracker_ID AND si.Payer_Id IS NOT NULL AND si.Deleted <> 1 AND an.Deleted <> 1 AND si.Visit_Date BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND p.Payer_Id = si.Payer_Id AND p.PayerType IN ( ) GROUP BY p.Payer_Id, p.PayerType, si.Output_Type ORDER BY p.PayName, p.PayerType, si.Output_Type
Payer Visits by Payer Type and Date Range

Total Visits by Payer for #Form.From_Date# to #Form.To_Date# #dt_Diff#

  « Go Back

bgcolor="##FFFFFF" bgcolor="##e7e7e9">
Payer Name Payer Type Output Type Visits Hours Billed
No Payers were found based on your search criteria
#PayName#  #PayerType# #Output_Type# #TotalVisits# #DecimalFormat(TotalHours)# #LSCurrencyFormat(MCARE, "local")##LSCurrencyFormat(TotalBilled, "local")#