AICS Research


Branch
Transaction
Report


Last updated:

February 15, 1999
Summit Spectrum 28.13

Report highlights

This report uses the data collected in the Branch Transaction databases to summarize the transactions performed by tellers during the day. Combined with the flexibility allowed in creating the branch transaction database, you are allowed almost complete flexibility over the commands to include, the tellers and/or accounting centers to include and the time intervals to report.

For example, you could determine the number of cash transactions performed by tellers at a specified branch, for each hour during the day. After running the report over a period of times, you would have empirical information regarding cash and staffing needs.

A job and macro are included to allow you to automate this report for running each month-end.


Files included
  • BrchTrnW - QueryCalc worksheet
  • BrchTrnM - QueryCalc macro
  • BrchTrnJ - job which runs the macro
  • Readme.txt - a text file of instructions

Databases accessed
  • CONTRL - Spectrum Image Database
  • LBRTRAN-PRDB
    - KSAM Database created by QueryCalc

Special Requirements

PostScript printer. In order to print the report to the PostScript form provided, you must have a PostScript printer. If you do not have a PostScript printer, you will need to edit the layout page(s).

Other Reports. The pseudodatabase used, (MCUDB) must be downloaded from this site and added to the QueryCalc dictionary.

QC Reports   QueryCalc

     Top