View Tables

WHAT IS A VIEW

If you write queries, you will save time with View tables! If you don’t write queries but you’d like to, Views will make it so much easier to begin. More on this later, but essentially a View table will combine, organize, or reformat the raw data stored in CU*BASE into a much friendlier and simple structure for use in Query!

A View is actually an alternative way of representing data stored in the database tables. They aren’t actual tables (surprise!) and they don’t have any permanent storage. Data still lives and is maintained in the original “base table”. But even though a View is not technically a table, it will work just like one when you use it in Report Builder (Query) – just put in the View name and the location is still your FILExx library. (don’t know what FILExx is – click here)

Read more from Annalyn about suggestions and insights with Views:

A “View” into a new Query future

What is a View?

 

HOW ARE VIEWS HELPFUL?

Views are helpful for multiple reasons and we build them in an effort to assist with simplifying our database for analysts. Remember, CU*BASE and its data and programs are above-all designed to best support the primary function of the core – data processing. Analysts like you and I often need to re-interpret or re-format data to work well with our projects to extract the data for analysis.

Some of the ways Views can specifically help include their abilities to:

  • Combine data from different base tables – Especially those combinations that are done frequently by many CUs and for many reasons
    • Combining MEMBER5 and MEMBER6 for loan reports)
  • Summarize data, or hide sensitive data
  • “Clean up” a table by filtering out certain portions of the data that are generally irrelevant to analysis.
  • Apply optimal formatting to fields
    • Handling the older data values by turning them into an ISO-format equivalent)
  • Add additional indicators or labels for some codes that are otherwise obscure without a deeper knowledge of configurations
  • Reorganize or filter tables that are particularly confusing, or that store many unrelated data elements

Ultimately, all these functions of Views will make data easier to access and decipher for analysts.

 

VIEWS YOU CAN USE TODAY

Here’s a brief list of some Views you can find in CU*BASE today to assist your data mining and analytics projects. Check the Database Search Assistant tool in CU*BASE for the most current list of available Views:

NameDescriptionUse Instead Of
MBRNACCTSQMEMBERx open accounts for active/open membershipsMEMBER1-6
MASTER
MBRNCLACQACHISTx closed accounts for closed memberships ACHIST1-6
MSHIST
MBRACLOSAQACHISTx closed accounts for active/open memberships ACHIST1-6
MASTER
ANRBALSETQANR Balance ConfigurationsSYSCTL
ANRLVLSETQANR Level ConfigurationsSYSCTL
DBTCRDRNDQDebit Card Roundup ConfigurationsSYSCTL
DVACTSETQDIV Account Control ConfigurationsSYSCTL
MBROBSDEMQOnline Banking DemographicsPCMBRCFG
OBMBRSECIN
MBROBSECQOnline Banking SecurityOBMBRSECIN
OBMBRCHQST
MBRXOTBQOTB Accounts for active/open membershipsOTBMST2-4
MASTER
CCACTSETQCredit Card Control ConfigurationsSYSCTL
CCLOANSETQCredit Card Category DefinitionSYSCTL
CDACTSETQCD Account Control ConfigurationsSYSCTL
CDRATERNGQCD Dividend Rate ConfigurationsSYSCTL
LOANSETQLoan Account Control ConfigurationsSYSCTL
MBRCUMBALQMember Cumulative (Aggregate) BalancesMBRBAL
MBRBAL
MASTER
COLCODESQCollateral Code ConfigurationsSYSCTL
COSIGNERSQCo-signers Name and AddressADSL
MEMBER5-6
COLLNASGNQCollateral Loan AssignmentsCLML
MEMBER5-6
TRANLNESCQLoan and Escrow Payments (current month)TRANS1-2
MEMBER4-6
HTRNLNESCQLoan and Escrow Payments (history only)HTRANS1-2
MEMBER4-6
TRANSEXTDQExtended Transaction DescriptionsTRDESC
MBRLNSUMQCombined Loan Summary of active/open loansMEMBER5-6
MBRALLACTQ
MEMBERx and OTBx combined open accounts for active/open memberships
MEMBER1-6
OTBMST2-4
MBRXOTBQOTBx open offline accounts for active/open membershipsOTBMST2
OTBMST3
OTBMST4

VIEWS HAVE A FEW RULES

A View must be located in the same location (library) as all the base tables from which it’s derived. This means we won’t making a View that contains all transaction history from current month (in FILExx) and all the historical months (in FILExxE).

