�STORE/RESTORE-HP/3000.MPEXL  &/� �8�����B5152AA  C602403/16/010000�8�?fS�	�U�$B�+���PROSTARJ        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS��U�$1�#��
�PROSTARM        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS��U�$v�N����PROSTART        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS��U�$8���5�PROSTARW        QCPUB           AICS            MGR             AICS            MGR     AICS    `@�����?fS��U�$��v<�#�PROSTRBS        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS��U�$���&��DOWNLOAD        QCPUB           AICS            MGR             AICS            MGR     AICS    `����8�(���H00000000000000000                            000000STORE  pros@,down@;*v
����������������� fS�	�U�$B�+���� ����DISC                             1PROSTARJ        QCPUB           AICS                            MGR     AICS    �fS5���25���25��P;5��P;��P�  5��P;AICS            ��!JOB PROSTARJ,MGR.CU1,QCPUB                                                     !COMMENT                                                                        !COMMENT  ******************************************                            !COMMENT  ***  CREATE PROFITSTAR DOWNLOAD FILES  ***                            !COMMENT  ******************************************                            !COMMENT                                                                        !SHOWTIME                                                                       !FILE QCMACROF=PROSTARM.QCPUB.CU1                                               !RUN QCX.QCPROGS.AICS                                                           !SHOWTIME                                                                       !COMMENT SET STDLIST=DELETE                                                     !EOJ                                                                             ��������
UfS��U�$1�#�
�
�� ����DISC                             1PROSTARM        QCPUB           AICS                            MGR     AICS    �fS5�����5�����5���:5���:
�

���  5���:AICS            
�
�QCMACRO   PROSTARM                                                                                                                                                                                                                                                 10  >***********************************                                                                                                                                                                                                                       20  >***  PROFITSTAR DOWNLOAD FILES  ***                                                                                                                                                                                                                       30  >***********************************                                                                                                                                                                                                                       40  /LOAD PROSTARW                                                                                                                                                                                                                                             50  !!                                                                                                                                                                                                                                                         60  /SAVE PROSTARW                                                                                                                                                                                                                                             70  /PRINTER LP                                                                                                                                                                                                                                                80  /PRINT B D PSLOAND                                                                                                                                                                                                                                         90  /PRINT C D PSCDD                                                                                                                                                                                                                                          100  /PRINT D D PSGLD                                                                                                                                                                                                                                       
U��������r`fS��U�$v�N�pp� ����DISC                             1PROSTART        QCPUB           AICS                            MGR     AICS    �fS5�҅F5�҅F5����5�ҋ�u��
���Y P�& &  5�ҋ�uAICS            ����                 QueryCalc Reports for Credit Unions                                               written by:  Mizzou Credit Union                                                    last update:  03/05/1999                                                                                                                                           PROFITSTAR DOWNLOAD                                                   -------------------------------------                                                                                                               Note:  This file is best viewed and printed with                                       the font set at Courier-New, Regular, 10                                                                                                                                                                                             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 report creates three ASCII files which are downloaded to a pc or           LAN and then read by ProfitStar.  The three files created represent             the Loan, CD and GL download files requested by ProfitStar.                                                                                                     Information included in these files is customizable by the user.                Additional fields may be added and existing fields may be changed or            deleted as desired.                                                                                                                                             The worksheet is all that is necessary to create the files.  However,           the report has been automated to run when the GL books are closed               without input or interference from an operator.  The files are                  prepared and waiting for the user to initiate a file transfer.                                                                                                                                                                                  Files included                                                                  **********************************************************************                                                                                           1)  ProstartW - QueryCalc worksheet                                             2)  ProstarM - QueryCalc macro                                                  3)  ProstarJ - job which runs the macro                                         4)  Prostar  - a sample reflection basic script for downloading                                the ASCII files                                                  5)  Download - a sample file for setting up the ProfitStar download             6)  Readme   - this text file of instructions                                                                                                                  Databases accessed                                                              **********************************************************************          This report uses data from the following databases:                                                                                                                     GLDATA   [SPECTRUM IMAGE DATABASE]                                              REPORT   [SPECTRUM IMAGE DATABASE] (copy of MEMBRS)                                                                                                                                                                                     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 in the job and macro is that               the files will be restored to                                                                                                                                             QCPUB.CU1                                                                                                                                             NOTES:                                                                          ------                                                                          a)  The files download.txt, prostar.rbs and readme.txt should                       not be restored to the HP3000.                                                                                                                              b)  The file prostar.rbs should be stored in the user                               subdirectory of the reflection subdirectory.                                                                                                                c)  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.                                                                                                                                       d)  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 harddrive.                                                                                                                                                                                                        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 (PROSTARJ).  These steps can be ignored if the job               was stored 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 (PROSTARM).  These steps can be ignored if the                 job was stored to QCPUB.CU1.                                                                                                                                    a)  In QueryCalc, type                                                                     /PROG PROSTARM                                                                                                                                       b)  Change the line that loads the worksheet to reflect the                         group.account where the worksheet was restored.                                                                                                             c)  Save the macro by typing "K"                                                                                                                                d)  Exit the macro by typing "E"                                                                                                                                                                                                            3)  Modify the WORKSHEET (PROSTARW).                                                                                                                                a)  Load the worksheet.  In QueryCalc, type                                                /LOAD PROSTARW                                                                                                                                       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 2 digits to the right of the decimal in the GL                          account numbers.  If your GL numbers have a different format,                   you will need to change the format of G/L numbers in your                       worksheet and the multiplier used in the Query FINDs.                                                                                                          1)  To change the format of G/L account numbers displayed on                        the worksheet, use the following command:                                          /FORM N D # N N N N R Range                                                                                                                                  Substitute # with the number of digits your G/L account                         numbers have to the right of the decimal point.                                                                                                                 Substitute Range with the worksheet range where G/L                             numbers are stored.  The range(s) will be provided below.                                                                                                   2)  Change the multiplier used in the Query FINDs for the                           G/L account numbers displayed to 10^n where n represents                        the number of digits to the right of the decimal place in                       your GL account numbers.  For example, if your GL account                       numbers have 3 digits to the right of the decimal place,                        use the following command:                                                          /S&R "*100" "*1000" Range                                                                                                                                   Substitute 1000 with the 10^n, where n is the number of                         digits your G/L account numbers have to the right of the                        decimal point.                                                                                                                                                  Substitute Range with the worksheet range where the                             FINDs are stored.  The range(s) will be provided below.                                                                                                                                                                                  e)  Page A:                                                                                                                                                        1)  Update the G/L account numbers in cells AD32 and AD33 to                        correspond to the appropriate G/L accounts.                                                                                                                 2)  Change the format of the G/L account numbers in the                             range AD32:AD33.  (See above.)                                                                                                                              3)  Change the multiplier used in the Query FIND for the                            G/L account numbers in the range A:A. (See above.)                                                                                                          4)  Variable rate loans - Mizzou Credit Union's variable rate                       loans change on the first day of each quarter (e.g. line                        of credit loan rates change 1/1, 4/1, 7/1, and 10/1.  If                        your loan portfolio uses different, or additional                               repricing dates for variable rate loans, additional                             calculations should be made on page A and refenced on                           Page B.                                                                                                                                                                                                                                  f)  Page B:                                                                                                                                                        1)  Cell A15 sets the maturity date equal to the system date,                       unless the loan is an open-ended loan, in which case there                      is no stated maturity date.  Change the collateral codes                        to coincide with your open-end loans.                                                                                                                       2)  Cell A16 blanks the maturity date if it is in the past.                                                                                                     3)  Cell A17 sets the repricing date.  If the loan is a fixed                       rate loan, the repricing date=maturity date.  If the loan                       has a variable rate code of 3 (change to reflect your                           credit union's parameters), the repricing date is set to                        the review date.  Otherwise, the repricing date is set to                       the quarterly repricing date calculated on Page A.                                                                                                                                                                                       g)  Page C:                                                                                                                                                        Mizzou Credit Union does not issue variable rate CDs.  The                      DESC-ABRV has the term included in it.  You may need to find                    another way to identify the term for ProfitStar.                                                                                                                                                                                             h)  Save the worksheet.                                                                    /SAVE PROSTARW                                                                                                                                                                                                                   4)  Modify the DOWNLAD SCRIPT (PROSTAR.RBS).                                                                                                                        a)  In Reflection, select SCRIPT, then EDIT SCRIPT, then                            PROSTAR.rbs.                                                                                                                                                b)  Change QCPUB.CU1 to the GROUP.ACCOUNT where the files were                      restored.                                                                                                                                                   c)  Change K:\DOWNLOAD to the drive and directory where you                         want the ASCII download files to be transferred to.                                                                                                         d)  Change the name of the file on the pc to the name you                           have set to correspond with your download files.  e.g.                          change CD.TXT to MYCDFILE.TXT                                                                                                                                                                                                           5)  Modify the PROFITSTAR DOWNLOAD PARAMETERS.                                                                                                                      a)  In ProfitStar, go to Download Files.                                                                                                                        b)  Choose EXTRACT FILES.                                                                                                                                           1.  Set the path to the path chosen in the download script                          above.                                                                                                                                                      2.  Change the File names to those chosen in the download                           script above.                                                                                                                                                  ** NOTE:  GL.TXT WILL BE ENTERED TWICE.  ONCE FOR BALANCE                       SHEET AND ONCE FOR INCOME STATEMENT.                                                                                                                         3.  Enter the field information as described in DOWNLOAD.TXT                                                                                                c)  Choose LINK SETUP and complete the tables as proscribed.                                                                                                                                                                                                                                                               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                                                ********************************r`.fS��U�$v�N�p-�-�����**************************************          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.                                                                                                                                                                                                                 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.                                                                                                                                         .��������8*fS��U�$8��5�5�� ����DISC                             1PROSTARW        QCPUB           AICS                            MGR     AICS    �fS5���YW5���YW5���hC5���hC5�@5���885���hCAICS            5�5�- V2.00 4 114  199903031999030415:22  2��$FA�� � %DAT$2(SYSDATE) �199903039T � %MIZZOU CREDIT UNION �d A��$FA�� � %DAT$2(B1,IF(DAY(B1)<25,0,20)) � 19990303V��$ � %MON$1(MONTH(D27))+" Profitstar DownLoad Report" �d%January Profitstar DownLoad Report                                               $�$�                                        "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�6��$FA� � %DAT$2(B2,-DAY(B2)) �19990228<��$ � %"As Of: "+DAT$6({AB3}) �
dAs Of: 02/28/995�z$ � %E8+" - Page A" �dAPROSTARW.QCPUB.CU1 - Page A=�t$ � %"RUN TIME: " +HRS$(12) �d RUN TIME: 2:14 AM-�T � %FILENAME: � eport                                               $�$�                                       "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�6�T � %PROSTARW.QCPUB.CU1 �0�T � %MACRO NAME: �6�T � %PROSTARM.QCPUB.CU1 �.�T � %JOB NAME: �6�T � %PROSTARJ.QCPUB.CU1 �0"T � %ASSUMPTIONS: �[#T � %REPRICING ASSUMPTIONS USED ON PAGE B ARE CORRECT � $�$�$�                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�.�T � %DATABASES: �*�T � %GLDATA �*�T � %REPORT �-�$FA� � %DAT$2(B3) �19990228.��N@@ � %MONTH(B20) �1T � %SCRATCH DATA �dK��N@� � %IF(B21<4,4,IF(B21<7,7,IF(B21<10,10,1))) �ED ON PAGE B ARE CORRECT � $�$�$�                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�C��NB�� � %IF(B22=1,YEAR(B20)+1,YEAR(B20)) �)@T � %VALUE �/AT � 'DESCRIPTION �2�r$ � %DAT$6(SYSDATE) �03/03/991�T � 'Today's Date �A-�X$FA� � %DAT$2(B3) �%199902280�T � 'Report Date � B ARE CORRECT � $�$�$�                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�G�>$FA�@ � %SUB$(B23,1,4)+RJS$("00"+B22,2)+"01" �)19990401>�T � 'Quarterly Repricing Date �+*ND�3  � %960100 �?+T � 'Net Income Close Account �o*DND�6@ � %960200 �BET � 'Net Income - I/E/N Control �Date � B ARE CORRECT � $�$�$Q                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2���TRBS� �B %USING GLDATA.CHART-FILE, STORE IN !X ACCOUNT WHEN CONTROL-FLAG="N" AND \ACCOUNT-STATUS\="A" AND ACCOUNT NE [D32*100] OR ACCOUNT=[D33*100] 1>�T � '!X=G/L DownLoad Accounts �.0T � %PAGE DATA �d(bT � %PAGE �,cT � %CONTENTS �ARE CORRECT � $�$�Q                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�%�T � %A �D1�T � %Scratch Page �L%�T � %B � B�T � %Download - Loan Information �%�T � %C �sI�T � %Download - Certificate Information �%�T � %D � � %CONTENTS �ARE CORRECT � $�$�$�                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�A�T � %Download - G/L Information �o��R� * � %USING REPORT.LOAN-FILE, FIND WHEN COLLATERAL < 995 AND BALANCE>0 zaG��R@ * � %REREADING, VAL OF CURR-BRANCH �*T � %BRANCH �F��RB&� * � %REREADING, VAL OF COLLATERAL �&6T � %CC �$�$�$Q                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�&7T � %1A �C��RD!� * � %REREADING, VAL OF BALANCE �E?��RDY� * � %REREADING, VAL OF APR �I�}R * � %REREADING, VAL OF VAR-RATE-CODE �'�T � %VRC �G�cR * � %REREADING, VAL OF REVIEW-DATE �&6T � %CC �$�$�$Q                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�I�IRFL!� * � %REREADING, VAL OF MATURITY-DATE �RB�/RC$ * � %REREADING, VAL OF AMOUNT �E�Q * � %REREADING, VAL OF FREQUENCY �AMGD��RFA�� * � %REREADING, VAL OF DUE-DATE �*��NB} � %A4/100 �+ T � %BALANCE �T � %CC �$�$�$Q                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�,��NA	 � %A5/10000 �(:T � %RATE �2��$FA�� � %DAT$2(SYSDATE) �19990303i��$FL!� � %IF$(A3=590,"",IF$(A3=760,"",IF$(A3=761,"",IF$(A3=990,"",DAT$2(A8))))) uA20000902=�y$ � %IF$(A15<A14,"",DAT$6(A8)) �09/02/00,�T � %MAT-DATE � � %CC �$�$�$Q                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�W�_$ � %IF$(A6=0,DAT$6(A8),IF$(A6=3,DAT$6(A7),DAT$6(AD28))) �09/02/00,�T � %REP-DATE �*�ENA���R � %A9/100 �+�T � %PAYMENT �,'�+$ � %A10 �M-�T � %FREQUENCY �.�$ � %DAT$6(A11) �04/02/99 � %CC �$�$�$�                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�,�T � %DUE-DATE �s��RB�� * � %USING REPORT.SHARE-FILE, FIND WHEN CONTROL-FLAGS(22)="1" AND BALANCE>0 tG��R@ * � %REREADING, VAL OF CURR-BRANCH �*T � %BRANCH �E��Q * � %REREADING, VAL OF DESC-ABRV �03C%'6T � %SDA �CC �$�$�$Q                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�&7T � %1A �?��RA$ * � %REREADING, VAL OF ACC �C��RD� * � %REREADING, VAL OF BALANCE �D�}RC� * � %REREADING, VAL OF DIV-RATE �K�cRFB@ * � %REREADING, VAL OF CERT-MAT-DT/LS4 �G+�INC  � %A5/100 � � %SDA �CC �$�$�$Q                                      "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�+�T � %BALANCE ��,�/N@�333333 � %A6/10000 �(�T � %RATE �0�$@` � %SUB$(A3,1,2) �03(�T � %TERM �-��$ � %DAT$6(A7) � 05/29/99,T � %MAT-DATE �-��$ � %DAT$6(A7) �05/29/99�CC �$�$�$�"                                     "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�, T � %REP-DATE �Z��RBS� * � %USING GLDATA.ACCOUNT-FILE, FIND WHEN ACCOUNT=!X �B��R * � %REREADING, VAL OF BRANCH �*T � %BRANCH �C��RF��b * � %REREADING, VAL OF ACCOUNT �A(6T � %SORT �&7T � %1A �$�$�$�"                                     "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�N��RE�� * � %REREADING, VAL OF LAST-MO-END-BAL(1) �@��Q * � %REREADING, VAL OF TYPE �O*�}ND�6@ � %A3/100 �+�T � %ACCOUNT �RW�cND;������ � %IF($A5=$"I",0,IF($A5=$"E",0,IF($A5=$"N",0,A4/100))) �T+�T � %BALANCE � � %1A �$�$�$Q"                                     "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�5�IN � %IF(A7=0,A4/100,0) �A*�T � %INCOME �,O 
 ,BXSA2K52dd �;O 
 ,BX C
H'Pd �;5O 
 ,BX C
HPd �F;OO 
 ,BX C
HPd �;iO 
 ,LN DZD'Zd �A$�$�$�"                                     "6�6��$�$�$�$�$��6�6�6�6�6�6�6�6�6�6�2�;�O 
 ,BX C)
H3Pd �;�O 
 ,BX C)
