Your request is being processed...
Did you mean:
Announcements
Most Relevant Content in All Topics
1 - 25 of 182
-
1.
How can I find out the name of a file or field I need when creating a new Query?
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.
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
2.
How do I train my staff how to send loan documents and other forms out for e-signing?
During the initial rollout the Imaging Solutions team will be offering regular training webinars to explain what your staff will need to know, as well as show examples of the member experience. We’ll record some of these sessions and post them online for your team to review. We’re also working on a couple of demo videos that will show the software in action and give tips for new users. Visit http://www.cuanswers.com/products/imaging-solutions/ for the latest details.
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
3.
I'm trying to pull a Query that shows the number of
NSF fees a member has been charged. Is there a field that separates the number of NSFs from the number of Courtesy Pay (ANR) items? I do not want to include ANR.
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
4.
We just got a CU*BASE software release and now when I try to run one of my custom Queries I get an error message, "Level for file XXXXX in XXXX does not match query (I C)." What should I do?
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
5.
How do I schedule my staff for online training?
If you are a new client, the CU*BASE Conversion Team will provide you with a tentative schedule for the 3 weeks of virtual or online training. You may adjust this schedule as needed, assign trainers, and attendees. For existing clients, visit our web site at www.cuanswers.com , click Clients then Education to view all education opportunities, including online courses.
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
6.
What’s the best way to print a batch of Query Definition Reports?
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
7.
I tried to print a Query definition and it doesn't go to my default printer like I want. Can I change that?
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
8.
I created a special report using Query a while ago but now I can't find the Query definition. Are these purged periodically?
Generally, no. We do purge files you create via a Query (see the link below), but not the Query definitions themselves.
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
9.
How can I analyze my Member Trackers without using query?
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
10.
What is the best data table/file to use when I am building a query of my file maintenance data? I see two options, CUFMAINT and CUFMNT.
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
11.
Is there a file I can Query to see on what membership applications we have received via "It's Me 247"?
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 .
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
12.
Why do the numbers from the LAHSTAT report (Tool #141"ARU/Online Banking Stats Dashboard") not match the number of internet logons if using Query on the file AUDICC?
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.
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
13.
When a database table (file) is expanded or reformatted as part of a development project, what kinds of adjustments might need to be made on my custom Queries that use that table in the definition?
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
14.
I'm working with a Query report that uses the AUDICC file. What are the values in the CCLOGT field that shows the type of connection?
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
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
15.
One of the custom reports I have set up in the Query Scheduler is not running properly. I recall something about file changes and updates that I need to make. Can you explain?
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.
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
16.
I'd like to clean up some of my old, unused Queries. What's the quickest way to delete a batch of Query definitions?
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.
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
17.
I've created a custom query report in Tool #100 CU*BASE Report Builder (Query), how do I know what Authority to assign the query?
Use the link below to read about this in CU*BASE GOLD online help.
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
18.
I am viewing a Query I created and I see some dates that look like this: 0000-01-01. What does that mean?
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
19.
I'd like to clean up my custom Queries. How can I get a report of what I have?
Use Tool #654 “Print List of Custom Rpts/Inqs”
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
20.
Can a CSR reset my employee ID password?
No, our CSRs will not reset the 2-character CU*BASE Employee IDs for your staff. This must be done by an internal CU security officer. Use Tool #762 Reset Employee ID Password . (This can also be done via Tool #327 CU*BASE Employee Security using the Reset PW option.) It is important that credit unions insure proper training to their employees regarding the expiration of their CU*BASE Employee ID password. We deliver a warning message of expiration 7 business days prior to the staff member. More...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
21.
I just deleted a table from QUERYxx in Tool #1980 Library Dashboard, so why do I still see it in QUERYxx when I look in Tool #100 Report Builder (Query)?
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
22.
What tips are there for creating Queries for use with Query Scheduler?
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
23.
What Education does CU* Answers offer?
CU*Answers strives to accommodate our clients by offering training in many different formats, from full classroom offerings (see the current CU*Answers University Catalog) to online learning and web conference sessions. We also offer individual training sessions, and workshops which can be held either at a credit union site, or here at CU*Answers. For credit union staff to train internally, we offer our web-based online courses as well as hands-on learning using a pretend CU*BASE credit union More...
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
24.
Can I export a canned Query to Excel?
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.
More...
(Rate/Comment, Related Content, Larger View, Tools)
-
25.
How do member phone numbers work as they relate to card orders and maintenance?
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...
More...
(Rate/Comment, Related Content, Larger View, Tools)
View Mobile Help
{"IncludeArchiveItems":false,"IncludeSubItems":true,"MatchValue":"and","ArticleStatusValue":"2,9","ArticleTextBoxValue":"","ProductVersionValue":"","SelectMutipleCategories":false,"Sort":null}
true
|