The tables to use for your custom data (this is also called Unique Data Management or UDM) are as follows: For membership-level custom fields: CMSCFDTA For account-level custom fields: CMBCFDTA

Do not use these instructions if you are performing one of the standard uploads such as to DMPIMPORT, FCBUSINESS, FCPERSON, IMPEMAIL, etc. Instead, look for your appropriate .FDFX companion file in C:\cubase\cubase\resources Instructions below are relevant for projects where you are working to upload data to a custom table destination that meets the following criteria: The table already exists in CU*BASE The table has been used before (has at least 1 row of data in it). For the purpose of the ex  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...

Yes, between the Apply for Loan Today / Contact Me About my Score button and the disclaimer is a content section, an area that can be modifed via a configuration in CU*BASE. Launch tool #569 Online/Mobile/Text Banking VMS Config. Select Credit Scores History Sales Text and use Select or Enter. Use the screen that appears to enter a URL to one of your web pages as well as the Comments that you would like to appear on the page to explain the feature to your members.

The iPay Customer Support staff can be reached at 877-434-4729 .

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

Yes, you can choose to customize the page to which It's Me 247 navigates whenever a member clicks the logout button. For example, Western Districts Members CU has the custom logout set to go to https://wdmcu.org/youve-successfully-logged-out/ , a page on the credit union's website used to promote other credit union services in which online members might be interested. Websites with this feature are It's Me 247 online and mobile web banking, BizLink 247 business banking (formelry kn  More...

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

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

Custom reports created using the CU*BASE Report Builder (Query) will only print what will fit on a standard width of paper (usually 132 characters). If you cannot eliminate some of the columns, try using the Format Columns option to shorten the length of some the columns in your report and/or abbreviate the column headings. Also try using the Choose output feature to activate the line wrapping option and/or adjust the wrapping width. Query

This link has all communications sent out from Fiserv and messages received from the member.

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

If you are requesting an EOM tape to be loaded from a month prior to your conversion to FEP in 2014, we will automatically convert it for FEP “on the fly” so that you can run Queries over it or print the report you need.

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

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

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.

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

If you are interested in being able to find out how many mobile phone numbers you have in your database, instruct your team to take advantage of the Mobile phone checkbox, which can be checked for any stored contact number. Then when creating a Query of the MASTPH file look for numbers with a Y in the MTPEFT field.

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

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

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

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