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...

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...

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...

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...

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...

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.

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 .

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

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.

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...

Use Tool #654 “Print List of Custom Rpts/Inqs”

If you are looking in Tool #100 Report Builder (Query) then you are not actually seeing a table/file. What you see is actually a list of query definitions - the saved parameters used to create the table. A query definition and a table can sometimes be confused for each other if they have identical names. As an example, you might have a CDDIVS query definition which you run to create or refresh the CDDIVS table. The practice of giving a table the same name as its query definition is a common one  More...

There is not currently a way to export a canned Query directly into an Excel file. If you want to export data from a canned Query, you'll need to create a similar custom Query via Tool #100 CU*BASE Report Builder (Query) . Once you have the Query built, then you can export the resulting database file. (See the related link below for instructions on downloading files.) Keep in mind that download authority is still required in order to export any data from the QUERYxx library.

Queries used in Query Scheduler cannot contain end-of-month files. If you are using output option Database file (3) be sure to set the Data in file option to Replace File (2) or for Queries that build on each other, use Add to Member (5). Make sure the Authority of your Queries is set to *ALL. Be sure to always run the Query first to generate a database file before using it in the Query Scheduler. If you update the Query that the scheduled Query is based on, return to the scheduled Query and u  More...

With the 16.10 release a new cross-reference system was implemented that automatically funnels 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.” In cases where the Depositor ID is the same, for example a husband and wife, these ACH transactions will be handled by the same master ACH distribution record under the Depositor ID since duplicate Depositor IDs are no  More...

Using CBX to Comply with New Rules for Tracking Beneficial Ownership FinCEN has issued new rules under the Bank Secrecy Act that require financial institutions to identify and verify the identity of the beneficial owners of all legal entity members (corporations, etc.). Under the final rule, credit unions are required to have written procedures to identify and verify beneficial owners of legal entity members who open new accounts on or after May 11, 2018. In addition to identifying and collecti  More...

There are several ways to obtain this data. To see the total number of active online banking members, use Tool #856 Tiered Svcs Monthly Comparison to display active user counts for any monthly period. (HINT: Click the Goal 4 button to display this data.) This can be done even if your credit union does not use Tiered Services for any other purpose. To print a report of usage statistics, use Tool #141 ARU/Online Banking Stats Dashboard To see online banking usage stats for a particular m  More...

If you pull credit reports using the CU*BASE online credit bureau access system, credit report data is stored online and can therefore be mined for opportunities. There are a couple of ways you can find this information: Use Tool #976 Where Your Members Borrow This tool pulls trade line data from stored credit report files, showing other financial institutions with whom your members do business. This tool lets you make a direct comparison between your credit union and a competitive FI. F  More...

You can Query the PCALTCFG file for information on e-Alerts and e-Notices. This file will show you all members who have signed up for these items, including an column indicating whether the member signed up to receive the alert via email or text message. In the alert type field, the types codes are as follows: AC = ACH transaction AB = Account Balance LN = Loan Payment Due NP = e-Notice

The Secondary Names (SECNAMES) file stores instructions that link a membership account to another member or non-member record. The file stores links to joint owner names and beneficiary names for all non-IRA account types. (IRA beneficiaries are stored in a completely different file because they are linked to an IRA Plan Type, not specific individual sub-accounts.) The file also stores a third type referred to as miscellaneous owner which can be used for any purpose you wish. The most co  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...

Download the Software Note: Our network requirements have been updated and can be found here . Please verify with your IT vendor that these changes have been put into place before attempting to download Station Control. You can download CBX from this link . Site-Four clients please use this link . Instructions for Manual Install of CBX Station Control Run the downloaded CBX Install Suite Prod CBX1.exe installer. This will require administrative privileges on the workstation. 1. On the CBX In  More...

General Requirements CU*BASE GOLD, CBX, and the associated cuasterisk.com software suite ( Station Control , ProDOC, SearchLink, etc.) require that the following networks be routed to the cuasterisk.com network (typically via a CU*Answers Cisco router): For all CU*Answers privately routed networks below, all ports/services should be allowed outbound from any device accessing CU*BASE or CBX. Required for standard Production connectivity: 63.150.21.96/27 63.236.240.16/28   More...