Difference between revisions of "Miscellaneous Reports"

From Vital Soft Wiki
Jump to: navigation, search
 
(7 intermediate revisions by 2 users not shown)
Line 4: Line 4:
 
h2=The CMNDXREF file should be added to the Visimage environment file so that it is accessible to all Visimage users. This file makes reporting HISTRY records easier by printing the CHAR-COMMAND (eg “FLAG”) instead of actual command number (79), that is stored in the database.|
 
h2=The CMNDXREF file should be added to the Visimage environment file so that it is accessible to all Visimage users. This file makes reporting HISTRY records easier by printing the CHAR-COMMAND (eg “FLAG”) instead of actual command number (79), that is stored in the database.|
 
h3=Do NOT use CHAR-COMMAND when selecting HISTRY records as it will dramatically slow down the selection.|
 
h3=Do NOT use CHAR-COMMAND when selecting HISTRY records as it will dramatically slow down the selection.|
h4=This version requires copying the CMNDFILE and is recommended for In-house clients only.|
+
f1=This version requires copying the CMNDFILE and is recommended for In-house clients only.|
 
link=CMNDXREF BUILD.ctx|
 
link=CMNDXREF BUILD.ctx|
 
created=2021/05/21|
 
created=2021/05/21|
Line 10: Line 10:
 
}}
 
}}
  
{{SampleContextWithBoth|
+
{{SampleContextWithNotes|
 
name=CMNDXREF History Command Cross Reference File - ASP Clients|
 
name=CMNDXREF History Command Cross Reference File - ASP Clients|
 
h1=Build an SD Indexed file called CMNDXREF on the Host.  This file is used to cross reference the numeric data that is stored in the HISTRY.SH-HISTORY.COMMAND and the HISTRY.LN-HISTORY.COMMAND fields, with the character commands entered by the tellers. |
 
h1=Build an SD Indexed file called CMNDXREF on the Host.  This file is used to cross reference the numeric data that is stored in the HISTRY.SH-HISTORY.COMMAND and the HISTRY.LN-HISTORY.COMMAND fields, with the character commands entered by the tellers. |
 
h2=The CMNDXREF file should be added to the Visimage environment file so that it is accessible to all Visimage users. This file makes reporting HISTRY records easier by printing the CHAR-COMMAND (eg “FLAG”) instead of actual command number (79), that is stored in the database.|
 
h2=The CMNDXREF file should be added to the Visimage environment file so that it is accessible to all Visimage users. This file makes reporting HISTRY records easier by printing the CHAR-COMMAND (eg “FLAG”) instead of actual command number (79), that is stored in the database.|
 
h3=Do NOT use CHAR-COMMAND when selecting HISTRY records as it will dramatically slow down the selection.|
 
h3=Do NOT use CHAR-COMMAND when selecting HISTRY records as it will dramatically slow down the selection.|
h4=This version loads commands from a CSV file and is recommended for ASP clients.|
+
f1=This version loads commands from a CSV file and is recommended for ASP clients.|
 
link=CMNDXREF BUILD.zip|
 
link=CMNDXREF BUILD.zip|
 
created=2021/05/24|
 
created=2021/05/24|
notes={{CMNDXREF_Readme|}}
+
notes={{Notes_CMNDXREF_CSV|}}
 
}}
 
}}
  

Latest revision as of 17:42, 28 May 2021

CMNDXREF History Command Cross Reference File - In-house Clients

  • Build an SD Indexed file called CMNDXREF on the Host. This file is used to cross reference the numeric data that is stored in the HISTRY.SH-HISTORY.COMMAND and the HISTRY.LN-HISTORY.COMMAND fields, with the character commands entered by the tellers.
  • The CMNDXREF file should be added to the Visimage environment file so that it is accessible to all Visimage users. This file makes reporting HISTRY records easier by printing the CHAR-COMMAND (eg “FLAG”) instead of actual command number (79), that is stored in the database.
  • Do NOT use CHAR-COMMAND when selecting HISTRY records as it will dramatically slow down the selection.
Sample Report Output

HISTRY.SH-HISTORY.ENTRY-DATE = #MONTH-LIST(@) and
HISTRY.SH-HISTORY.TYPE = 100 and
CMNDXREF.CMNDXREF.CHAR-COMMAND = "SHDP"


Notes:

#MONTH-LIST(@) is a global array variable that and loads an entire month's worth of dates allowing
a keyed read.

TYPE 100 selects monetary transactions

SHDP is stored in HISTRY.SH-HISTORY.COMMAND as the number 15


DATE: 05/21/2021        TIME: 11:42 AM                                        Page: 1
 
                                  SHDP Transactions
 
