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 Data Insights 6.1 Cash Flow Edits 6.1.1 Common Filters 6.1.1.1 “Rules” Canvas Prompt Filters 6.1.1.2 “Process Stats” Canvas Prompt Filters 6.1.1.3 “Message Log” Canvas Prompt Filters 6.1.2 Report Data Action 6.1.3 Rules 6.1.4 Process Stats 6.1.5 Message Log 7 Processed Data Insights 7.1 Interest Rate Risk 7.1.1 Common Filters 7.1.2 Report Hierarchies 7.1.3 In canvas Variable Prompts 7.1.4 Interest Rate Risk Gap 7.1.5 Interest Rate Risk Runoff 7.1.6 Interest Rate Risk Rates & Term 7.2 Liquidity Rate Risk 7.2.1 Common filters 7.2.2 Report Hierarchies 7.2.3 In canvas Variable Prompts 7.2.4 Liquidity Rate Risk Gap 7.2.5 Liquidity Rate Risk Runoff 7.2.6 Liquidity Rate Risk Rates & Term 7.3 Financial Results 7.3.1 Common filters 7.3.2 Report Hierarchies 7.3.3 In canvas Variable Prompts 7.3.4 Financial Risk Runoff 7.3.5 Financial Risk Rates & Term