Toucnet Bill File PopSel in Banner

 Problem Description : 

How to run the popsels for the bill load in Touchnet Biill+Pay

 Resolution : 

I have placed two batch files under N\BO\SQLS\PopSel Sqls and Batch’s for the Touchnet Bill+Pay Statement Load.

1.TN_BILL – Jackie will run the batch file that will populate the PopSel TN_BILL , then run the ZSRCBIL file based on this PopSel. She can then load that file to Touchnet for Statements.

This sql pulls anyone with a bill date that’s balance is > 0 and the priority code is NOT in (you have four prompts to exclude specific priority codes. Do not leave one blank, just put the letter A in – it will not run if one is blank. EX. P1 883 P2 884 P3 885 P4 593 or if you want to include 883 this time just put P1 A P2 884 P3 885 P4 593) . Always go to GLAEXTR and verify that there is someone in the PopSel and check to be sure it is the correct people.

2.TN_BILLAGEING is the second batch file to run. This time is will Be students who are IN the Priority Codes that you enter. It runs the very same way. You run this file through the ZSRCBIL process as well but do not load this file to Touchnet. This will be used for the aging process only.

 Revision Date : 11/29/2011