Sending Banner Direct Deposit Notices via email

  by Bruce Knox  bknox @t uaex.edu     Oracle Database Programmer/Analyst                                                                 date last updated 02/13/2014
 

  

This page is intended for users of  SCT's Banner Finance Software Only! 

These are programs that we use to send Direct Deposit Notices via email.

   

The program scripts have UNIX commands that are run by using the HOST statement.  We use the HOST abbreviation of ! for our IBM RS6000.  Other servers may use the $ for this abbreviation.

If you are not on a UNIX server, then the underlying statements must be converted as well.  Most of these are just sending information to the user while running the script.  However, each program also removes files and the output files are changed via UNIX commands.

 

create_dd_audit.sql  Create the Direct Deposit Audit Table.  A one time script.

 

Creates Table: dd_audit

The dd_audit table will store the information from the Banner temporary table FATCKIN.

 

dd_audit.sql  Update the dd_audit table with values from the FATCKIN temporary table.  A simple report listing the transactions is sent to the user's monitor.

 

This program updates only the dd_audit tables.  No Banner tables are updated by this user script.

 

dd_email.sql  Create the email messages from today's dd_audit transactions.

 

dd_email_exceptions_print.shl  A script used to test for any email notice exceptions.  If any email addresses are missing a printed notice is created instead.  This script runs from within dd_email.sql

 

The following shows where the scripts are inserted into the standard user procedures:

 

Reimbursement Direct Deposits Process Sequence:

Run FAABATC from Banner Jobsub (FORM to set run parmeters)

Run FABCHKS from Banner Jobsub

Run Access Reports & Check for Credit Memos

  Direct Deposit File

  Direct Deposits with Overridden Cr Memo

Run FAPDIRD from Banner Jobsub

Run dd_audit from Telnet

Run Access Query

  Travel Direct Deposit Audit

Run FABCHKR from Banner Jobsub

Run fapdird.shl from Telnet    (runs dd_email)

Check dd_email_send.shl lis file

FTP dd_trans_travel.txt to Direct Deposit folder on PC and Check File Format

Send Transmission File (dd_trans_travel.txt) to Bank via Hyperterminal

Confirm Transmitted File with Bank

Send email notifications from Telnet (run dd_email_send.shl)

Run FABCHKA from Banner Jobsub

 

Note that we manually run the dd_email_send.shl, but this could be done from within dd_email (your option).


 

 

 

http://betwinx.com/banner_dd_email.htm is a personal site maintained by Bruce Knox ( bknox at uaex.edu )
 

Disclaimer
Use this information and these scripts at your own risk. As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences.  The scripts and information are provided "as is" without warranty, implied or otherwise.  Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:)

Any University of Arkansas Division of Agriculture website Disclaimer terms found in conflict with terms of this disclaimer shall over ride and replace the conflicting terms found herein.


Most of the works of art on my pages
Book Dragon copyright 2006 J. Wilson Spenceare used by permission of J. Wilson Spence.

http://bewinx.com is oriented to Reporting from Ellucian's Banner product. (I maintain a number of special topic pages with links from this primary site.)