Table of Contents Table of Contents Title and Copyright Information 1 Get Help 1.1 Get Help in the Applications 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 Staging Transaction Summary Data 5.4.1 Asset Transaction Summary 5.4.2 Liabilities Transaction Summary 5.4.3 Fee Based Services Transaction Summary 5.4.4 Off Balance Sheet Transaction Summary 5.5 Processing Instrument Data 5.5.1 Assets 5.5.2 Liabilities 5.5.3 Derivative Contracts 5.5.4 Fee Based Services 5.5.5 Loan Commitments 5.5.6 Off Balance Sheet Items 5.5.7 Ledger - Instruments 5.6 Processing Instrument Supplementary Data 5.6.1 Account Index History 5.6.2 Account Rate Tiers 5.6.3 Embedded Options Schedule 5.6.4 Payment Schedule 5.7 Processing Ledger Data 5.7.1 Management Ledger 5.7.2 Management Ledger01 5.7.3 Management Ledger02 5.7.4 Management Ledger03 5.7.5 Management Ledger04 5.7.6 Management Ledger05 5.8 Processing Transaction Summary Data 5.8.1 Asset Transaction Summary 5.8.2 Liabilities Transaction Summary 5.8.3 Fee Based Services Transaction Summary 5.8.4 Off Balance Sheet Transaction Summary 6 Cash Flow Report 6.1 Overview of Cash Flow Report 6.2 Viewing Cash Flow Report 6.3 Downloading the Report 7 Data Insights 7.1 Cash Flow Edits 7.1.1 Common Filters 7.1.1.1 “Rules” Canvas Prompt Filters 7.1.1.2 “Process Stats” Canvas Prompt Filters 7.1.1.3 “Message Log” Canvas Prompt Filters 7.1.2 Report Data Action 7.1.3 Rules 7.1.4 Process Stats 7.1.5 Message Log 8 Processed Data Insights 8.1 Cash Flow Output 8.1.1 Common filters 8.1.2 Report Hierarchies 8.1.3 In canvas Variable Prompts 8.1.4 Report Data Action 8.1.5 Process Stats 8.1.6 Runoff by KPDs 8.1.7 Balances by KPDs 8.1.8 Rates by KPDs 8.1.9 Process Results Details