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

Analytics Booth is FREE for Credit Unions with Less Than 2,000 Members!

Analytics Booth is FREE for Credit Unions with Less Than 2,000 Members!

The Asterisk Intelligence team is excited to announce that, beginning in 2021, Analytics Booth will be free to all credit unions with less than 2,000 members.  With your subscription to Analytics Booth, you will have access to 80+ trend lines of your credit union’s data, 12 dashboards, customized alerts, Powerlines, etc.  To activate your subscription,… Read more »

Jan 19, 2021

Engage Your Board of Directors with a Dive into Analytics Booth!

Engage Your Board of Directors with a Dive into Analytics Booth!

Board Member engagement is critical to the health and success of your credit union.  Some of the most important contributions your board can make come from asking the right questions and challenging the status quo. If you’re looking to further engage your Board of Directors, Asterisk Intelligence can support your initiative with an educational briefing… Read more »

Jan 15, 2021

Free Download from AI for the 20 Quick Data Fact Projects Book

Free Download from AI for the 20 Quick Data Fact Projects Book

Free Download: 20 Quick Data Facts Book from Asterisk Intelligence Be surprised by data about your credit union!  See some information that raises more questions that you want to research and learn!  Discover (or re-discover) a data set you didn’t know you had at the click of a button! There are thousands of facts available… Read more »

Jan 13, 2021

Analytics Booth is FREE for Credit Unions with Less Than 2,000 Members!

Analytics Booth is FREE for Credit Unions with Less Than 2,000 Members!

The Asterisk Intelligence team is excited to announce that, beginning in 2021, Analytics Booth will be free to all credit unions with less than 2,000 members.  With your subscription to Analytics Booth, you will have access to 80+ trend lines of your credit union’s data, 12 dashboards, customized alerts, Powerlines, etc.  To activate your subscription,… Read more »

Jan 7, 2021

Kick Off the New Year with Analytics Booth!

Kick Off the New Year with Analytics Booth!

Take on the new year with enhanced operational reporting and improved trending abilities – impress your board with insights powered by Analytics Booth! Take advantage of operational trend lines and organizational insights accessible anywhere you have an internet connection.  Never wait for the end of the month again to review your performance – enjoy daily… Read more »

Dec 28, 2020

Asterisk Intelligence completes a data tune-up

Asterisk Intelligence, a data analytics team at CU*Answers, which provides business intelligence consulting, fulfillment, and educational services to credit unions, recently completed a Data Tune-Up consulting engagement with a Texas based Credit Union. A Data Tune-Up helps credit union partners learn how to manage their operations in ways which allow for more detailed analytics, insights, […]

Dec 16, 2020

CU*BASE Favorites from AuditLink: Audit CU File Maintenance

CU*BASE Favorites from AuditLink: Audit CU File Maintenance

The File Maintenance Inquiry screen is used to monitor file maintenance activity made by various programs throughout CU*BASE.  Data from the CUFMAINT file is displayed with the most current activity at the top. This includes data from the CUFMNT file, as well as additional data not included in CUFMAINT.  Each month, an additional month’s data is added… Read more »

Dec 14, 2020

It’s Thursday of Asterisk Intelligence Week!

It’s Thursday of Asterisk Intelligence Week!

The Asterisk Intelligence Team welcomes you to participate in the final sessions of its 4-day event, Asterisk Intelligence Week.  Attend our live webinars today (Registration required!) Below are several free webinars scheduled today, December 3rd, offered by the Asterisk Intelligence team. Use the links below to register for any class that catches your eye! Introduction… Read more »

Dec 3, 2020

It’s Wednesday of Asterisk Intelligence Week!

It’s Wednesday of Asterisk Intelligence Week!

The Asterisk Intelligence Team welcomes you to participate OnDemand in the Wednesday session of their 4-day event, Asterisk Intelligence Week. Today’s session is Prove It with Data: Strategies and Solutions. Below is an OnDemand curriculum of recorded classes, offered by Asterisk Intelligence and available when you are. Use this curriculum to attend anytime that is… Read more »

Dec 2, 2020