�STORE/RESTORE-HP/3000.MPEXL  3	� �������B5152AA  C602403/16/010000���?fS���U� 8�_���NEWLOANJ        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS���U� %�V��+�NEWLOANM        QCPUB           AICS            MGR             AICS            MGR     AICS    `0�����?fS���U� �=���0NEWLOANT        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS���U� !�M��(NEWLOANW        QCPUB           AICS            MGR             AICS            MGR     AICS    `�������(���H00000000000000000                            000000STORE  new@;*v
����������������� fS���U� 8�_���� ����DISC                             1NEWLOANJ        QCPUB           AICS                            MGR     AICS    �fS5��'UV5��'UV5��'��5��'����P�  5��'��AICS            ��!JOB NEWLOANJ,MGR.CU1,QCPUB                                                     !COMMENT                                                                        !COMMENT  ****************************************                              !COMMENT  ***  PRINT MONTHLY NEW LOAN REPORTS  ***                              !COMMENT  ****************************************                              !COMMENT                                                                        !SHOWTIME                                                                       !FILE QCMACROF=NEWLOANM.QCPUB.CU1                                               !RUN QCX.QCPROGS.AICS                                                           !SHOWTIME                                                                       !SET STDLIST=DELETE                                                             !EOJ                                                                             ��������.4fS���U� %�V�+�+�� ����DISC                             1NEWLOANM        QCPUB           AICS                            MGR     AICS    �fS5��$`5��$`5���O5���O+�0,,++���  5���OAICS            +�+�QCMACRO   NEWLOANM                                                                                                                                                                                                                                                 10  >********************************                                                                                                                                                                                                                          20  >***  LOAN PRODUCTION REPORT  ***                                                                                                                                                                                                                          30  >***                          ***                                                                                                                                                                                                                          40  >***   CREATE NEWLOAN-PRDB    ***                                                                                                                                                                                                                          50  >********************************                                                                                                                                                                                                                          60  /LOAD NEWLOANW.QCPUB.CU1                                                                                                                                                                                                                                   70  !!A:B                                                                                                                                                                                                                                                      80  /PRINTDB B NEWLOAN                                                                                                                                                                                                                                         90  >                                                                                                                                                                                                                                                         100  >***********************************                                                                                                                                                                                                                      110  >***        PRINT DETAILED       ***                                                                                                                                                                                                                      120  >***  APPROVED/TURNDOWN REPORTS  ***                                                                                                                                                                                                                      130  >***********************************                                                                                                                                                                                                                      140  !!C:G                                                                                                                                                                                                                                                     150  /PRINT E S FORMC                                                                                                                                                                                                                                          160  /PRINT F S FORMD                                                                                                                                                                                                                                          170  >                                                                                                                                                                                                                                                         180  >*******************************                                                                                                                                                                                                                          190  >***  PRINT SUMMARY REPORTS  ***                                                                                                                                                                                                                          200  >*******************************                                                                                                                                                                                                                          210  /PRINT G S                                                                                                                                                                                                                                                220  >                                                                                                                                                                                                                                                         230  >***************************************                                                                                                                                                                                                                  240  >***  PRINT OFFICER SUMMARY REPORTS  ***                                                                                                                                                                                                                  250  >***************************************                                                                                                                                                                                                                  260  !!H                                                                                                                                                                                                                                                       270  LISTFILE #1=!O                                                                                                                                                                                                                                            280  ON END OF LIST #1 EXITOFF                                                                                                                                                                                                                                 290  LOOPOFF:                                                                                                                                                                                                                                                  300  READ LISTFILE #1                                                                                                                                                                                                                                          310  HD33:$"%LISTITEM1"                                                                                                                                                                                                                                        320  !!HA33:HZ90                                                                                                                                                                                                                                               330  !!I                                                                                                                                                                                                                                                       340  /PRINT I S                                                                                                                                                                                                                                                350  GOTO LOOPOFF                                                                                                                                                                                                                                              360  EXITOFF:                                                                                                                                                                                                                                                  370  /SAVE NEWLOANW                                                                                                                                                                                                                                            380  >                                                                                                                                                                                                                                                         390  >*******************************                                                                                                                                                                                                                          400  >***  PRINT SUMMARY REPORTS  ***                                                                                                                                                                                                                          410  >*******************************                                                                                                                                                                                                                          420  /PRINTER ACC                                                                                                                                                                                                                                              430  /PRINT G S                                                                                                                                                                                                                                             .4��������r`fS���U� �=�pp� ����DISC                             1NEWLOANT        QCPUB           AICS                            MGR     AICS    �fS5�¢�5�¢�5�©+�5�©+��0
���EpP�% %  5�©+�AICS            �0                 QueryCalc Reports for Credit Unions                                               written by:  Mizzou Credit Union                                                     last update:  01/01/99                                                                                                                                            LOAN PRODUCTION REPORT                                                -------------------------------------                                                                                                                                                                                           This file contains important information on the following topics:               **********************************************************************          Report highlights                                                               Files included                                                                  Databases accessed                                                              Download instructions                                                           Restoring files to the HP3000                                                   Customizing the report for the credit union                                     Verifying databases are defined                                                 Updating the database dictionary                                                Troubleshooting common problems                                                 Limited warranty on reports                                                                                                                                                                                                                     Report highlights                                                               **********************************************************************          This is a management report that was written as an alternative to Loan          Committee Minutes report.  The reports show the total number and                dollar amount of loans approved and denied during a specified period            of time.  It also lists the APR and term for approved loans.  Further,          it reports the totals by loan officer.  Detail reports are also                 included which list each loan and the pertinent information.                                                                                                    The macro provided demonstrates a looping technique that reads and              uses items stored in a storelist.  Each time an item is read from the           list, the macro loops through a series of commands.  In this example,           the loan officer code is written back to the worksheet and used as              the basis for calculating the loan officer summary reports.                                                                                                     The worksheet is all that is necessary to create the report.  However,          the report has been automated to run at the end of the month without            input or interference from an operator.  In this way, the report is             printed and waiting with the other month end reports.                                                                                                           
                                                                               Files included                                                                  **********************************************************************                                                                                           1)  NewLoanW - QueryCalc worksheet                                              2)  NewLoanM - QueryCalc macro                                                  3)  NewLoanJ - job which runs the macro                                         4)  Readme   - this text file of instructions                                                                                                                  Databases accessed                                                              **********************************************************************          This report uses data from the following databases:                                                                                                                     MEMBRS          [SPECTRUM IMAGE DATABASE]                                       LOANAP          [SPECTRUM IMAGE DATABASE]                                       NEWLOAN-PRDB    [KSAM DATABASE CREATED BY QUERYCALC]                                                                                                                                                                                    Download instructions                                                           **********************************************************************          Although downloading reports from the web site is quite simple, you             may wish to print these instructions before proceeding.  The procedure          outlined below requires the use of: (i) a relatively recent version of          the Reflection terminal emulator and (ii) either Netscape Navigator             3.0 (or greater) or Microsoft Internet Explorer 3.0 (or greater),               running on any version of Windows (3.x, 95, or NT). If you're missing           any of these pieces, the downloading procedure unfortunately will not           work.                                                                                                                                                                Step 1.                                                                         -------                                                                         Click on the desired download link. Store the self-extracting                   file anywhere you wish on your PC. Its residency on your PC                     will only be temporary. At the conclusion of the downloading                    process, after the files have been successfully transferred to                  your HP3000, this file will be deleted.                                                                                                                         Step 2.                                                                         -------                                                                         Once the file has been downloaded, double click on the newly                    downloaded file. When you press the UnZip button, the file will                 unzip itself and automatically build an AICS directory (folder)                 on the C: drive, with a subdirectory (subfolder) labeled                        Reports.                                                                                                                                                        Step 3.                                                                         -------                                                                         You will now find files in the Reports subdirectory.  The files                 include a Readme.txt file, the report and any attendant macros,                 jobs and ancillary files (see above).  These files are stored                   in Reflection's WRQ protocol (LABEL mode) and must be                           transferred back onto your HP3000 in that format. The particular                version of Reflection that was used to originally upload these                  files was 5.21. It would probably be best to use a reasonably                   similar version.                                                                                                                                                Step 4.                                                                         -------                                                                         Using Reflection, restore the files to your HP3000 using the                    procedure outlined below.                                                                                                                                       Step 5.                                                                         -------                                                                         Once the transfer is complete, follow the instructions below to                 setup the report for your credit union.                                                                                                                         Step 6.                                                                         -------                                                                         Once you are satisfied that the report is working, you may                      delete the self-extracting download file as well as the Reports                 subdirectory and its files from your PC's file directory.                                                                                                       Step 8.                                                                         -------                                                                         Congratulations on a successful download. We sincerely hope you                 will find your new QueryCalc report useful!                                                                                                                                                                                                Restoring files to the HP3000                                                   **********************************************************************           1)  Using Reflection, sign onto your HP3000 to the group and account                the files are to be stored to.  You may use any group or account                you choose.  However, the assumption is that files will be                      restored as follows:                                                                                                                                                      DATA.CU1 . . . . . . TEMPLATES                                                                                                                                 QCPUB.CU1 . . . . . . JOBS                                                                . . . . . . MACROS                                                              . . . . . . WORKSHEETS                                                          . . . . . . ASCII READ FILES                                                    . . . . . . ASCII OUTPUT FILES                                                                                                                                                                                               NOTES:                                                                          ------                                                                          a)  If this group does not exist, your system administrator can                     create it.  This is a handy way of keeping your QueryCalc                       reports separate from the other files on your system.  The                      capabilities that should be assigned are BA, IA and PH.                         The security should be set to Read/Any, Write/AC, Append/AC,                    Lock/AC, Execute/Any.                                                                                                                                       b)  After due consideration, MCU has adopted the following                          conventions.                                                                                                                                                    1)  We created new groups on the CU1 account for our                                QueryCalc reports.  QCPUB is one such group.  In this                           way, groups are used in the same manner that a                                  subdirectory on a PC is used - to help organize the                             files.  Further, the only thing that is stored in the                           group are QueryCalc reports and their related files.                                                                                                        2)  We have adopted a naming convention in which the last                           letter of the name indicates the type of file (e.g.                             W = Worksheet, M = Macro, J = Job).  The only exception                         to this was that we continued using Summit's convention                         of naming templates with a leading "T".                                                                                                             2)  Using Reflection, transfer the files, using LABEL mode transfer.                                                                                            3)  Once the transfer is complete, you may delete the files and                     directories from your PC hard drive.                                                                                                                                                                                                       Customizing the report for the credit union                                     **********************************************************************          The following steps should be taken to insure the report runs on your           system.                                                                                                                                                          1)  Modify the job (NEWLOANJ).  These steps can be ignored if                       the files were restored to QCPUB.CU1.                                                                                                                           a)  Speak to the DP supervisor.  They may need to do this for                       you.  You will require access to an MPE ":" prompt, access                      to the group.account where the files were stored and access                     to an editor such as QUAD.                                                                                                                                  b)  Change line 1 to logon to the group and account where the                       files were restored.                                                                                                                                        c)  Change the macro line to read the macro from the group and                      account where the files were restored.                                                                                                                      d)  Add any password formatting your system may require.                                                                                                                                                                                    2)  Modify the MACRO (NEWLOANM).                                                                                                                                    a)  In QueryCalc, type                                                                     /PROG NEWLOANM                                                                                                                                       b)  Change the line that loads the worksheet to reflect the                         group.account where the worksheet was restored.                                                                                                             c)  In addition to printing the summary report to the specified                     postscript printer, the macro prints an additional copy to                      a second postscript printer.  If you do not wish to print a                     second copy, delete lines 380/430.  Otherwise, change line                      420 to the name of the second postscript printer.                                                                                                           d)  Save the macro by typing "K"                                                                                                                                e)  Exit the macro by typing "E"                                                                                                                                                                                                            3)  Modify the WORKSHEET (NEWLOANW).                                                                                                                                a)  Load the worksheet.  In QueryCalc, type                                                /LOAD NEWLOANW                                                                                                                                       b)  Change the credit union name.                                                       /S&R "MIZZOU CREDIT UNION" "MY CREDIT UNION NAME" ALL                                                                                                   c)  Change the printer to the name of your postscript printer                              /PRINTER MYPRINTER                                                                                                                                   d)  MCU has placed its logo on many report pages.  If your logo                     is not stored in your system, stop after deleting the                           reference to the logo.  Otherwise, you may replace the logo                     with your own by following the steps listed below.                                                                                                              On the appropriate pages, the information regarding the                         existing logo will be provided to assist you with answering                     the prompts.                                                                                                                                                       a)  Delete the existing logo.                                                       1)  Place the cursor on the logo.                                               2)  Type /CO to "clear the object".                                                                                                                         b)  Put your logo on the page.                                                      1)  /LOGO                                                                       2)  Press RETURN until your logo is displayed.  Select                              by pressing "=".                                                            3)  Answer the prompts.                                                                                                                                                                                                              e)  Page A:                                                                                                                                                        1)  In the range AB32:AD39: Change the formulas to insure that                      the correct collateral codes are stored in the storelists.                                                                                                      "TYPE=R4" is necessary for pulling the information from                         the KSAM database.  This is because numbers are stored                          in this format when the /PRINTDB command is used to build                       a KSAM database.                                                                                                                                                There are 3 techniques demonstrated in this range for                           creating storelists.                                                                                                                                            a)  AB32:  stores the collateral code from the database.                            In this example, all collateral codes assigned to a                             specified GL account number are stored into list !X.                                                                                                            Note that the GL number does not include the decimal                            point in the database.  Consequently, it cannot be                              included in the find.                                                                                                                                       b)  AD32:  stores the collateral code from a list typed in                          manually.                                                                                                                                                   c)  AB33:  stores the collateral code using Set Math.                               QueryCalc allows 4 operators to be used to combine                              storelists.  These equate to algebraic set math and                             the old Venn diagrams.                                                                                                                                          + = addition; the members of Set 1 AND Set 2                                    - = subtraction; the members of Set 1 not included                                  in Set 2                                                                    * = intersection; the members of Set 1 which are also                               in Set 2                                                                    / = exclusion; the members of Set 1 which are NOT also                              in Set 2, AND the members of Set 2 which are NOT                                in Set 1.                                                                                                                                        f)  Page B:                                                                                                                                                        1)  BA25: This cell assigns a loan term of 18 months to loans                       that have no stated maturity (i.e. term=999).  These are                        typically open-end loans (e.g. lines of credit).  Our                           experience and scheduled repayment amounts indicate that                        these loans have an average maturity of approximately 18                        months.  If you experience differs, change the formula in                       this cell to reflect your average maturity.                                                                                                              g)  Page C:                                                                                                                                                        1) Update the LOGO. The MCU logo was stored at K2 (0,80)                           at 20%.                                                                                                                                                   h)  Page D:                                                                                                                                                        1) Update the LOGO. The MCU logo was stored at K2 (0,80)                           at 20%.                                                                                                                                                   i)  Page G:                                                                                                                                                        1) Update the LOGO. The MCU logo was stored at M2 (50,80)                          at 20%.                                                                                                                                                   j)  Page I:                                                                                                                                                        1) Update the LOGO. The MCU logo was stored at M2 (50,80)                          at 20%.                                                                                                                                                   k)  Save the worksheet.                                                                    /SAVE NEWLOANW                                                                                                                                                                                                                  Verifying the databases are defined                                             **********************************************************************          Unless you have used the database(s) above in other reports, it would           be prudent to verify they have been defined in your QueryCalc                   dictionary.  The process only takes a few minutes and could save you            some trouble-shooting later.  You can verify the databases are                  defined by attempting to open each of them from within QueryCalc.                                                                                                1)  Get into QueryCalc.  From a MPE prompt, type:                                             RUN QCX.QCPROGS.AICS                                                                                                                              2)  Once a blank worksheet has been loaded, type:                                             @OPENDB databasename/password.                                                                                                                        NOTE:  Most SPECTRUM image databases use "LOOKUP" as the                               password, while HP, QueryCalc and CFO module databases                          use "READER" as the password.  Pseudodatabases can use                          any password assigned by the creator.  Try "LOOKUP" and                         "READER" if you receive a password error.                                                                                                            3)  If the database exists, it will be opened.  If it does not exist,               you will receive the following error message, in which case you                 will need to add the database to your QueryCalc dictionary.                                                                                                     The database DATABASENAME isn't registered in QueryCalc's                       dictionary.                                                                                                                                                                                                                                Updating the database dictionary                                                **********************************************************************          If a needed database does not exist, you will need to add it to the             QueryCalc database dictionary.  The procedure varies only slightly,             depending on the type of database to be added.                                                                                                                                                                                                  Adding an IMAGE database                                                        ------------------------                                                        Most SPECTRUM databases and CFO module databases are IMAGE databases.                                                                                            1)  From a MPE prompt, type:  RUN ADDIMAGE.AICS.QCPROGS;PARM=1234               2)  Type:  A   (to add)                                                         3)  Enter the fully qualified database name.  (e.g. MEMBRS.DATA.CU1)            4)  Enter the password.  (e.g. LOOKUP)                                          5)  Type:  E   (to exit)                                                        6)  Verify the database has been added to your dictionary by                        following the steps above.                                                                                                                                                                 r`(pfS���U� �=�p(0(0����                                                Adding a copy of an IMAGE database                                              ----------------------------------                                              You may want to run reports against a copy of a database.  The most             common example is a copy of the MEMBRS database, created at month-end           after dividends are posted.  This database is typically stored on               REPORT.CU1.                                                                                                                                                      1)  From a MPE prompt, type:  RUN ADDIMAGE.AICS.QCPROGS;PARM=1234               2)  Type:  A   (to add)                                                         3)  Enter the fully qualified database name. (e.g. MEMBRS.REPORT.CU1)           4)  Enter the password.  (e.g. LOOKUP)                                          5)  Enter the database synonym (1-16 chars):  (e.g. REPORT)                     6)  Type:  E   (to exit)                                                        7)  Verify the database has been added to your dictionary by                        following the steps above.                                                                                                                                                                                                                 Adding a QueryCalc KSAM database                                                --------------------------------                                                A database denoted above with [KSAM database created by QueryCalc] was          created and opened by QueryCalc.  These databases are created by                simply calculating a report and printing the results of a detail list           report or a storelist into a database via the /PRINTDB command.  You            do not need to do anything, since the macro which automatically                 calculates this report will build the database(s) for you.  For more            information on these databases, see QUERYCALC, ADDITIONAL DOCUMENTS.                                                                                                                                                                            Adding a pseudodatabase                                                         -----------------------                                                         A database denoted above as [Pseudodatabase . . .] allows you to                "read" a file on the HP3000 as if it were a database.  Many times,              this is simply a flat, ASCII file.  Two files are required in order             to define a pseudodatabase of this type.  The first, is the file to             be read.  The second, is a schema file that "maps" the file for the             dictionary.  For example, it might indicate that the first 20                   characters are for the name, the second 20 for the address, etc.  If            a pseudodatabase is required for this report, both of the required              files have been included in the files downloaded.                                                                                                               The process for adding the database to your dictionary is, once again,          straightforward and simple.                                                                                                                                      1)  From a MPE prompt, type:  RUN ADDKSAM.AICS.QCPROGS;PARM=1234                2)  Type:  A   (to add)                                                         3)  Database schema file:  (e.g. DEFTSTDB.QCPUB.CU1)                            4)  Enter the password.  (e.g. LOOKUP)                                          5)  Type:  E   (to exit)                                                        6)  Verify the database has been added to your dictionary by                        following the steps above.                                                                                                                                 For additional information on creating and using pseudodatabases, see           QUERYCALC, ADDITIONAL DOCUMENTS.                                                                                                                                                                                                                Troubleshooting Common Problems                                                 **********************************************************************          Q: "When I try to modify the macro, I receive an error message stating              that the macro does not exist."                                             ----------------------------------------------------------------------          A:  You must be signed on to the group and account where the macro was              stored.  Some logon scripts sign you on to specific groups and                  accounts.  If this is not the same group and account where the                  macro was stored, you won't be able to modify it.  You will need                to sign off and then sign back on to the correct group and account                                                                                              Be careful qualifying the macro and then modifying it.  For                     example, you could be logged on to DATA.CU1 and type                              /PROG MYMACRO.QCPUB.CU1                                                                                                                                       The macro would be displayed.  You could make changes to it.                    However, the macro would be saved back to the group and account                 where you are signed on, not the original group and account.  In                the above example, the changed macro would be saved to DATA.CU1.                                                                                                                                                                            Q: "I receive an error message stating that a dataset does not exist                in a database.  However, I am sure the dataset does exist in this               database."                                                                  ----------------------------------------------------------------------          A:  First, verify the database exists in your database dictionary.                  You can do this quickly by closing the database and then                        re-opening it.  If you receive an error telling you that the                    database isn't registered in QueryCalc's dictionary, follow the                 steps listed above to add this database to your dictionary.                                                                                                     If the database is in your dictionary, it may be that the                       database has been modified since the dictionary was last updated.               This typically occurs when a SPECTRUM release is loaded to your                 system. In this case, delete the database from your dictionary                  and then add it back in, following the steps listed above.                                                                                                                                                                                  Q: "I have transferred all of the files to the HP3000.  However, when               I look in the QueryCalc catalog, the report does not show up."              ----------------------------------------------------------------------          A:  Relax.  The file is on your HP3000.  It will not show in the                    QueryCalc catalog until you retrieve and save the file.  To                     retrieve the file, type                                                                /LOAD filename                                                                                                                                           To save the file, type                                                                 /SAVE                                                                                                                                                    Now use the /CAT command and your report will be listed.                                                                                                                                                                                        For macros, type                                                                       /PROG filename                                                                                                                                           To save the file, type                                                                 K filename                                                                                                                                               Now use the /CAT command and your macro will be listed.                                                                                                                                                                                                                                                                     Limited Warranty on Reports                                                     **********************************************************************          *  The reports are distributed "AS IS".  No warranties are made or                 provided by any parties.                                                                                                                                     *  The reports are copyrighted.  Sale or redistribution of the                     reports is strictly prohibited.                                                                                                                              *  The download and/or use of these reports indicates acceptance of                the terms set forth.                                                                                                                                         (p��������r`fS���U� !�Mpp� ����DISC                             1NEWLOANW        QCPUB           AICS                            MGR     AICS    �fS5���b5���b5����e5����e�(�llk�(��nn5����eAICS            �(�(- V2.00 9 587  199811221999012207:33 ,2��$F8�@ � %DAT$2(SYSDATE) �199811019T � %MIZZOU CREDIT UNION �dA��$F8�@ � %DAT$2(B1,IF(DAY(B1)<25,0,20)) ��199811016"T � %NEW LOAN REPORTS �d6��$F8�� � %DAT$2(B2,-DAY(B2)) �19981031                                                  $�$�"                                       "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�L��$ � %"As Of: "+DAT$6(SYSDATE,-DAY(SYSDATE)) �
dAs Of: 10/31/985�z$ � %E8+" - Page A" �dTNEWLOANW.QCPUB.CU1 - Page A=�r$ � %"RUN TIME: " +HRS$(12) �d1RUN TIME: 1:58 PM-�T � %FILENAME: ��6�T � %NEWLOANW.QCPUB.CU1 �                                            $�$�                                       "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�0�T � %MACRO NAME: �6�T � %NEWLOANM.QCPUB.CU1 �.�T � %JOB NAME: �6�T � %NEWLOANJ.QCPUB.CU1 �0"T � %ASSUMPTIONS: �K#T � %COLLATERAL STORE LISTS ARE ACCURATE �;=T � %VISA IS NOT INCLUDED �           $�$�$�                                      "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�.pT � %DATABASES: �*qT � %LOANAP �*�T � %MEMBRS �0�T � %NEWLOAN-PRDB �#�  � �1T � %SCRATCH DATA �d)@T � %VALUE �A/AT � %DESCRIPTION �AIS NOT INCLUDED �           $�$�$�"                                     "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�2�r$F8�@ � %DAT$2(SYSDATE) �199811011�T � 'Today's Date �8�X$F8�@ � %DAT$2(B3,-DAY(B3)+1) �19981001;�T � 'Beginning Report Date �-�>$F8�� � %DAT$2(B3) �199810318�T � 'Ending Report Date �SCRIPTION �AIS NOT INCLUDED �           $�$�$R"                                     "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2����RA �B %USING MEMBRS.LN-CONTROL-FILE, STORE IN !X COLLATERAL WHEN GL-LN-ACCT=70110000,70120000;TYPE=R4 \#)  �B �8a��R@� �B %USING SETS, DEFINE !A AS 100,110,119,200,210,219;TYPE=R4 �$S+T � 'Store List !A (New Auto Collateral Codes) �IION �AIS NOT INCLUDED �           $�$�$R"                                     "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�B��R@� �B %USING SETS, !X = !X - !A �#C  �B �0Y��R@� �B %USING SETS, DEFINE !B AS 310,319,410,419;TYPE=R4 �TET � 'Store List !B (Used Auto Collateral Codes) �#\  �B � #]  �B �IION �AIS NOT INCLUDED �           $�$�$R"                                     "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�B��R@� �B %USING SETS, !C = !X - !B �X_T � 'Store List !C (Other Secured Collateral Codes) �#v  �B �#w  �B � ���R@� �B %USING MEMBRS.LN-CONTROL-FILE, STORE IN !D COLLATERAL WHEN GL-LN-ACCT=70220000;TYPE=R4 eN �AIS NOT INCLUDED �           $�$�R"                                     "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�YyT � 'Store List !D (Unsecured Loan Collateral Codes) ���pR@� �B %USING MEMBRS.LN-CONTROL-FILE, STORE IN !X COLLATERAL WHEN GL-LN-ACCT=70305000;TYPE=R4 e#�  �B ���nR �B %USING MEMBRS.LN-CONTROL-FILE, STORE IN !E COLLATERAL WHEN GL-LN-ACCT=70210000;TYPE=R4 eLUDED �           $�$�R"                                     "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�T�T � 'Store List !E (VISA Loan Collateral Codes) ���VR@ �B %USING MEMBRS.LN-CONTROL-FILE, STORE IN !F COLLATERAL WHEN GL-LN-ACCT=75110000;TYPE=R4 e#�  �B �B�TR@� �B %USING SETS, !F = !X + !F �W�T � 'Store List !F (1st Mortgage Collateral Codes) �   $�$�R"                                     "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#�  �B �L#�  �B �)��:R@� �B %USING MEMBRS.LN-CONTROL-FILE, STORE IN !G COLLATERAL WHEN GL-LN-ACCT=70310000;TYPE=R4 eW�T � 'Store List !G (2nd Mortgage Collateral Codes) �,#�  �B �#�  �B � ortgage Collateral Codes) �   $�$�$R"                                     "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�{� R@ �B %USING MEMBRS.LN-CONTROL-FILE, STORE IN !H COLLATERAL WHEN COLLATERAL=999;TYPE=R4 jNC�T � 'Store List !H (Charge Offs) �P#�  �B �#�  �B �l#�  �B �#  �B �#  �B �aral Codes) �   $�$�$�"                                     "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#  �B �M.~T � %PAGE DATA �d(�T � %PAGE �,�T � %CONTENTS �%�T � %A �+�T � 'Scratch � %T � %B �0T � 'NEWLOAN-PRDB �%2T � %C �Ces) �   $�$�$�$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�83T � 'FORM: Denied Loans �%LT � %D �:MT � 'FORM: Approved Loans �%fT � %E �BgT � 'DETAIL REPORT: Denied Loans �%�T � %F �0D�T � 'DETAIL REPORT: Approved Loans � � %C �Ces) �   $�$�$�$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�%�T � %G �nD�T � 'SUMMARY REPORT: M.C.U. Totals �%�T � %H �s+�T � 'Scratch �%�T � %I �O�T � 'SUMMARY REPORT: Totals by Loan Officer � � 'DETAIL REPORT: Approved Loans � � %C �Ces) �   $�$�$Q$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2����RB4@ * �A %USING LOANAP.APPLICATION, FIND WHEN LAST-DATE IB [{AD27}],[{AD28}] AND ACTION="A","G","T","D" ]C��RG
�t * � %REREADING, VAL OF APP-SSN �'T � %SSN �F��R@� * � %REREADING, VAL OF APP-NUMBER �+6T � %APP-NUM �s � %C �Ces) �   $�$�Q$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�B��Q * � %REREADING, VAL OF ACTION �D *PT � %ACTION �%RN@@ � %2 �H��Q * � %REREADING, VAL OF LOAN-OFFICER �BM+jT � %OFFICER �%lN@� � %4 ��C�}QI��gN * � %REREADING, VAL OF APP-KEY � 394489437006�   $�$�$�$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�+�T � %APP-KEY �V&�N@� � %12 �|�cRB&� � %USING LOANAP.LOAN-TERMS, VAL OF COLLATERAL WHEN APP-SSN=[A2] AND APP-NUMBER=[A3] j.�T � %COLLATERAL �C�IRC�� * � %REREADING, VAL OF ACCOUNT ��B�/RA * � %REREADING, VAL OF SUFFIX �06�   $�$�$Q$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�B�RD�@ * � %REREADING, VAL OF AMOUNT �?��RD� * � %REREADING, VAL OF APR �O'T � %APR �S@��RA� * � %REREADING, VAL OF TERM �E��Q * � %REREADING, VAL OF FREQUENCY �BOUNT ��B�/RA * � %REREADING, VAL OF SUFFIX �06�   $�$�Q$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�}��Q � %USING LOANAP.AP-OFF-ACTION, VAL OF COMMENTS WHEN APP-SSN=[A2] AND APP-NUMBER=[A3] i t��Q � %USING LOANAP.BORROWER, VAL OF NAME WHEN APP-SSN=[A2] AND APP-NUMBER=[A3] rSCHUSTER/DONALD LYLE(nT � %NAME �&pNA8 � %30 � * � %REREADING, VAL OF SUFFIX �06�   $�$�Q$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2���yQ � %USING LOANAP.VEHICLE-INFO, VAL OF PURCHASE-ORDER WHEN APP-SSN=[A2] AND APP-NUMBER=[A3] dPREMIER*�T � %DEALER �&�N@� � %10 �H�_Q * � %REREADING, VAL OF VEHL-LICENSE �*�T � %DIRECT �%�N@� � %8 �FSUFFIX �06�   $�$�$Q$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�-�E$ � %DNS$(A14) �I1�T � %DENIAL-REASON �]&�NAp � %56 �G�+$� � %IF$(A9<0,"---","-"+RJS$("00"+A9,2)) �0-21*�T � %SUFFIX �m�NA( � %IF($A13=$"M",12,IF($A13=$"S",24,IF($A13=$"B",26,IF($A13=$"W",52,12000)))) q FSUFFIX �06�   $�$�$Q$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�.��ND�@ � %MAX(0,A10) �*
T � %AMOUNT �;��NB6����� �A %(A11/1000000)*(A21/100) �*$T � %WEIGHT �6��$C�� � %IF$(A8<0,"N/A",A8) �49024+>T � %ACCOUNT �1%@N@� � %8 �=2��NA_������ �A %(A12/(A20/12)) �   $�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�L��NA_������ �A %IF(A12=999,18,IF(A24>360,18,MAX(0,A24))) �(rT � %TERM �,��$ � %" "+AE8 �
d NEWLOANW.QCPUB.CU19 T � %MIZZOU CREDIT UNION �
dAC��$ � %" RUN DATE: "+DAT$6(SYSDATE) �
dN RUN DATE: 11/01/988:T � %NEW MINUTES REPORT �
d   $�$�$R"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�)<T � %FROM: �,/��$ � %DAT$6(AD27) �10/01/98=��$ � %" RUN TIME: "+HRS$(12) �
dd RUN TIME: 2:01 PM1TT � %DENIED LOANS �
d'VT � %TO: �N/��$ � %DAT$6(AD28) �110/31/980�T � &OF SSN-APP# �
d   $�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�.�T � 3ACCOUNT-SF �
0�T � %AMOUNT CODE �
(�T � 0NAME �
2�T � *DENIAL REASON �
,��$ � %" "+AE8 �
d NEWLOANW.QCPUB.CU19 T � %MIZZOU CREDIT UNION �
d(C��$ � %" RUN DATE: "+DAT$6(SYSDATE) �
d RUN DATE: 11/01/98$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�8:T � %NEW MINUTES REPORT �
d)<T � %FROM: �(/��$ � %DAT$6(AD27) �10/01/98=��$ � %" RUN TIME: "+HRS$(12) �
d% RUN TIME: 2:01 PM3TT � %APPROVED LOANS �
dR'VT � %TO: �/��$ � %DAT$6(AD28) �10/31/98 11/01/98$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�0�T � &OF SSN-APP# �
.�T � 4ACCOUNT-SF �
0�T � %AMOUNT CODE �
(�T � 0NAME �
/�T � %TERM/MONTHS �
:2�T � (INTEREST RATE �
*�T � %WEIGHT �
/��$ � %DAT$6(AD28) �10/31/98 11/01/98$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�Y��RA� * � %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN ACTION=T �FC��Q * � %REREADING, VAL OF OFFICER �
dTH+T � %OFFICER �&T � %1A �?��RG7"2� * � %REREADING, VAL OF SSN �C��Q * � %REREADING, VAL OF ACCOUNT � N/A10/31/98 11/01/98$�$�$Q"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�+PT � %ACCOUNT �AB��Q * � %REREADING, VAL OF SUFFIX �--- &jT � %SF �B�}RE#|� * � %REREADING, VAL OF AMOUNT �F�cRB&� * �A %REREADING, VAL OF COLLATERAL �(�T � %CODE �&�T � %2A � N/A10/31/98 11/01/98$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�@�IQ * � %REREADING, VAL OF NAME �MORTON/ROBERT LI�/Q * � %REREADING, VAL OF DENIAL-REASON �;td;delinquent past or present credit obligations withU*�T � %REASON �&�NAp � %56 �:�$G7"2� � %RJS$("000000000"+A3,9) �	499682471%2A � N/A10/31/98 11/01/98$�$��"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�U��$ � %SUB$(A10,1,3)+"-"+SUB$(A10,4,5)+"-"+SUB$(A10,6,9) �
d�499-68-2471'T � %SSN �L)��$ � %A4+A5 �eN/A---+ T � %ACCT-SF �*��NCX �A %A6/100 �*:T � %AMOUNT � %RJS$("000000000"+A3,9) �	499682471%2A � N/A10/31/98 11/01/98$�$�$Q"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�a��$ � %NAM$(SUB$(A8,POS(A8,"/")+1,30)+" "+SUB$(A8,1,POS(A8,"/")-1)) ~7Robert L Morton(TT � %NAME �&VNA8 � %30 �Z��RB� * � %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN ACTION<>T �C��Q * � %REREADING, VAL OF OFFICER �BM+T � %OFFICER �098$�$�$Q"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�&T � %1A �?��RG
�t * � %REREADING, VAL OF SSN �tC��QC�� * � %REREADING, VAL OF ACCOUNT �49024+PT � %ACCOUNT � B��Q� * � %REREADING, VAL OF SUFFIX �-21&jT � %SF �B�}RD�@ * � %REREADING, VAL OF AMOUNT �98$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�F�cRB&� * �A %REREADING, VAL OF COLLATERAL �(�T � %CODE �&�T � %2A �@�IQ * � %REREADING, VAL OF NAME �SCHUSTER/DONALD LYLE?�/RD� * � %REREADING, VAL OF APR �T@�RA_������ * � %REREADING, VAL OF TERM �EREADING, VAL OF AMOUNT �98$�$�$Q"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�(�T � %TERM �B��RB6����� * �A %REREADING, VAL OF WEIGHT �*T � %WEIGHT �:��$G
�t � %RJS$("000000000"+A3,9) �	394489437UU��$ � %SUB$(A12,1,3)+"-"+SUB$(A12,4,5)+"-"+SUB$(A12,6,9) �@394-48-9437�':T � %SSN �M)��$ � %A4+A5 �98$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�49024-21+TT � %ACCT-SF ��*��NC� �A %A6/100 �*nT � %AMOUNT �a�y$ � %NAM$(SUB$(A8,POS(A8,"/")+1,30)+" "+SUB$(A8,1,POS(A8,"/")-1)) ~Donald Lyle Schuster(�T � %NAME �&�NA8 � %30 �.�_N?5?|�h � %A9/1000000 �+A5 �98$�$�$��                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�'�T � %APR �C(T � %HIDE �,��$ � %" "+AE8 �
d NEWLOANW.QCPUB.CU19 T � %MIZZOU CREDIT UNION �
d+C��$ � %" RUN DATE: "+DAT$6(SYSDATE) �
d RUN DATE: 11/01/988:T � %NEW MINUTES REPORT �
d)?T � %FROM: �98$�$�$��                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�/��$ � %DAT$6(AD27) �T10/01/98=��$ � %" RUN TIME: "+HRS$(12) �
dA RUN TIME: 2:02 PM6TT � %COLLATERAL TOTALS �
d'YT � %TO: �%/��$ � %DAT$6(AD28) �T10/31/982�T � %FINAL SUMMARY �
#�  �@ �%OM: �98$�$�$��                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#  �@ �D#"  �@ �,$T � %APPROVED �d*+T � %DENIED �d%�T � %# �d*�T � .Amount �d%�T � %% �d(�T � /Term �d%�T � %# �d�@ �%OM: �98$�$�$�$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�*�T � 2Amount �d.�T � %New Autos �m�\RA< �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!A AND ACTION<>"T" wC�[RD��, �@ %REREADING, SUM OF AMOUNT/100 �?�YRC�М�O
� �@ %REREADING, SUM OF WEIGHT �7�XN?�n�2 � %IF(E17=0,0,G17/E17) � 98$�$�$R$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�=�WRAt���G� �@ %REREADING, AVG OF TERM �l�TRA �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!A AND ACTION="T" xC�SRD{P���
= �@ %REREADING, SUM OF AMOUNT/100 �N/�T � %Used Autos �m�BRA� �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!B AND ACTION<>"T" w98$�$�R$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�C�ARE��
=p� �@ %REREADING, SUM OF AMOUNT/100 ��?�?RD.YnC�z �@ %REREADING, SUM OF WEIGHT �7�>N?&�h�+ � %IF(E18=0,0,G18/E18) �=�=RAY)�)� �@ %REREADING, AVG OF TERM �l�:RA� �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!B AND ACTION="T" xATERAL=!B AND ACTION<>"T" w98$�$�R$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�C�9RD�=n�\ �@ %REREADING, SUM OF AMOUNT/100 ��2�T � %Other Secured �m�(R@� �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!C AND ACTION<>"T" wNC�'RD��(� �@ %REREADING, SUM OF AMOUNT/100 �N?�%RCC��=�x �@ %REREADING, SUM OF WEIGHT �ERAL=!B AND ACTION<>"T" w98$�$�R$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�7�$N?�Xd�B� � %IF(E19=0,0,G19/E19) �/=�#RAV5sW5sZ �@ %REREADING, AVG OF TERM �l� R@` �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!C AND ACTION="T" xC�RC�� �@ %REREADING, SUM OF AMOUNT/100 �9�T � (Total Secured Loans �d 0�NAՀ �@ %SUM(D17:D19) �d$�$�$R$�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�0�
NE&v-���� �@ %SUM(E17:E19) �d0�NDN?!&Ԁ �@ %SUM(G17:G19) �d7�
N?!��~�� � %IF(E20=0,0,G20/E20) �d G�	NA]���\>0 �@ %((D17*I17)+(D18*I18)+(D19*I19))/D20 �d0�NA� �@ %SUM(L17:L19) �d0�NE
(��\(� �@ %SUM(M17:M19) �d#  �@ ��#  � �d$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#  �@ �:-$T � %Unsecured �1m��RA� �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!D AND ACTION<>"T" w1C��RDP6�z�H �@ %REREADING, SUM OF AMOUNT/100 �(?��RC�2�X� �@ %REREADING, SUM OF WEIGHT �d7��N?K(9�V� � %IF(E22=0,0,G22/E22) � � �d$�$�$R"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�=��RA�<.� �@ %REREADING, AVG OF TERM �l��RA| �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!D AND ACTION="T" xC��RD>݀ �@ %REREADING, SUM OF AMOUNT/100 �U#@  �@ ��#D  � �W#H  �@ �1XT � %1st Mortgage �d$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�m��R@� �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!F AND ACTION<>"T" wPC��RE�� �@ %REREADING, SUM OF AMOUNT/100 �R?��RD� �@ %REREADING, SUM OF WEIGHT �#7��N?��Y�� � %IF(E24=0,0,G24/E24) �=��RA� �@ %REREADING, AVG OF TERM � � %1st Mortgage �d$�$��"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�l��R@` �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!F AND ACTION="T" xC��RDi�� �@ %REREADING, SUM OF AMOUNT/100 �1rT � %2nd Mortgage � m��RA �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!G AND ACTION<>"T" wDC��RD�� �@ %REREADING, SUM OF AMOUNT/100 �d$�$��"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�?��RC������ �@ %REREADING, SUM OF WEIGHT �7��N?���[� � %IF(E25=0,0,G25/E25) �=��RA��E��B �@ %REREADING, AVG OF TERM �l��R@@ �@ %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN COLLATERAL=!G AND ACTION="T" xC��RD�� �@ %REREADING, SUM OF AMOUNT/100 �#�  �@ �d$�$�$Q"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#�  � �N#�  �@ �7�T � (Loans Before VISA �d�0�XNB� �@ %SUM(D20:D26) �d0�WNEd��Ǯ{ �@ %SUM(E20:E26) �d0�UND�ĵѬ�� �@ %SUM(G20:G26) �d7�TN?��=��8 � %IF(E27=0,0,G27/E27) �dOAMOUNT/100 �#�  �@ �d$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�Q�SNAlG%z�� �@ %((D20*I20)+(D22*I22)+(D24*I24)+(D25*I25))/D27 �d0�PNA� �@ %SUM(L20:L26) �d0�ONE'l��\(� �@ %SUM(M20:M26) �d#�  �@ �2#�  � �#�  �@ ��(�T � %VISA �#�  �@ � �@ �d$�$�$�"�                                    "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#�  � �2#�  �@ �#�  �@ �U#�  � �#�  �@ �0T � (TOTAL LOANS �d#  �@ �#  � �#  �@ �#*  �@ �d$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#.  � �2#2  �@ �#D  �@ �U#H  � �#L  �@ �#^  �@ �L#b  � � #x  �@ � #|  � � #�  �@ � @ �d$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#�  � �2#�  �@ �#�  � �U#�  �@ �#�  � �#�  �@ �L#�  � � #�  �@ � #�  � � #  �@ � @ �d$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#  � �2#.  �@ �#2  � �r`ghfS���U� !�Mpg(g(����U#H  �@ �#L  � �#b  �@ �L#f  � � #|  �@ � #�  � � #�  �@ � @ �d$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#�  �@ �2#�  �@ �#�  �@ �U#�  �@ �#  �@ �#2  �@ �L#L  �@ � '��$F8�@ � %AB1 �#19981101'��$ � %AH1 �MIZZOU CREDIT UNION @ �d$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�'��$F8�@ � %AB2 �#19981101'��$ � %AH2 �NEW LOAN REPORTS'��$F8�� � %AB3 �19981031'��$ � %AH3 �As Of: 10/31/98�5�z$ � %E8+" - Page H" �d�NEWLOANW.QCPUB.CU1 - Page H=�r$ � %"RUN TIME: " +HRS$(12) �dZRUN TIME: 2:02 PM�d$�$�$R$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�-�T � %FILENAME: �8'�E$ � %AE8 �NEWLOANW.QCPUB.CU10�T � %MACRO NAME: �'�+$ � %AE9 �NEWLOANM.QCPUB.CU1.�T � %JOB NAME: �(�$ � %AE10 �NEWLOANJ.QCPUB.CU10"T � %ASSUMPTIONS: �E: 2:02 PM�d$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�(��$ � %AE12 �'COLLATERAL STORE LISTS ARE ACCURATE (��$ � %AE13 �VISA IS NOT INCLUDEDM.pT � %DATABASES: �(��$ � %AE15 �LOANAP(�u$ � %AE16 �MEMBRS(�[$ � %AE17 �NEWLOAN-PRDB#�  � �: PM�d$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�1T � %SCRATCH DATA �dR)@T � %VALUE �/AT � %DESCRIPTION �E2�r$ � %DAT$6(SYSDATE) �01/22/991�T � 'Today's Date �(�X$F8�@ � %AD27 �19981001;�T � 'Beginning Report Date �� �: PM�d$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�(�>$F8�� � %AD28 �199810318�T � 'Ending Report Date �#)  �B �Ek��R@� �B %USING NEWLOAN-PRDB.NEWLOAN, STORE IN !O OFFICER WHEN OFFICER<>"" z?+T � 'Store List !O (Officers) �#C  �B �D(D$ � %"TS" �TSd$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�+ET � 'Officer �9]��RA� �B %USING NEWLOAN-PRDB.NEWLOAN, FIND WHEN OFFICER=[$HD33] �6_T � 'Find for Officer �#�  �B �#�  �B �.�T � %PAGE DATA �d(.T � %PAGE �,/T � %CONTENTS �$�$�$��                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�%bT � %A �+cT � 'Scratch �O%�T � %B �D3�T � 'PRINTDB-NEWLOAN �O%�T � %C � 8�T � 'FORM: Denied Loans �%�T � %D �d:�T � 'FORM: Approved Loans � � %CONTENTS �$�$�$�$J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�%�T � %E �B�T � 'DETAIL REPORT: Denied Loans �%�T � %F �D�T � 'DETAIL REPORT: Approved Loans �%T � %G �MDT � 'SUMMARY REPORT: M.C.U. Totals �%2T � %H � oans � � %CONTENTS �$�$�$�$J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�+3T � 'Scratch �%LT � %I � OMT � 'SUMMARY REPORT: Totals by Loan Officer �(	T � %HIDE �,	��$ � %" "+AE8 �
d NEWLOANW.QCPUB.CU19	 T � %MIZZOU CREDIT UNION �
dTC	��$ � %" RUN DATE: "+DAT$6(SYSDATE) �
d�$�$�$�$J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2� RUN DATE: 11/01/988	:T � %NEW MINUTES REPORT �
d)	?T � %FROM: � /	��$ � %DAT$6(AD27) �T10/01/98=	��$ � %" RUN TIME: "+HRS$(12) �
dA RUN TIME: 2:02 PM6	TT � %COLLATERAL TOTALS �
d'	YT � %TO: �%RUN DATE: "+DAT$6(SYSDATE) �
d�$�$�$�$J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�/	��$ � %DAT$6(AD28) �10/31/98C	�x$ � %"OFFICER SUMMARY FOR: "+HD33 �
OFFICER SUMMARY FOR: TS#	�  �@ �$#	  �@ �"#	"  �@ �,	$T � %APPROVED �d*	+T � %DENIED �d%	�T � %# �dd�$�$�$�"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�*	�T � .Amount �d%	�T � %% �d(	�T � /Term �d%	�T � %# �d*	�T � 2Amount �d.	�T � %New Autos �[	�\R@� �@ %REREADING, FIND WHEN COLLATERAL=!A AND ACTION<>"T" ��d%	�T � %# �dd�$�$�$�"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�M	�[RD7R�G�{ �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �I	�YRCMƱ7�� �@ %LEVEL 2 REREADING, SUM OF WEIGHT �7	�XN?n�r��� � %IF(E17=0,0,G17/E17) �dG	�WRA~ �@ %LEVEL 2 REREADING, AVG OF TERM �Z	�TR@` �@ %REREADING, FIND WHEN COLLATERAL=!A AND ACTION="T" � � %# �dd�$�$��"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�M	�SRC�� �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �/	�T � %Used Autos �,[	�BRA8 �@ %REREADING, FIND WHEN COLLATERAL=!B AND ACTION<>"T" �M	�ARD�MpQ� �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �I	�?RC�{���9 �@ %LEVEL 2 REREADING, SUM OF WEIGHT � � %# �dd�$�$��"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�7	�>N?"�
�N� � %IF(E18=0,0,G18/E18) �OG	�=RA]333333 �@ %LEVEL 2 REREADING, AVG OF TERM �Z	�:RA �@ %REREADING, FIND WHEN COLLATERAL=!B AND ACTION="T" �M	�9RDU��G� �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �2	�T � %Other Secured �M OF WEIGHT � � %# �dd�$�$��"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�[	�(R@` �@ %REREADING, FIND WHEN COLLATERAL=!C AND ACTION<>"T" �EM	�'RC��=p��
 �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �,I	�%RB�vW�i� �@ %LEVEL 2 REREADING, SUM OF WEIGHT �7	�$N?#��2� � %IF(E19=0,0,G19/E19) �2G	�#RA������� �@ %LEVEL 2 REREADING, AVG OF TERM � � %# �dd�$�$��"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�Z	� R@ �@ %REREADING, FIND WHEN COLLATERAL=!C AND ACTION="T" �M	�RB�@ �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �9	�T � (Total Secured Loans �dO0	�NAR �@ %SUM(D17:D19) �d0	�
ND���z�G� �@ %SUM(E17:E19) �d0	�NC�@v�l� �@ %SUM(G17:G19) �d � %# �dd�$�$�$Q"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�7	�
N?�Y��1 � %IF(E20=0,0,G20/E20) �dLG	�	NAf�J�D�� �@ %((D17*I17)+(D18*I18)+(D19*I19))/D20 �d0	�NA �@ %SUM(L17:L19) �d0	�NDpњ�G� �@ %SUM(M17:M19) �d#	  �@ �1#	  � �@#	  �@ ��-	$T � %Unsecured �dd�$�$�$�"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�[	��RA �@ %REREADING, FIND WHEN COLLATERAL=!D AND ACTION<>"T" �1M	��RC�0 �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �1I	��RC+�fffff �@ %LEVEL 2 REREADING, SUM OF WEIGHT �7	��N?J�/#��� � %IF(E22=0,0,G22/E22) �G	��RA� �@ %LEVEL 2 REREADING, AVG OF TERM �%secured �dd�$�$��"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�Z	��R@� �@ %REREADING, FIND WHEN COLLATERAL=!D AND ACTION="T" �M	��RC� �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �#	@  �@ � #	D  � �#	H  �@ �01	XT � %1st Mortgage �EL 2 REREADING, AVG OF TERM �%secured �dd�$�$�$R"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�[	��R �@ %REREADING, FIND WHEN COLLATERAL=!F AND ACTION<>"T" �M	��R �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �I	��R �@ %LEVEL 2 REREADING, SUM OF WEIGHT �7	��N � %IF(E24=0,0,G24/E24) �G	��R �@ %LEVEL 2 REREADING, AVG OF TERM �%secured �dd�$�$�R"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�Z	��R �@ %REREADING, FIND WHEN COLLATERAL=!F AND ACTION="T" �M	��R �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �1	rT � %2nd Mortgage �,[	��R �@ %REREADING, FIND WHEN COLLATERAL=!G AND ACTION<>"T" �M	��R �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �dd�$�$�R"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�I	��R �@ %LEVEL 2 REREADING, SUM OF WEIGHT �C7	��N � %IF(E25=0,0,G25/E25) �EG	��R �@ %LEVEL 2 REREADING, AVG OF TERM �MZ	��R �@ %REREADING, FIND WHEN COLLATERAL=!G AND ACTION="T" �M	��R �@ %LEVEL 2 REREADING, SUM OF AMOUNT/100 �AUNT/100 �dd�$�$�R"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#	�  �@ �2#	�  � �#	�  �@ �07	�T � (Loans Before VISA �d0	�XNAr �@ %SUM(D20:D26) �d0	�WND�s�z�G� �@ %SUM(E20:E26) �d0	�UNC۲��9m �@ %SUM(G20:G26) �d7	�TN?#��=YR � %IF(E27=0,0,G27/E27) �d/0 �dd�$�$�$�"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�Q	�SNAS}�pG �@ %((D20*I20)+(D22*I22)+(D24*I24)+(D25*I25))/D27 �d0	�PNA@ �@ %SUM(L20:L26) �d0	�OND~5�G� �@ %SUM(M20:M26) �d#	�  �@ �#	�  � �2#	�  �@ �(	�T � %VISA �#	�  �@ �0 �dd�$�$�$�"J                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#	�  � �2#	�  �@ �#	�  �@ �U#	�  � �#	�  �@ �0	T � (TOTAL LOANS �d#	  �@ �#	  � �#	  �@ �#	*  �@ �d�$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#	.  � �2#	2  �@ �#	D  �@ �U#	H  � �#	L  �@ �#	^  �@ �L#	b  � � #	x  �@ � #	|  � � #	�  �@ � @ �d�$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#	�  � �2#	�  �@ �#	�  � �U#	�  �@ �#	�  � �#	�  �@ �L#	�  � � #	�  �@ � #	�  � � #	  �@ � @ �d�$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#	  � �2#	.  �@ �#	2  � �U#	H  �@ �#	L  � �#	b  �@ �L#	f  � � #	|  �@ � #	�  � � #	�  �@ � @ �d�$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�#	�  �@ �2#	�  �@ �#	�  �@ �U#	�  �@ �#	  �@ �#	2  �@ �L#	L  �@ � ,O 
 ,BXSA2M>2dd �;O 
 ,BX AK-dd �  @ �d�$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�;O 
 ,BX AK-dd �:O 
 ,BXSAN0ddd �,O 
 ,BXSA2M92dd �:	O 
 ,BXSAN0ddd �-O 
 ,BX C
K)Pd �;O 
 ,BX AKdFdd �X;O 
 ,BX AKdFdd �d�$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�;!O 
 ,BX ANdFdd �-"O 
 ,BX C
K$Pd �;#O 
 ,BX ANdFdd �:-5O 
 ,BX C
KPd �;7O 
 ,BX AFKdFd �;8O 
 ,BX AFKdFd �;;O 
 ,BX AFNdFd ��$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�-<O 
 ,BX C
KPd �;=O 
 ,BX AFNdFd �-OO 
 ,BX C
KPd �;QO 
 ,XC KPKE?dd� �;RO 
 ,XC KPKE?dd� �;UO 
 ,XC M2PN?dd� �-VO 
 ,BX C
KPd � ��$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�;WO 
 ,XC M2PN?dd� �-iO 
 ,LN D0J02d �;oO 
 ,BX DJ
d
 �-pO 
 ,LN D+J+2d �;qO 
 ,BX DJ
d
 �-�O 
 ,BX C,
K<Pd �;�O 
 ,BX LN
d
 � ��$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�-�O 
 ,BX C'
K7Pd �;�O 
 ,BX LN
d
 �-�O 
 ,BX C.
K0Pd �;�O 
 ,BX APB!dFd
 �-�O 
 ,BX C)
K+Pd �;�O 
 ,BX APB!dFd
 �;�O 
 ,LN DZD)Zd � ��$�$�$�$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�;�O 
 ,BX DJ!d �;�O 
 ,LN DZD$Zd �;�O 
 ,BX DJ!d �;�O 
 ,LN D0ZD<Zd �;�O 
 ,BX LN!d �;�O 
 ,LN D+ZD7Zd � � ��$�$�$Q$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�;�O 
 ,BX LN!d �;�O 
 ,LN C2K2d �;�O 
 ,LN D-_Id_d �;�O 
 ,LN C2K2d �;�O 
 ,LN D-_Id_d �;O 
 ,BX C,
K.Pd � � ��$�$�$Q$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�;O 
 ,LN D-_Id_d �;O 
 ,BX C'
K)Pd �;
O 
 ,LN D-_Id_d �;%O 
 ,LN D-_Id_d �;'O 
 ,LN D-_Id_d �;?O 
 ,LN D-_Ed_d � � ��$�$�$Q$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�;AO 
 ,LN D-_Ed_d �=YO 
 ,LN D _I d_d �=[O 
 ,LN D _I d_d �;;sO 
 ,LN L-_Md_d �;;uO 
 ,LN L-_Md_d �;;�O 
 ,LN L-_Md_d � � ��$�$�$Q$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�;�O 
 ,LN L-_Md_d �;�O 
 ,LN L-_Md_d � ;�O 
 ,LN L-_Md_d �=�O 
 ,LN L -_M d_d � =�O 
 ,LN L -_M d_d �;;�O 
 ,LN L-_Md_d � � ��$�$�$Q$�                                   "$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�2�;�O 
 ,LN L-_Md_d �O$$$			

$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6��6�6�6�6�6�2�
	
					6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6[6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6[	^EOUDQFS^�@6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�2�6[



<<�<LOANAP.LOANAP.CU1            IM)+*%.(�LOANAP            <MEMBRS.DATA.CU1              IM)+*%.(�MEMBRS            <NEWLOAN.CFS.CU1              KS=S
1���NEWLOAN-PRDB      QCREPRTE    10  GROUP 16�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�2�6[    20  H,SKIPTO 7V    30  D,UNIFY 4;OFFICER,1,NR;SSN,6;ACCT-SF,-30;AMOUNT,-43;CODE,-49;NAME,53;REASON,74    40  BREAKON OFFICER    50  F,UNIFY 9=    60  F,"DENIED LOAN AMOUNTS FOR OFFICER:  ",-48;OFFICER,50#    70  F,"Count:",-41;CODE,-55,NUMS&    80  F,"Amount:",-41;AMOUNT,-55,SUM	    90  F 	    91  F.   100  ENDBREAK	   110  F�#   120  F,"TOTAL DENIED LOANS:",-48CREPRTE    10  GROUP 1$�$�$[6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�2�6[#   130  F,"Count:",-41;CODE,-55,NUM &   140  F,"Amount:",-41;AMOUNT,-55,SUM	   150  F9   160  ONNEWPAGE   170  H,SKIPTO 7   180  ENDPAGEN   190  ENDGROUPQCREPRTF    10  GROUP 1F    20  H,SKIPTO 7i    30  D,UNIFY 4;OFFICER,1,NR;SSN,6;ACCT-SF,-30;AMOUNT,-43;CODE,-49;NAME,53;TERM,-82;APR,-96;WEIGHT,-115    40  BREAKON OFFICER     50  F,UNIFY 126    60  F,"LOAN AMOUNTS FOR OFFICER:  ",-41;OFFICER,43$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�2�6[     70  F,"AMOUNT",-55;"APR",-65#    80  F,"Count:",-41;CODE,-55,NUM-3    90  F,"Maximum:",-41;AMOUNT,-55,MAX;APR,-65,MAXP3   100  F,"Minimum:",-41;AMOUNT,-55,MIN;APR,-65,MIN 3   110  F,"Average:",-41;AMOUNT,-55,AVG;APR,-65,AVG;B   120  F,"Weight:",-20;WEIGHT,-30,SUM;"Total:",-41;AMOUNT,-55,SUM	   130  FG	   140  F    150  ENDBREAK	   160  F0   170  F,"TOTAL LOANS:",-41    180  F,"AMOUNT",-55;"APR",-65R,43$�$�$Q6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�2�6[#   190  F,"Count:",-41;CODE,-55,NUM 3   200  F,"Maximum:",-41;AMOUNT,-55,MAX;APR,-65,MAXm3   210  F,"Minimum:",-41;AMOUNT,-55,MIN;APR,-65,MINm3   220  F,"Average:",-41;AMOUNT,-55,AVG;APR,-65,AVGeB   230  F,"Weight:",-20;WEIGHT,-30,SUM;"Total:",-41;AMOUNT,-55,SUM	   240  Fa   250  ONNEWPAGES   260  H,SKIPTO 7   270  ENDPAGEN   280  ENDGROUP
^EODLTMPS^^EOQ$^Gqb;W?H"y1S!NXd:{MF.1h$k'$�$�$�4�2�6�6�6�6�6�6�6�6�6�6�6�6�6�6�$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�2�6[d�loan department                                                                                                                                                                                                  150                                          H,SKIPTO 7   270  ENDPAGEN   280  ENDGROUP
^EODLTMPS^^EOQ$^Gqb;W?H"y1S!NXd:{MF.1h$k'6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�2�6[gh�����������������������STORE/RESTORE-HP/3000.MPEXL  3	� �������B5152AA  C602403/16/010000�������������������������