SELECT * FROM #Request.prefix_db_lookup#.cron_835 WHERE Agency_ID = '#session.agencyid#' AND status = 0 AND payment_pushed = 0 GROUP BY Remit_No,CLP_ID ORDER BY Remit_No,CLP_ID ASC

Cron 835 Payment Claims

Patient Name	Date Deposit	Deposit_Type	Date Check/ Status	Remit_No	Pay Name	Payer type	Net Total	Paid Amount	Action
#Patient_Name#	#dateformat(Date_Deposit,"yyyy-mm-dd")#	#Deposit_Type#	#dateformat(Date_Check,"yyyy-mm-dd")#	#Remit_No#	#Left(Pay_Name,30)#..	#Payer_Type#	#Net_Total#	#Paid_Amount#