FRS Bank Reconciliation Jobs

Owned by Kathleen Avery (Deactivated)
Nov 13, 2014
1 min read
  1. Read through the check reconciliation table and select all un-reconciled state bank records
    --  (BANK-NUMBER = 'xx' AND DROP-FLAG NOT = '!').
  2. Match the extracted records with the VOUCHER table. If the date in the VOUCHER table is less than or equal to the date from the control record, the extract record is selected.
  3. Match the selected extract records against the FRS check reconciliation table. Matched records are flagged to be dropped from the check reconciliation table and are flagged as recoiled in the VOUCHER table.

*** DB2 tables are updated. ***

VBM001UC

Matches the extract file created in STEP02 against the FRS check reconciliation table. Matched records are flagged to be dropped from the table and are flagged in the VOUCHER table. A reconciliation report is produced. Updates the VC and VO tables.

VBM001U2

Does the same thing as VBM001UC, except it was created in July 2001 to run for BANK01 only. BANK01 is for student checks, all of which have the same vendor. A new index had to be added (BANK-NUM, CHECK-NUM) to the VOUCHER table to eliminate tablespace scans for each check being reconciled. Uses cloned copybook, FCVORCUC, and cloned COBOL IO program, FSVOIOUC, to pick up the new UConn-added index.

 
VBM094

Reads the check reconciliation VSAM file to create an outstanding check report. 

 J9615M03 (BANK=15)  Bank 15 Check Reconciliation

 

VBM001UC    UAPFRSP.FRSPROD.CTLLIB(C9615M03)

PGM=VBM001,BANK=15,TAPEFORMAT=NEW
VBM094UAPFRSP.FRSPROD.CTLLIB(C9615M04)
PGM=VBM094,BANK=15,TYPE=OUT,SELECT-THRU=11/30/2013

 
J9615M05 (BANK=04)  Bank 04 Check Reconciliation

VBM001UC   UAPFRSP.FRSPROD.CTLLIB(C9615M05)

PGM=VBM001,BANK=04,TAPEFORMAT=NEW
VBM094UAPFRSP.FRSPROD.CTLLIB(C9615M06)
PGM=VBM094,BANK=04,TYPE=OUT,SELECT-THRU=11/30/2013

 

J9615M06 (BANK=17) Bank 17 Check Reconciliation

VBM001UC   UAPFRSP.FRSPROD.CTLLIB(C9615M6A)

PGM=VBM001,BANK=17,TAPEFORMAT=NEW
VBM094UAPFRSP.FRSPROD.CTLLIB(C9615M6B)
PGM=VBM094,BANK=17,TYPE=OUT,SELECT-THRU=11/30/2013

 
J9615M11 (BANK=01)  Bank 01 Check Reconciliation


VBM001U2   UAPFRSP.FRSPROD.CTLLIB(C9615M1A) 

PGM=VBM001,BANK=01,TAPEFORMAT=NEW
VBM094UAPFRSP.FRSPROD.CTLLIB(C9615M1B)
PGM=VBM094,BANK=01,TYPE=OUT,SELECT-THRU=11/30/2013

 
J9615M18 (BANK=18)  Bank 18 Check Reconciliation

VBM001UC   UAPFRSP.FRSPROD.CTLLIB(C9615M2A)

PGM=VBM001,BANK=18,TAPEFORMAT=NEW
VBM094UAPFRSP.FRSPROD.CTLLIB(C9615M2B)
PGM=VBM094,BANK=18,TYPE=OUT,SELECT-THRU=11/30/2013

 
J9615M19 (BANK=16)  Bank 16 Check Reconciliation

VBM001UC   UAPFRSP.FRSPROD.CTLLIB(C9615M9A)

PGM=VBM001,BANK=16,TAPEFORMAT=NEW
VBM094UAPFRSP.FRSPROD.CTLLIB(C9615M9B)
PGM=VBM094,BANK=16,TYPE=OUT,SELECT-THRU=11/30/2013