AICS Research


Loans to
Officials
Report


Last updated:

January 31, 2000
Summit Spectrum 28.4

Report highlights

Credit unions are required to report loans to credit union officials whenever submitting their call reports. The most common method is to gather the information, either manually or with a report, and then type the information onto the required form. This method often allows unintentional errors and can take an extended period of time to complete.

This report uses QueryCalc to retrieve the information from the databases and QueryCalc's postscript capabilities to recreate the form used by the State of Missouri. By launching a template, the credit union will receive a copy of their financial statements and the Report of Loans to Credit Union Officials.

The form can be changed to duplicate the one needed by your credit union. A list of credit union officials is maintained by the credit union and used as the source of accounts to be reported.


Files included
  • Ln2OffcW - QueryCalc worksheet
  • Ln2OffcM - QueryCalc macro
  • TCallRp1 - template which runs the macro
  • Readme.txt - a text file of instructions

Databases accessed
  • REPORT
    - Spectrum Image Database (copy of MEMBRS)
  • MCUDB
    - Pseudodatabase created by Mizzou Credit Union

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