SELECT dr.*,p.Pt_Last, p.Pt_First,p.Pt_Agy_ID, p.Status,ass.F26,py.Pay_Name,ptpay.Sub_First,ptpay.Sub_Last, inv.Invoice_ID,inv.DateSent FROM #Request.prefix_db_agency#.DRC dr JOIN #Request.prefix_db_agency#.pPatients p ON dr.Patient_ID = p.patient_ID AND p.Status IN (0,1,4) JOIN #Request.prefix_db_agency#.pAssessments ass ON dr.Assmt_ID = ass.Assmt_ID AND ass.Status = 0 JOIN #Request.prefix_db_agency#.pPtPayer ptpay ON dr.PtPayer_ID = ptpay.PtPayer_ID AND ptpay.Status = 0 JOIN #Request.prefix_db_agency#.pPayer py ON py.Pay_ID = ptpay.Payer_ID AND py.Status = 0 JOIN #Request.prefix_db_agency#.pSchedules sch ON sch.Schedule_ID = dr.Schedule_ID AND sch.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.Invoices inv ON inv.Invoice_ID = sch.Invoice_ID AND inv.Deleted = 0 WHERE MONTH(Start_Date) = MONTH('#url.monthYear#') AND YEAR(Start_Date) <= YEAR('#url.monthYear#') GROUP BY dr.DRC_ID SELECT p.Patient_ID, p.Pt_Last, p.Pt_First, p.Status FROM #Request.prefix_db_agency#.pPatients p WHERE p.Loc_ID = '#session.agencyid#' AND p.Status < 2 ORDER BY p.Pt_Last ASC, p.Pt_First ASC SELECT e.Emp_ID, e.Emp_Last, e.Emp_First, e.Status FROM #Request.prefix_db_lookup#.pEmployee e WHERE e.Loc_ID = '#session.agencyid#' AND e.Emp_Type = 'employee' ORDER BY e.Emp_Last ASC, e.Emp_First ASC
Daily Revenue Calculation
Fetch latest report Export Report

total_visits - #total_visits#
LUPA - #LUPA#
completed_visits - #completed_visits#
Patient    Name MRN Assessment    Payer SOC Date Current
Billing Period		 Start Date Billing Period
End Date		 Discharge
Date		 Month End Bill PD Days
in CM		 Total
Period		 HIPPS LUPA
Threshold		 Completed
Visits		 Estimated
Episode Payment		 CM Gross
Revenue		 CM
Sequester		 Adjusted
Daily Rate		 CM Net
Revenue		 Invoice ID Invoice Date
#Pt_Last#, #Pt_First# #Pt_Agy_ID# #F26# #Pay_Name# #DateFormat(SOC_Date,"mm/dd/yyyy")# #First_or_second_Period# #DateFormat(Start_Date,"mm/dd/yyyy")# #DateFormat(End_Date,"mm/dd/yyyy")# #DateFormat(Discharge_Date,"mm/dd/yyyy")# #DateFormat(endofmonthday,"mm/dd/yyyy")# #Num_days# #Total_Periods# #HHRG# #LUPA# style="color:red;" --->>#completed_visits# #Payment# #CM_Gross# #CM_Sequester# #Total_CM# #CM_Net# #Invoice_ID# #DateFormat(DateSent,"mm/dd/yyyy")#