CHAR-COMMAND COMMAND     ACCOUNT SUFFIX       AMOUNT-SH TELLER-INTL ENTRY-DATE
 
        SHDP      15         472     00         700.00         92D3 09-30-2002
        SHDP      15        2972     15          30.92         68D3 09-06-2002
        SHDP      15        3653     16          49.57         67D3 09-05-2002
        SHDP      15        3757     10         700.00         92D3 09-30-2002
        SHDP      15        3757     10       1,000.00         BOP  09-05-2002
        SHDP      15        4061     16          37.08         67D3 09-05-2002
        SHDP      15        5138     16          25.00         68D3 09-06-2002
        SHDP      15        6101     16          28.00         68D3 09-06-2002
        SHDP      15        6917     15         138.22         68D3 09-06-2002
        SHDP      15        7189     16          52.44         68D3 09-06-2002
        SHDP      15        7212     16       2,102.98         68D3 09-06-2002
        SHDP      15        7228     16          11.12         68D3 09-06-2002
        SHDP      15        7228     16         100.00         BOP  09-10-2002
  • This version requires copying the CMNDFILE and is recommended for In-house clients only.

Download CMNDXREF History Command Cross Reference File - In-house Clients
Created: 2021/05/21

CMNDXREF History Command Cross Reference File - ASP Clients

  • Build an SD Indexed file called CMNDXREF on the Host. This file is used to cross reference the numeric data that is stored in the HISTRY.SH-HISTORY.COMMAND and the HISTRY.LN-HISTORY.COMMAND fields, with the character commands entered by the tellers.
  • The CMNDXREF file should be added to the Visimage environment file so that it is accessible to all Visimage users. This file makes reporting HISTRY records easier by printing the CHAR-COMMAND (eg “FLAG”) instead of actual command number (79), that is stored in the database.
  • Do NOT use CHAR-COMMAND when selecting HISTRY records as it will dramatically slow down the selection.
Special Notes
Create CMNDXREF From CSV file:
==============================
 - Extract the files in the ZIP file.
 - Run Visimage3 and open the "Create CMNDXREF from CSV.ctx" context file.
 - Click the OPEN button in the Layout section of the Design tab.
   - Locate and open the supplied cmndxref.csv file
 - Click GO to execute the context
 - The context should create a file called ../VISCONF/CMNDXREF

Using the CMNDXREF file:
========================
 - To use the CMNDXREF file in another context:
   - Create a new context or open an existing context
   - Click View > Manage Databases
     - Click the large + sign
       - In Full Name, enter: ../VISCONF/CMNDXREF
       - Click OK
     - Check the "Save Database changes with context." option
     - Click OK
 - CMNDXREF will become a permanent part of the context.
  
Alternatively, you can request that Fiserv add a reference to "../VISCONF/CMNDXREF" to the ENVIR: section of your Visimage3 manager files (both live and eom).
  • This version loads commands from a CSV file and is recommended for ASP clients.

Download CMNDXREF History Command Cross Reference File - ASP Clients
Created: 2021/05/24

Response File Responses

  • Reports responses for Quest-Code = REGEDATE, REGEMTHD, REGEACTN, REGENAME or REGECONF.
  • This context will report Response-File.Response for Response-File.Quest-Code entries matching : REGEDATE, REGEMTHD, REGEACTN, REGENAME or REGECONF.

Download Response File Responses
Created: 2016/09/01

XD3307

  • Script to create an SD indexed file from D3307 csv file.
  • The spectrum P3307 program creates a csv file called which contains several delinquent loan fields not stored in the MEMBRS database. This script converts the D3307 file into an SD indexed file that can be read by AskPlus and Visimage. Extract the install instructions which are stored inside the zip file.
Sample Report Output

Download XD3307
Created: 2016/09/01

GL-HISTORY-HOLD-FILE-COMBO

  • Created in LIST. Uses multipass reporting and contains 3 LISTS.
  • The first LIST, or pass, will ask for the GL ACCOUNT number and the date range for the transactions in the HISTORY-FILE and outputs to a HOST file called GLCOMBO. The second LIST will select all records for the GL ACCOUNT number entered in the first list and append the information to the GLCOMBO file. The third and final LIST uses the GLCOMBO file to report all entries from the HISTORY-FILE and the HOLD-FILE for the given GL ACCOUNT.

Download GL-HISTORY-HOLD-FILE-COMBO
Created: 2016/09/01

REVERSE-NAME-ADD-SLASH

  • Created in REPORT. Names stored FIRST-NAME LAST-NAME print as LAST-NAME/FIRST-NAME.
  • Names stored FIRST-NAME LAST-NAME print as LAST-NAME/FIRST-NAME. This is the same format as the MEMBER-FILE.NAME field is stored in the database.

Download REVERSE-NAME-ADD-SLASH
Created: 2016/09/01


Back to Context Library