SELECT pay.* FROM #Request.prefix_db_agency#.pPayer pay WHERE pay.Loc_ID = #session.AgencyID# and pay.Status != 2 GROUP BY pay.Pay_ID ORDER BY pay.Status,pay.Pay_Name

Payer List #getPay.Pay_Name#

New Payer Back

Name	Type	Payer ID	Provider ID	M0150	Bill Freq	GL Account	Output	Status	Action
Encrypted_Pay_ID=encrypt(#Pay_ID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); #Pay_Name#	#Biller_Type#	#Payer_No#	#Submitter_ID#	#Left(M0150,15)#...	#Pay_frequency#	#GL_account#	#Output#	ActiveInactive