Table of Contents Table of Contents Title and Copyright Information 1 Get Help 1.1 Get Help in the Applications 1.1.1 Additional Resources 1.2 Learn About Accessibility 1.3 Get Support 1.4 Get Training 1.5 Join Our Community 1.6 Share Your Feedback 1.7 Before You Begin 2 Introduction 3 Access Business Intelligence (BI) Reports 4 Preparing Data using SQL Query Browser 5 Raw Data Analysis 5.1 Staging Instrument Data 5.1.1 Assets 5.1.2 Liabilities 5.1.3 Derivative Contracts 5.1.4 Fee Based Services 5.1.5 Loan Commitments 5.1.6 Off Balance Sheet Items 5.1.7 Ledger - Instruments 5.2 Staging Instrument Supplementary Data 5.2.1 Account Index History 5.2.2 Account Rate Tiers 5.2.3 Embedded Options Schedule 5.2.4 Payment Schedule 5.3 Staging Ledger Data 5.3.1 Management Ledger 5.3.2 Management Ledger01 5.3.3 Management Ledger02 5.3.4 Management Ledger03 5.3.5 Management Ledger04 5.3.6 Management Ledger05 5.4 Processing Instrument Data 5.4.1 Assets 5.4.2 Liabilities 5.4.3 Derivative Contracts 5.4.4 Fee Based Services 5.4.5 Loan Commitments 5.4.6 Off Balance Sheet Items 5.4.7 Ledger - Instruments 5.5 Processing Instrument Supplementary Data 5.5.1 Account Index History 5.5.2 Account Rate Tiers 5.5.3 Embedded Options Schedule 5.5.4 Payment Schedule 5.6 Processing Ledger Data 5.6.1 Management Ledger 5.6.2 Management Ledger01 5.6.3 Management Ledger02 5.6.4 Management Ledger03 5.6.5 Management Ledger04 5.6.6 Management Ledger05 6 Data Insights 6.1 Pre-Process Data Analysis 6.1.1 Common Filters 6.1.2 Report Data Action 6.1.3 Number Accounts Outliers 6.1.3.1 Use Case Flow for “Number Accounts Outliers” Analysis 6.1.4 Cur Par Bal Outliers 6.1.4.1 Use Case flow for “Cur Par Bal Outliers” Analysis 6.1.5 Trends 6.1.6 Detail Acct Level Info 6.2 Cash Flow Edits 6.2.1 Common Filters 6.2.1.1 “Rules” Canvas Prompt Filters 6.2.1.2 “Process Stats” Canvas Prompt Filters 6.2.1.3 “Message Log” Canvas Prompt Filters 6.2.2 Report Data Action 6.2.3 Rules 6.2.4 Process Stats 6.2.5 Message Log 7 Processed Data Insights 7.1 Process Results Data Analysis 7.1.1 Common Filters 7.1.2 Report Hierarchies 7.1.3 Report Data Action 7.1.4 Transfer Rate Outliers 7.1.5 Rate & Charge Credit 7.1.6 Rate Bands 7.1.7 FTP Margin 7.1.8 Regional FTP Margin Rate 7.1.9 Regional FTP Margin Amount 7.1.10 Detailed Acct Level Info 7.1.11 STD Deviation