Yes! This is definitely not a save it and forget it process. Set a monthly reminder to check that your Queries are running as expected. Once the automated Queries are run, the Automated Run of Scheduled Queries – Audit Report (PRUNAQ) will appear in your DAILYxx OUTQ. Be sure to review this report. Also remember that after CU*BASE software releases you may need to refresh your Query to adapt to changes made to the underlying database tables. Use the link below to learn how.

Use Tool #332 Database Search Assistant. This tool lets you enter part or all of a table (file) name, a column (field) name, or even a portion of a table or column description to help locate where data is stored in your member files.

The NSF Statistics Dashboard (Tool #557) will track this information for you automatically. It is separated into the NSF category and the Courtesy Pay Category. Credit unions are using this dashboard to help predict averages of NSF/Courtesy Pay fee income and also to track how many members may be using the service. You can click on any of the origins (listed in blue text) and you can drill further to members who had more than X transactions in a specific month. There are a lot of graphical oppor  More...

No. The way that normal CU*BASE features work is to use the CU*BASE Workstation Configuration settings to determine a default printer for certain functions, or you can choose a printer directly when printing most CU*BASE reports. But since IBM Query is not a CU*BASE program but rather a generic program offered by IBM, it does not have any way of looking at CU*BASE configs for the info it would need to direct the print job. Therefore a Query definition will go to your list of spooled files and  More...

This occurs when the release includes changes to the files that your Query uses. For example, if we add a new field to the MASTER file, any Query you have that uses that file will display an error message. Fortunately, it is very easy to refresh your Query so that you can use it again. All you need to do is access the Query and save it. That's all. You don't have to make changes to it, it's just important that you save it so it can refresh itself to match the new file layout.   More...

To analyze Member Trackers, simply run a report in Tool #664 Print Member Trackers . When configuring Tracker Type ( Tool #277 Configure Tracker Types ) and Memo Type ( Tool #260 Configure Memo Type Codes for Trackers ), you created specific codes that track these types of records. Tool #664 allows you to generate a report based on multiple search criteria, including Tracker Type and Memo Type, as well as date range, and Employee ID. Additional options are available to analyze Sales Trackers via  More...

Beginning with the 17.10 CUBASE Release (October 22, 2017 for online clients), CU*Answers implemented the CUFMAINT table, which includes data from the CUFMNT table, as well as additional data not included in CUFMNT. CU*Answers recommends using the CUFMAINT table for all report building and query activity. If you currently have any Queries using the CUFMNT table, they will still work, as CUFMNT is now a View over the C UFMAINT table but without all of the additional information, so it will s  More...

Generally, no. We do purge files you create via a Query (see the link below), but not the Query definitions themselves.

Launch Tool #100 CU*BASE Report Builder (Query) Make sure the Location reads QUERYxx (where xx is your CUID) Click the Lookup button next to the Name input field Use the tab key to jump down to the list at the bottom of the screen, and use tab or page down to scroll to the first query you wish to print Tap the letter “P” or choose Print definition from the drop-down menu Repeat steps 4 5 for a small batch of Queries (to avoid an error message, choose no more than 8-10 at a time)   More...

Prior to the 16.10 release, the SSA began using multiple Company IDs, and it was recommended that credit unions consider using Automated Funds Transfers (AFTs) to handle distributions. Beginning the 16.10 release a new cross-reference system will be implemented that will automatically funnel all incoming company IDs from the Social Security Administration and treat them as if they came from one, consistent company ID we’re referring to as the “Primary ID.” With the changes ma  More...

There is a file HBMASTER that you can query to find the membership applications you have received via online and mobile web banking. To work these applications, use Tool #13 Work Online Banking Apps/Requests .

For things like expanded balance and transaction $ amounts, Query will automatically adapt to larger amounts, and you generally won’t need to do anything. (The only exception is if you send the output to a vendor, they’ll need to be made aware of the larger amounts. Or perhaps if your report is completely full side to side and you need to remove a column in order for everything to still fit across a printed page.) As far as dates, if a date was formerly 3 separate fields for year  More...

The numbers will be different because two different files are used. One file is LAHSTAT, and the other file is AUDICC. AUDICC will give the true total of internet logons that the member has performed for the month. The other file LAHSTAT, will add all internet logons and will stop when our operations team begins our end of month processing, but members can still sign on to online banking during end-of-month processing and that is tracked in the AUDICC file.

Since the list of valid values changes periodically, we suggest you use the Database Search Assistant to look up the most current set of values in this field: Launch Tool #332 Database Search Assistant Select Table and enter AUDICC in the search box and press Enter to search Click the View columns lookup button in front of the AUDICC table in the list Click the More information button in front of the CCLOGT column/field name

Whenever you add files to your Query definition or remove files from it, you also need to refresh the automation configuration, which is basically just a list of the files needed by the Query and must match the Query definition. See the link below for step-by-step instructions.

Prior to the 16.10 release, the SSA began using multiple Company IDs, and it was recommended that credit unions consider using Automated Funds Transfers (AFTs) to handle distributions. Beginning with the 16.10 release a new cross-reference system will be implemented that will automatically funnel all incoming company IDs from the Social Security Administration and treat them as if they came from one, consistent company ID we’re referring to as the “Primary ID.” With the chang  More...

Starting with the 16.10 release, you can schedule recurring Automated Funds Transfers to and from accounts that are configured with the CU*BASE Account to Account (A2A) feature. You can also set up recurring outgoing AFTs to accounts set up with the “Off Trial Balance” (OTB) feature. Refer to the linked to Answer Book items for more information. This was implemented with the 16.10 release that was implemented to online clients on October 23, 2016.

The Closed Account Report and the Closed Membership Report have two versions. LCLACE and LCLMBE are the daily reports that run at EOD. These reports show closed accounts and closed memberships for a single day. LCLAC and LCLMB are the reports that are run from the CU*BASE menu and via Report Automation, and these show closed accounts and closed memberships for a given month.

There are several configurations that control the member’s ability to set up and maintain Automated Funds Transfer (AFTs) online. Does your credit union's Personal Internet Branch configuration allow the maintenance of AFTs? Are AFTs configured to show in online banking? Does the member's PIB configuration allow maintenance of AFTs in online banking? For existing AFTs: Is the record locked to prevent changes in online banking? 1. Does your credit union's Personal Internet Bran  More...

A quick way to clean house is to click the Lookup button next to “Name” on the initial Query screen (Tool #100) to display all of the definitions in your QUERYxx library. Use the drop down lists to choose Delete (the keyboard shortcut is “D”) on any that you no longer need. To avoid errors, we recommend you delete only small batches at a time.

Use the link below to read about this in CU*BASE GOLD online help.

With the File Expansion Project (FEP) in 2014 we introduced new formats for date fields in the account and transaction database tables. Referred to as the ISO date format, dates with this format can easily be used in search and selection criteria, as well as in calculations (such as the number of days between dates, etc.). In the past, a date field that didn't have any data entered into it was simply blank. But with the ISO date format, a null date, meaning no date has been recorded,  More...

Three reports can be used to monitor your AFTs. The Member Automatic Account Transaction Record (TAT1) report includes a detailed listing of automatic transfers that posted. The Member Automatic Account Transfer Notification Report (TAT2) show automatic transfers that did not post. The Member Automatic Account Notification Register (TAT3) lists transfers to 360 accounts that were “out of the ordinary” such as members who are making principal-only payments or additional payments. L  More...

Yes! The Call Report software is able to calculate more than one automation routine for the same NCUA account code. This is especially useful for the loan areas of the Call Report when you need to gather information from various codes (purpose, security, category, G/L) for the same NCUA category or if you have off-trial-balance (OTB) loans and in-house loans that fall into the same NCUA category. Each automation routine is set up separately then is automatically added together to provide the   More...

Starting with the 16.10 release, credit unions can begin allowing AFTs with accounts that are “off the books” including accounts set up with the CU*BASE Account to Account (A2A) and CU*BASE “Off Trial Balance” (OTB) feature. The screen used for delinquency handling is skipped when setting up an AFT in CU*BASE with one of these accounts. See a link to this skipped screen below. When members set up AFTs in online banking, they cannot set delinquency rules. For this reas  More...