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

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

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

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

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

The Asterisk Intelligence team has provided a helpful PDF explaining what is happening and how to sign up for a data warehouse before March 1st. View the information first, and vist the CU*Answers Store to sign up for a data warehouse !

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

When a device first connects to the iSeries, a virtual device is created - consider it a placeholder for that workstation or printer. Only one device can exist for each ID, which is why only one person can sign into a printer at a time. Throughout the virtual devices lifecycle, there are several different statuses that device can be in. Read below for some details! Workstations VARY ON PENDING - this is the default status of the virtual device. This status means the device is ready and wai  More...

IMPORTANT NOTE: When It’s Me 247 was updated in 2021, the “See” option shown on here was made unavailable. There are two major points to consider when thinking about allowing members to see information beyond the account to which they are actually logged in. Both extend beyond online banking to consider a financial institution’s role and responsibility in protecting member private data via all access channels, from the teller line to a back office employee answering   More...

The following old special Comment codes are no longer valid now that your credit data is being reported using the Metro 2 format: BU BV BW BX BY CA CB Instead, use the Consumer Information Indicator field on the loan account to report bankruptcy. This can be changed using Tool #20 Update Account Information on the loan account (click the Credit Reporting Info button to display the the Credit Bureau Reporting Information screen). NOTE: You only need to report bankrtupcy once. If the bankrup  More...

ISA (Foreign Conversion) Fees have two different calculations based on whether the transaction being processed is being done in US funds ('no conv' as displayed on BIN configuration screen) or will require a conversion from the 'foreign' country's currency to US funds (w/conv as displayed on BIN configuration screen) for processing. The way it is determined which fee should be calculated is within the 'transaction' message that your vendor sends to CU*BASE for process  More...

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

If you or your member notice an account is not being updated (or the additional signer on a loan) you should first try to find out if the loan/additional signer was included in the file sent over to the bureau. You can do this for the most recent reporting cycle by running Tool #658 Print Loan Info Sent to Credit Bureau . If the member loan/additional signer information (defined by METRO 2 as the J1 segment or J2 Segment) is present in that file you need to look further into the following types  More...

To find out if your credit union is currently using a Data Warehouse, you can try any of the methods explained below. Method 1: Ask the Asterisk Intelligence Team Contact the AI team at ai@cuanswers.com and we'll be happy to tell you if your credit union has been set up for a data warehouse. Method 2: Library Dashboard Tool Use Tool #1980 Library Dashboard and see if the 'Library' lookup has the DW code (for data warehouse) available in this list. If present, then yes, you do have   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...

Credit Report data is stored 60 days unless attached to a loan, in which case it will be stored until the loan is closed in CU*BASE. For online clients, per our Online Pricing guide, credit bureau report online archival and retrieval detail after 60 days will incur an additional per-month charge. For example, if you would like to store the detail credit reports not attached to loans for 6 months, the first two months are no charge. At the third month, the cost is $5*, the fourth month $10, the  More...

CU*BASE uses phone numbers that are stored in the MASTPH file when generating card activation information to send to vendors on initial card orders. The numbers in MASTPH are determined by the label/flag applied in Tool #3 Open/Maintain Memberships/Accounts or Tool #15 Update Membership Information as follows: Nighttime # - primary phone number sent to vendor and defaulting into the Card Activation field when ordering a card. Daytime # - secondary phone number sent to the vendor. Mobile –   More...