There is a table called MBRAPPSTAT which holds records of various API calls done during the entire member authentication process, even before they have successfully logged in to online banking (even if through the mobile app). That is the first place TO look to see records of what's happening with this member's account as they step through that process. There is one row for each API call, and each API call represents a different phase of the process. For example - Get Username, Get Chall  More...

After accessing your query in Report Builder (Tool #100), select the option to Choose Files and select to add the DATELOOKUP table. To join this file, select 1 or 2 (matched records or matched with primary) and join by the compatible date fields. As an example, if your original file's date field is OPENDT and the format is MMDDYY layout, you would then match the OPENDT field with the matching field format in the DATELOOKUP table, DTMMDDYY. Once the DATELOOKUP table is linked in, you need  More...

You can easily convert columns in Excel so that they can be formatted as dates by using the Text to Columns wizard. While in your Excel table, follow these steps: First, use the column header to select the entire column with data to convert In the menu ribbon, select the Data tab Within the Data Tools section, click the Text to Columns button Follow these steps within the resulting wizard pop up Step 1 – no changes Step 2 – no changes Step 3 – Select Date and then if needed   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...

What This Message Means: This appears when your credit union has set a password expiration period for inactive accounts. This means that if a member doesn't log in to Online Banking for a certain period of time, their password will be deactivated. If a member sees this message, they cannot reset the password themselves and must contact the credit union for reactivation. What Steps to Take in CU*BASE: See the link below for step-by-step instructions. BE CAREFUL!! Always verify the person'  More...

In this case the credit union name is being pulled from your chart of accounts, from the corporation record. This is updated using Tool #202 Chart of Accounts/Budget Groups Maint.

If you are creating a membership by copying over the data from an existing non-member record (like a joint owner or co-borrower is joining the credit union), the system will copy over all phone numbers tied to that non-member record and attach them to the new membership, then delete the old numbers tied to the non-member (since the non-member record itself also gets deleted at that time). This is not the same when copying from another existing membership , or when copying from a closed membershi  More...

This procedure should be used if the member's password was disabled because of too many invalid retries. The error message the member will see reads: Please contact the Credit Union for a new password. (Click the Related Q A link below for instructions on what to do if the password was expired due to non-use.) Launch Tool #14 Member Personal Banker and enter the member's account number. Select Online Banking/ARU (activate, change PIN/password;view password history) option. Under   More...

If you need to allow an employee to perform upload and/or download tasks (FinCEN, AIRES, ALM, uploading G/L entries to post, etc.), you must first complete the iShield Security Access Request form and have it signed by your credit union’s designated Security Officer to sign. Once our Client Services team receives your signed form and verifies it, a request will be submitted to our System i administrators, and you will be notified when the new permissions have been granted. This process wi  More...

For CU*Answers online clients, effective in March 2017 the standard online retention is 12 months for basic savings and checking accounts, and 48 months for all certificates, IRAs (shares and CDs), HSA share and checking accounts, club accounts (such as vacation, holiday, Christmas), tax escrows, and all loans. Prior to March 2017, data retention was 6 months for savings/checking, and 24 months for other member transaction history . Note that when this data is purged, it also removes the additio  More...

Yes, there is the PREGD Reg D statistical report that is automatically generated every day and is located in CU*SPY under the Member Service category. This report gives you the balances of your shares, drafts, and certificate accounts along with the balance for GL 739.00 Cash. Simply print the days you need to collect for the FR2900 report. To find the balances for other GL accounts for the 5 days requested in the FR2900 report you can use Tool #650 Print GL Trial Balance (monthly) to select  More...

Yes. CU*BASE offers an great feature to calculate a membership ownership or patronage dividend that allows for an audit run to evaluate the total amount and accounts that may be excluded. At the time the patronage dividend audit or posting run is processed, there are two files created that reside in the QUERYXX library. The data file for the excluded accounts is PATRDIVEXC. For the accounts that will earn the patronage dividend, the file name is PATRDIVINC. The data in each file represents the l  More...

Yes, If you are a CU*BASE client and your check processing is handled by the Check Item Processing team, you can offer your members the ability to print copies of cancelled checks using Online Banking and the CheckViewer. If your credit union chooses to activate this feature, the member simply clicks a button from either the checks cleared screen or the account detail transaction listing, to pull that specific check. We also offer interfaces to check images from many other item processing vendor  More...

The following is a summary of the authority control layers every database administrator should be aware of when managing access to data tables and the raw information they hold. Warehouse authority – blanket of permissions and prerequisite to all other layers of authority. These permissions are applied per Library based on User ID for individual warehouses. Table authority – precision for just one table but generally remains consistent across tables within any one warehouse. These   More...

There are a couple of access points: Launch Tool #14 Member Personal Banker and select the Online banking/ARU (activate, change PIN/password; view password history) option OR Launch Tool #72 Update ARU/Online Banking Access (PIN) (Shortcut: PIN) It's Me 247 CU*TALK CUTalk

Yes. The data match file we already send to the State of Wisconsin each quarter will be used now by them for multiple purposes, including tax data, unemployment insurance, etc. Your credit union is still charged the same quarterly fee* for transmitting a single file to the state. (Note: This same technique may also be used by other states that are now requiring unemployment insurance claim data matches. CUs do not need to do anything; the file content is the same and the state is simply using  More...

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

What This Message Means: This appears when the member has tried 3 times to enter their password incorrectly. The message does instruct the member to click I forgot my password and answer all three Security Questions to reset the password themselves. But if the member doesn't know their password or their security questions, they will need to contact the CU. BE CAREFUL: This is a scenario that presents the most risk to your members. If a bad guy finds out a member's name, account nu  More...

The previous tools used for uploading and downloading to and from CU*BASE will be retired when your credit union recieves the 20.07 CU*BASE software release. For online and Site-Four credit unions, that date is Sunday, July 12. Self-processing credit unions will receive the release the following Sunday, July 19. To replace the two tools, a new tool was introduced in November 2018, Tool #1375 Data Transfers (Upload or Download) . Following the release, this tool will be the default data transfer  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...

Members need to remember that when they provide their online banking login credentials to financial aggregation software (Quicken, Mint, Yodlee, etc.) these programs login to online banking in order to retrieve their information. As a result, each time they refresh their data through this software will result in a login being recorded by our online banking software.

No, you do not have to automatically activate OLB or ARU for new memberships. Actually, you can default all new memberships to deactivate online banking and/or audio response access until the member specifically requests it. This is highly recommended as it helps to protect members who join the credit union but never get around to using your online tools right away. These accounts may be your most vulnerable since the member hasn't set up a private password or security questions. By deact  More...

Contact a CSR for assistance with this issue. The impact of the solution may vary from situation to situation.

Log into online banking, then in the Info Center section and select Username. Or if it is required by the credit union, the member will be presented this screen at login.

The following applies only to credit unions that have activated the Text-To-Speech (TTS) engine for CU*Talk Audio Response. You can use Tool #506 Member Rate Maintenance to control product rates read to members in CU*Talk Audio Response. But keep in mind that because you are using Text-To-Speech, changes made here directly affect the credit union website and It's Me 247 online banking as well. Once in the menu option, select shares or certificates. From the next rate menu, you will see a   More...