AICS Research


Fee Tag File


Last updated:

February 15, 1999
Summit Spectrum 28.13

Report highlights

When MCU's Board of Directors implemented fees on savings and checking accounts, they decided to offer members a way to opt out of the fee. Spectrum's PFeeCalc program's options, however, were insufficient to meet our needs.

This report identifies accounts that should be charged a fee, based on credit union defined criterion. The report uses QueryCalc's storelists and set math capabilities to calculate the accounts to fee and creates the tag file to be used by the posting job. Once you know the format that a tag file must take, it is almost always possible to create it with QueryCalc. In fact, we haven't found a case yet where the tag file could not be created.

The worksheet is all that is necessary to create the report. A template and macro are included to help automated running the report at the end of the month.


Files included
  • PDFeeTgW - QueryCalc worksheet
  • PDFeeTgM - QueryCalc macro
  • TPDFeeT1 - template which runs the macro
  • Readme.txt - a text file of instructions

Databases accessed
  • MEMBRS - Spectrum Image Database
  • PAYROLL-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.

Other Reports. The KSAM database accessed is created with the End-of-Month Database Report.

QC Reports   QueryCalc

     Top