II. Creating a Direct Deposit Subscription 1. Enter the secure area of Banner
Student Self Service
2. Select the Student and Financial Aid Menu Option
3. Select the eDeposit Menu option 4. Create Banking Information 5. Confirm the eDeposit Subscription
Agreement
6. Confirm the eDeposit Subscription Acknowledgement
7. Load the Direct Deposit Subscription Data into the PeopleSoft staging table
Using Direct Deposit Subscription
I. Setting Up Codes and Rules
Introduction to
Setup Specific codes and rules are required for processing Direct Deposit Subscriptions. Users establish codes and rules within Banner to allow the students to have the ability to enter, change, inactivate, and delete direct deposit banking information through Banner Student Self Service.
The E-Mail Process Definition Form (ZTVPROC) is used to define the eDeposit process to the e-mail system for the generation of e-mail notifications to students.
The E-Mail Status Definition Form (ZTVSTAT) is used to define the statuses associated with e-mails. Error conditions are also identified.
The E-Mail Rules Form (ZUREMRU) is used to enter the mail host settings for the institution. Users can define the Banner instance as production or test. Production will generate e-mail notifications to the student. Test will generate e-mail notifications to the e-mail address entered in the form.
The E-Mail Text Rules Form (ZURMAIL) is used to create the text and formatting for an mail notification. Types and descriptions of the e-mail notifications are entered or created in this form.
The E-Mail Hierarchy Definition Form (ZUREHIR) is used to define the hierarchy of e-mail types to which e-mail notifications will be generated to students.
The Letter Code Validation Form (GTVLETR) is used to define the letter codes for each type of e-mail notification that will be processed through direct deposit subscription.
The E-Mail Process/Letter/Status Control Form (ZUREPLS) is used to define the status of each letter code. The letter codes associated with direct deposit subscription are defined with system-required value of HOLD as the status.
The Direct Deposit Control Form (ZSRDDRU) is used to control the direct deposit processes. Users have the ability to activate or inactivate the Web subscription and Web refund. Agreement text is stored in this form.
The Bank Routing Number Load (ZGRDIRD) is used to load bank routing numbers from an ACH file into the Bank Routing Number Validation Form (GXVDIRD).
The Bank Routing Number Validation Form (GXVDIRD) is used to store the bank routing numbers.
1. Define an e-mail
process Define a Direct Deposit Subscription process to the e-mail system.
Note: The system-required value EDEPOSIT is delivered through a script to load the record. This record should not be updated or deleted.
2. Define e-mail statuses and identify error conditions
Define e-mail statuses and identify potential error conditions in the E-Mail Status Definition Form (ZTVSTAT).
Note: The system-required values to support Direct Deposit are
delivered with a script. These delivered values should not be updated or deleted.
for the generation of e-mail notifications.
4. Create text and formatting for e-mail notifications
Create the text and formatting for e-mail notifications in the E-Mail Rules Form (ZURMAIL). The type and description may be entered, created, or updated from this form. When a transaction is created through Banner Student Self Service, the e-mail notification text and format will be sent to the student.
There are four types of transactions that will generate an e-mail
notification. Each notification is generated based on the text and format entered in this form.
• DDACT: This notification is generated when a direct deposit subscription is activated.
• DDCHG: This notification is generated when a direct deposit subscription is changed.
• DDDEL: This notification is generated when a direct deposit subscription is deleted.
• DDINACT: This notification is generated when a direct deposit subscription is inactivated.
5. Define the e-mail
type hierarchy Define the e-mail type hierarchy in the E-Mail Hierarchy Definition Form (ZUREHIR). The process code EDEPOSIT is used for the address selection hierarchy.
6. Define letter The Letter Code Validation Form (GTVLETR) is used to define the
7. Define letter
code statuses The E-Mail Process/Letter/Status Control Form (ZUREPLS) is used to define the status of each letter code. The letter codes are defined with a system required HOLD status. E-mail requests are ‘released’ and changed to the status of SEND automatically once the subscription data is created, audit records are generated, and PeopleSoft data is created.
Note: Required values to support Direct Deposit Subscription are preloaded with delivered scripts.
8. Establish Direct Deposit Process Controls
The Direct Deposit Rules Form (ZSRDDRU) is used to control the Direct Deposit Process as follows:
• Turn on and off the link to the Direct Deposit Subscription and Refund Status pages on Banner Student Self Service.
• Create/edit the agreement text displayed on the agreement verification page of Banner Student Self Service.
• Create/enter hierarchy of address types. Note: The direct deposit process uses this hierarchy when selecting the student address to load into PeopleSoft.
The Web Subscription and Web Refund Enabled indicators allow the user to control the WebTailor settings that create the menu item. The menu items are available when the indicators are marked with a check.
The Agreement Text provides the user with the ability to enter the text that is displayed when students subscribe to Direct Deposit. Note: The agreement text should follow National Automated Clearing House Association (NACHA) standards.
PeopleSoft requires address information for the processing of direct deposit subscriptions. The Address Hierarchy provides the priority for which an address will be selected to load into PS.
9. Load bank
routing numbers The Bank Routing Number Load (ZGRDIRD) is used to insert bank routing numbers in the Bank Routing Number Validation Form (GXVDIRD).
ACH File The ACH file is obtained from the Federal Reserve Financial Services Web site. The location is:
https://www.fededirectory.frb.org/download.cfm
The Receive All FedACH Participant RDFIs link should be selected to download the file containing the bank routing numbers. The files must then be moved from the location and saved to the
$DATA_HOME/tapedata/arsys directory for the ZGRDIRD process to read.
The parameters displayed in the Job Submission Form (GJAPCTL) are as follows. The parameter number, name, requirement, and description are provided to assist you when entering the parameter values.
Parameters for ZGRDIRD
No Name Required? Description/Instructions
Default Values 01 Fed ACH Data
File Name
Yes Enter the name of the file downloaded.
Samples of the zgrdird.log and zgrdird.lis files follow.
Sample zgrdird.log
Sample zgrdird.lis
10. Validate bank
routing numbers The Bank Routing Number Validation Form (GXVDIRD) is used to store the bank routing numbers for the purposes of validating when direct deposit subscription data is entered through Banner Student Self Service.
Note: Required values are preloaded for the purposes of Direct Deposit Subscription
II. Creating a Direct Deposit Subscription
Introduction to Direct Deposit Web Interface
The second major step in Direct Deposit Subscription is creating subscription data in Banner Student Self Service.
The user enters the secure area of Banner Student Self Service acting as a student. The eDeposit menu appears after selecting the Student and Financial Aid Menu option.
The eDeposit Subscription page provides the user with information regarding the subscription of direct deposit to an account. A sample check is displayed to provide the user with the location of the bank routing and account numbers. The user enters this data to create a subscription record. An e-mail notification is generated at the time the subscription is created.
The eDeposit Subscription Agreement page provides the institution permission to submit financial aid proceeds and other refunds to the bank account provided by the student.
The eDeposit Subscription Acknowledgement provides the user notification that data related to direct deposit have been
received/processed.
The eDeposit Subscription records generated are fed to PeopleSoft Financials. The information processed will allow for the creation of the ACH file to be sent to the bank for processing.
1. Enter secure area of Banner Self Service
Enter the Secure Area of Banner Student Self Service.
Acting as a student, enter a login and password.
3. Select eDeposit
Menu Select the eDeposit Menu Option.
4. Create Banking
Information Enter the Bank Routing Number and the Bank Account Number that will be used to direct deposit financial aid proceeds and other refunds.
A sample check is provided to display the information required for processing.
5. Confirm eDeposit subscription agreement
The eDeposit Agreement is displayed when the user submits the routing and account numbers. The agreement text follows NACHA standards for the submission of banking information online.
6. Confirm Acknowledge-ment
The eDeposit Subscription Acknowledgement is displayed as a confirmation to the user that the information has been
received/processed.
7. Load Records into PeopleSoft
The loading of the subscription data into PeopleSoft Financials happens automatically by a trigger in the system. Once the Banner tables are saved, the data is sent through the Banner to PeopleSoft link to a staging table where it awaits further processing to be loaded in the required PeopleSoft tables.