H+Pd �A;�O 
 ,BX C+
H-Pd �;�O 
 ,LN D-ZD3Zd �;�O 
 ,LN C
HPd �;O 
 ,LN C#
H#Pd �$$$$�$�$�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[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�2�6[<�<GLDATA.DATA.CU1              IM)+*%.(�GLDATA            <MEMBRS.REPORT.CU1            IM)+*%.(�REPORT            QCREPRTB    10  GROUP 1x    20  D,BRANCH,-8;CC,-11;BALANCE,-23;RATE,-30;MAT-DATE,-41;REP-DATE,-49;PAYMENT,-65;FREQUENCY,-67;DUE-DATE,-75;VRC,-78    30  ENDGROUPQCREPRTC    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�2�6[S    20  D,BRANCH,-8;SDA,-11;BALANCE,-23;RATE,-30;TERM,-33;MAT-DATE,-41;REP-DATE,-49L    30  ENDGROUPQCREPRTD    10  GROUP 1 6    20  D,BRANCH,-8;ACCOUNT,-17;BALANCE,-32;INCOME,-62    30  ENDGROUP
^EODLTMPS^^EOQ$^
Dt_\!y`K[Kbd<g94%;d-7cIdYMENT,-65;FREQUENCY,-67;DUE-DATE,-75;VRC,-78    30  ENDGROUPQCREPRTC    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�2�6[�accounting                                                                                                                                                                                                       316                                         ;d-7cIdYMENT,-65;FREQUENCY,-67;DUE-DATE,-75;VRC,-78    30  ENDGROUPQCREPRTC    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�2�6[8*��������&8fS��U�$��v<#�#�� ����DISC                             1PROSTRBS        QCPUB           AICS                            MGR     AICS    �fSA5����5����5��~N5��~N#��m$�8��' '5��~NAICS            #�P��ࡱ�>��	����P��������������������������������������������������������������������������������P����������������������������������������������������������������������������������P��������������������������������������������������������������������������������P��������������������������������������������������������������������������������P����������������������������������������������������������������������������������P��������������������������������������������	
P
��������������������������������������������������������������������P����������������������������������������������������������������������������������P��������������������������������������������������������������������������������P��������������������������������������������������������������������������������P����������������������������������������������������������������������������������P����������������������������������������������������������������Root EntPry��������@�bf�
�fpP�ْf��SummaryInformation��P(����8PSource������������P	t
Binary Reflectio��Pn 1x v521168������������P3�����

P !"#$��P%&'()*+,-./012����45678P9:;<=>?@ABCDEFGHIJKLPMNOPQRSTUVWXYZ[\]^_`��Pa����������������������������������������������������������������������������P��������������������������������������������������@�bf�
�fp����P�Oh��+'��D�*�Cm�fp�����	��P ,8
DPXdp|�
P����Rob PerkinsProfitStar DownloadP8Downloads monthly data necessary for ProfitStar update.
Reflection 1��P1@P��גf�@��u���@P��גf�P@<P (4
������������������P����������������������������������������������������������������������э��������P������������������������������������������������������߫���ߏ��������ߛ���������P�����ߙ��߯���������ߊ������������������������������������������������������������P������������������������������ߺ�����������������߱�����������������������������P�����߷�������������ߞ�߶����������������������߲���������ߞ�߶�����������������P��߲�������ߞ�߬��������ݺ�������������߼�߾�߬�����������߼���׍������߼���������P��߼������Ҳ������߳�߾�߬�������������߼���׍������߼���������߼������ҵ�������P��߾�߬�����������߉�߾�߬�����������߲��ߞ�߬�����������߯�������߾�߬���������P���߲����������߼���׍�������������߼���׍������������������߾��������������������Pߺ����߸���ߺ����������������߶���������ݺ����ߪ���߱��������ݪ���߱������������P�ߪ�����ײ���׉���������������߶�����׫���׉���߫���߸���ߺ������������Ѩ�������P�����������������ߺ����߸���ߺ�����������������߯������������ݺ����ߪ���߯��������P������ݪ���߯������������������ߪ�����ײ���׉����������������߶�����׫���׉���߫P���߸���ߺ�������������Ѩ��������������������Ѽ�������ݽ���߰�����߬����������ѬP�����������ݨ������ߙ��߯����������������Ѩ�������������ݲ��Ж����߱��������������P��ߍ��������������������������Ѩ���������������������Ѭ�����������������ѫ������P��ݷ��������߉�����Ӳ��Ѽ��Ӯ����į��»����߼��ߍ����������������������������Ѭ�P����������ݨ������ߙ��߯�������������������Ѩ������������߳��������߱�������������P���ߍ��������������������������Ѩ���������������������������Ѭ������������������P���ߺ����߸���߫��������������������������Ѭ�����������ݫ�����������߸�߻���ߋ��P�ţ�����������ѫ�������������Ѩ��������������ݴţ�����������ѫ�����ݯ����Ѯ�������P�����ߍ�������ߍ�����������ѫ����������������������������ߍ���������������������P������������ݫ�����������߼�߻���ߋ�ߴţ�����������ѫ�������������Ѩ������������P��ݴţ�����������ѫ�����ݯ����Ѯ����Ѽ����ߍ�������ߍ�����������ѫ����������������P��������������ߍ��������������������Ѭ�����������ݫ�����������߳���߻���ߋ�ߴţ�P������������ѫ�������������Ѩ��������������ݴţ�������������ѫ�����ݯ������Ѯ���P�Ѽ����ߍ�������ߍ�����������ѫ����������������������������ߍ���������������������P��������������������������������������������߼���ߺ�����������߷����������������P���������ݹ���ߛ���ߑ��ߚ����ߐ�ߗ�����߯�����ߜ����������ߠ�������ݏ������ߞ���P���ߞ�����������������������߲���߲����������߲����������������ߺ�����������������Pݺ��������ߺ������������ߺ����׺�����ߠ����������߯�����ߑ�����߼���������������P��������߲���߲����������߲��������������߬�������������������������Ѭ����������P������������������������Ѽ��������߫����ѻ�������������Ѯ���������������������ߨ��P����������߬�������������������������������������#�N�����K�������PC�����7���������������������������߱�����������ߪ���߱���������������������~}}��P������߰�����߬������������~}������������ߙ��߯����������������~{�����������������P�����������������Ж��������~{}}����~}}����������������Ӳ��Ѽ��Ӯ����į��»�����~P{}�����������ߙ��߯���������������������������߸�߻���ߋ�ߴţ�����������ѫ������P�����������Ѯ����Ѽ��������ţ�����������ѫ���������~{{}}}}}��������~��������������P������߼�߻���ߋ�ߴţ�����������ѫ�����������������Ѯ����Ѽ��������ţ�����������Pѫ��������������������߳���߻���ߋ�ߴţ�������������ѫ�������������������Ѯ�����P�������ţ�������������ѫ��������������ߛ���ߑ��ߚ����ߐ�ߗ�����߯�����ߜ������ߏ��P������ߞ��ߋ��ߞ��������������������������������������������������������߯������P������߼���������������~���~���~��������b�I��������������������������������P������������������������������������������������������������������������s���������P��������������������������������������������������������������������������������P������X�����������������������������������������������������������������������P����������������������������������������������D����������������������g�����������P������������������������������������������������������������������:�������:��Z��P��������������������h�������k���������d�a�����������G�c�D���������d�d�����������PG�c�D���������_�9���������d�d����d����d����������Q���	������������Q���	������P������������G�c�D���������d�����d�f�m�����Q�����C�����~�����-�����G�c�D�����n�P����d�������C�����0�	������������n�������r�������d���������Q���	�����H�����D�P��������������Q���	�����H�����D���������������Q���H�����D���������n�j��������s���PQ���	���������g�Q���H�����D���[�������n�d���d���H�����D���S���������Q���H�����D�P��������f��������K�����G�e���D�����?�e�������G�e���D�H�����D���'����������Q���PH�����D���������n�j��������s�Q���	��������������G�e���D�H�����D���[�������n�d���P��d���H�����D���S���������Q���H�����D���������_������������Q���H�����D���������Pd���d���d���i����n����������Q���������Q���H�����D���������c�H�����D�����������P����Q���H�����D���������d���d���d���i����n��������W�Q�������C�Q���H�����D�������P����c�H�����D�������������+�Q���H�����D���������d���d���d���i����n����������Q�P��������Q���H�����D���������c�H�����D���������r�������n������������r�������r���P�����������}�n�����������������G�c�D�����n�����k�Q���	������^���������G�	�����PD��������q�������r�c�������������c�	���n����������������W�	�������������n�����P����������������{�O�	�����s��������G�c�D�����n�����k�Q���	������^���������G�P	���D��������q���������Q���H�����D���������n�H�����D���/�n�������H�����D���+�����P��H�����D���'�����������g�����o�����������������������������������������������P����������������������w��������������������'����������������������������Pw�������s�������������������������������������������������������������������������P��������������������������������������������������������������������������������P���������������������������������P��PPP��@��&8���������fS��U�$���&��� ����DISC                             1DOWNLOAD        QCPUB           AICS                            MGR     AICS    �fS5��K$5��K$5��#�5����{U�pP�   5���AICS            ��                 QueryCalc Reports for Credit Unions                                               written by:  Mizzou Credit Union                                                    last update:  03/05/1999                                                                                                                                              DOWNLOAD.TXT                                                       -------------------------------------                                                                                                               Note:  This file is best viewed and printed with                                       the font set at Courier-New, Regular, 10                                                                                                                                                                                             This file contains information on setting up the ProfitStar download            **********************************************************************          GL.TXT - Balance Sheet                                                          GL.TXT - Income/Expense                                                         CD.TXT - Time Deposits                                                          LOAN.TXT - Loans                                                                                                                                                                                                                                GL.TXT - Balance Sheet                                                          **********************************************************************          Type = 0                                                                        Block = 0                                                                                                                                                       Field Name        Format         Sign   Abs   Begin   Length   Codes            --------------------------------------------------------------------            Account #         Normal                          9        9                    Current Balance   No Adjustment  -xx             18       15                    Average Balance   No Adjustment  -xx             33       15                                                                                                                                                                                                                                                                    GL.TXT - Income/Expense                                                         **********************************************************************          Type = 0                                                                        Block = 0                                                                                                                                                       Field Name        Format         Sign   Abs   Begin   Length   Codes            --------------------------------------------------------------------            Monthly Inc/Exp   No Adjustment  -xx             18       15                                                                                                                                                                                                                                                                    CD.TXT - Time Deposits                                                          **********************************************************************          Type = 0                                                                        Block = 0                                                                                                                                                       Field Name        Format         Sign   Abs   Begin   Length   Codes            --------------------------------------------------------------------            #1 Sort Field     Normal                          9        3                    Amount            No Adjustment  N/A             12       12                    Interest Rate     No Adjustment  N/A             26        5                    Original Term                                    31        3                    Maturity Date     MM DD YY                       34        8                    Repricing Date    MM DD YY                       42        8                                                                                                                                                                                                                                                                    LOAN.TXT - Loans                                                                **********************************************************************          Type = 0                                                                        Block = 0                                                                                                                                                       Field Name        Format         Sign   Abs   Begin   Length   Codes            --------------------------------------------------------------------            #1 Sort Field     Normal                          9        3                    #2 Sort Field     Normal                         78        1                    Amount            No Adjustment  N/A             12       12                    Interest Rate     No Adjustment  N/A             24        6                    Maturity Date     MM DD YY                       34        8                    Repricing Date    MM DD YY                       42        8                    Payment Amount    No Adjustment  N/A             54       12                    Next Pmt Date     MM DD YY                       68        8                    Pmt Frequency                                    67        1    ***                                                                                             ***                                                                             Every Week           = W                                                        Twice Every Month    = S/B                                                      Up Through One Month = M                                                        Every Three Months   = Q                                                        Calendar Quarter     = Q                                                        Annual               = A                                                                                                                                        Other terms listed   = Z                                                        ������������������������STORE/RESTORE-HP/3000.MPEXL  &/� �8�����B5152AA  C602403/16/010000�������������������������