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

Don’t Forget, the Analytics Booth Release Arrives June 27th!

Don’t Forget, the Analytics Booth Release Arrives June 27th!

The Asterisk Intelligence Team is excited to present the AB_21.06 Analytics Booth Release to Analytics Booth subscribers this Sunday, June 27!  This release features: Additional Web Version launch points within four new CU*BASE tools to quickly access in-depth analysis. Seven new data points, such as average credit score and average weighted rate, in the Static… Read more »

Jun 23, 2021

Register for Asterisk Intelligence Week at CU*Answers

Register for Asterisk Intelligence Week at CU*Answers

Join the Asterisk Intelligence team for one or more sessions in the July Asterisk Intelligence Week! Options include both skills and strategy sessions! During the event, participants will review and discuss data analytics, data management, and data warehousing solutions and strategies. Also available by popular demand is an entire day of tactical skills instruction on… Read more »

Jun 22, 2021

Proving Data Strategies: CU*BASE Tool Usage Insights

Proving Data Strategies: CU*BASE Tool Usage Insights

Join the Asterisk Intelligence Team as they review the Tool Usage Analysis Dashboard (#1195) available within CU*BASE.  How effectively are you and your team utilizing CU*BASE and which tools are used the most by your team?  Did you know that the 21.05 CU*BASE release introduced 10 new features within CU*BASE; are your team members aware… Read more »

Jun 18, 2021

Asterisk Intelligence Presents: Removing Barriers that Keep You from Earning

Asterisk Intelligence Presents: Removing Barriers that Keep You from Earning

Data analytics can help your credit union make informed decisions and offer a competitive edge, yet misconceptions about data analytics can obstruct the impact and hinder your earning abilities.  During our upcoming webinar, the Asterisk Intelligence team will explore 3 common misconceptions surrounding data analytics and how your credit union can turn these fallacies into… Read more »

Jun 17, 2021

The AB_22.06 Analytics Booth Release Arrives June 27!

The AB_22.06 Analytics Booth Release Arrives June 27!

The Asterisk Intelligence Team is excited to present the AB_21.06 Analytics Booth Release, arriving to Analytics Booth subscribers on Sunday, June 27!  This release features: Additional Web Version launch points within four new CU*BASE tools to quickly access in-depth analysis. Seven new data points, such as average credit score and average weighted rate, in the… Read more »

Jun 14, 2021

Don’t Miss This Week’s Proving Data Strategies: Analytics Booth Peer Comparison

Don’t Miss This Week’s Proving Data Strategies: Analytics Booth Peer Comparison

Join the Asterisk Intelligence team as they review the Peer Group Trend Graphing feature of Analytics Booth.  Your data is an asset and it’s simple to gain quick value from it – track your operational trends alongside cuasterisk.com network peer groups, defined by you.  Available for all Trends in Analytics Booth, create a Primary Peer… Read more »

Jun 1, 2021

Proving Data Strategies: Analytics Booth Peer Comparison

Proving Data Strategies: Analytics Booth Peer Comparison

Join the Asterisk Intelligence team as they review the Peer Group Trend Graphing feature of Analytics Booth.  Your data is an asset and it’s simple to gain quick value from it – track your operational trends alongside cuasterisk.com network peer groups, defined by you.  Available for all Trends in Analytics Booth, create a Primary Peer… Read more »

May 27, 2021

Join the Asterisk Intelligence Team for a Release Review!

Join the Asterisk Intelligence Team for a Release Review!

Asterisk Intelligence Release Review: Data Strategies Join the CU*Answers Asterisk Intelligence Team for a review of their favorite changes and new tools implemented with the 21.05 CU*BASE release.  They will discuss new dashboards, feature enhancements and database changes from this release.  Hear firsthand how certain features can be integrated into your operations and help to… Read more »

May 24, 2021

Join the Asterisk Intelligence Team for a Release Review!

Join the Asterisk Intelligence Team for a Release Review!

Asterisk Intelligence Release Review: Data Strategies Join the CU*Answers Asterisk Intelligence Team for a review of their favorite changes and new tools implemented with the 21.05 CU*BASE release.  They will discuss new dashboards, feature enhancements and database changes from this release.  Hear firsthand how certain features can be integrated into your operations and help to… Read more »

May 19, 2021

Don’t Miss This Week’s Proving Data Strategies: Where Your Members… Shop/Borrow/Pay Bills

Don’t Miss This Week’s Proving Data Strategies: Where Your Members… Shop/Borrow/Pay Bills

Join the Asterisk Intelligence team as they review the set of “Where Your Members….” Dashboards within CU*BASE GOLD.  Your data is an asset and it’s simple to gain quick value from it – follow along with several fast and simple data reviews that bring light to exactly where members are doing their financial business outside… Read more »

May 17, 2021