select * from #Request.prefix_db_agency#.pPayer WHERE Loc_ID = '#session.AgencyID#' and Status = 0 SELECT MAX(s.Payment_ID) as Payment_ID,s.PaymentDate,s.Record_Created_By, (select sum(s.Amount) from #Request.prefix_db_agency#.Payments s WHERE s.invoice_id = p.invoice_id AND s.PaymentDate >= #CreateODBCDate(url.df)# AND s.PaymentDate <= #CreateODBCDate(url.dt)# and s.deleted <> 1) as paid, (select s.PaymentDate from #Request.prefix_db_agency#.Payments s WHERE s.invoice_id = p.invoice_id AND s.PaymentDate >= #CreateODBCDate(url.df)# AND s.PaymentDate <= #CreateODBCDate(url.dt)# AND s.Amount > 0 and s.deleted <> 1 ORDER BY s.PaymentDate DESC LIMIT 0,1) as paid_date, (s.WriteOffAmount) as WriteOffAmount, s.PatientPayer_ID , (select sum(writeoffamount) from #Request.prefix_db_agency#.Payments where invoice_id = p.invoice_id and Deleted <> 1 AND s.PaymentDate >= #CreateODBCDate(url.df)# AND s.PaymentDate <= #CreateODBCDate(url.dt)# ) as wOff, p.PayerBalance,p.claim_status, pa.Patient_ID, pa.Pt_Last, a.F177 AS STARTS, a.F178 AS ENDS , CASE WHEN DATEDIFF(p.DateSent,a.F177) < 30 THEN a.F177 WHEN DATEDIFF(p.DateSent,a.F177) >= 30 THEN DATE_ADD(a.F177, INTERVAL 30 DAY) ELSE a.F177 END as START, CASE WHEN DATEDIFF(p.DateSent,a.F177) < 30 THEN DATE_ADD(a.F177, INTERVAL 29 DAY) WHEN DATEDIFF(p.DateSent,a.F177) >= 30 THEN DATE_ADD(a.F177, INTERVAL 59 DAY) ELSE a.F178 END as END, a.F26 AS TYPE, pa.Pt_First, pa.Status,pa.Pt_Agy_ID, DATE_FORMAT(pa.Pt_DOB,'%m/%d/%Y') AS DateOfBirth, (SELECT Date_Deposit FROM #Request.prefix_db_agency#.pDeposit WHERE pDeposit.Internal_control_number = p.Internal_control_number AND pDeposit.Status = 0 ORDER BY Date_Deposit DESC LIMIT 0,1) AS Date_Deposit, (SELECT Min(Visit_Date) FROM #Request.prefix_db_agency#.pSchedules where Assmt_ID = p.Assmt_ID AND p.Invoice_ID = pSchedules.Invoice_ID and status = 0 ORDER BY Visit_Date) as MIN, (SELECT Max(Visit_Date) FROM #Request.prefix_db_agency#.pSchedules where Assmt_ID = p.Assmt_ID AND p.Invoice_ID = pSchedules.Invoice_ID and status = 0 ORDER BY Visit_Date) as MAX, p.Invoice_Id, p.Comment, p.Output as POUT, DATE_FORMAT(p.DateSent,'%Y-%m-%d') AS DateSent, DATEDIFF(CURDATE(), p.DateSent) AS age, MAX(DATE_FORMAT(s.PaymentDate,'%Y-%m-%d')) AS PaymentDate, DATE_FORMAT(p.DateSent,'%m/%d') AS ds, (p.InvoiceTotal) as InvoiceTotal, p.PayerBalance, pr.Pay_ID, pr.Pay_Name, pr.Payer_No, p.Output AS PayerOutputType, (SELECT Invoice_Id FROM #Request.prefix_db_agency#.Invoices WHERE Assmt_ID = p.Assmt_ID AND InvoiceTotal = '0.00' and Deleted <> 1 LIMIT 1) AS FinalBilling, (p.InvoiceTotal - (select sum(amount + writeoffamount + Pay_Seq_Amount) from #Request.prefix_db_agency#.Payments where invoice_id = p.invoice_id and Deleted =0)) AS remaining_amount from #Request.prefix_db_agency#.Payments s JOIN #Request.prefix_db_agency#.Invoices p on p.Invoice_ID = s.Invoice_ID JOIN #Request.prefix_db_agency#.pPatients pa on p.patient_id = pa.patient_id JOIN #Request.prefix_db_agency#.pPayer pr on p.PatientPayer_ID = pr.Pay_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments a on p.Assmt_ID = a.Assmt_ID AND a.status = 0 WHERE p.Agency_Id = '#session.agencyid#' AND pa.Status IN (#Request.patient_status#) AND (a.status = 0 OR p.Assmt_ID = 0) AND pr.Pay_ID = '#url.ID#' AND p.Output like '#url.Output#' AND s.PaymentDate >= #CreateODBCDate(url.df)# AND s.PaymentDate <= #CreateODBCDate(url.dt)# AND pa.Patient_ID = '#url.patient_filter#' AND pa.Patient_ID = '#form.patient_filter#' AND s.PaymentDate >= #CreateODBCDate(form.df)# AND s.PaymentDate <= #CreateODBCDate(form.dt)# AND s.Deleted <> 1 AND p.Deleted <> 1 AND (p.InvoiceTotal > 0 ) AND p.Output is not null AND (s.Amount > 0 OR claim_status = 'Paid' OR (p.InvoiceTotal - (select sum(amount + writeoffamount + Pay_Seq_Amount) from #Request.prefix_db_agency#.Payments where invoice_id = p.invoice_id and Deleted =0)<= 0 ) ) Group BY p.Invoice_Id ORDER BY Pt_Last, Pt_First ASC SELECT DISTINCT p.Patient_ID, p.Pt_Last, p.Pt_First, p.Status FROM #Request.prefix_db_agency#.pPatients p, #Request.prefix_db_agency#.Invoices i WHERE p.Loc_ID = '#session.agencyid#' AND p.Status = 0 AND i.Patient_ID = p.Patient_ID AND i.PatientPayer_ID = #GetI.Pay_ID# Group by p.Patient_ID ORDER BY p.Pt_Last

Paid Claim Details For #GetI.Pay_Name#

Back &df=#url.df#&dt=#url.dt#&payer_filter=#url.payer_filter#&patient_filter=#url.patient_filter#"> Export Report

	Patient	MRN	Assessment	Billing Period	Output	Invoice ID	Date Billed	Date Paid	Amount Paid	claim Status	Adjustment	Delete
	#Pt_Last#, #Pt_First#	#Pt_Agy_ID#	SOCRECERT	#DateFormat(MIN,"mm/dd/yy")# - #DateFormat(MAX,"mm/dd/yy")# #DateFormat(MIN,"mm/dd/yy")# - #DateFormat(MIN,"mm/dd/yy")# #DateFormat(START,"mm/dd/yy")# - #DateFormat(END,"mm/dd/yy")# #DateFormat(MIN,"mm/dd/yy")# - #DateFormat(MAX,"mm/dd/yy")#	#POUT#	#Invoice_ID#	#DateFormat(DateSent,"mm/dd/yy")#	#DateFormat(paid_date,"mm/dd/yy")#	#DollarFormat(paid)# By Remit	style="color:red; font-weight:bold;"style="color:green; font-weight:bold;"> #claim_status#	#DollarFormat(wOff)#	Delete

TOTALS #DollarFormat(tDue)#

No Payments were found.