University of ConnecticutCheck Reconciliation (EDI)
Introduction
The previous section described the FRS System's standard processing capabilities to reconcile checks issued from any of the FRS Memo Banks and associated checking accounts. This section will describe the process forexchanging check reconciliation data with the bank through Electronic Data Interchange (EDI) procedures. In this process, the data is transmitted electronically from the bank to UConn, and vice versa, instead of exchanging magnetic tapes. As of the date of publishing this document (August 1994), capability being used with Shawmut Bank for the exchange of check data pertaining to FRS Memo Bank 15.
SHAWMUT BANK Check Reconciliation (EDI)
FRS Production Jobs
SHAWMUT Bank check reconciliation is accomplished by scheduling and running the following FRS production jobs:
Memo Bank 15
- J9615S92 - Check Data Transmission Shawmut To UITS (EDI) - Bank15
- J9615S93 - SHAWMUT Check Reconciliation Reformatter (EDI) - Bank 15
- J9615M03 - VBM001/VBM094: SHAWMUT Bank Check Reconciliation
- J9615R08 - VBM094: Check File Reports (Outstanding/Reconciled/Void)
Procedures
The procedures for performing SHAWMUT Bank check reconciliation through the University Information Technology Services (UITS) are as follows:
- J9615S92 is submitted remotely by Shawmut Bank data control personnel via the established dialup procedure. Transmission timing is governed by the bank's monthly check clearing cycle. The FRS System Administrator is alerted to the execution of this job when a copy of the JES JobLog is sent to the reader of CMSID CONADM02.
- Following successful execution of J9615S92, the FRS System Administrator should submit the the job request form for J9615S93 to the UITS Scheduling Department.
- After J9615S93 has been run, the FRS System Administrator should review the job output for accuracy.
- When satisfied with the results of J9615S93, the FRS System Admin should update the Control Cards for jobs J9615M03 and J9615R08 and then place these jobs on the FRS schedule. The standard FRS schedule segment 'CHKS2'(BANK 15) should be inserted into the Weekly (FRIDAY)schedule from within the UCONN SCHEDULING MANAGER (UCSCHED).
NOTE: Jobs J9615M03 and J9615R08 are normally scheduled on the Weekly (FRIDAY) schedule so that they run over the weekend. This is done since J9615M03 sometimes runs an exceptionally long time dependent on the amount of input data.
SHAWMUT BANK Output Data File Creation
An essential part of the full check reconciliation procedure for Memo Bank 15 is the regular creation of an output data file for Shawmut Bank which identifies the checks written by FRS during the period since the most recent file was created. This output data file is normally created weekly and during FRS month-end processing. The bank uses this data as input to its own reconciliation and reporting process. As with the transmission of data from Shawmut to UConn described above, this outgoing data file from UConn is transmitted to the bank through Electronic Data Interchange (EDI) via the established dialup procedure.
FRS Production Jobs
Creation of the SHAWMUT Bank output data file is accomplished by scheduling and running the following FRS production jobs:
Memo Bank 15
- J9617M01 - SHAWMUT BANK Data Creation
- J9617S12 - Check Data Transmission UITS To Shawmut (EDI) - Bank15
Procedures
The procedures for requesting creation of the SHAWMUT Bank output file data through the University Information Technology Services (UITS) are as follows:
- J9617M01 runs on the FRS Weekly (Friday) and Month-end schedules. This job creates an original copy of the SHAWMUT output for University Information Technology Services (UITS) retention. It also updates the FRS Check Reconciliation File to indicate that specific checks have been reported to the bank.
- After J9617M01 has been run, the FRS System Administrator should review the job output for accuracy.
- When satisfied with the results of J9617M01, the FRS System Administrator should submit the job request form for J9617S12 to the UITS Scheduling Department. J9617S12 copies the UITS file tape to a data file on the JES spool. The file is retained on the JES spool until the bank dials in according to a predetermined schedule, at which time transmission takes place.
- The FRS System Administrator is alerted to the execution of J9617S12 when a copy of the JES Job Log is sent to the reader of CMSID CONADM02.
- Following successful execution of J9617S12, the FRS System Administrator must FAX a copy of the monthly Issue File Transmittal Letter to the Shawmut Account Reconcilement Service (FAX number 800-945-8062).