A Quick Tip for Report Writers: Members who Don’t Use Online Banking

Hello! Today’s tips are for my fellow query users who need to pull lists of members who are not online banking users. Recent branch closures have you especially interested in reaching out to raise awareness of your remote self-services. I am encouraged to see many people putting forth these efforts in the light of genuinely…Read More

A Quick Tip for Data Analysts: Analyzing Mobile Deposits

Hello! Today’s tips are for my fellow CU*BASE analysts who need to work with data on mobile deposits (RDC) – use this information to start or enhance your efforts to analyze the RDC service’s recent activity. Tips for Analyzing: Large Deposits – Monitor for repetitive checks at or near the maximum daily limit. If you…Read More

The Lightbulb Went Off… Sort/Break/Summary (Totals)

This is one of those tricks in Query that typically comes around later on in the learning process. It’s an odd gray area of just a little too complex to effectively teach right away, but useful enough that it really can be a key time-saving and simplifying tactic of many projects. I was just fine…Read More

Quick Tip for Report Writers – Use the Better Date from CUFMAINT

Save time, simplify your work, and stop typing your dates in both the YYMMDD and MMDDYY layouts each time you run a query over the File Maintenance data. The original Maintenance Date field of MNTDAT will naturally have dates in both layouts, which is friendliest for optimal processing by the programs that write out the…Read More

The Lightbulb Went Off…Add to Member & Y/N Conversions

I’ve recently been working on a hefty project that is stretching my skills with custom queries up to a new level, primarily with its requirements for very specific formatting and column rules. The part that became my lightbulb moment relates to hand-crafting Y/N (Yes/No) indicators on various pieces of information that do not already live in CU*BASE(r) data as Y/N. Quite a few were…Read More

Know the Numbers

Yesterday I had the pleasure of spending about 45 minutes with a group of ladies who are considering CU*BASE as the next core processor for their credit union. It was a perfect occasion to cover the sheer volume of pre-defined data resources available. As I was talking through some of the details, it struck me that I should definitely be telling everybody else the…Read More

The Lightbulb Went Off….Dates and LIBCRTAUT

This is a post theme I plan to repeat occasionally and I’m excited to kick it off here! The idea is to share big moments whenever I discover something that I feel is a breakthrough for me, or for a credit union I’m working with at the moment. I want to share these discoveries and strategies with everyone! Topics…Read More