Why? Crossing over libraries causes issues on the back-end that hinder disaster recover and data restore processes.

 

Views won’t automatically pick up new columns that might be added to its base tables in future CU*BASE software releases. They require maintenance to recognize the new columns. We do our best to do the maintenance proactively as we apply changes to base tables, but if you notice one we missed, please reach out!

 

View tables are consistently named a special way – The last letter of a View will be the letter ‘Q’.

Why? This is the way we chose to differentiate Views from other table names in the system. It helps you to identify them quickly and it helps us to identify them from our internal programming Views which end in a different letter.

Updated
September 17, 2019

Meet the Analyst: Deriving Data Insights to Help Your Business Strategy

Meet the Analyst: Deriving Data Insights to Help Your Business Strategy

In order to become a more data-driven organization, you need a person or a team that ensures quality information can be used in a meaningful way throughout your entire business.  Meet the Analyst is your human resource for managing a range of data-driven functions, including overseeing data management, creating data strategies and improving data quality…. Read more »

May 20, 2022

Analyze Courtesy Pay Fees and Make Informed Decisions for Your Organization

Analyze Courtesy Pay Fees and Make Informed Decisions for Your Organization

Courtesy Pay fee programs have been a topic of national attention in 2022, with several national banks deciding to adjust their fee schedules, prompting many more financial institutions to start scrutinizing their own practices. How many of your members are currently using these services?  What types of transactions are causing these fees?  What would happen… Read more »

May 17, 2022

Asterisk Intelligence facilitates ‘Management Dashboard’ training to credit union leadership teams

Asterisk Intelligence, the data analytics and data warehousing team at CU*Answers, recently announced the completion of their annual management dashboard training event offered to credit union leadership teams. “CU*BASE, our credit union core processing application, contains over 110 management dashboards,” said Thomas Hull, Business Intelligence Analyst with Asterisk Intelligence. “With each dashboard designed to provide […]

May 11, 2022

Take Advantage of Analytics Booth – 90 Days FREE for New Users!

Take Advantage of Analytics Booth – 90 Days FREE for New Users!

We’re excited to offer a 90-day FREE trial of Analytics Booth for new users! With Analytics Booth, your credit union’s vitals are at your fingertips – track hundreds of data points across Balance, Member and Transaction data categories!  Customize alerts to be notified of key metrics and glean data from our 12 available dashboards.  Free… Read more »

May 6, 2022

Optics Data Zooms in on Member Engagement, Click-by-Click

Optics Data Zooms in on Member Engagement, Click-by-Click

With data collection for Online Banking Optics and Phone Optics, your credit union can have a more detailed analysis of your member base and the ways they are engaging with your organization.  Best of all, these data collection options are FREE to activate for Data Warehouse users! Online Banking Optics Data Collection With Online Banking… Read more »

May 5, 2022

Meet the Analyst: Deriving Data Insights to Help Your Business Strategy

Meet the Analyst: Deriving Data Insights to Help Your Business Strategy

In order to become a more data-driven organization, you need a person or a team that ensures quality information can be used in a meaningful way throughout your entire business.  Meet the Analyst is your human resource for managing a range of data-driven functions, including overseeing data management, creating data strategies and improving data quality…. Read more »

May 4, 2022

Frankenmuth Credit Union gets started with a data warehouse

Asterisk Intelligence, the data analytics and data warehousing team at CU*Answers, recently announced that Frankenmuth Credit Union (Frankenmuth, MI) has partnered with the data analytics consultants to establish a data warehouse with CU*Answers. “Turning on another data warehouse solution is always exciting and it’s a privilege to be working with another credit union who is […]

May 2, 2022

Asterisk Intelligence offers new NSF and Courtesy Pay fee program analysis

Asterisk Intelligence, the data analytics and data warehousing team at CU*Answers, recently announced it is offering a new service designed to address the growing interest in NSF and Courtesy Pay fee programs. “In 2022, we have seen a noticeable increase in credit unions looking to analyze and understand the performance of their NSF and Courtesy […]

Apr 28, 2022

Asterisk Intelligence Presents: Custom Queries and Training Opportunities

Asterisk Intelligence Presents: Custom Queries and Training Opportunities

Did you know?  The Asterisk Intelligence team can help build a query for custom reports or data mining insights for your credit union!  These query results will be provided as a database file in your QUERYxx CU*BASE library.  Training is also available upon request, so that you can run the query on your own in… Read more »

Apr 28, 2022