insight user guide v5.1.0 - oracle cloud · oracle insurance insight user guide oracle insurance...
TRANSCRIPT
Oracle Insurance Insight User Guide Version 5.1.0 February 2009
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 2
Oracle® Insurance Insight
User Guide
Version 5.1.0
E14944-01
February 2009
Copyright © 2009, Oracle. All rights reserved.
The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.
The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.
Oracle, JD Edwards, and PeopleSoft are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
THIRD PARTY SOFTWARE NOTICES This product includes software developed by the Apache Software Foundation (http://www.apache.org/).
THIS SOFTWARE IS PROVIDED "AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
The Apache Software License, Version 2.0 Copyright (c) 2004 The Apache Software Foundation. All rights reserved.
The Apache Software License, Version 1.1 Copyright (c) 1999-2003 The Apache Software Foundation. All rights reserved.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 3
---------
This product includes software developed by Advanced Software Engineering (http://www.advsofteng.com)
Advanced Software Engineering – Chart Director
* This software is based in part on the work of the Independent JPEG Group
* This software is based in part of the work of the FreeType Team
Copyright © 2004 Advanced Software Engineering Limited
---------
This product includes software developed by Sitraka Inc.
Sitraka is owned by Quest Software (http://www.quest.com/).
Copyright © 2000, 2001 by Sitraka Inc. All Rights Reserved.
Sitraka, the Sitraka logo, JClass, JClass Chart, JClass Chart 3D,JClass DataSource,
JClass Elements, JClass Field, JClass HiGrid, JClass JarMaster, JClass LiveTable,
JClass PageLayout, and JClass SwingSuite are trademarks of Sitraka Inc.
Parts of JClass code use material Copyright 1998, James R. Weeks and BioElectroMech as part of the work done by the Independent JPEG group. Use of this software for JPEG encoding is covered by this license: The JpegEncoder and its associated classes are Copyright (c) 1998, James R. Weeks and BioElectroMech.
THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
---------
This product includes software developed by Tanuki Software (http://wrapper.tanukisoftware.org/)
Tanuki Software – Java Service Wrapper
All SET components were released under the following license, which must be included verbatim in the documentation of any Oracle application incorporating the Tanuki software:
Copyright (c) 2001 Silver Egg Technology
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sub-license, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE ANDNON-INFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
---------
This product includes software developed by John Resig (http://jquery.com/)
jQuery - Copyright (c) 2008 John Resig
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 4
use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
---------
This product includes JSON software (http://json.org/)
JSON-lib 2.0
Copyright (c) 2002 JSON.org
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 5
Table of Contents
TABLE OF FIGURES...................................................................................................................... 7
0BABOUT THIS GUIDE .................................................................................................................... 11 Welcome to the Insight User Guide...................................................................................... 11 37BCustomer Support ................................................................................................................ 12 38BManual History...................................................................................................................... 12
1BCHAPTER 1 .................................................................................................................................. 13 2BSYSTEM INFORMATION................................................................................................................ 13 SYSTEM REQUIREMENTS ............................................................................................................ 13 26BSYSTEM FEATURES .................................................................................................................... 14
39BBasic Safety Precautions...................................................................................................... 14 40BInactivity / Timeout................................................................................................................ 14 41BNavigating Insight ................................................................................................................. 14 42BClearing Temporary Files ..................................................................................................... 15 43BTroubleshooting.................................................................................................................... 16
3BCHAPTER 2 .................................................................................................................................. 17 4BINTRODUCTION TO INSIGHT ..................................................................................................... 17
5BCHAPTER 3 .................................................................................................................................. 21 6BLOGIN AND LOGOUT OF INSIGHT ............................................................................................ 21
44BLogin Help............................................................................................................................. 22 45BChanging Your Password..................................................................................................... 23
27BLOGGING OUT OF INSIGHT .......................................................................................................... 23
7BCHAPTER 4 .................................................................................................................................. 25 8BDASHBOARD ............................................................................................................................... 25
46BDashboard Icons .................................................................................................................. 26 47BDashboard Tabs ................................................................................................................... 27 48BAlerts..................................................................................................................................... 27 49BReports ................................................................................................................................. 28 50BMy Analysis........................................................................................................................... 28 51BMonitor Summaries .............................................................................................................. 29
9BCHAPTER 5 .................................................................................................................................. 31 10BREPORTS ..................................................................................................................................... 31
52BReports Navigation ............................................................................................................... 32 53BReports Screen..................................................................................................................... 34
11BCHAPTER 6 .................................................................................................................................. 39 12BANALYTICS .................................................................................................................................. 39
28BDEVELOPING ANALYSES.............................................................................................................. 40 29BCATEGORIES OF DATAMARTS...................................................................................................... 41
58BSetup .................................................................................................................................... 46 59BFilters .................................................................................................................................... 46 60BMetrics .................................................................................................................................. 54 61BView...................................................................................................................................... 57
30BRUNNING THE ANALYSIS ............................................................................................................. 63
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 6
62BPreviewing an Analysis......................................................................................................... 63 63BRunning the Analysis in the Background.............................................................................. 63
EXCEEDING THE ROW COUNT LIMIT FOR AN ANALYSIS ................................................................. 65 Running a Query .................................................................................................................. 66
GENERATING A REPORT.............................................................................................................. 66 ANALYSIS OUTPUT...................................................................................................................... 70
SQL Analysis ........................................................................................................................ 81 SQL Analysis ........................................................................................................................ 81
31BOUTPUT SELECTIONS ................................................................................................................. 84 65BOpening an Analysis............................................................................................................. 84 Saving an Analysis ............................................................................................................... 86 Report ................................................................................................................................... 87 Export to Microsoft Excel...................................................................................................... 88 69BE-Mail.................................................................................................................................... 93
32BWARNING MESSAGES ................................................................................................................. 95
14BCHAPTER 7 .................................................................................................................................. 97 14BMONITORS ................................................................................................................................... 97
33BMONITOR BASICS ....................................................................................................................... 98 34BFILTERS ..................................................................................................................................... 99
70BLoss Monitor ....................................................................................................................... 100 71BRetention Monitor ............................................................................................................... 119 72BProfile Monitor .................................................................................................................... 131 73BClaims Monitor.................................................................................................................... 147
35BOUTPUT SELECTIONS ............................................................................................................... 163 36BWARNING MESSAGES ............................................................................................................... 171
15BAPPENDIX A............................................................................................................................... 173 16BAVAILABLE REPORTS.............................................................................................................. 173
17BAPPENDIX B............................................................................................................................... 183 18BFILTERS...................................................................................................................................... 183
19BAPPENDIX C............................................................................................................................... 203 20BMETRICS..................................................................................................................................... 203
21BAPPENDIX D............................................................................................................................... 215 22BFAILURE TO DISPLAY POPUPS .............................................................................................. 215
23BGLOSSARY................................................................................................................................. 221
24BINDEX.......................................................................................................................................... 229
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 7
Table of Figures
FIGURE 1: INSIGHT TOP BAR MENU .................................................................................................. 14
FIGURE 2: BROWSER TOOLBAR ....................................................................................................... 15
FIGURE 3: DELETE FILES ................................................................................................................. 15
FIGURE 4: TEMP FILE WARNING MESSAGE ....................................................................................... 16
FIGURE 5: LOGIN SCREEN................................................................................................................ 21
FIGURE 6: LOGIN HELP PAGE .......................................................................................................... 22
FIGURE 7: CHANGE PASSWORD MENU OPTION ON THE DROP DOWN LIST ......................................... 23
FIGURE 8: LOGOUT .......................................................................................................................... 23
FIGURE 9: DASHBOARD CONTAINS TAB SEPARATED AREAS ............................................................. 25
FIGURE 10: DASHBOARD ICONS ....................................................................................................... 26
FIGURE 11: SELECT ALL OPTION ..................................................................................................... 26
FIGURE 12: POPULATED DASHBOARD .............................................................................................. 30
FIGURE 13: REPORTS HOME PAGE................................................................................................... 31
FIGURE 14: SUBSCRIBED REPORTS.................................................................................................. 34
FIGURE 15: VIEWING A REPORT ....................................................................................................... 35
FIGURE 16: REPORT DOCUMENT ...................................................................................................... 36
FIGURE 17: ARCHIVED REPORTS...................................................................................................... 37
FIGURE 18: ANALYTICS NEW SCREEN .............................................................................................. 40
FIGURE 19: ANALYTICS TOP BAR MENU ........................................................................................... 42
FIGURE 20: EXPANDING THE VIEW.................................................................................................... 43
FIGURE 21: SCREEN DEFINITIONS - GRAPH....................................................................................... 44
FIGURE 22: SCREEN DEFINITIONS – DRILL DOWN ............................................................................. 45
FIGURE 23: SETUP AREA OF ANALYTICS - FILTERS ........................................................................... 46
FIGURE 24: ANALYTICS FILTER SETUP PAGE.................................................................................... 48
FIGURE 25: FILTERS SELECTIONS .................................................................................................... 48
FIGURE 26: WHEN FILTER OPTIONS ................................................................................................. 50
FIGURE 27: WHEN CURRENT OPTIONS ............................................................................................. 52
FIGURE 28: WHEN RANGE OPTIONS ................................................................................................. 53
FIGURE 29: WHEN CUSTOM OPTIONS ............................................................................................... 54
FIGURE 30: SETUP AREA OF ANALYTICS - METRICS.......................................................................... 55
FIGURE 31: METRICS SELECTIONS.................................................................................................... 56
FIGURE 32: ANALYTICS METRIC SETUP PAGE................................................................................... 57
FIGURE 33: SETUP AREA OF ANALYTICS - VIEW................................................................................ 58
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 8
FIGURE 34: VIEW SELECTIONS ......................................................................................................... 59
FIGURE 35: ANALYTICS METRIC SETUP PAGE................................................................................... 60
FIGURE 36: ANALYTICS VIEW SETUP PAGE ...................................................................................... 61
FIGURE 37: TITLE ENTRY FROM VIEW ............................................................................................... 61
FIGURE 38: ANALYTICS ANALYSIS SUMMARY ICON DESCRIPTIONS .................................................... 62
FIGURE 39: MONITOR ANALYSIS ...................................................................................................... 63
FIGURE 40: BACKGROUND QUERIES ................................................................................................ 64
FIGURE 41: EDIT MAXCLIENTROWCOUNT PARAMETER IN THAZARGLOBAL_EN_US.PROPERTIES FILE ............................................................................................................................. 65
FIGURE 42: WARNING MESSAGE GENERATED BY A QUERY .............................................................. 66
FIGURE 43: PDF REPORT GENERATED BY ANALYTICS=>REPORTS ................................................... 66
FIGURE 44: “SHOWN” DIMENSIONS IN THE ANALYSIS SUMMARY VIEW............................................... 67
FIGURE 45: SELECT FILTERS FROM THE DRILL HIERARCHY ............................................................... 68
FIGURE 46: HIDE FILTERS ................................................................................................................ 68
FIGURE 47: HIDDEN FILTERS IN THE ANALYSIS SUMMARY VIEW ........................................................ 69
FIGURE 48: ONE LEVEL OF DRILL DOWN .......................................................................................... 70
FIGURE 49: DATA AREA VIEW .......................................................................................................... 71
FIGURE 50: POLICY COUNT LISTINGS IN EXCEL ................................................................................ 72
FIGURE 51: ADDITIVE AND SEMI-ADDITIVE METRICS ......................................................................... 73
FIGURE 52: RESULTS FOR THE ADDITIVE AND SEMI-ADDITIVE METRICS ............................................. 73
FIGURE 53: SQL STATEMENT FOR A SEMI-ADDITIVE DISTINCT INFORCE POLICY COUNT METRIC........ 74
FIGURE 54: SQL STATEMENT FOR A SEMI-ADDITIVE SNAPSHOT INFORCE POLICY COUNT METRIC ..... 75
FIGURE 55: SELECT CURRENT QUARTER FOR SEMI-ADDITIVE DISTINCT INFORCE POLICY COUNT....... 75
FIGURE 56: SEMI-ADDITIVE SNAPSHOT INFORCE POLICY CANNOT BE VIEWED QUARTERLY................ 76
FIGURE 57: SQL VIEW..................................................................................................................... 81
FIGURE 58: INCREMENTAL LOSS TRIANGLE AND DEVELOPMENT FACTORS ........................................ 82
FIGURE 59: RETRIEVE AN ANALYSIS................................................................................................. 84
FIGURE 60: DELETE A SAVED ANALYSIS........................................................................................... 85
FIGURE 61: SAVING AN ANALYSIS .................................................................................................... 86
FIGURE 62: CONFIRMATION OF SAVING ............................................................................................ 86
FIGURE 63: PDF REPORT ................................................................................................................ 87
FIGURE 64: EXPORT TO EXCEL ........................................................................................................ 88
FIGURE 65: DASHBOARD WIZARD FOR SAVING PAGES ..................................................................... 89
FIGURE 66: ANALYTICS ALERT WIZARD............................................................................................ 91
FIGURE 67: E-MAIL – TO SEND AN E-MAIL: ....................................................................................... 93
FIGURE 68: WARNING MESSAGE ...................................................................................................... 95
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 9
FIGURE 69: EXAMPLES OF FILTER CATEGORIES AND FILTERS ........................................................... 99
FIGURE 70: LOSS MONITOR MAIN SCREEN ..................................................................................... 100
FIGURE 71: LOSS MONITOR ANALYSIS SETUP ................................................................................ 101
FIGURE 72: LOSS MONITOR SIDE BAR MENU.................................................................................. 102
FIGURE 73: LOSS RATIO AGING PAGE............................................................................................ 103
FIGURE 74: LOSS RATIO RELATIVITY PAGE .................................................................................... 105
FIGURE 75: EXAMPLE OF CALENDAR/ACCIDENT CASE INCURRED LOSS RATIO ................................ 106
FIGURE 76: EXAMPLE OF LOSS RATIO RELATIVITY.......................................................................... 106
FIGURE 77: FREQUENCY AGING PAGE............................................................................................ 107
FIGURE 78: FREQUENCY RELATIVITY PAGE .................................................................................... 109
FIGURE 79: EXAMPLE OF LOSS FREQUENCY PER CAR YEAR........................................................... 110
FIGURE 80: EXAMPLE OF FREQUENCY RELATIVITY.......................................................................... 110
FIGURE 81: SEVERITY AGING PAGE................................................................................................ 111
FIGURE 82: SEVERITY RELATIVITY PAGE ........................................................................................ 113
FIGURE 83: EXAMPLE OF ACCIDENT YEAR LOSS SEVERITY ............................................................. 114
FIGURE 84: EXAMPLE OF SEVERITY RELATIVITY ............................................................................. 114
FIGURE 85: SUMMARY SUBMITTAL PAGE........................................................................................ 115
FIGURE 86: LOSS MONITOR SUMMARY BY BRANCH OFFICE – LOSS RATIO TAB............................... 116
FIGURE 87: LOSS MONITOR SUMMARY BY BRANCH OFFICE – FREQUENCY TAB ............................... 117
FIGURE 88: LOSS MONITOR SUMMARY BY BRANCH OFFICE – SEVERITY TAB................................... 118
FIGURE 89: RETENTION MONITOR ANALYSIS SETUP SCREEN .......................................................... 119
FIGURE 90: RETENTION MONITOR SIDE MENU ................................................................................ 120
FIGURE 91: SCRAP RATE FIRST 3 MONTHS .................................................................................... 121
FIGURE 92: NEW BUSINESS RETENTION PAGE 12 MONTHS ............................................................. 123
FIGURE 93: RETENTION TREND 48 MONTHS ................................................................................... 125
FIGURE 94: TENURED RETENTION OVER 48 MONTHS...................................................................... 127
FIGURE 95: RETENTION MONITOR ANALYSIS ................................................................................ 129
FIGURE 96: RETENTION MONITOR SUMMARY BY BRANCH ............................................................... 130
FIGURE 97: PROFILE MONITOR MAIN SCREEN ................................................................................ 131
FIGURE 98: PROFILE MONITOR ANALYSIS SETUP ........................................................................... 132
FIGURE 99: PROFILE TEMPLATE PAGE .......................................................................................... 133
FIGURE 100: NEW ENTRIES TO PROFILE TEMPLATE ....................................................................... 134
FIGURE 101: RESCORED PROFILE TEMPLATE ................................................................................ 135
FIGURE 102: PROFILE MONITOR SIDE MENU................................................................................... 137
FIGURE 103: VARIATION FROM PROFILE........................................................................................ 138
FIGURE 104: ADVERSE SELECTION ............................................................................................... 140
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 10
FIGURE 105: ATTRIBUTE OVERVIEW .............................................................................................. 142
FIGURE 106: SUMMARY PAGE........................................................................................................ 144
FIGURE 107: PROFILE MONITOR SUMMARY BY UNDERWRITING COMPANY ....................................... 145
FIGURE 108: CLAIMS MONITOR ANALYSIS PAGE ............................................................................ 147
FIGURE 109: BAND PARAMETER SETUP ......................................................................................... 148
FIGURE 110: BAND LOCATION CHART ............................................................................................ 149
FIGURE 111: CLAIMS MONITOR SIDE MENU .................................................................................... 150
FIGURE 112: LOSS RESERVE ACCURACY – BY DOLLAR.................................................................. 151
FIGURE 113: LOSS RESERVE ACCURACY – BY CLAIMS................................................................... 153
FIGURE 114: POLICY DETAIL FOR LOSS RESERVE ACCURACY ........................................................ 155
FIGURE 115: INFLATION RATE PAGE .............................................................................................. 156
FIGURE 116: CLAIM EXPENSE PAGE .............................................................................................. 157
FIGURE 117: SALVAGE & SUBROGATION PAGE .............................................................................. 159
FIGURE 118: TIME LAG MEASUREMENTS ........................................................................................ 161
FIGURE 119: SAVING AN ANALYSIS ................................................................................................ 163
FIGURE 120: NAMING A SAVED ANALYSIS ...................................................................................... 163
FIGURE 121: RETRIEVE SAVED ANALYSIS ...................................................................................... 164
FIGURE 122: DASHBOARD WIZARD FOR SAVING PAGES ................................................................. 165
FIGURE 123: ADDING SCORING TO THE DASHBOARD ...................................................................... 166
FIGURE 124: ALERT WIZARD ......................................................................................................... 168
FIGURE 125: ALERT E-MAIL SCREEN .............................................................................................. 169
FIGURE 126: AN ANALYSIS IN AN EXCEL SPREADSHEET ................................................................ 170
FIGURE 127: NO DATA WARNING MESSAGE ................................................................................... 171
FIGURE 128: RESCORE WARNING MESSAGE .................................................................................. 171
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 11
0BAbout This Guide
Welcome to the Insight User Guide
This guide provides detailed instructions for using Insight V5.1.0 to access information. Using the step-by-step instructions and examples pictured for each task, the User Guide will demonstrate the capability to generate, view, distribute, store, and retrieve reports electronically.
Terms, fields, and formulas introduced throughout the guide, and often indicated by italicized text, are defined in the Glossary located at the back of the manual. Detailed descriptions of reports available in Reports are provided in Appendix A. A summary of the filters found in Analytics and the Monitors is located in Appendix B. Metric descriptions can be found in Appendix C.
How this Manual is Organized
Chapter 1: System Information Describes the Insight system requirements.
Chapter 2: Introduction to Insight Provides an overview of the architecture and components of the Insight system.
Chapter 3: Login and Logout of Insight Describes how to login and logout of Insight.
Chapter 4: Dashboard Provides an overview of the Insight Dashboard interface.
Chapter 5: Reports Describes the Reports screen interface.
Chapter 6: Analytics Describes how to use the Analytics screen to create an analysis.
Chapter 7: Monitors Describes how to use the Monitors screen to perform analyses of key business data.
Appendix A: Available Reports Proves an overview of the Insight reports.
Appendix B: Filters Provides a listing of the standard filters available in Insight.
Appendix C: Metrics
Provides a description of the metrics available in Insight.
Appendix D: Failure to Display Popups Describes how to override popup blockers which may inadvertently prevent important information screens from displaying with Insight.
Glossary Provides a glossary on Insight terms.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 12
37B
Manual History
New editions incorporate any updates issued since the previous edition.
Publication Number Product Version
Updated
P01-500-09 Version 5.1.0 February 2009
P01-500-08 Version 5.0.8.2 July 2008
P01-500-07 Version 5.0.8 February 2008
P01-500-06 Version 5.0.7 January 2008
P01-500-05 Version 5.0.6.2 June 2007
P01-500-04 Version 5.0 July 2006
P01-500-03 Version 4.5 November 2005
P01-500-02 Version 4.0 July 2004
P01-500-01 Version 3.5 August 2001
Customer Support
If you need assistance with Oracle Insurance Insight, please log a Service Request using My Oracle Support at http://metalink.oracle.com.
Address any additional inquiries to:
Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. Worldwide Inquiries: Phone: +1.650.506.7000 Fax: +1.650.506.7200 oracle.com
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 13
1BChapter 1
2BSystem Information 25B
System Requirements Oracle recommends the following as the minimum requirements for Insight.
Operating Environment:
• Windows 2003
Database Platform:
• Microsoft SQL Server 2005 Service Pack 2, Enterprise Edition
* Insight requires this version to enable specific features such as: Table Storage Partitions and VarDecimal Storage Format
Application Server Environment:
• IBM WebSphere Application Server Version 5.1, V6.0
* Contact Oracle for other J2EE environments
NOTE Netscape® and Mac® OS browsers are unable to fully support Insight.
End-user Workstation Requirements:
• P3 500 MHz processor or faster
• 512 MB of RAM or greater
• 20 MB of free disk space
• Microsoft Windows 2000 or XP
• Microsoft Internet Explorer Version 6.0 and later
• Adobe Acrobat Reader 5.0 and later
NOTE If you have a popup blocker installed, you will need to disable it for Insight to work properly.
For help on disabling popup blocker, see 467HAppendix D.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 14
26BSystem Features
The following are shared features found throughout Insight and apply to all logins.
39BBasic Safety Precautions Secure your computer when you leave your workspace. This prevents any unintentional changes to the analysis in progress and protects the integrity of your work.
40BInactivity / Timeout Insight is a web-based application and will log you out of the system without saving your work if left inactive for a certain length of time. Your system administrator establishes the specified number of minutes. The default setting is 20 minutes. If timeout does occur, log back onto the system and continue to work.
41BNavigating Insight Navigate through Insight by clicking on the top and side menus. Do not use the browser buttons: BACK, STOP, REFRESH or HOME. Using the browser to navigate the application may cause information to be lost.
Figure 1: Insight Top Bar Menu
The top bar menu will be available in the Analytics, Monitors and Reports applications. Popup windows may not have a top bar menu or may be different depending upon which application launched the pop up. Top bar menus will be explained in the applications where they occur.
Top bar menu options are:
• Dashboard – This option contains your selected alerts, reports and analyses. It acts as a home page for Insight.
• Analytics – This option will take you to Analytics, an ad-hoc query tool that lets you query, analyze and drill-up/drill-down on specific data elements.
• Monitors – Monitors are a set of applications that will guide you through specific, pre-defined insurance analyses. You must select a Monitor from the drop down menu: Loss, Profile, Retention or Claims.
• Reports – This option will take you to a list of 50 standard reports for Claims, Underwriting, Sales/Marketing, and Executive.
• My Settings – This option lets you manage your password.
• Help – This option will take you to the Insight help system.
• Logout – This option will log you out of the system.
Side menus will vary according to the screen you are in. Some applications will not have a side menu. Side menus will be explained in the applications where they occur.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 15
75BNavigation Notes
Prior to visiting another web site, make sure you save any analyses that you want. If you leave the Insight screen for an extended period of time, you may have to log back in when you return.
If the browser window closes unexpectedly, any unsaved application analyses will be lost. It will be necessary to open a new window and log on again to regain access to the application.
42BClearing Temporary Files
Because Insight is a web-based application, you may need to clear out your browser’s temporary file periodically.
Keeping the temporary file clear may improve performance by clearing off space from your hard drive.
76BClearing the Temp File
Open up a regular browser window. On the top menu bar, click Tools Internet Options.
Figure 2: Browser Toolbar
A popup box will be displayed. The General Tab will be the top Option displayed. Click the Delete Files button on the General Tab Temporary Internet Files – located in the middle section.
Figure 3: Delete Files
To view your temp files or to define your temp file settings, click the Settings button. This will open up an information screen where you can make any adjustments.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 16
A warning message will appear.
Figure 4: Temp File Warning Message
You can select to delete all offline content in addition to the temp files. This will remove any pages that may be stored. Stored pages specify that when you return to a page you viewed previously, the browser should not check to see whether the page has changed since you last viewed it.
Selecting this option can provide the most speed when browsing through pages you have already viewed.
Removing stored pages will force the browser to get the page. This may result in slower page loading. However, deleting older pages will help to make sure that you are viewing the most current version of a page.
To clear the temp file:
• Check if you want to Delete all offline content.
• Click OK to clear the temp file.
• Depending upon the amount of files that need to be deleted, this may take a few minutes. When the temp files have been removed, you will be returned to the previous page.
• Click OK to close the Internet Options box and continue working.
If you do not want to clear your temp file, click Cancel to return to the previous screen.
43BTroubleshooting If you experience any trouble with Insight please contact your system administrator.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 17
3BChapter 2
4BIntroduction to Insight
Insight is a comprehensive business intelligence system created exclusively for the Property and Casualty (P&C) insurance industry. The Insight Business Intelligence System:
• Consolidates data from multiple, disparate source systems to provide a strategic enterprise-wide view across operating units.
• Provides an underlying data model constructed specifically for the P&C insurance industry.
• Delivers information management, reporting and advanced analytics to end-users through an easy-to-use Web application.
• Automates many manual processes “on the fly”, such as Loss Triangles and Incurred Loss Ratios.
• Accommodates all P&C lines of business and all states/provinces in the U.S. and Canada.
Insight is a complete, end-to-end business intelligence system comprised of two main components, Insight Information Management Suite (Data Layer) and Insight Applications Suite (Application Layer) with Insight Implementation & Support Services involved from system implementation to user adoption.
Insight Information Management Suite (Data Layer) The Insight Information Management Suite is the underlying data layer that provides all components necessary to extract, transform, load and manage data. The Information Management Suite includes the ETL Templates, the Data Warehouse and Insure Mart data models, a comprehensive set of data loading and balancing procedures and a Meta Data repository for the Insight applications.
Insight Applications Suite (Application Layer) The Insight Applications Suite is a complete set of Web-based analytical and reporting applications that enable users to generate, view, distribute, electronically store and retrieve critical reports. The applications offer an easy-to-follow, point-and-click interface using built-in insurance metrics, common industry terms, quantitative measurements and industry-standard naming conventions. The Insight Applications Suite is comprised of four main components:
• Dashboard
• Analytics
• Monitors
• Reports
Functionality Overview
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 18
Dashboard
The Dashboard serves as a personalized homepage for users to save reports and analyses for quick access. As data is refreshed in the datamarts, items saved to a user’s Dashboard are automatically updated with the most recent data. From the Dashboard users can navigate to any Application to which security access has been granted.
Features Include:
• Organize Dashboard in specific sections, such as Reports, Alerts, My Analysis and Background Results.
• Subscribe to Reports to display the most current data on your Dashboard.
• Save Alerts with specific parameters (ex: Paid Losses > $10,000) that once reached will notify a user by changing the color of display.
• Monitor a specific measurement (ex: Inforce Premium) that is updated every Day or every Month.
Analytics
Analytics is an intuitive ad hoc query tool that enables users to query, analyze and drill-up/drill-down on specific data elements in a graphical or data chart view. Each Analytics datamart is presented to the user as a category. Some categories, such as Corporate Experience Summary, Corporate Detail and Claim Detail, provide data across all supported lines of business. Other categories, such as Personal Auto Detail, provide data specific to that line of business.
Analytics supports both monthly and daily datamarts. Data in the monthly marts represents a snapshot as of the end of a specific month and can be viewed by month, by quarter or by year on an accident year, calendar year and policy year basis. Data in the daily marts represents a snapshot as of the end of a specific day and can be viewed by day, by week or by month on a calendar year basis.
When setting-up queries in Analytics, a user selects data from two areas:
• Metrics – Represent calculated values, including premiums, losses, exposures, ratios, averages and counts.
• Filters – Represent elements by which the metrics can be analyzed, such as by line of business, agency, program, adjuster, class code and postal code. Filters are organized in a Who, What, When, Where format to facilitate ease of navigation.
Users can define the specific drill paths of how they wish to view the results of a query.
For example, if you want to view premiums filtered by month, then by producer and then by territory, you can set-up this specific drill path. Data outputs also can be saved in a PDF format or exported to Microsoft Excel where the data can be further manipulated. All queries that you create can be saved to your Dashboard or shared with other users of Insight via e-mail.
Monitors
The Monitors are a set of applications that guide you through specific, pre-defined insurance analyses, such as Loss Frequency and Severity, Claims Reserve Accuracy and New Business Retention. Like Analytics, you can select from a list of filters to analyze premium and loss data by various elements. Filters are specific to each Monitor application and are organized in a who, what, when, where format to facilitate ease of navigation.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 19
The Monitors support monthly datamarts only where policy and claims data can be viewed by month, by quarter or by year on a calendar year basis. Many functions in Analytics also exist in the Monitors, including saving queries to the Dashboard, e-mailing saved queries and exporting data to Microsoft Excel.
Reports
The base Insight product includes more than 50 standard reports accessible through the Reports application. Each report includes a definition document explaining the report, including data elements, calculations and target audience.
Reports are generated on a monthly basis, and a copy of each monthly report is archived for future reference. Existing reports can be modified using Crystal Reports.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 20
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 21
5BChapter 3
6BLogin and Logout of Insight
The System Administrator will supply a User Name and Password to you.
To login to Insight, enter User Name and Password and click .
Figure 5: Login Screen
• A successful login opens onto the Insight Dashboard screen.
• A failed login will result in an error message on top of the login field.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 22
44BLogin Help
If you have forgotten your user name and password, an e-mail reminder can be sent to you from your system administrator.
Figure 6: Login Help Page
• Make this request by clicking on the help line located underneath the login area.
If you have forgotten your password, please click here for help.
• Enter in your e-mail address and click .
You also have the option to try again. Click on the highlighted here located underneath the e-mail request box, to be returned to the login screen.
NOTE If you experience any further difficulty logging in, please contact your system administrator.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 23
45BChanging Your Password
It is recommended that you change your Password periodically.
Figure 7: Change Password Menu Option on the Drop Down List
To change your password:
1. Click on My Settings.
2. Select Change Password from the drop down menu. You will be placed on the Change Password screen.
3. Enter in your new password.
4. Confirm your new password.
5. Click the Change Password button. Your password will be updated.
6. Click OK to return to the previous screen.
If this is not the screen you wanted, click Cancel to return to the previous screen.
27BLogging Out of Insight
When you are ready to logout, be sure to save any analysis you may want to run or view later. Analyses are not automatically saved upon exiting the system.
Figure 8: Logout
77BTo Logout
• Click from the top blue bar menu to be disconnected from the system.
• A successful logout will return you to the Insight login screen.
Once you have successfully logged out, you can navigate to another site or close the window.
NOTE If you experience any difficulty logging out, please contact your system administrator.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 24
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 25
7BChapter 4
8BDashboard
The Insight Dashboard provides a location to place selected alerts, subscribed reports and data analyses generated by Insight.
Most of the information that you choose to place on your Dashboard doesn’t need to be re-subscribed to every time data is updated. Subscribed Reports that have been added to the Dashboard will automatically be updated every time the data is refreshed. Data analyses will be updated as well. Alert parameters will be tested as new data is brought into Insight, either monthly or daily. Summaries, found on the Monitor Summaries tab, are not updated when data is refreshed.
Figure 9: Dashboard Contains Tab Separated Areas
The first time you login, the Dashboard will be empty. You can select the information that you want displayed on the Dashboard in the Reports, Analytics and Monitors applications. Your selections will appear on the Dashboard immediately after you save them, and will remain on the Dashboard until you choose to delete them. The Dashboard does not have to be populated; however, it is recommended.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 26
46BDashboard Icons
On the Dashboard, you will encounter several icons that are used for identifying contents on the Dashboard. The list below provides a quick view of what each icon means.
Figure 10: Dashboard Icons
78BSelect All Option
On the Dashboard, you will see a check box next to the title name.
Figure 11: Select All Option
This indicates that Select All is available on this screen. When you check the box in the menu field, it will automatically check every available check box in that field, effectively selecting all of them.
Use this option when you need to delete or add large numbers of entries.
Symbol Purpose
Active Alert A red alarm bell indicates an alert that has been activated on a particular analysis.
Alert An alarm bell indicates that an alert has been set for a particular analysis.
Report This icon indicates a report has been saved from the Reports application.
Monitor Summaries This icon indicates a summary report has been saved.
Delete Clicking this icon will delete any checked items on the page.
Expand Information This icon, found on the My Analysis tab, means the information has been condensed and is not on display. Clicking this icon will expand the information below. This icon will be located in front of an analysis.
Condense Information This icon, found on the My Analysis tab, means the information displayed has been expanded to show all. Clicking this icon will condense the information below. This icon will be located in front of an analysis.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 27
47BDashboard Tabs
The Dashboard contains four tabs:
• Alerts
• Reports
• My Analysis
• Monitor Summaries
48BAlerts
Alerts can help identify problem areas where adjustments may be needed to improve financial results. Setting an alert lets you know immediately when business falls outside of performance levels. Alerts will remain in set status until alert parameters have been reached.
79BActive Alerts
When alert parameters have been reached, an Alarm will be activated. The icon will change from yellow to red. When the Alarm has been activated, the Subject name will become a hyperlink. Clicking the Subject name will take you to the application and query that triggered the alert.
80BAdding an Alert
The Alerts tab is populated whenever an alert has been set up from within the Monitors application or the Analytics application. Alerts cannot be added from the Dashboard.
81BViewing an Alert
You will be able to view an Alert only when the Alert has been activated. When the Alarm has been activated, the Subject name will become a hyperlink. Clicking the Subject name will take you to the application and query that triggered the alert.
82BEditing an Alert
Alerts cannot be edited from the Dashboard. If you would like to change or edit an Alert, you must re-enter the Monitor or Analytics application, re-create the query with the changes you need and save this new Alert to your Dashboard.
83BDeleting an Alert
If an Alert is no longer required, it can be deleted. To remove an Alert from the Dashboard, first check the box in front of the Alarm icon on the far left side of the screen. Next, click the Delete icon found at the bottom of the tab.
A caution box will be displayed to verify that the selected Alarm should be removed. Click OK, to remove the Alarm from the Dashboard immediately. Click Cancel to be returned to the Dashboard without deleting the Alarm.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 28
49BReports
Reports provide a “snapshot” of premium and loss data as of the end of a particular month. The static data is organized between summary-level reports that provide top-level analyses across all lines of business and reports that provide analyses specific to separate lines of business. More detailed ad hoc analyses can be run in the Analytics application.
84BAdding a Report
The Reports tab is populated whenever you subscribe to a Report. Reports can be added from within the Reports application only.
85BViewing a Report
When the Report Title is clicked, the Report will be produced in a separate window using the same parameters as the initial Report request.
86BEditing a Report
Reports cannot be edited from the Dashboard. If you would like to change or edit a Report, you must re-enter the Reports application, re-create the Report with the changes you need and subscribe to this new Report in order for it to be displayed on your Dashboard.
87BDeleting a Report
If a Report is no longer required, it can be deleted. To remove a Report from the Dashboard, first check the box in front of the Report icon on the far left side of the screen. Next, click the Delete icon found at the bottom of the tab. Deleting a Report is the same thing as Unsubscribing from a Report.
A caution box will be displayed to verify that the selected Report should be removed. Click OK, to remove the Report from the Dashboard immediately. Click Cancel to be returned to the Dashboard without deleting the Report.
50BMy Analysis
Analyses can be performed in both the Analytics application and the Monitor application. These applications enable you to analyze specific areas of business in an ad hoc manner. By pointing and clicking through common industry terms and viewing quantitative measurements, you will be able to identify trends in business results that you may never have detected.
The metrics (currency, ratio) and filters (who, what, when, where) cannot be altered on the analysis displayed; however the information will reflect the latest data load in the warehouse.
88BAdding an Analysis
The My Analysis tab is populated whenever you click the button after running an analysis in the Analytics application. Or whenever you click the Add to Dashboard option found on the left side menu, in the Monitors application.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 29
89BViewing an Analysis
When the Analysis Title is clicked, the Analysis will be produced in a separate window, using the same parameters as the initial request.
You can view the information selected to appear on the Dashboard by clicking the expand information icon in front of the Analysis Title. When you are finished, you can collapse the information by clicking the condense information icon .
90BEditing an Analysis
An Analysis cannot be edited from the Dashboard. To change an Analysis, enter the Analytics application, re-create and run the modified Analysis, then subscribe to this new Analysis, in order for it to be displayed on your Dashboard. If the original Analysis was saved, you can open and edit the Analysis. Run and save the modified Analysis by either replacing the original or by giving it a new name, then add the new Analysis to your Dashboard.
91BDeleting an Analysis
If an Analysis is no longer required, it can be deleted. To remove an Analysis from the Dashboard, first check the box in front of the Analysis on the far left side of the tab. Next, click the Delete icon found at the bottom of the tab.
A caution box will be displayed to verify that the selected Analysis should be removed. Click OK, to remove the Analysis from the Dashboard immediately. Click Cancel to be returned to the Dashboard without deleting the Analysis.
51BMonitor Summaries
Loss, Retention and Profile Monitors allow you to run Summaries. Claims Monitor does not have a Summary option. These summary requests take some time and can run in the background of the application. This means that you can continue working in Insight without affecting the Summary running at the same time. Summaries allow you to create a page that displays scores for all attributes with weighting, View Adverse Selection, Change in Profile, and/or Variation. Summaries also display and score Observed Rating.
Summaries on the Monitor Summaries tab are not updated with each new data load. You can place multiple summaries on your Monitor Summaries tab, which would enable you to compare/contrast summaries from various time periods.
92BAdding a Summary
The Monitor Summaries tab is populated whenever you run a Summary from the Monitors application. Summaries can be added from within the Monitors application only.
93BViewing a Summary
When the Summary Name is clicked, the Summary will be produced in a separate window containing the information from the initial Summary request.
The navigation options on this page are:
Print this window – which will send the contents of the screen to your regular printer.
Close Window – which will close the window and return you to the Dashboard.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 30
94BEditing a Summary
A Summary cannot be edited from the Dashboard. If you would like to change or edit a Summary, you must re-enter the Monitors application, re-create the Summary with the changes you need and run this new Summary, in order for it to be displayed on your Dashboard.
95BDeleting a Summary
If a Summary is no longer required, it can be deleted. To remove a Summary from the Dashboard, first check the box in front of the Monitor Summaries icon on the left side of the tab, center screen. Next, click the Delete icon found at the bottom of the tab.
A caution box will be displayed to verify that the selected Summary should be removed. Click OK, to remove the Summary from the Dashboard immediately. Click Cancel to be returned to the Dashboard without deleting the Summary.
96BPopulated Dashboard
A populated Dashboard can contain as much or as little information as you need. You can expand or collapse areas, as you need. Scroll bars on each tab will allow you to view all the alerts, reports and summaries that you have chosen.
Figure 12: Populated Dashboard
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 31
9BChapter 5
10BReports
Insight includes more than 50 standard reports accessible through the Reports application. The wide range of reports provides meaningful data targeted to specific business groups and lines of business. Each report is published in PDF format. Many reports have a definition document explaining the report, including data elements, calculations and target audience. 230HAppendix A is a listing of the current reports. You also can subscribe or unsubscribe to any report and have it appear on your dashboard.
Figure 13: Reports Home Page
Reports are generated on a monthly basis and a copy of each monthly report can be archived for future reference allowing data and trends to be analyzed month by month, quarter by quarter, or year by year.
All listed Reports will be from the most current load. The last Load Date will be displayed in the upper left hand corner of the report screen.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 32
52BReports Navigation
The top of the Reports window contains the Load Date, on the far left side of the screen, along with options to help you select the report that best suits your needs. You can select filters, or search for specific words or phrases. You can also subscribe, unsubscribe or view a list of available reports.
As long as a filter is selected, that criteria will be included in any filtering or search results. To remove a filter select the “all” option.
Filtering Options
Filtering can eliminate the reports that do not meet your criteria. The three filter options are source, type and group.
Source
Source is defined as the person who initially requested the report. Some reports will be open to everyone and some reports will have limited viewer ship. To select a report by source, choose a source name from the drop down menu. Reports that match that filter will be displayed below.
Type
Report Types are defined by time, either monthly or yearly. To choose a specific type, select a type from the drop down list. Reports that match that filter will be displayed below.
Group
Groups are defined as individuals or executive. To choose a specific group, select the group from the drop down menu. Reports that match that filter will be displayed below.
Searching Search through a variety of standard reports to find the report that meets your specific analysis criteria. You can use keywords or phrases to hone in on the reports that will contain the information or data that you need.
Search
To search for a specific report, enter in your keyword or phrase and click the Search button. The results that match will be displayed below.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 33
97BSuggested Keywords to Search On
98B
Adjuster Number Effective Date New Business
ALAE Employee Paid Expense
Annual Retention Expense Reserve Paid Loss
Branch Expiration Date Policy Count
Cause of Loss Governing State Policy Number
Claim Number Line of Business Producer
Claim Report Date Loss Date Recovery Loss
Claim Status Loss Reserve Renewal Term
Claimant Number Named Insured Written Premium
Options You can print a complete list of available Reports, Subscribe to any Report and Unsubscribe from any Report using the options found on the top bar menu.
Print List
Clicking this icon will allow you to view a printable version of the Current Reports list on a separate screen. To print the list, scroll to the bottom of the new window and click the Print this window link. The list will print to your local printer.
Subscribe Subscribing to a Report will place this Report on your Dashboard in the Reports tab. Subscribed Reports are updated with each new data load.
Unsubscribe Unsubscribing a Report will remove this Report from the Reports tab on your Dashboard.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 34
Subscribing to a Report
1. To Subscribe to a Report, check the box at the end of the report row.
2. Click the Subscribe button. The Report will be placed on your Dashboard on the Reports tab.
If you are currently subscribed to a Report, there will be a check mark in the Dash column on the right side of the screen.
Figure 14: Subscribed Reports
99BUnsubscribing a Report
1. To Unsubscribe a Report, check the box at the end of the report row.
2. Click the Unsubscribe button. The Report will be removed from the Reports tab on your Dashboard.
Deleting a Report from the Reports tab on your Dashboard will Unsubscribe a Report as well. 53B
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 35
Reports Screen
The main body of the reports screen contains the entire list of current reports, various viewing options and description information.
The column headings are:
• ID – Report Identification Number. This number is for Oracle use.
• Src – Source is defined as the person who initially requested the report. Some reports will be open to everyone and some reports will have limited viewer ship.
• 231HReport Name – The name of the Report. Reports can be viewed, printed and saved. Reports cannot be edited in this format.
• 232H233HDoc – Many reports have Report Documentation that describes the reason for the report, who would benefit from it, report columns, keywords and other information. Report Documentation can be viewed, printed and saved.
• Type – Types are defined by time, either monthly or yearly.
• Group – Groups are defined as individuals or executive.
• 234HHist –Reports that have been stored for later reference are Archived Reports. The Archived Reports can be viewed, printed and saved. Archived Reports cannot be edited.
• Dash – A checkmark in this column indicates that this Report is listed on the Dashboard.
• – This checkmark box will be used when you want to subscribe or unsubscribe Reports.
100BReport Name – Viewing Reports
To view a report, click on the Report Name and the details of the report will be displayed on a separate screen.
Figure 15: Viewing a Report
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 36
101BReport Name – Saving and Printing Reports
Reports are in PDF format and can be saved to your local drive or network by clicking the Save a Copy button. Reports also can be printed to your local printer by clicking the Printer button.
Other menu options will be dependent on the version of Adobe Acrobat you have.
NOTE At minimum, you must have Adobe Acrobat Reader installed on your system to use this feature. Acrobat Reader is available from 235Hwww.adobe.com.
102BDoc – Viewing Report Documentation
Many reports have report documentation that describes the reason for the report, who would benefit from it, report columns, keywords and other information. To view the report document, click the doc link on the same line of the report you want to view. The report will be displayed on a separate screen in PDF format.
Figure 16: Report Document
103BDoc – Saving and Printing Report Documentation
Report Documentation is in PDF format and can be saved to your local drive or network by clicking the Save a Copy button. Report Documentation also can be printed to your local printer by clicking the Printer button.
Other menu options will be dependent on the version of Adobe Acrobat you have.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 37
NOTE At minimum, you must have Adobe Acrobat Reader installed on your system to use this feature. Acrobat Reader is available from 236Hwww.adobe.com.
104BHist – Viewing Archived Reports
Archived Reports contains previously run Reports that have been stored for later reference. To view archived reports, click the arc link located on the same line as the report you want to view. A separate screen will be displayed.
The report information - ID, Type and Group - will be listed at the top along with the Report Documentation link. Archived reports will be listed by Load Date. To view a specific report, click the Load Date of the report you want to view. The Report will be displayed in a separate window in PDF format.
Figure 17: Archived Reports
When you are finished viewing any Archived Reports, click the Back to Reports button to return to the Reports screen.
105BHist – Saving and Printing Archived Reports
Archived Reports are in PDF format and can be saved to your local drive or network by clicking the Save a Copy button. Archived Reports also can be printed to your local printer by clicking the Printer button.
Other menu options will be dependent on the version of Adobe Acrobat you have.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 38
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 39
54B107B55B11BChapter 6
12BAnalytics
Analytics is an intuitive ad hoc query tool that enables you to query, analyze and drill-up/drill-down on specific data elements in a graphical or data chart view. Each Analytics Datamart is presented as a category. Some categories, such as Corporate Experience Summary, Corporate Detail and Claim Detail, provide data across all supported lines of business. Other categories, such as Personal Auto Detail, provide data specific to that line of business.
Analytics supports both monthly and daily datamarts. Data in the monthly marts represents a snapshot as of the end of a specific month and can be viewed by month, by quarter or by year on an accident year, calendar year and policy year basis. Data in the daily marts represents a snapshot as of the end of a specific day and can be viewed by day, by week or by month on a calendar year basis.
When setting-up queries in Analytics, you will select data from two areas: Metrics and Filters. Metrics represent calculated values, including premiums, losses, exposures, ratios, averages and counts. Filters represent elements by which the metrics can be analyzed, such as by line of business, agency, program, adjuster, class code and postal code. Filters are organized in a who, what, when, where format to facilitate ease of navigation. Filter examples include:
• Who: By which insurance company, agent, underwriter or a combination of these elements?
• What: What line of business do you want to analyze? What underwriting elements do you wish to evaluate? General Liability? Class Code? Standard Industry Code?
• When: What is the period of time you wish to compare? Accident Year, Calendar Year, or Policy Year?
• Where: Would you like to view your results by exposure state? Postal code?
You can define the specific drill paths to view the results of a query. For example, if you want to view premiums filtered by month, then by producer and then by territory, Analytics can be set-up with this specific drill path. Data outputs also can be saved in a PDF format or exported to Microsoft Excel where the data can be further manipulated. All queries created by you can be saved to your Dashboard or shared with other Insight users via E-mail.
Analytics Features:
• Analyze premiums, losses and incurred loss ratios by producer and distribution channel. • Perform historical renewal analysis by underwriter and by program. • Create loss triangles and reserve analysis to monitor incurred loss, reserve changes and
expense payments. • Examine claim counts by adjuster / examiner, claim status, claim type and geography. • Analyze aspects of reinsurance program effectiveness, including direct, ceded, assumed
and net of reinsurance. • Measure inforce, canceled and expired policy counts by annual statement line, class
code, underwriter and product. • Compare profitability and expenses between lines of business, companies, programs and
geographies.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 40
28BDeveloping Analyses
This is a high level view of creating an analysis. The basic steps are the same for all users. Each Analysis is user customized by selecting from a variety of filters, metrics and views.
1. To analyze business data in Analytics, first select a Category. This first step is to ensure the correct filters and metrics are in place. The default Category is Corporate Experience Summary.
2. Go into Setup to select the filters and metrics.
a. Select the appropriate filters to create an analysis from the Who, What, When, Where and Additional Filters Setup.
b. After selecting the filters, select the metrics that are to be used. Metrics represent the factual data such as dollar amounts, counts, ratios, exposures and averages that are queried from the data warehouse.
3. After selecting the filters and metrics, click on the View tab. A summary of the selected filters and metrics will be displayed. Use the Setup to adjust the Hidden and Shown items. The View tab is where you will name the new analysis.
4. Run the analysis or get a preview by clicking the Chart Preview tab or the Data Preview Tab.
Each of theses steps will be discussed in detail in the following sections.
Figure 18: Analytics New Screen
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 41
29BCategories of Datamarts
There are several analysis categories provided within Analytics. Some examples of analysis categories are:
• Corporate Experience Summary – Top level of data summarization. Corporate Experience Summary groups data by underwriter, agent, company, or line of business. Corporate Experience Summary is designed to provide a summary or overview of all data at the highest level.
• Corporate Detail – Mid level of data summarization. Corporate Detail groups data by underwriter, agent, company, or line of business with the ability to drill down to a policy coverage level.
• Line of Business Detail – Lowest level of data summarization. Line of Business Detail groups data by attributes specific to that line of business. The Line of Business Detail analysis category lets you filter on attributes specific to the line of business that you selected. These attributes can be selected individually or in combination to analyze data at very deep levels of detail.
Profiling business by specific attributes is possible, and these profiles can be applied through saved analyses to many different levels from enterprise wide scenarios down to specific agents, states, rating territories and postal codes.
Lines of business include:
− Claims Daily Detail − Claims Detail − Commercial Auto − Commercial Property − Corporate Daily Detail − Corporate Daily Summary − Corporate Detail − Corporate Experience Summary − Dwelling Fire − Homeowners − Personal Auto − Personal Umbrella
The Corporate Detail and Lines of Business categories provide more exact details for the analysis. These levels allow you to query for results that include filtering on attributes that are specific to the line of business level selected. These attributes can be selected individually or in combination to set up a very detailed data analysis.
NOTE Only one analysis category can be selected at any given time. The more summarized analysis categories will return results faster than the more detailed line of business analysis categories.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 42
194BTop Bar Menu
The Top Bar Menu at the top of the page provides all the options available in Analytics. The top bar menu does not change according to login. All options are available to all users at all times.
Top Bar Menu
New Analysis Clears all current Filter, Metric and View Selections so that you can begin a new analysis.
Open Analysis Click this to open a previously saved analysis.
Save Analysis Click this to save a current analysis under a specific name.
Setup Sets up the Filters, Metrics and View Selection for an analysis.
Run Analysis Performs a query that returns the results of the Setup in a chart and table format.
Run Report Performs queries that return a PDF file containing a preformatted report of the current Filter, Metric, and View Selections.
Export Analysis Performs queries that return a CSV file of the current Filter, Metric, and View Selections. The file is compatible with most spreadsheet applications.
Background Runs the query in the background. The button changes to CANCEL when a query is running in the background.
Add to Dashboard Adds the current saved analysis to the Dashboard on the My Analysis tab.
Create an Alert Places an Alert on the Dashboard that will send an e-mail notification to specified recipients when set parameters are exceeded.
E-mail You can send a message with a PDF-file of the current analysis or a hyperlink to a saved analysis to other Insight users.
Figure 19: Analytics Top Bar Menu
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 43
195BExpanding the View
The page view can be changed to only display the setup area of the screen or only the summary area of the page by clicking the expand arrows.
Figure 20: Expanding the View
196BTo Expand the View
Click the arrow once to change the screen.
To return the screen to the original view, click the opposite arrow once.
• The top arrow will expand the Setup area to the left of the screen.
• The bottom arrow will expand the results area to the right of the screen.
197B
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 44
Screen Definitions
Analytics has many options to setup, view, print and distribute data. The screen definitions below will apply to most analyses.
198BTitle Bar
Tab Options
Drill Options
Resize Option
Print Option
Graph
Figure 21: Screen Definitions - Graph
Title Bar – Located beneath the Top Bar Menu, the Title Bar contains the Category, the owner of the analysis, the name of the analysis and the status of the Loss Triangles.
Tab Option – This area, located at the top of the analysis, contains the Chart, Data and SQL tabs.
Drill Options – The ability to drill up or down will be displayed with this button. If a drill up or drill down button is not visible, click on the bars of the graph to drill down.
Resize Option – When an analysis extends beyond the page, click the resize button to resize the graph.
Print Option – Click this button and a popup window will be displayed with a printable version of the graph.
Graph – The analysis graph will display in the results window under the “Chart” tab. The X axis and Y axis will be labeled with criteria from the analysis setup.
Analytics has many options to setup, view, print and distribute data. The Drill Information will apply to most analyses.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 45
199BTitle Bar
200B Drill Info
Figure 22: Screen Definitions – Drill Down
Title Bar – Located beneath the Top Bar Menu, the Title Bar contains the Category, the owner of the analysis, the name of the analysis and the status of the Loss Triangles.
Drill Info – This area will display the drill levels available. The highlighted area is the level currently being displayed.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 46
58BSetup
The Setup area contains tabs for the selection of Filters, Metrics, View Options and Drill Information. The filters and metrics available will depend on the selected analysis category.
59BFilters Filters are selected to group the data into specified categories, time ranges and selected subjects. Analytics begins with all available company data then groups this data based on the categories selected under the filter tab, and also constrains the data to the specific time ranges chosen.
You may choose as many filters as you need to generate the analysis results. The greater the number of filters, the more focused the results.
Figure 23: Setup Area of Analytics - Filters
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 47
Analytics lets you analyze data by asking four simple questions to select filters:
• WHO – Represents selections for individual companies, branch offices, underwriters, and agents.
• WHAT – Represents selections for individual lines of business, or line of business attributes, depending on the analysis category.
• WHEN – Which time frame is applicable to the analysis? A valuation period is selected by opening the When filter and selecting the period of time that will be used to analyze the data. The valuation period can be a single month, a quarter, year-to-date by month, several consecutive or nonconsecutive months, several quarters, several years, or any of the other choices listed in the pop-up window within the When filter category. All analyses have the same time options:
− Calendar Premium, Calendar Year Losses – Operational premium and loss transaction data, based on the calendar month/year the transaction occurs.
− Calendar Premium /Accident Year Losses – Operational premium based on the calendar month/year of the premium transactions and loss data transactions based on the month/year of the accident accumulating to the valuation date.
− Policy Premium, Policy Year Losses – Represents operational premium and loss transaction data based on the policy inception date and the date of loss falls within the policy term.
• WHERE – Represents selections for specific states, territories, or postal codes depending on the analysis category, if specific geographic areas are being targeted.
• ADDITIONAL FILTERS – Represent selections for filtering on new/renewal, active/cancelled, or direct, ceded, and assumed business depending on the analysis category.
The filters reduce the data into specific categories and time ranges.
NOTE Be sure to select a time period or accept the default time range, which is the current month and current year.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 48
Figure 24: Analytics Filter Setup Page
To define a filter, expand the item for further detail, for example, “Who” will show the options available for this category. Click on the item to further define the options. For example, Underwriting Company, will open a popup window with options to include in the analysis.
Figure 25: Filters Selections
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 49
Select as many items as needed. Filters are selected and deselected by mouse clicks.
To include or remove items listed:
• Click the All>> button and all items in the Not Selected area will be moved to the Selected Items area.
• Use the Shift key + a mouse click for contiguous areas and click Include>. The highlighted items will be moved from the Not Selected area to the Selected Items area.
• Use the Control key + a mouse click for selecting or deselecting one line at a time. Click the Include> and the highlighted items will be moved from the Not Selected area to the Selected Items area.
• All >> selects all of items within a list box and moves them from the Not Selected area to the Selected Items area.
• Remove these items by utilizing the <Remove button to remove single items or the <<All to remove all items from the Selected Items area to the Not Selected area.
• Use the Clear button to move all items from the Selected Items area to the Not Selected area.
Once all choices are made, click the Save button to save the selections. The box will close and you will be returned to the Setup screen with all selections in place.
If this is not the filter you wanted to define, click Cancel to return to the previous screen. Analytics allows multiple filters to be selected and defined, except in the “When” filter.
201BWhen Filter Options
Insurance Company profitability can be measured on several accounting bases. The goal in any review is to:
• Evaluate the results in a particular period of time.
• Minimize influences from events outside this period of time.
• Provide consistent review of the results that are unaffected by the experience of prior years. Establish underwriting profit targets on an accident year basis.
• Compare actual results to targets on an accident year basis.
The resulting comparison allows utilization of underwriting profit targets to accurately assess whether recent operations have been sufficiently profitable.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 50
Figure 26: When Filter Options
202BYear Basis Options
You can choose to have time measured in years. Calendar Premium, Calendar Losses Year; Calendar Premium, Accident Losses Year and Policy Premium, Policy Losses Year are simply different means of organizing the same premium and claim data. The count and metric amounts may change based on which Year Basis is chosen for the analysis.
• Some analyses can be run using all three Year Basis options, while other analyses can only be run on Calendar Premium – Calendar Losses year basis.
• If the Year Basis chosen is Calendar Premium-Accident Losses or Policy Premium-Policy Losses, a valuation date may also be selected. This is a month and year used to look at the data “As Of” that month and year. If no valuation month/year is selected, the when filter defaults to the current or most recent month/year for which data is available.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 51
Calendar Premium (cycle date), Calendar Losses year (cycle date)
• Shows the premium and claims activity during a financial period.
• Incurred claims will differ from accident year incurred claims valued at the end of the particular year.
• Once calculated for a given period the experience never changes.
• Calendar Premium, Calendar Losses year is the default year basis.
• When Calendar Premium-Calendar Losses year basis is chosen, the Valuation Date entry box is grayed out and is not applicable.
The default time measure is Calendar Premium, Calendar Losses.
Calendar Premium (cycle date), Accident Losses Year (loss date)
• Shows the development history of claims, from the time they were incurred up to the present time.
• Derived by grouping claims from accidents that occur in the same calendar period.
• The estimated value of such claims varies depending on the valuation date selected, equaling the sum of paid claims up to that point in time and the loss reserves carried at that point in time.
When you choose this option, you will have to select the Valuations dates you want to include.
You also will have the option to run a Loss Triangle. If you want a Loss Triangle performed, select either Cumulative or Incremental from the drop down menu.
Policy Premium (policy effective date), Policy Losses Year (date of loss falls within policy term)
• Organizing claims or premiums based on policy writing dates involves the grouping of claims and premiums written during a financial period.
• Generally used for establishing ratemaking and loss reserve analysis.
• Use the Policy Premium, Policy Losses Year basis to get Loss Triangles.
When you choose this option, you will have to select the Valuations dates you want to include.
You also will have the option to run a Loss Triangle. If you want a Loss Triangle performed, select either Cumulative or Incremental from the drop down menu.
203BMonthly, Quarterly and Rolling Time Measurements
For more defined detail, such as monthly, quarterly or rolling, use the lower section to define the analysis time period.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 52
204BCurrent
Generally the most current year loaded in the database is used in an analysis. Make any selection by clicking a radio button in front of one of the six options. The most current load date will be displayed to help make the appropriate selection.
Figure 27: When Current Options
Under the Current tab, you can select one of the following time periods:
• Current Month – This is the month of the most recent data loaded to the datamarts.
• Current Quarter – This is the quarter or last three months of the most recent data loaded to the datamarts.
• Current Quarter by Month – This is the same as the Current Quarter but data will be broken out by each of the three months in the quarter.
• Year to Date by Month – This is the most recent data loaded to the marts displayed by month from the beginning of the current year through the current month.
• Rolling Year by Month – This time period looks at data on a current year basis by month.
• Rolling Year by Quarter – This time period looks at data on a current year basis grouped by month.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 53
205BRange
On this tab, you can select a specific time frame by month or quarter. Make selections by clicking on the drop down menus and highlighting selections.
Figure 28: When Range Options
Range options include selection for:
• Show by, either Month or Quarter
• Start Date, Month and Year
• End Date, Month and Year
206BCustom
You can pick the exact month(s) and quarter(s) for specific years that you want with the options on the Custom tab.
• To select exact months, click on the month, and the box will be highlighted. Pick and choose as many as necessary. Select all months by clicking the All Months box at the top.
• To select exact quarters, click on the quarter, and the box will be highlighted. Pick and choose as many as necessary. Select all quarters by clicking the All Quarters box at the top. Clicking a quarter deselects months previously highlighted.
• To select exact years, click on the year, and the year will be highlighted. Pick and choose as many as necessary. Select all years by clicking the All Years box at the top.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 54
Figure 29: When Custom Options
Custom options include selections for:
• Specific Month(s)
• Specific Quarter(s)
• Year(s)
After making the selection, click Save to be returned to the previous screen.
Continue through the Where and Additional Filters making selections for the analysis setup. Where and Additional Filters function in the same way as the What filter described previously.
60BMetrics The next step in the Setup is selecting the metrics to associate with the filter items previously selected. The Metrics tab will display types of metrics based on the selected analysis category. The analysis category determines the level of detail displayed.
An example would be selecting a company name under the Who filter to review the written premium. Select written premium under the Metrics tab. The metrics are factual data, such as dollar amounts, counts, ratios, exposures and averages that are queried and aggregated from the data warehouse, that can be used as types of measurements.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 55
Figure 30: Setup Area of Analytics - Metrics
To define a metric, expand the item for further detail, for example, Currency Metrics. The options available are displayed for this category. Click on the item to further define selections. For example, Premium Amounts, a popup window provides the options. 238HAppendix B contains examples of metrics by line of business.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 56
Figure 31: Metrics selections
Select as many items as necessary to setup the analysis. Metrics are selected and deselected by clicking with the mouse.
To include or remove items listed:
• Click the All>> button and all items in the Not Selected area will be moved to the Selected Items area.
• Use the Shift key + a mouse click for contiguous areas and click Include>. The highlighted items will be moved from the Not Selected area to the Selected Items area.
• Use the Control key + a mouse click for selecting or deselecting one line at a time. Click the Include> and the highlighted items will be moved from the Not Selected area to the Selected Items area.
• All >> selects all of items within a list box and moves them from the Not Selected area to the Selected Items area.
• You can remove these items by utilizing the <Remove button to remove single items or the <<All to remove all items from the Selected Items area to the Not Selected area.
• Use the Clear button to move all items from the Selected Items area to the Not Selected area.
Once all choices have been made, click the Save button to save the selections. The box will close and you will be returned to the setup screen with all selections in place.
If this is not the metric you wanted to define, click Cancel to return to the previous screen.
Select and define as many metrics as necessary to setup an analysis.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 57
Figure 32: Analytics Metric Setup Page
The Analysis Summary, located to the right side of the screen, will list the setup items selected, indicate if shown or hidden, and display the value.
61BView The next tab is the View Tab. The view tab gives a summary of the filters and metrics filters and metrics can be arranged in any order. Specify which filters and metrics should be hidden or shown.
Start with the filters selections using the hidden and shown boxes to determine what will be displayed on the chart or report output. The shown items are the ones that will appear and the hidden items will be used only to filter the results and will not show up on the chart or report. Use the view tab to change the way filter selections are grouped to customize the level of detail shown in the analysis display.
The first filter selected is always placed in the shown category and the remaining filter selections are placed in the hidden section. These filters can be hidden or shown and their order can be changed. For instance, to filter companies for results that span more than one time period, but display these as totals only, hide the time filter. The results are grouped into one total for that time period. The metrics selections also are shown and the order can be modified for the chart or report layout.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 58
Figure 33: Setup Area of Analytics - View
To define a View, expand the item for further detail. For example, Filter Selections, has a popup window with options displayed on screen.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 59
Figure 34: View Selections
Select as many items as necessary to setup the analysis. Views are selected and deselected by clicking with the mouse.
To include or remove items listed:
• Click the All>> button and all items in the Hidden area will be moved to the Shown area.
• Use the Shift key + a mouse click for contiguous areas and click Show>. The highlighted items will be moved from the Hidden area to the Shown area.
• Use the Control key + a mouse click for selecting or deselecting one line at a time. Click the Show> and the highlighted items will be moved from the Hidden area to the Shown area.
• All >> selects all of items within a list box and moves them from the Hidden area to the Shown area.
• You can remove these items by utilizing the <Hide button to remove single items or the <<All to remove all items from the Shown area to the Hidden area.
• You can move item up or down the Shown list by highlighting the item and clicking Up or Down to move the item.
• Use the Clear button to move all items from the Shown Items area to the Hidden area.
Once all choices are made, click the Save button to save the selections. The box will close and you will be returned to the setup screen with all selections in place.
If this is not the View you wanted to define, click Cancel to return to the previous screen.
Select and define as many Metrics as necessary to setup an analysis.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 60
Figure 35: Analytics Metric Setup Page
The right side of the screen contains the Analysis Summary. The Analysis Summary provides a table view of the selected items and columns indicating if the item is Shown and stating the value. This allows you to review all of the selected filters and metrics and determine whether these items will be shown or hidden on the display.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 61
Figure 36: Analytics View Setup Page
207BTitles
Report/Chart Titles can be added at this point. Titles are bolded and placed on the top most line shown on the report or chart output. The title and all of the filter selections shown will be saved when the analysis is saved.
To enter a title, click on Title in the View area of the Setup. A popup window will be displayed.
Figure 37: Title Entry from View
Enter in the title name and click Save. You will be returned to the previous screen.
If you do not want to title the analysis, click cancel to be returned to the previous screen.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 62
208BAnalysis Summary Icons
The Icons along side analysis summary filters and metrics selected in Analytics are described below.
Analysis Summary Icons
Security Locked Dimension or can be used for Security and Filter Locks.
Filter Who, What, When, Where, or Additional Filters.
Formula A Formula has been used.
Snapshot Click for a snapshot view.
Cancel Click to exit.
Remove Click to remove metric or filter from the analysis.
Dollar Results expressed in dollar amounts.
Count Results expressed as a number of.
Ratio Results expressed as a ratio.
Non-Additive Values cannot be added.
Additive Values can be added across all dimensions. See page 481H73 for further details.
Semi-Additive Distinct
Can process an aggregation across multiple time periods. Values can be added within a Calendar Month but not across months. See page 482H73 for further details.
Semi-Additive Snapshot
Values are pre-aggregated and stored at a monthly level. These metrics are snapshots of those monthly periods and must be viewed in a context of a monthly period. As with Semi-Additive Distinct, they can be added within a Calendar Month but not across months.
See page 483H73 for further details.
Figure 38: Analytics Analysis Summary Icon Descriptions
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 63
30BRunning the Analysis
Now you are ready to run the analysis. Click the button in the top bar menu to run the analysis.
62BPreviewing an Analysis You can preview an analysis by clicking either the Chart Preview or Data Preview tab prior to actually running the analysis. This will allow a look at the data before running the analysis. It may be helpful to do this to verify the results. Click Run before saving an analysis.
Previewing does not allow an analysis to be saved. A sample watermark displays across the graph or data as a reminder to Run the analysis before saving.
63BRunning the Analysis in the Background An analysis may take some time to run, depending upon the amount of data it needs to sort through. The button on the Top Bar Menu allows you to run an analysis in the background, freeing you to perform other work within Insight.
After you launch an analysis by clicking the button, click the button on the Top Bar Menu. When the analysis has been converted to “Background” processing, the Background button will change to a Cancel button. At this point you can continue working by starting a “New” analysis, or “Open” an existing analysis. Additionally, you can navigate to other marts, Monitors, Reports, or Dashboard. You can even logout of Insight and as long as the server is running, the background queries will continue to run.
Cancel the analysis at anytime by clicking on the Cancel button.
209BMonitoring the Background Process
You can monitor the progress of the background query from the Open Analysis Web Page Dialog Box. To do so:
1. Click on the Open button on the Top Bar Menu to open this box.
Figure 39: Monitor Analysis
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 64
2. Select the “Background Queries” radio button. The screen now shows only those queries running in the background. A “Status” column indicates whether the query is pending, executing, failed, or completed.
Figure 40: Background Queries
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 65
Exceeding the Row Count Limit for an Analysis
This release of Insight allows the user to set a limit on the number of rows that are returned to Analytics by a query or report. The row limit is set via the MaxClientRowCount parameter in the ThazarGlobal_en_US.properties file. This file is located under:
\InsightV5.1.0\Applications\Insight\config\properties\
By default, this feature is turned off (i.e., MaxClientRowCount = 0). To turn on the row count feature, the Insight administrator must edit the ThazarGlobal_en_US.properties file and enter a row limit.
Figure 41: Edit MaxClientRowCount parameter in ThazarGlobal_en_US.properties File
In the example in the figure above the row limit has been set to 5000. In the event that a query or report returns results which exceed this limit then you will receive a message warning you of this fact.
There are several scenarios that will produce warning messages.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 66
Running a Query
If the query exceeds the designated row limit, when the user clicks the button, a message will appear across the top of the Data screen similar to the one shown below. The query will display the results but only up to the row limit.
Figure 42: Warning Message Generated by a Query
Generating a Report If you generate a report via the Report option on the Analytic’s top bar menu and the row limit is exceeded, a warning message will appear at the top of the PDF report. As with the query, the report is generated but only up to the designated row limit.
Figure 43: PDF Report Generated by Analytics=>Reports
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 67
A warning message may also be returned based upon the “projected” row count in a report. In this case the report will not be generated and a message box similar to the one shown below will appear on the screen.
The row count is calculated by multiplying all “Shown” dimensions in the drill hierarchy. In the Analysis Summary View below, these dimensions are the filters marked “Yes” in the Shown column:
Figure 44: “Shown” Dimensions in the Analysis Summary View
In order to view the full data set you must either select more specific filter criteria or remove some of the filters from the drill hierarchy until the row count is equal to or less than the row limit.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 68
Removing Filters from the Drill Hierarchy
To remove filters from the drill hierarchy:
1. Select View>Filter Selections on the Analysis Setup page to open the Filter Selections box.
Figure 45: Select Filters from the Drill Hierarchy
2. Select one or more filters under “Shown” and click the Hide button to move them to the “Hidden” list.
Figure 46: Hide Filters
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 69
3. In the Analysis Summary View, a “No” will appear next to the hidden filter name under the Shown column.
Figure 47: Hidden Filters in the Analysis Summary View
4. Rerun the query or regenerate the report to confirm that the results fall within the row limit.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 70
Analysis Output
The requested analysis will be displayed as a chart or a data table depending upon the filters and metrics selected. Most analysis will have three output tabs:
• Chart
• Data
• SQL
It is possible to only get the Data and SQL tabs to display information. If an error message is displayed when the Chart tab is clicked, return to the filters and metrics to confirm or adjust the selections, then run the analysis again.
210BChart Tab View
The Chart Tab is where you can see how filters and metrics are displayed on a chart. From this display you can select specific grouping levels that will highlight the intended goals of the analysis. You can view your analysis as a graph at any time by clicking the Chart Tab.
Figure 48: One Level of Drill Down
You can drill down by clicking any of the grouped bars to get a more detailed analysis. The level of drill down will be displayed on the left hand side of the screen in the Drill Down Info.
To drill down further, click on any bar on the graphic, the next level down will be displayed. This may change the display from the chart area to the data area. To return up a level, click on the drill up button, the next level up will display. These buttons will not always be available and will vary depending upon the level displayed.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 71
211BData Tab View
You can view data in the data area at any time by clicking on the Data Tab. The Data Tab View will show data in a table output format rather than a graphical format. In some instances, this may be the only way to view data, especially at the lowest drill down level.
Figure 49: Data Area View
The level of drill down will be displayed on the left hand side of the screen in the Drill Down Info.
To drill down further, click on the drill down button, the next level down will display. To return up a level, click on the drill up button, the next level up will display. These buttons will not always be available and will vary depending upon the level displayed.
212BPolicy and Claim Count Metrics Drill Down Capabilities
If certain analyzes include Policy or Claim count metrics then the values for these counts will appear in the Data view as active hyperlinks. When selected, these links export and display the Policy or Claim level details for the respective count to an Excel spreadsheet.
The user must first setup and run an analysis containing one or more Policy or Claim Count Metrics and select a datamart category which supports this feature. The following categories of datamarts enable this capability:
• Claims Detail • Claims Daily Detail • Corporate Detail • Corporate Daily Detail • Dwelling Fire
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 72
• Homeowners • Personal Auto • Personal Umbrella
This functionality is NOT enabled in the following datamarts due to the level of detail already enabled:
• Corporate Experience Summary
• Corporate Daily Summary
The counts appear in the Data view area as blue, underlined text. When the user clicks on a count value, Insight generates a list of Policy or Claim Details and then exports it to an Excel spreadsheet which launches over the Insight interface in a separate window. Users can then save, manipulate, or email the data contained in the spreadsheet.
Figure 50: Policy Count Listings in Excel
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 73
213BAdditive vs. Semi-Additive Metrics
A metric can have either Additive or Semi-Additive values. Additive values are those that can be added together. Semi-Additive values are those that can not be added together. When you view the results of an analysis in the Data view, Additive metrics will display totals while Semi-Additive metrics will show only “n/a” in the Totals row.
The additive and semi-additive icons identify the values of the selected metrics in the summary area. In this example, both the Inforce Policy Count and Claim Count metrics have semi-additive values.
Figure 51: Additive and Semi-Additive Metrics
The When Filters for the above analysis are:
• Calendar Premium, Calendar Losses • Current Quarter by Month – Oct, Nov, Dec 2005
When the analysis is run, it generates the following results:
Figure 52: Results for the Additive and Semi-Additive Metrics
All of the Additive metrics show totals. Note, however, that the totals for the both the Semi-Additive Inforce Policy Count and the Claim Count metrics read: n/a. They are only valid within the context of a time period (a Calendar Month) and cannot be summed across the three month period of the Current Quarter by Month filter.
Additive
Semi-Additive
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 74
Likewise, the Claim Count represents a Claim in the system rather than a Claim event such as Claim Opened or Claim Closed. Normally, these two events would be assigned to a time period and be fully additive. In this case, adding these numbers together would produce invalid results because records would be counted multiple times.
214BSemi-Additive Distinct vs. Semi-Additive Snapshot
There are actually two types of semi-additive metric values:
Semi-Additive Snapshot
Semi-Additive Distinct
A Semi-Additive Distinct metric is one that is processed using COUNT(DISTINCT…<KEY VALUE>) SQL logic. By counting distinct keys, the system can produce valid aggregations of semi-additive metrics across time periods. The figure below shows the SQL statement for an analysis containing a Semi-Additive Distinct Inforce Policy Count metric.
Figure 53: SQL Statement for a Semi-Additive Distinct Inforce Policy Count Metric
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 75
A Semi-Additive Snapshot metric is pre-aggregated and stored in a datamart using Datamart load logic. In a monthly datamart, the metric is pre-aggregated and stored for each month supported by the monthly datamart. These metrics are snapshots within those monthly periods and must be viewed in the context of a monthly period. The figure below shows the SQL statement for an analysis containing a Semi-Additive Snapshot Inforce Policy Count metric.
Figure 54: SQL Statement for a Semi-Additive Snapshot Inforce Policy Count Metric
The core difference between Semi-Additive Distinct and Semi-Additive Snapshot is that the Distinct variety CAN process an aggregation across multiple time periods and the Semi-Additive Snapshot CANNOT.
For example, in a monthly datamart with a Semi-Additive Distinct Inforce Policy Count, you can create an analysis that computes Quarterly totals for Inforce Policy Counts (i.e., When Filter = “Current Quarter”).
Figure 55: Select Current Quarter for Semi-Additive Distinct Inforce Policy Count
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 76
In a monthly datamart with a Semi-Additive Snapshot Inforce Policy Count, you can NOT select Quarterly totals on this metric. The values are pre-aggregated and stored at a monthly level and must be viewed that way. If you were to select “Current Quarter” a warning message similar to one below would appear. To run the analysis you would need to either remove the Semi-Additive Snapshot Inforce Policy Count or select a Monthly based filter.
Figure 56: Semi-Additive Snapshot Inforce Policy Cannot be Viewed Quarterly
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 77
Metric Values
The following table identifies the value of each metric.
Metric Value Allocated Expense Reserve Change Additive Allocated Expense Reserve Change Ratio Additive Average Alloc Expense Paid Per Claim Semi-Additive SnapshotAverage Cancellation Premium Additive Average Combined Expense Paid Per Claim Semi-Additive SnapshotAverage Effective Premium Additive Average Expiration Premium Additive Average Inforce Premium Semi-Additive SnapshotAverage Retained Premium Additive Average Transaction Size Additive Average Unalloc Expense Paid Per Claim Semi-Additive SnapshotCancelled Policy Count Additive Cancelled Premium Additive Cancelled Premium to Written Premium Additive
Claim Feature Count Semi-Additive Distinct
Claim Occurrence Count Semi-Additive Distinct
Claim Status Count Semi-Additive Distinct Claim to Date Incurred Amount Semi-Additive Snapshot
Claimant Count Semi-Additive Distinct Claims Closed Additive Claims Opened Additive Combined Expense Reserve Change Additive Combined Expense Reserve Change Ratio Additive Combined Incurred Expense Additive Combined Incurred Expense Ratio Additive Combined Incurred Loss and Recovery Additive Combined Incurred Loss and Recovery Ratio Additive Combined Incurred Loss, Expense and Recovery Additive Combined Incurred Loss, Expense and Recovery Ratio Additive Combined Incurred Recovery Additive Combined Incurred Recovery Ratio Additive Combined Incurred Recovery to Incurred Loss Ratio Additive Combined Loss and Expense Incurred Additive Combined Loss and Expense Incurred Ratio Additive Combined Loss and Expense Reserve Change Ratio Additive Combined Loss and Recovery Reserve Change Additive Combined Loss and Recovery Reserve Change Ratio Additive Combined Loss, Expense and Recovery Reserve Change Additive
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 78
Metric Value Combined Loss, Expense and Recovery Reserve Change Ratio Additive Combined Outstanding Expense Reserve Semi-Additive SnapshotCombined Outstanding Loss and Expense Reserve Semi-Additive SnapshotCombined Outstanding Loss and Recovery Reserve Semi-Additive SnapshotCombined Outstanding Loss, Expense and Recovery Reserve Semi-Additive SnapshotCombined Outstanding Recovery Reserve Semi-Additive SnapshotCombined Paid Expense Ratio Additive Combined Paid Loss and Expense Ratio Additive Combined Paid Loss and Recovery Ratio Additive Combined Paid Loss, Paid Expense and Recovery Ratio Additive Combined Recovery Ratio Additive Combined Recovery Reserve Change Additive Combined Recovery Reserve Change Ratio Additive Combined Recovery to Paid Loss Ratio Additive Commission Additive Count Renewal Retention Additive
Coverage Count Semi-Additive Distinct Deductible Recovered to Paid Loss Ratio Additive Deductible Recovery Ratio Additive Deductible Reserve Change Additive Deductible Reserve Change Ratio Additive Earned Composite Rate Additive Earned Exposure Additive Earned Premium Additive Earned Premium to Written Premium Additive Effective Policy Count Additive Effective Premium Additive Expense/Incurred Amount Semi-Additive SnapshotExpense/Incurred Including Expenses Semi-Additive SnapshotExpired Policy Count Additive Expired Premium Additive Future Booked Premium Semi-Additive SnapshotFuture Written Premium Semi-Additive SnapshotIncurred Allocated Expense Additive Incurred Allocated Expense Ratio Additive Incurred Allocated Expense to Incurred Loss Ratio Additive Incurred Combined Expense to Incurred Loss Ratio Additive Incurred Deductible Additive Incurred Deductible Ratio Additive Incurred Deductible to Incurred Loss Ratio Additive Incurred Loss Additive
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 79
Metric Value Incurred Loss and Combined Expense to Earned Exposures Additive Incurred Loss Ratio Additive Incurred Salvage Additive Incurred Salvage Ratio Additive Incurred Salvage to Incurred Loss Ratio Additive Incurred Subrogation Additive Incurred Subrogation Ratio Additive Incurred Subrogation to Incurred Loss Ratio Additive Incurred Unallocated Expense Additive Incurred Unallocated Expense Ratio Additive Incurred Unallocated Expense to Incurred Loss Ratio Additive Inforce Policy Count Semi-Additive Snapshot
Inforce Policy Count Semi-Additive Distinct Inforce Premium Semi-Additive SnapshotInforce Premium to Written Premium Semi-Additive SnapshotLoss Reserve Change Additive Loss Reserve Change Ratio Additive Loss Severity Semi-Additive SnapshotOutstanding Allocated Expense Reserve Semi-Additive SnapshotOutstanding Deductible Reserve Semi-Additive SnapshotOutstanding Loss Reserve Semi-Additive SnapshotOutstanding Salvage Reserve Semi-Additive SnapshotOutstanding Subrogation Reserve Semi-Additive SnapshotOutstanding Unallocated Expense Reserve Semi-Additive SnapshotPaid Allocated Expense Additive Paid Allocated Expense Ratio Additive Paid Allocated Expense to Paid Loss Ratio Additive Paid Combined Expense Additive Paid Combined Expense to Paid Loss Ratio Additive Paid Combined Loss and Expense Additive Paid Combined Loss and Recoveries Additive Paid Combined Loss, Paid Expense and Recoveries Additive Paid Deductible Additive Paid Loss Additive Paid Loss Ratio Additive Paid Salvage Additive Paid Subrogation Additive Paid Unallocated Expense Additive Paid Unallocated Expense Ratio Additive Paid Unallocated Expense to Paid Loss Ratio Additive
Policy Count Semi-Additive Distinct
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 80
Metric Value Premium Renewal Retention Additive Processed Premium Additive Recoveries/Paid Losses Additive Retained Policy Count Additive Retained Premium Additive Retained Premium to Effective Premium Additive Salvage Recovered to Paid Loss Ratio Additive Salvage Recovery Ratio Additive Salvage Reserve Change Additive Salvage Reserve Change Ratio Additive Subrogation Recovered to Paid Loss Ratio Additive Subrogation Recovery Ratio Additive Subrogation Reserve Change Additive Subrogation Reserve Change Ratio Additive Total Open Claims Semi-Additive SnapshotUnallocated Expense Reserve Change Additive Unallocated Expense Reserve Change Ratio Additive Written Exposure Additive Written Premium Additive Written Premium Policy Count Additive
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 81
SQL Analysis To run a SQL analysis or verify details in an external report program, Insight has a tab that will display the SQL statement used in the analysis. Click on the SQL tab to get the SQL statement used for the analysis. Copy the statement into the external report program to run the query.
Figure 57: SQL View
NOTE Insight does not contain a program or feature that will allow you to run your own SQL queries.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 82
215BRunning a New Analysis
After obtaining the analysis results and saving the analysis, start a new analysis by clicking on the New Analysis tab on the Top Bar Menu. This will clear the screen of the previous analysis and present a refreshed screen for a clean start.
You will be asked if you want to save your analysis. If you do not wish to save, click OK and continue.
Loss Triangles - Accident Year Data
Accident year data refers to losses that occurred within the time period used, regardless of when the loss was reported, paid or reserve changes were made. The changes in losses that have occurred within a given accident period, as time goes on, is called “development.” A separate loss development triangle, showing the percentage rate at which the initial amount or count changes in each subsequent time period, accompanies all cumulative triangles.
Figure 58: Incremental Loss Triangle and Development Factors
Accident Year Triangles
Loss Triangles can be Setup from any analysis Category by selecting a loss Metric, such as, paid losses, reserve change amounts, loss adjustment expenses, incurred losses, or certain loss ratios and counts. Only one metric at a time can be displayed on a Loss Triangle.
After choosing the metric, set the When filter. Select the Calendar Premium / Accident Losses year basis, the type of triangle, and the date range.
Loss triangles can be developed and displayed on either an incremental or cumulative basis. Select the appropriate option from the When filter drop-down box.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 83
• A cumulative accident year triangle shows the total number of loss dollars for the accident year period in each successive time period.
• The incremental version of the same data shows the amount added to, or subtracted from, the total in each time period.
Results can be viewed monthly, quarterly or annually. Use the Range Tab to show the results by month or quarter and set the start date and end date range. Use the Current or Custom tabs for a wider variety of date selections.
Run the analysis to view the results.
The table name includes the type of triangle, the metric selected, and a description of how the results are shown. “Incremental Triangle,” “Incurred Loss – Age by Number of Months”
The table rows are titled by the time period selected in the When filter Setup. (“Cal/Accident Year,” “Cal/Accident Quarter,” “Cal/Accident Month”)
Columns reflect the number of months in each development time period.
• Annual: the first column time period is titled 12, the second 24, the third 36, etc.
• Quarterly: column time periods are titled 3, 6, 9, etc.
• Monthly: column time periods are titled 1, 2, 3, etc.
Accompanying cumulative triangles are separate loss development triangles that show the percentage change from the initial value to any subsequent time period.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 84
31BOutput Selections
The various output and retrieval methods in Analytics are Retrieve a Saved Analysis, out put to a report, export to Microsoft Excel, add to your Dashboard or create an alert.
65BOpening an Analysis Analyses that are used periodically can be saved for future use. To retrieve a previously saved analysis, click on Open in the Action Bar. A popup box will list Analyses available, the Category, the Owner Name and the date of the last update for each.
Choose the analysis to retrieve, check the box in front of the analysis and then click the open button.
Analyses are saved with the last filters and metrics chosen. The most current month or time period such as an evaluation date of the current month must be selected.
Click the Chart/Data button to re-run the analysis with the most current data loaded.
Figure 59: Retrieve an Analysis
216BSearching for an Analysis
To search for a specific analysis, click on the column name to sort the data either alphabetically or numerically in ascending or descending order.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 85
217BDeleting an Analysis
Delete unnecessary analyses by checking the box in front of the Analysis Name and clicking the Delete button at the top or bottom of the box. A popup window will confirm the deletion.
Figure 60: Delete a Saved Analysis
If this is not the screen you wanted, click the Cancel button to be returned to the previous screen. 66B
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 86
Saving an Analysis Analyses that are periodically used can be saved and retrieved. Click Run before saving an analysis. Click on Save in the Top Bar Menu. A popup window will be displayed.
Type in the Name (up to 50 Characters in length), select the owner and click Save.
Figure 61: Saving an Analysis
After making changes to an analysis, save it again before exiting. Click save and the popup window will be displayed. Save it with the original name or enter in a new name and save.
To save the analysis with the original name, double click on the analysis name, or click on the button in front of the analysis name. A confirmation message states what is about to happen. Click OK to overwrite the previous analysis with the revised analysis. Click Cancel to save the revised analysis with a different name.
Figure 62: Confirmation of Saving
If this is not the screen you wanted, click the Cancel button to be returned to the previous screen. 67B
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 87
Report Analytics generates a PDF file in Adobe Acrobat providing data for all levels of the ‘shown’ analysis.
NOTE You must have Adobe Acrobat Reader installed on your machine to use this feature.
Figure 63: PDF Report
The report is fully formatted for either portrait or landscape modes containing columns for each metric.
Search report contents and adjust the screen size using Adobe Acrobat features. The report is printed using Adobe Acrobat commands for individual pages, selected pages, or all pages. 8B
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 88
Export to Microsoft Excel Insight generates a CSV (Comma Delimited) file that you can share with other members of the organization.
Figure 64: Export to Excel
The report will be displayed in an Internet Explorer Window that can be saved and edited like any Microsoft Excel spreadsheet.
NOTE You must have Microsoft Excel installed on your system to use this feature.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 89
Add to Dashboard from within an Application
Run the analysis before adding it to the Dashboard. Click on Add to Dashboard from the Top Bar Menu. The Dashboard Wizard will be displayed in a separate screen. There are multiple ways to save pages to your Dashboard.
Save the same filters by checking the box on the far left side of the filters area.
Save the entire table by checking the Add Table box.
OR
Save selected information by checking the boxes of the information you want. Select entire columns by checking the box at the top of the column or an entire row by checking the box on the far left side of the row.
Enter in any scoring that may be needed.
Enter a Title and Click Finish to Save.
Figure 65: Dashboard Wizard for Saving Pages
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 90
218BTo Save to Dashboard:
1. Begin by selecting the criteria to be displayed on the Dashboard. Select specific columns or rows of data, specific tables, or one specific item. Multiple sections of data may be made.
2. Next assign any scoring. By assigning a score to a table, trends and goals can be more easily noticed. Whichever cell or cells are selected in the Table will be scored when numbers have been entered into the Numeric Score Selections table. You can set the floor and ceiling levels for key performance indicators.
a. Enter the top and bottom scores at each end of the table and click the “Auto-Fill” button to have the application pro rate the number scores in the table as an added convenience.
b. The Data may include “Add Selected Filters Table to Dashboard”, or other “Add” properties that will allow you to add a graphic number and score between –4 and +4.
3. After making selections, enter in a Title for the analysis.
4. Click the Finish button and the analysis will be placed on the Dashboard on the My Analysis tab. This analysis will be updated to add each additional month as new data becomes available.
If this is not the analysis you want to save, click Cancel in the lower right hand corner to be returned to the previous page.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 91
219BCreate an Alert Via the Alert Wizard
An Alert Wizard is created to help set the alert parameters.
Figure 66: Analytics Alert Wizard
Click Create an Alert on the Action Bar for an Alert Wizard popup window to be displayed. This wizard functions in the same way as Adding to Dashboard.
To begin you must select the criteria you want to watch. When these parameters are exceeded, it will trigger an alert.
1. Make selections either by checking the section title or selecting the individual check boxes.
2. Next set the Monthly Alert Selections. Monthly Alert Selections are located in the solid gray box.
3. Choose the relationship:
a. > greater than
b. >= greater than or equal to
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 92
c. < less than
d. <= less than or equal to
4. Choose the value. Enter in the numeric value that you need to trigger an alert.
5. After making selections, enter in a title for the analysis.
6. Click the Finish button and the analysis will be placed on the Dashboard under the Alerts section. This alert will be updated to add each additional month as new data becomes available.
The alert exists on the Dashboard as a one-line entry showing the date created. When the alert parameter is exceeded, an e-mail is forwarded to the creator and anyone else specified.
If this is not the analysis you wanted to save, click Cancel in the lower right hand corner to be returned to the previous page.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 93
69BE-Mail Many times analysis results need to be reviewed and shared with other Insight users within the company. You can use E-mail. This will send an e-mail to the recipient, through Microsoft Outlook, that contains a link to the Insight page you want to share with them. If the user is not logged in, they must log in prior to being placed on the page.
Figure 67: E-mail – To send an E-mail:
1. Select the E-mail option from the Top Bar Menu. A separate popup window will be displayed.
2. From the E-mail Users list, select the message recipients.
3. Select as many people as necessary. Names are selected and deselected by clicking with the mouse.
a. Click the All>> button and all items in the E-mail Users area will be moved to the Recipient area.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 94
b. Use the Shift key + a mouse click for contiguous areas and click To>. The highlighted items will be moved from the E-mail Users area to the Recipient area.
c. Use the Control key + a mouse click for selecting or deselecting one line at a time. Click the To> and the highlighted items will be moved from the E-mail Users area to the Recipient area.
d. All >> selects all of items within a list box and moves them from the E-mail Users area to the Recipient area.
e. Remove these items by utilizing the <Remove button to remove single items or the <<All to remove all items from the Recipient area to the E-mail Users area.
4. Enter in the subject line text.
5. Enter in the message text.
6. Check the preference to send a PDF or a link.
7. Click on the Send button to send.
If this is not the screen you wanted, click the Cancel button to be returned to the previous screen.
NOTE
220BMaking Recipient Selections
Recipients are selected and deselected by using the following mouse and keyboard commands:
• Shift key + mouse click for contiguous areas
• Control key + mouse click for selecting or deselecting one item at a time
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 95
32BWarning Messages
If there is not any data fitting the criteria selected, the page will be returned with a warning message placed at the top of the Summary.
Figure 68: Warning Message
The message will state the request could not be fulfilled and will provide instruction on how to proceed.
For Example: “You must select at least one currency metric (Premium, Loss, Etc.)”
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 96
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 97
13BChapter 7
14BMonitors
Data Monitors are easy to use and offer point-and-click analysis of key business performance indicators, such as, policy retention and loss frequency. You can choose the filters you want to setup the Monitor reports. The Monitor series provides a variety of pre-formatted output options, such as tables and graphs, to meet specific business analysis needs that can be exported to a spreadsheet application or added to the Dashboard.
Insight offers the following Monitors:
• Loss Monitor – Measures underwriting excellence and loss experience to help make informed decisions about underwriting programs and pricing. You can apply filters to setup the Loss Monitor and you even have the ability to exclude parameters like CAT losses or “shock” losses from the reports. Each line of business is a separate Loss Monitor (ex: Personal Auto Loss Monitor and Homeowner’s Loss Monitor).
• Retention Monitor – Measures retention trends across all lines of business. This helps to gauge the impact of retention tactics and analyze the most profitable segments within a book of business.
• Profile Monitor – Measures selected profile characteristics of inforce, new business and expiring business to help analyze the change on a goal-seeking basis, minimize adverse selection, and identify the impact of underwriting guidelines. You can report on agency performance including establishing specific goals and plans for the agency and reporting on progress against the plan. Each line of business is a separate Profile Monitor (ex: Commercial Auto Profile Monitor, and Dwelling Fire Profile Monitor).
• Claims Monitor – Measures key claim facts, such as loss reserve accuracy and changes over time, claim expense, time lag and recovery factors in order to establish claim service standards and develop claim operations excellence.
Monitors provide a flexible, easy-to-use graphical framework for building and saving personalized analyses of key business data. This means not having to know a programming language to write analysis queries. A complex analysis can be setup, submitted and the results returned with current data in minutes.
The information critical to managing the business can be modified when and where it is needed. In addition, all Monitors are designed so that an existing analysis can be modified to gain a different perspective quickly and easily.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 98
33BMonitor Basics
The Analysis Setup is where Filter selections reduce the data into specific categories and time ranges for analysis. It is not necessary to select filters to analyze enterprise-wide data.
The filters are based on line of business for Loss Monitor and Profile Monitor. Choose the line of business and select filters to setup an analysis. When setting up an analysis for Claims Monitor and Retention Monitor, it is not necessary to select a line of business.
Filter selections for all Monitors are organized into List Boxes. The filters identify who, what, when, where, and summary selections to narrow the data to include in the analysis. Not making any filter selections means all available data will be included in the data analysis.
• Who – Presents selections for individual companies, branch offices, and adjusters.
• What – Presents selections for coverage or program attributes.
• When – Selects the data to be reviewed based on when the claims were reported or the policies were booked. Valuation dates to review change over time. Select an ending date time period or accept the default for the “When” timeframe, generally, the most current month and year loaded in the database.
• Where – Selects the location by governing, exposure or accident state.
• Summary Selections – Used to group data outputs by program, producer, state or coverage when you request a Summary report.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 99
34BFilters Filters are attributes associated with your business. These attributes can be used to combine data into more specific, useful groups or to select detailed data for analysis. Filter selections determine how data will be reported.
The attributes of your business are categorized into who, what, when and where. The attributes are further divided into filters to reflect a company's organization and available data.
For example, the Filter Category of "Who" might be broken into the following filters: “Company,” “Branch,” “Agent,” or “Underwriter.”
The actual attribute values fall under each filter.
For example, under the "Agent" Filter would be a listing of all of the agents in a List Box.
Filter Category Filter
Who Company
Branch
Agent
Underwriter
What Line of Business
Annual Statement Line
Coverage Type
Deductible Type
When Calendar Year
221BWhere Governing State
Exposure State
Postal Code
222BSummary By 223BProducer
Figure 69: Examples of Filter Categories and Filters
During the Analysis Setup, selecting filters narrows the dataset for review. Filtering is the act of moving from all available data to a narrower slice of data to look at attributes about the facts being analyzed. If none of the filters in a filter category are selected, such as “Company”, then data for all companies will be looked at in the analysis for an enterprise-wide view. Any possible combination of filters can be selected. 239HAppendix B contains examples of filters by line of business.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 100
70BLoss Monitor
Loss Monitor measures underwriting excellence and loss experience to help you make informed decisions about the critical elements of underwriting programs and rate changes.
Loss Monitor provides a variety of pre-formatted output options to meet specific needs. Data can be exported to a spreadsheet application, added to the Dashboard, and set as alerts.
Figure 70: Loss Monitor Main Screen
From the main screen you can:
• Retrieve a previous analysis
• Create a new analysis.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 101
224BCreating a New Analysis
The filters are based on line of business for Loss Monitor. This is necessary to organize the filters on the Analysis Setup page to match the line of business selected.
Figure 71: Loss Monitor Analysis Setup
The Analysis Setup is where you make the filter selections to organize data into categories to include in the pre-formatted reports. Filter selections are organized into List Boxes.
The filters are based on the line of business selected on the previous page. Loss Monitor will allow the setting of Who, What, When, Where, Loss Amount Filters, and Summary Selections. Not making any filter selections means all data will be included in the data analysis.
Define the timeframe for the analysis as 6 Months, 6 Quarters or 6 Years from the specified Ending Month/Year selected in the When filter.
Certain values that distort numbers can be managed in the Loss Amount Filters. You can filter losses based on the amount paid. Remove small losses or large losses by designating the dollar amount to exclude from the analysis and improve the results.
• Cap losses not to exceed a certain amount (ceiling) from the results.
• Exclude losses less than a certain amount (floor) from the results. It is important to keep in mind stating “less than $50” also excludes loss amounts from the results for “$0.00,” as well as, negative dollar amounts.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 102
After selecting the analysis criteria, choose the output format from the left hand menu.
The analysis pages available are:
Loss Ratio Aging Page 484H103
Loss Ratio Relativity Page 485H105
Frequency Aging Page 486H107
Frequency Relativity Page 487H109
Severity Aging Page 488H111
Severity Relativity Page 489H113
Summary – Only on the Setup page Page 490H115
Also listed on the left hand menu are the options for saving, printing, sharing and additional information.
Save Page 491H163
Retrieve Page 492H164
Add to Dashboard Page 494H165
Create an Alert Page 495H168
Export to Excel Page 496H170
Print Page 497H170
Figure 72: Loss Monitor Side Bar Menu
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 103
Loss Ratio Aging
Loss Ratio Aging analyzes Incurred Loss Ratio as a measure of Accident Month Incurred Loss to Calendar Month Earned Premium. The top part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results.
Figure 73: Loss Ratio Aging Page
The Loss Ratio Aging page provides three sections of information to analyze Loss Ratio. Ages of Policies display in bands of months (rows) to show results based on how long a policy has been in effect. All table displays are shown in periods of either 6 Months, 6 Quarters or 6 Years (columns). The three analysis tables are:
• Calendar Month Earned Premium (in $000's) – The amount of earned premium for a given time period on a calendar month basis.
− Information on the last row on the Calendar Month Earned Premium (in $000’s) table is Total, displaying the sum of earned premium for each calendar month.
• Accident Month Case Incurred Loss (in $000's) – Loss paid plus loss reserve amounts of all losses occurring during a given time period on an accident month basis. Incurred Loss equals all paid amounts plus all reserve changes. Expenses are not included in the formula.
− Information on the last row on the Accident Month Case Incurred Loss (in$000’s) table is Total, displaying the sum of incurred loss for each month.
• Calendar/Accident Case Incurred Loss Ratio (%) – The relationship between incurred loss amounts and earned premium expressed as a percentage on an accident month basis. (Accident Month Incurred Loss/Calendar Month Earned Premium)
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 104
− Information on the last row on the Calendar/Accident Case Incurred Loss Ratio (%) table is an Aggregate. This is a division of the totals from the tables above to provide an average loss ratio for all data. (Total Incurred Loss/Total Calendar Month Earned Premium)
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 105
225BLoss Ratio Relativity
Loss Ratio Relativity provides a different view of Loss Ratio from a perspective termed relativity. Relativity is the division of the Loss Ratio amount by the Aggregate Loss Ratio Amount. Loss Ratio Relativity measures the Incurred Loss Ratio in a given month for a particular Policy Age relative to the Incurred Loss Ratio for all Policy Ages in the same month. The first part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results.
Figure 74: Loss Ratio Relativity Page
The Loss Ratio Relativity page provides three sections of information for a Loss Ratio analysis. The top two displays shown are the Calendar/Accident Case Incurred Loss Ratio and the Loss Ratio Relativity including aggregates. The bottom section is a Loss Ratio Relativity graph. Ages of Policies display in bands of months (rows) to show results based on how long a policy has been in effect. All table displays are shown in periods of 6 Months, 6 Quarters, or 6 Years (columns). The two tables are:
• Calendar/Accident Case Incurred Loss Ratio (%) – Displays the Accident Month Incurred Loss divided by Calendar Month Earned Premium
− Information on the Calendar/Accident Case Incurred Loss Ratio table includes an Aggregate along the bottom row and in the last column. (Total Incurred Loss by Total Calendar Month Earned Premium)
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 106
• Loss Ratio Relativity – Displays the Incurred Loss Ratio (for the month) divided by the aggregate from the Calendar/Accident Case Incurred Loss Ratio table.
− Along the Aggregate row, the relative point is set at 1.000 as a standard to measure relativity. Loss Ratios with relativity amounts below 1.000 represent Loss Ratios that are below the aggregate (average) Loss Ratio amount. Loss Ratios with relativity amounts above 1.000 represent Loss Ratios that are above the aggregate (average) Loss Ratio amount.
− Information on the Loss Ratio Relativity table includes an Aggregate in the last column. This is the division of the Loss Ratio aggregate for a single policy age across all time periods by Loss Ratio aggregate for all policy ages across all time periods.
The last two columns to the right side of the Relativity table are charted. An example of the relativity division of numbers is as follows:
Calendar/Accident Case Incurred Loss Ratio (%)
Age of Policies (in Months) 2001 Q1
0 - 12 66.5 %
13 - 24 45.2 %
25 - 36 37.2 %
37 - 48 70.5 %
Over 48 36.0 %
Aggregate 52.9 %
Figure 75: Example of Calendar/Accident Case Incurred Loss Ratio
Loss Ratio Relativity
Age of Policies (in Months) 2001 Q1
0 - 12 1.257 (66.5% / 52.9%)
13 - 24 0.854 (45.2% / 52.9%)
25 - 36 0.703 (37.2% / 52.9%)
37 - 48 1.332 (70.5% / 52.9%)
Over 48 0.681 (36.0% / 52.9%)
Aggregate 1.000 (52.9% / 52.9%)
Figure 76: Example of Loss Ratio Relativity
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 107
226BFrequency Aging
Frequency Aging analyzes Loss Frequency (per month) as a measure of Accident Month Losses to Calendar Month Earned Exposures. The first part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results.
NOTE
Frequency Aging and Frequency Relativity use earned exposure data in their analysis. In the event that there is no exposure data present in the Warehouse you can disable these features by having your Insight administrator edit the thz3.ProductConfig table and set the ExposuresEnabled property to “false”. Once this property is turned off, the Frequency Agency and Frequency Relativity features will no longer appear under the Analysis menu. The Summary Selection filter will be disabled as well.
For further information, refer to Appendix A of the Insight Installation Guide.
Figure 77: Frequency Aging Page
The Frequency Aging page provides three sections of information to analyze Loss Frequency. Ages of Policies display in bands of months (rows) to show results based on how long a policy has been in effect. All table displays are shown in periods of either 6 Months, 6 Quarters or 6 Years (columns). The three analysis tables are:
• Calendar Month Earned Exposure – The amount of earned exposure for a given time period on a calendar month basis. Earned exposure is calculated for all policies and is not limited to inforce policies.
− Information on the last row on the Calendar Month Earned Exposure table is Total, displaying the sum of earned exposures for each calendar month.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 108
• Accident Month Number of Losses – A count of all claims with a loss date within a given accident month calculated on an accident month basis.
− Information on the last row on the Accident Month Number of Losses table is Total, displaying the sum of Number of Losses for each accident month.
• Loss Frequency per Month – The accident month number of losses divided by the number of calendar month earned exposure.
− Information on the last row on the Loss Frequency table contains an Aggregate. This is a division of the totals from the tables above to provide an average loss frequency for all data (Total Accident Month Number of Losses/Total Calendar Month Earned Exposure).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 109
227BFrequency Relativity
Frequency Relativity provides a different view of Loss Frequency from a perspective termed relativity. Relativity is the division of the Loss Frequency amounts by the Aggregate (average) Loss Frequency Amounts. Frequency Relativity measures Loss Frequency in a given month for a particular Policy Age relative to the Loss Frequency for all Policy Ages in that same month. The first part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results.
NOTE
Frequency Aging and Frequency Relativity use earned exposure data in their analysis. In the event that there is no exposure data present in the Warehouse you can disable these features by having your Insight administrator edit the thz3.ProductConfig table and set the ExposuresEnabled property to “false”. Once this property is turned off, the Frequency Agency and Frequency Relativity features will no longer appear under the Analysis menu. The Summary Selection filter will be disabled as well.
For further information, refer to Appendix A of the Insight Installation Guide.
Figure 78: Frequency Relativity Page
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 110
The Frequency Relativity page provides three sections of information for a Loss Frequency analysis. The top two displays shown are the Loss Frequency and Frequency Relativity including aggregates. The bottom section is a Frequency Relativity graph. Policy ages display in bands of months (rows) to show results based on how long a policy has been in effect. All table displays are shown in periods of either 6 Months, 6 Quarters or 6 Years (columns). The two tables are:
• Loss Frequency Per Month – Displays Accident Month Number of Losses divided by Calendar Month Earned Exposures.
− Information on the Loss Frequency table includes an Aggregate along the bottom row and in the last column. This is the division of total Accident Month Number of Losses by total Calendar Month Earned Exposure.
• Frequency Relativity – Displays Loss Frequency (for the month) divided by Aggregate from the Loss Frequency per Month table.
− Along the Aggregate row, the relative point is set at 1.000 as a standard to measure relativity. Loss Frequencies with relativity amounts below 1.000 represent Loss Frequencies that are below the aggregate (average) Loss Frequency amount. Loss Frequencies with relativity amounts above 1.000 represent Loss Frequencies that are above the aggregate (average) Loss Frequency amount.
− Information on the Frequency Relativity table is an Aggregate in the last column. This is a division of the Loss Frequency per Month Aggregate for a single Policy Age across all time periods by Loss Frequency per Month Aggregate for all Policy Ages across all time periods.
The last two columns to the right side of the Relativity table are charted.
An example of the relativity division of numbers is as follows for Personal Auto:
Figure 79: Example of Loss Frequency Per Car Year
275BFrequency Relativity Age of Policies (in Months) 2001 Q1 0 - 12 0.654 (0.065 / 0.099) 13 – 24 1.387 (0.137 / 0.099) 25 – 36 1.732 (0.171 / 0.099) 37 – 48 1.260 (0.125 / 0.099) Over 48 1.164 (0.115 / 0.099) Aggregate 1.000 (0.099 / 0.099)
Figure 80: Example of Frequency Relativity
274BLoss Frequency Per Month Age of Policies (in Months) 2001 Q1
0 - 12 0.065 13 – 24 0.137 25 – 36 0.171 37 – 48 0.125 Over 48 0.115 Aggregate 0.099
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 111
228BSeverity Aging
Severity Aging analyzes Accident Month Loss Severity ($ per Loss) as a measure of Accident Month Number of Losses to Accident Month Incurred Loss. The first part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results.
Figure 81: Severity Aging Page
The Severity Aging page provides three sections of information to analyze Loss Severity. Policy ages are displayed in bands of months (rows) to show results based on how long a policy has been in effect. All table displays are shown in periods of either 6 Months, 6 Quarters or 6 Years (columns). The three analysis tables are:
• Accident Month Case Incurred Loss (in $000's) – Loss paid plus loss reserve amounts of all losses occurring during a given time period on an accident month basis. Incurred loss equals all paid amounts plus all reserve changes. Expenses are not included.
− Information on the last row on the Accident Month Case Incurred Losses table is Total, displaying the sum of incurred losses for each accident year/quarter/month.
• Accident Month Number of Losses – A count of all claims with a loss date within the given month calculated on an accident month basis.
− Information on the last row on the Accident Month Number of Losses table is Total, displaying the sum of Number of Losses for each accident month.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 112
• Accident Month Loss Severity ($ per Loss) – The amount of Accident Month Number of Losses divided by Accident Month Incurred Losses.
Information on the last row on the Loss Severity table is an Aggregate. This is a division of the totals from the tables above to provide an average loss severity for all data (Accident Month Case Incurred Loss/Accident Year Number of Losses).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 113
229BSeverity Relativity
Severity Relativity provides a different view of Loss Severity from a perspective termed relativity. Relativity is the division of the Loss Severity amounts by the Aggregate (average) Loss Severity amount. Severity Relativity measures Loss Severity in a given month for a particular Policy Age relative to the Loss Severity for all Policy Ages in that same month. The first part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results.
Figure 82: Severity Relativity Page
The Severity Relativity page provides three sections of information for a Loss Severity analysis. The top two displays shown are Loss Severity and Severity Relativity including aggregates. The bottom section is a Severity Relativity graph. Policy ages are displayed in bands of months (rows) to show results based on how long a policy has been in effect. All table displays are shown in periods of either 6 Months, 6 Quarters or 6 Years (columns). The two tables are:
• Accident Month Loss Severity ($ per Loss) – Displays the Accident Month Number of Losses divided by Accident Month Incurred Loss.
− Information on the Accident Month Loss Severity ($ per Loss) table includes an Aggregate along the bottom row and in the last column. This is the division of total Accident Month Case Incurred Loss divided by the total Accident Month Number of Losses.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 114
• Severity Relativity – Displays Loss Severity (for the month) divided by the Aggregate from the Loss Severity per Month table.
− Along the Aggregate row, the relative point is set at 1.000 as a standard to measure relativity. Loss Severity Relativity with amounts below 1.000 represent Loss Severities that are below the aggregate Loss Severity amount. Loss Severities with relativity amounts above 1.000 represent Loss Severities that are above the aggregate Loss Severity amount.
− Information on the Severity Relativity table is an Aggregate in the last column. This is a division of the Loss Severity aggregate for a single policy age across all time periods by the Loss Severity aggregate for all policy ages across all time periods.
The last two columns to the right side of the Relativity table are charted.
An example of the relativity division of numbers is as follows:
Figure 83: Example of Accident Year Loss Severity
276BSeverity Relativity Age of Policies (in Months) 2001 Q1 0 – 12 1.103 ($6,329 / $5,737) 13 – 24 0.923 ($5,295 / $5,737) 25 – 36 1.018 ($5,841 / $5,737) 37 – 48 1.043 ($5,986 / $5,737) Over 48 0.681 ($3,907 / $5,737) Aggregate 1.000 ($5,737 / $5,737)
Figure 84: Example of Severity Relativity
Accident Year Loss Severity ($ per Loss)
Age of Policies (in Months) 2001 Q1
0 - 12 $6,329 13 – 24 $5,295 25 – 36 $5,841 37 – 48 $5,986 Over 48 $3,907 Aggregate $5,737
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 115
230BSummary
A Summary Selection filter on the Analysis Setup page determines how the Summary Requested results will be grouped and displayed.
NOTE
Frequency Aging and Frequency Relativity both use earned exposure data in their analysis. In the event that there is no exposure data present in the Warehouse you can disable these features by having your Insight administrator edit the thz3.ProductConfig table and set the ExposuresEnabled property to “false”. Once this property is turned off, the Frequency Agency and Frequency Relativity features will no longer appear under the Analysis menu. The Summary Selection filter will be disabled as well.
For further information, refer to Appendix A of the Insight Installation Guide.
To Generate a Summary:
1. Select the Line of Business.
2. Select the Filters and Metrics on the Setup page.
3. Click Summary. This places the Analysis Summary on the Monitor Summaries tab on the Dashboard.
As indicated in the screen message, the newly created Summary has been submitted and the result will be added to the Dashboard.
An e-mail notification is sent upon completion.
Figure 85: Summary Submittal Page
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 116
To return to the previous page, click the highlighted Back to Previous Page link located underneath the Summary Submitted box.
231BViewing Summary on Dashboard
You can view the Summary on the Dashboard on the Monitor Summaries tab. The Summary will be labeled according to the summary selection made during the Analysis Setup. In 498HFigure 107, the Summary Group is by Branch Office, with the date that the request was submitted.
To view the Summary, click on the link. Your Summary will be displayed on a separate screen.
For a Loss Monitor, there will be three tabs that contain the information you need:
• Loss Ratio
• Frequency
• Severity
Figure 86: Loss Monitor Summary by Branch Office – Loss Ratio Tab
On the Loss Ratio Tab, you will find:
• Calendar/Accident Year Case Incurred Loss Ratio (%) displays the Accident Year Incurred Loss divided by Calendar Year Earned Premium.
− Information on the Calendar/Accident Case Incurred Loss Ratio table is averaged along the bottom row. (Total Incurred Loss/Total Calendar Year Earned Premium)
• Age of Policies (in Months) - Policy ages display in bands of months (columns) to show results based on how long a policy has been in effect (columns).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 117
The Summary will be labeled according to the summary selection made during the Analysis Setup. In 499HFigure 108, the Summary Group is by Branch Office.
To view the Summary, click on the link. Your Summary will be displayed on a separate screen. Select the Tab you want to view.
Figure 87: Loss Monitor Summary by Branch Office – Frequency Tab
On the Loss Frequency Tab, you will find:
• Loss Frequency Per Exposure Unit - The accident month number of losses divided by the number of calendar month earned exposure units.
− Information on the last row on the Loss Frequency table is averaged. This is a division of the totals from the tables above to provide an average loss frequency for all data (Total Accident Month Number of Losses/Total Calendar Month Earned Exposure).
• Age of Policies (in Months) - Policy ages display in bands of months (columns) to show results based on how long a policy has been in effect (columns).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 118
The Summary will be labeled according to the summary selection made during the Analysis Setup, in 500HFigure 109, the Summary Group is by Branch Office.
To view the Summary, click on the link. Your Summary will be displayed on a separate screen. Select the Tab you want to view.
Figure 88: Loss Monitor Summary by Branch Office – Severity Tab
On the Loss Severity Tab, you will find:
• Accident Year Loss Severity ($ per Loss) displays the Accident Year Number of Losses divided by Accident Year Incurred Loss.
− Information on the Accident Year Loss Severity ($ per Loss) table is averaged along the bottom row. This is the division of total Accident Year Case Incurred Loss divided by the total Accident Year Number of Losses.
• Age of Policies (in Months) - Policy ages display in bands of months (columns) to show results based on how long a policy has been in effect (columns).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 119
71BRetention Monitor
Retention Monitor measures retention trends, such as, customer and agency loyalty, and the impact of retention tactics across all lines of business. Retention Monitor measures historical policy retention as of the month and year selected. Query results are grouped by originating month and can be filtered by who, what, when and where. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results. Outputs are displayed in table and graphical formats.
Figure 89: Retention Monitor Analysis Setup Screen
To begin, select analysis setup parameters.
The Analysis Setup is where you make the filter selections to organize data into pre-formatted output pages. Filter selections are organized in List Boxes.
Retention monitor offers filters for Who, What, When, Where and Summary Selections. User-defined selections can include Company, Branch, Producer, Line of Business, Class Code, State, and many more. Not making any filter selections means all data will be included in the data analysis.
After completing the Analysis Setup, click on the desired output page from left navigation panel.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 120
After selecting analysis criteria, choose the output format from the left hand menu.
The pages you can select are:
Scrap Rate Page 501H120
New Business Retention Page 502H123
Retention Trend Page 503H125
Tenured Retention Page 504H127
Summary – Only on the Setup page
Page 505H129
Also listed on the left hand menu are the options for saving, printing, sharing and additional information.
Save Page 506H163
Retrieve Page 507H164
Add to Dashboard Page 509H165
Create an Alert Page 510H168
Export to Excel Page 511H170
Print Page 512H170
Figure 90: Retention Monitor Side Menu 232B
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 121
Scrap Rate
The Scrap Rate page displays the counts and percentages of policies that became inactive during the first three months of a policy life. The first part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results. Results are displayed in table and graphical formats depicting the scrap rate trend.
Figure 91: Scrap Rate First 3 Months
Lost Policy information is based on an established Originating Month/Year, also known as, the book month, or the month in which the policy was entered into the processing system. The table rows are organized based on the End Date selected in the When filter during the Analysis Setup. This End Date is the last row shown and the rows above go back in time by 15 months to provide information on new business retention.
A chart is provided to represent the Scrap Rate (%) column in the table, which is the percentage of policies canceled during the first three months of a policy life.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 122
Definitions:
• Number of Lost Policies – a table for displaying the number of lost policies on a monthly basis. This table starts with the total policies issued for an ending period month and shows the number of policies that are no longer active.
− Originating Month/Year – the book month or the month the policy was entered into the processing system.
− Policies Issued – the total number of policies that were processed within the originating month.
− Originating Month – the number of policies that became inactive during the first month of policy life.
− Second Month – the number of policies that became inactive during the second month of policy life.
− Third Month – the number of policies that became inactive during the third month of a policy life.
− Total – a total of the number of policies lost within the first three months of a policy life. This is the sum of the Originating Month, Second Month, and Third Month columns.
− Policies Retained – the number of policies remaining active after the first three months of a policy life. This is calculated as the Total column subtracted from the Policies Issued column.
− Scrap Rate (%) – the percentage of policies canceled during the first three months of a policy life. This is calculated as the Policies Retained column divided by the Policies Issued column.
NOTE The Retention Monitor uses the original effective date to determine policies for Scrap Rate analysis.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 123
233BNew Business Retention
The New Business Retention page provides counts and percentages of new policies that remain active during quarterly time periods through 12 months. The first part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results. Results are displayed in table and graphical formats depicting the new business retention trend.
Figure 92: New Business Retention Page 12 Months
Lost Policy information is based on an established Originating Month/Year, also known as, the book month, or the month in which the policy was entered into the processing system. The table rows are organized based on the End Date selected in the When filter during the Analysis Setup. This End Date is the last row shown and the rows above go back in time by 24 months to provide information on new business retention to analyze. The information is illustrated in quarters showing the percentage of policies that are remaining active for each quarter. The quarterly percentages are then multiplied together to show the percentages and counts of the policies that are retained after a 12-month period.
Drill-down to policy level data by placing the cursor over any of the table figures and double clicking. Drill-down to display additional information, including name of insured; policy number; effective, expiration and originating dates; written and earned premium, and incurred loss ratio.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 124
A chart is provided to represent the Policies Remaining column in the table. The First Year Survival Ratio is the percentage of policies retained twelve months after the originating month/year, calculated by multiplying the first four quarters together.
Definitions:
• Policies Retained by Count & Percentage – This table displays the number of policies issued during the originating month/year, the percentage of policies lost during each of the four quarters, the total percentage of policies lost for a 12-month period from the originating month, and the number of policies remaining.
− Originating Month/Year – the book month or the month the policy was entered into the processing system. An End Date is selected, and the prior 24 months are displayed.
− Policies Issued – the number of policies entered into the processing system during the originating month/year.
− Originating Month to 3 Months (%) – the percentage of policies remaining at the end of three months.
− From 4 to 6 Months (%) – the percentage of policies remaining three months after the prior time period (Originating Month to 3 Months).
− From 7 to 9 Months (%) – the percentage of policies remaining three months after the prior time period (4 to 6 Months).
− From 10 to 12 Months (%) – the percentage of policies remaining three months after the prior time period (7 to 9 Months).
− Policies Remaining After 12 Months (%) – the percentage of policies retained twelve months after the originating month/year. This is calculated by the first four quarters being multiplied together.
− Policies Remaining After 12 months (Counts) – the number of policies retained twelve months after the originating month/year. This is calculated as "Policies Issued" times the "Policies Remaining After 12 Months (%)".
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 125
234BRetention Trend
The Retention Trend report provides the percentages of all policies that remain active during multiple time periods up to 48 months. The first part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results. Results are displayed in table and graphical formats depicting the retention trend.
Figure 93: Retention Trend 48 Months
Retained policy information is based on an established Originating Month/Year, also known as, the book month, or the month in which the policy was entered into the processing system. The table rows are organized based on the End Date selected in the When filter during the Analysis Setup. This End Date is the last row shown and the rows above go back in time by 15 months to provide information on retention to analyze.
A chart is provided to represent the percentages of the “New To 48-Months” column in the table. The 48 Month Survival Ratio is the percentage of policies remaining in force 48-months after the originating month/year, calculated by multiplying the previous five columns on the table together.
Definitions:
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 126
• Policies Remaining Active – This table displays the number of policies issued during the originating month/year, the percentage of policies remaining for the prior 15 months, and the total percentage of policies remaining after a 48-month period from the originating month.
− Originating Month/Year – the book month or the month the policy was entered into the processing system. An End Date is selected, and the prior 15 months are displayed in rows.
− New (Originating Month) to 6 Months (%) – the percentage of policies remaining at the end of six months.
− From 7 to 12 Months (%) – the percentage of policies remaining 6 months after the prior time period, New to 6 Months.
− From 13 to 24 Months (%) – the percentage of policies remaining 12 months after the prior time period, 7 to 12 Months.
− From 25 to 36 Months (%) – the percentage of policies remaining 12 months after the prior time period, 13 to 24 Months.
− From 37 to 48 Months (%) – the percentage of policies remaining 12 months after the prior time period, 25 to 36 Months.
− New to 48 Months (%) – the percentage of policies retained 48 months after the originating month/year. This is calculated by the multiplying the previous five columns together.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 127
235BTenured Retention
The Tenured Retention page provides policy counts and percentages of active policies over 48 months old (tenured) that remain in force at the end of any given measurement month/year. The first part of the page lists the report criteria based on selected filters. Policies meeting the user-defined criteria from the Analysis Setup page will be included in the results. Results are displayed in table and graphical formats depicting tenured retention.
Figure 94: Tenured Retention Over 48 Months
Tenured Retention policy information is based on an established Originating Month/Year, also known as, the book month, or the month in which the policy was entered into the processing system. The table rows are organized based on the End Date selected in the When filter during the Analysis Setup. This End Date is the last row shown and the rows above go back in time by 15 months to provide information on tenured retention to analyze.
The charts provided represent the Percentages columns in the table for policies Entering Tenure(%), Leaving Tenure(%) and Annual Retention Rate(%).
Definitions:
• Tenured Retention – This table shows the number of policies entering and leaving tenure. “Tenure” is defined as policies that are still active at least 48 months from when they first originated. Results are grouped by a measurement month and show the number of tenured policies at the beginning of the month, the number of policies entering tenure that month, the number of policies leaving tenure that month, and the number of tenured
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 128
policies at the end of the month. A separate table calculates percentages for the number of policies entering tenure (%), leaving tenure (%), annual retention rate (%) and net change (%)for each measurement month.
• Number of Tenured Policies – The table shows the number of policies at the beginning, entering, leaving, and at the end of tenure.
− Measurement Month/Year – the End Date is selected as the measurement and the prior 15 months display in rows.
− At the Beginning – the number of policies remaining active over 48 months at the beginning of the measurement month.
− Entering Tenure – the number of policies that are active for 49 months during the measurement month.
− Leaving Tenure – the number of tenured policies over 48 months that become inactive during the measurement month.
− At the End of Tenure – represents the following calculation:
♦ The number of tenured policies At the Beginning of the measurement month,
♦ PLUS the number of policies Entering Tenure,
♦ MINUS the number of policies Leaving Tenure during a given measurement month.
• Percentages – The table shows the percentages of policies entering and leaving tenure at both an Annual Retention Rate and a Net Change (%).
− Entering Tenure (%) – the percentage of policies that are already active over 48 months at the beginning of the measurement month. This is calculated as the Entering Tenure column divided by the At the Beginning column.
− Leaving Tenure (%) – percentage of tenured policies active over 48 months that become inactive during the measurement month/year. This is calculated as the Leaving Tenure column divided by the At the Beginning column.
− Annual Retention Rate (%) – percentage of tenured policies retained at the end of the measurement month. This is calculated as the number of policies Leaving Tenure column divided by the number of policies At the end of Tenure column minus 1.00 and multiplied to the twelfth power to annualize.
− Net Change (%) – percentage change in the number of tenured policies at the end of the measurement month. This is calculated as the Leaving Tenure (%) column minus the Entering Tenure (%).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 129
236BSummary
A Summary Selection filter on the Analysis Setup page determines how the Summary Requested results will be grouped and displayed.
To Generate a Summary:
1. Select the Line of Business.
2. Select the Filters and Metrics on the Setup page.
3. Click Summary. This places the Analysis Summary on the Monitor Summaries tab on the Dashboard.
As indicated in the screen message, the newly created Summary has been submitted and the result will be added to the Dashboard.
An e-mail notification is sent upon completion.
Figure 95: Retention Monitor Analysis
To return to the previous page, click the highlighted Back to Previous Page link located underneath the Summary Submitted box.
237BViewing Summary on Dashboard
You can view the results on the Dashboard on the Monitor Summaries tab. The Summary will be labeled according to the summary selection made during the Analysis Setup. In 513HFigure 117, Summary by Branch was selected with the date that the request was submitted.
To view the Summary, click on the link. Your Summary will be displayed on a separate screen.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 130
Figure 96: Retention Monitor Summary by Branch
• Scrap Rate (%) – The percentage of policies canceled during the first three months of a policy life. This is calculated as the Policies Retained divided by the Policies Issued.
• Policies Remaining After 12 Months (%) – The percentage of policies retained twelve months after the originating month/year. This is calculated by the first four quarters being multiplied together.
• Entering Tenure (%) – The percentage of policies that are already active over 48 months at the beginning of the measurement month. This is calculated as the Entering Tenure divided by the At the Beginning.
• Leaving Tenure (%) – Percentage of tenured policies active over 48 months that become inactive during the measurement month/year. This is calculated as the Leaving Tenure divided by the At the Beginning.
• Annual Retention Rate (%) – Percentage of tenured policies retained at the end of the measurement month. This is calculated as the number of policies Leaving Tenure divided by the number of policies At the end of Tenure minus 1.00 and multiplied to the twelfth power to annualize.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 131
72BProfile Monitor
Profile Monitor measures subtle changes in a book of business and enables you to profile specific characteristics of inforce, new and expiring business by line of business. You can create profiles that identify specific policy data attributes as indicators for growth and adverse selection, in order to compare these attributes between specific time periods, and to score the results against the profile to measure changes. Profile Monitor is often used to report on agency performance by setting specific goals for each agency and then reporting on the progress against plan on a monthly or quarterly basis.
Figure 97: Profile Monitor Main Screen
From the main screen you can:
• Retrieve a previous analysis
• Create a new analysis
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 132
238BCreating a New Analysis
Filters in Profile Monitor are unique to each supported line of business. Choose the line of business from the “Select Line of Business” screen. This will take you to the Analysis Setup screen for that particular Line of Business.
Figure 98: Profile Monitor Analysis Setup
The Analysis Setup screen is where you select from a list of filters to organize data outputs into pre-formatted report pages. Filter selections are organized into List Boxes.
Filters are segmented into Who, What, When, Where categories. The Summary Selections category is used to group data outputs when you choose Summary from the left navigation panel. The Summary function saves a pre-run analysis to your Dashboard with the data grouped by the Summary Selection. As with all Monitors, by not making any filter selections in Profile Monitor all data will be included in the report outputs.
Define the timeframe for the analysis by specifying Beginning and Ending months and years in the When filter. Period 2 is only used for Adverse Selection and the Attribute Overview report outputs to compare changes for the selected policy attributes between Period 1 and Period 2.
Once the filters have been selected on the Analysis Setup page, click on Profile Template from the left navigation panel to run your first report output.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 133
239BProfile Template
The Profile Template is where you set your preference for where you would like the current book of business to be for each attribute based on the current month’s Inforce Policy count. These attribute preferences become the basis for all report outputs in Profile Monitor. The top of the screen indicates the selected filters that are being measured and for what time period. All inforce policies meeting the criteria defined from the previous Analysis Setup page will be included in the results.
Figure 99: Profile Template Page
The Profile Template provides a breakdown of the current inforce policy count (Observed Count) and the percentage of the current inforce policy count (Observed Percent) by the filters selected from the Analysis Setup page. Use the interactive Profile Template page to set the Preference Direction and Preferred Percent for each attribute based your preferred breakdown of the current inforce policies.
An easy-to-understand scoring system provides a quick comparison between the preferred ratings and the current inforce data to determine how closely the business characteristics match the preferred profile characteristics. Results are displayed in the Observed Rating column.
To establish the Profile Template settings:
1. Click the Preference Direction arrow boxes to either up, down or horizontal depending on the preference for more change, less change or a neutral change in each attribute value.
2. Enter the Preferred Percent based on the Observed Count and Observed Percent figures.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 134
NOTE The Preferred Percent numbers you enter must total 100%.
Figure 100: New Entries to Profile Template
NOTE When making changes to the Profile Template page, a warning message will appear in the center of the screen. This is a reminder to rescore the page to display accurate data.
3. Click the Rescore Observed Rating button to score the profile settings against the current month inforce business.
• White means that the Preferred profile closely matches the Observed profile
• Red means the Preferred profile does not closely match the Observed profile
• Green means the Preferred profile exceeds the Observed profile.
4. After Preference Direction and Preferred Percent settings have been established select one of the pre-formatted output reports by clicking the report name in the left navigation panel.
5. The preference settings can be applied to multiple attributes using the Profile Template, but only one at a time
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 135
Figure 101: Rescored Profile Template
240BDefinitions
• Inforce Business (Current Month) – This table displays the selected profile characteristics in rows and provides columns that allow for setting preferences or goals for each attribute value. A display of attribute values selected from current month Inforce Business is provided to help establish goals.
• Attribute Value – Each row displays the attribute values or profile characteristics selected from the Analysis Setup screen.
• Preference Direction – This setting allows more refined scoring of individual profile characteristics based on preferences relating to the Preferred Percent as follows:
− Up Arrow – indicates a preference for the preferred percent to be exceeded,
− Horizontal Arrow – indicates no preference above or below the preferred percent,
− Down Arrow – indicates a preference to be less than the preferred percent.
• Observed Count – Observed Count – The number of inforce policies for a specific attribute.
• Observed Percent – The percentage of inforce policies for a specific attribute versus all inforce policies.
• Preferred Percent – User preferred percentage of inforce policies versus current inforce policies for the selected profile characteristic.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 136
• Preferred Count – Derived for each profile characteristic by multiplying the Preferred Percent by the total Observed Count column.
• Observed Rating – A scorecard comparing the Observed Percent to a combination of the Preferred Percent and Preference Direction. The best rating is +4 and the worst rating is –4, while 0 is neutral.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 137
After selecting analysis criteria and entering Profile Templates, choose the output format from the left navigation menu.
Profile Monitor provides a variety of pre-formatted output options to meet specific needs. Data can be exported to a spreadsheet application, added to the Dashboard, shared via E-mail, and set as Alerts.
The page options are:
Variation from Profile Page 514H138
Adverse Selection Page 515H140
Attribute Overview Page 516H142
Summary Page 517H144
The left navigation panel includes additional options.
Save Page 518H163
Retrieve Page 519H164
Add to Dashboard Page 521H165
Create an Alert Page 522H168
Export to Excel Page 523H170
Print Page 524H170
Figure 102: Profile Monitor Side Menu
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 138
241BVariation From Profile
Variation from Profile provides a comparison between the preference settings and observed rating from the Profile Template for New and Expiring business. The top of the screen indicates the selected filters that are being measured and for what time period. All inforce policies meeting the criteria defined from the previous Analysis Setup page will be included in the results.
Figure 103: Variation From Profile
242BDefinitions
• Attribute Value – Each row displays the attribute values or profile characteristics selected from the Analysis Setup screen.
• Preference Direction – This setting allows more refined scoring of individual profile characteristics based on preferences relating to the Preferred Percent as follows:
− Up Arrow – indicates a preference for the preferred percent to be exceeded
− Horizontal Arrow – indicates no preference to be above or below the observed percent
− Down Arrow – indicates a preference to be less than the observed percent.
• Observed Count – The number of inforce policies for a specific attribute.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 139
• Observed Percent – The percentage of inforce policies for a specific attribute versus all inforce policies.
• Preferred Percent – User preferred percentage of inforce policies versus current inforce policies for the selected profile characteristic.
• Preferred Count – Derived for each profile characteristic by multiplying the Preferred Percent by the total Observed Count column.
• Observed Rating – A scorecard comparing the Observed Percent to a combination of the Preferred Percent and Preference Direction. The best rating is +4 and the worst rating is –4, while 0 is neutral.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 140
243BAdverse Selection
Adverse Selection measures variation between the preference settings and observed rating from the Profile Template between the two time periods (Period 1 and 2) defined on the Analysis Setup screen. The top of the screen indicates the selected filters that are being measured and for what time period. All inforce policies meeting the criteria defined from the previous Analysis Setup page will be included in the results.
The Composite Score provides a scoring system that compares the four different analyses to measure Adverse Selection and Change in Profile between the two time periods.
Figure 104: Adverse Selection
Definitions:
• New and Expiring Business Tables
− New Business & Expiring Business – Results are displayed separately for new and expiring business, as well as, the two time periods selected.
− Attribute Value – Each row displays the selected attribute values.
− Count – The actual number of policy attributes meeting the profile characteristic described on the row, displayed separately as New and Expiring Business, Time Periods 1 and 2.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 141
− Percent – The actual percent of each characteristic count grouped by selected profile characteristics, displayed separately as New and Expiring Business, Periods 1 and 2. This is calculated as the characteristic count divided by the total count in that column.
• Composite Score Table – A score is developed with the best rating of +4 and the worst rating of -4 based on the Percent columns compared to a combination of Preferred Percent and Preference Direction in the Profile Template. The following comparisons are scored:
− Measuring Adverse Selection
♦ New Business Plus Expiring Business Period 1
♦ New Business Plus Expiring Business Period 2
− Measuring Change in Profile
♦ New Business Period 1 vs Period 2
♦ Expiring Business Period 1 vs Period 2
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 142
244BAttribute Overview
The Attribute Overview page returns the scoring ratings derived from the criteria on the Variation from Profile and Adverse Selection pages. A Composite Weight is applied to each attribute to generate a composite score for each output. The top of the screen indicates the selected filters that are being measured and for what time period. All inforce policies meeting the criteria defined from the previous Analysis Setup page will be included in the results.
Adverse Selection Columns – Scorings for each attribute are provided from the Composite Score found at the bottom of the Adverse Selection screen.
Change in Profile Columns – Scorings for each attribute are provided from the New and Expiring Business tables found on the Variation from Profile screen.
The Composite Weight column allows you to apply percentage weights to each attribute. This only affects the composite score on the bottom Composite row. If the selected percentages are changed, click the Rescore Composite Ratings button. The Composite row must total 100%.
Figure 105: Attribute Overview
Definitions
• Attribute – Each row displays observed ratings from every attribute established with preferences on the Profile Template page.
• Composite Weight – This column provides the option to input a numeric value to each attribute allowing for a score that is composite weighted for all attributes. Each attribute is weighted based on its importance in relation to all other attributes giving a clearer picture of the overall measurement of the total book of business.
• Adverse Selection Columns
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 143
− New Business + Expiring Business Period 1 – This column displays the New + Expiring Business observed ratings from the Adverse Selection page (for Period 1).
− New Business + Expiring Business Period 2 – This column displays the New + Expiring Business observed ratings from the Adverse Selection page (for Period 2).
• Change in Profile Columns
− New Business Period 1 Vs Period 2 – This column displays New Business observed ratings from the Adverse Selection page (for Period 1 vs. Period 2).
− Expiring Business Period 1 Vs Period 2 – This column displays Expiring Business observed ratings from the Adverse Selection page (for Period 1 vs. Period 2).
• Variation Columns
− New Business – This column displays the observed rating for New Business from the Variation from Profile page.
− Expiring Business – This column displays the observed rating for Expiring Business from the Variation from Profile page.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 144
245BSummary
A Summary Selection filter on the Analysis Setup page determines how the Summary Requested results will be grouped and displayed.
To Generate a Summary:
1. Select the Line of Business.
2. Select the Filters and Metrics on the Setup page.
3. Click Summary. This places the Analysis Summary on the Monitor Summaries tab on the Dashboard.
As indicated in the screen message, the newly created Summary has been submitted and the result will be added to the Dashboard.
An e-mail notification is sent upon completion.
Figure 106: Summary Page
To return to the previous page, click the highlighted Back to Previous Page link located underneath the Summary Submitted box.
246BViewing Summary on Dashboard
You can view the results on the Dashboard on the Monitor Summaries tab. The Summary will be labeled according to the summary selection made during the Analysis Setup, in 525HFigure 128 Summary by Underwriting Company was selected, with the date that the request was submitted.
To view the Summary, click on the link. Your Summary will be displayed on a separate screen.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 145
Figure 107: Profile Monitor Summary by Underwriting Company
A score is developed with the best rating of +4 and the worst rating of -4, based on the Percent columns compared to a combination of Preferred Percent and Preference Direction in the Profile Template. The following comparisons are scored:
• Adverse Selection Columns
− New Business + Expiring Business Period 1 – This column displays the New + Expiring Business observed ratings from the Adverse Selection page (for Period 1).
− New Business + Expiring Business Period 2 – This column displays the New + Expiring Business observed ratings from the Adverse Selection page (for Period 2).
• Change in Profile Columns
− New Business Period 1 Vs Period 2 – This column displays New Business observed ratings from the Adverse Selection page (for Period 1 vs. Period 2).
− Expiring Business Period 1 Vs Period 2 – This column displays Expiring Business observed ratings from the Adverse Selection page (for Period 1 vs. Period 2).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 146
• Variation Columns
− New Business – This column displays the observed rating for New Business from the Variation from Profile page.
− Expiring Business – This column displays the observed rating for Expiring Business from the Variation from Profile page.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 147
73BClaims Monitor
Claims Monitor measures key claim facts, such as loss reserve accuracy and changes over time, claim expense, time lag and recovery factors to help you establish claim service standards and develop claim operations excellence.
Results are grouped into specific bands. These bands are grouped either by amount of the incurred loss amount (based upon user preference) or specific time frames, usually beginning with the date on which the claim is reported.
Figure 108: Claims Monitor Analysis Page
247BCreating a New Analysis
The Analysis Setup is where you make the filter selections to organize data into categories to include in the pre-formatted reports. Filter selections are organized into List Boxes.
Claims Monitor has the ability to organize the data from the Who, What, When, Where, Loss Summary Selections and Band Parameters filters.
Define the beginning and ending month/year timeframes for the new analysis in the When filter.
Establish the timeframes in three steps:
• Claims Reported From – enter the Beginning and Ending dates for the period of time to be analyzed, typically one month or one quarter.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 148
• Claims Valued as of 1st Valuation Date – set the date to capture the Loss Reserves as of the end of the month entered, typically the same date as the Claims Reported From Ending month/year entry.
• Claims Valued as of 2nd Valuation Date – set a second date to capture the Loss Reserves at the end of the second month entered for the timeframe established in the Claims Reported From section.
• Always Current – checkmark the box for the analysis saved on the Dashboard to be updated to current load date for monitoring Loss Reserves.
Figure 109: Band Parameter Setup
Band Parameter Setup, located at the bottom of the Analysis Setup page, is used to set the Claim Band values for an analysis. The default band ranges are shown above.
Band values can be set through manual entry or by entering a value in any Band and clicking the Auto-Fill button to have Insight calculate the values.
Click Reset to clear the fields to set new band parameters.
Click Submit to have the band values enabled.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 149
248BBand Locations
Claims Status
Claim Bands
Case Incurred
Loss Amounts
Or Claim Counts
Sector Change
Sector Drift
Total Drift
Legend
Upward,
Downward or
Neutral Change
by Band
Figure 110: Band Location Chart
Color coded bands represent under-reserved claims movement in red tones and over-reserved claims movement in blue tones. Values remaining within the band have no movement and are displayed without color. The yellow block highlights the Total Drift.
The drill-down function provides details of the underlying claims, including, insured name, claim number, policy number, adjuster and total incurred loss amount.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 150
After selecting the analysis criteria and band values, choose the output format from the left hand menu.
The pages you can select are:
Loss Reserve Accuracy
- By Dollar Amount Page 526H150
- By Claim Amount Page 527H153
Inflation rate Page 528H156
Claim Expense Page 529H157
Salvage & Subrogation Page 530H159
Time Lag Measurements Page 531H161
Also listed on the left hand menu are the options for saving, printing, sharing and additional information.
Save Page 532H163
Retrieve Page 533H164
Add to Dashboard Page 535H165
Create an Alert Page 536H168
Export to Excel Page 537H170
Print Page 538H170
Figure 111: Claims Monitor Side Menu 249B
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 151
Loss Reserve Accuracy – By Dollar Amount
Loss Reserve Accuracy measures incurred loss changes, reflecting reserve accuracy between two evaluation periods, typically claims reported month and a future month. The results are grouped by claims status and the bands represent dollar amounts of incurred loss. The first part of the page lists the report criteria based on selected filters. Claims meeting the user-defined criteria from the Analysis Setup page will be included in the results.
Figure 112: Loss Reserve Accuracy – By Dollar
250BBand Definitions
• Claim Bands – Separates incurred losses by ranges of dollar amounts.
• Claim Status – Provides results for open, closed and total claims.
• Case Incurred Loss Amounts – Provides results at two-valuation dates and displays the total change.
• Total Change – Results are totaled by sector to summarize movement.
• Upward Change by Number of Bands – Displays total incurred loss amounts by upward movement within the bands at the second evaluation date. Individual policies can
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 152
be reviewed by clicking on the total amounts in each band. Bands are color-coded for moderate to significant upward movement.
• Downward Change by Number of Bands – Displays total incurred loss amounts by downward movement within the bands at the second evaluation date. Individual policies can be reviewed by clicking on the total amounts in each band. Bands are color-coded for moderate to significant downward movement.
• Remaining within Band – Displays total incurred loss amounts that remain within each band at the second evaluation date. Individual policies can be reviewed by clicking on the total amounts in each band.
• Sector Change – Displays total incurred loss amounts by significant or moderate upward or downward movement, or no movement.
• Total Drift – Total movement within all bands, calculated as the sum of all sector changes.
• Legend – Results are separated by sector and color-coded based on the extent of change.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 153
251BLoss Reserve Accuracy – by Claim Count
Loss Reserve Accuracy measures incurred loss changes, reflecting reserve accuracy over time. The results are grouped by claims status and bands represent claim counts. The first part of the page lists the report criteria based on selected filters. Claims meeting the user-defined criteria from the Analysis Setup page will be included in the results.
Figure 113: Loss Reserve Accuracy – By Claims
252BBand Definitions
• Claim Bands – Separates claim counts based on total incurred losses by ten incremental ranges of dollar amounts established during the Analysis Setup.
• Claim Status – Provides results for open, closed and total claims.
• Claim Counts – Provides results at two valuation dates and displays the claim count.
• Total Change – Results are totaled by sector to summarize movement.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 154
• Upward Change by number of Bands – Displays claim counts based on total incurred loss amounts by upward movement within the bands at the second evaluation date. Individual policies can be reviewed by clicking on the total amounts in each band. Bands are color-coded for moderate to significant upward movement.
• Downward Change by number of Bands – Displays claim counts based on total incurred loss amounts by downward movement within the bands at the second evaluation date. Individual policies can be reviewed by clicking on the total amounts in each band. Bands are color-coded for moderate to significant downward movement.
• Remaining within Band – Displays claim counts based on total incurred loss amounts that remain within each band at the second evaluation date. Individual policies can be reviewed by clicking on the total amounts in each band.
• Sector Change – Displays total claim counts by significant or moderate upward or downward movement, or no movement.
• Sector Drift – Displays sector totals for Significant Upward, Moderate Upward, Moderate Downward and Significant Downward weighted to show total movement within each sector. This is calculated by the absolute value of the sector change (+2 Upward Change = 2, -2 Downward Change = 2) times the claim count within that band times 100. That result is then divided by the total of all changes from the sector change column, including the amount Remaining Within Band.
• Total Drift – Total movement within all bands, calculated as the sum of all sector changes.
• Legend – Results are separated by sector and color-coded based on the extent of change.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 155
253BLoss Reserve Accuracy – Claim Detail
During review, you may require the ability to identify the individual claims contained in a band and drift. By selecting the cell, a second browser opens and provides a claim listing.
The details will include the following type of information:
• The selected filters
• The selected row
• The selected column
• Claim details – including claim number ID, policy number, loss date, use of business description, adjuster number, adjuster name, named insured, loss reserve amount and incurred loss amount
Figure 114: Policy Detail for Loss Reserve Accuracy
Available Options:
• Print – Using a regular printer
• Export to Excel – Send this information to a Microsoft Excel spreadsheet, to share information with others in the organization.
Click Close Window at the bottom of the page to close the page.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 156
254BInflation Rate
Inflation rate measures the historical increases or decreases in the cost of settling claims by displaying the number and cost of claims by incurred loss bands over time. The first part of the page lists the report criteria based on selected filters. Claims meeting the user-defined criteria from the Analysis Setup page will be included in the results.
Figure 115: Inflation Rate Page
Inflation Summary displays four years of data up to the selected end date and reflects the average incurred amount for each year and the percentage of change from the prior year. The Claims Counts and Incurred Loss Values are displayed by Band by Range with Totals.
Band Definitions
• Claim Counts and Incurred Loss Values by Band – Separates claim counts and total incurred losses by ten incremental ranges of dollar amounts that are determined during Analysis Setup. Time periods are selected end-month/year and prior three year-ends.
• Counts by Band – Summarizes the number of claims for prior periods by bands of ten incremental ranges of dollar amounts that are determined during Analysis Setup. Time periods are selected end-month/year and prior three year-ends.
• Percentage of Claim Counts by Band – Provides the percentage of claim count by selected band amounts in each year. This is calculated by dividing Counts by Band ranges by Totals column for that year.
• Burning Costs by Brand – Separates claim to date (burning costs) incurred amounts by ten incremental ranges of dollar amounts that are determined during Analysis Setup. Time periods are selected end-month/year and prior three year-ends.
• Percentage of Claim Cost by Band – Provides the percentage of claim cost by selected band amounts in each year. This is calculated by dividing Burning Costs by Band ranges by Totals column for that year.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 157
255BClaim Expense
An average claim expense for losses is established based on the amount of time since the claim was reported. The first part of the page lists the report criteria based on selected filters. Claims meeting the user-defined criteria from the Analysis Setup page will be included in the results. Results are displayed in a graphical chart depicting claim expense trends.
Figure 116: Claim Expense Page
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 158
Claim Expense (by Year/Quarter/Month)
Displays claims expense information based on Report Year/Quarter/Month and Age of Claims. The ending month/year is selected, and time period options in the Analysis Setup include:
• Report Year – The year in which the claim was incurred, with selected month/year and prior seven year-ends.
• Report Quarter – The quarter in which the claim was incurred, with selected month/year and prior seven quarters.
• Report Month – The month in which the claim was incurred, with selected month/year and prior seven months.
Age of Claims is organized into four time periods:
• 0-12 months
• 12-24 months
• 25-36 months
• Over 36 months
These time periods reflect the time passed since the claim was incurred. Results are displayed in $000’s and counts:
• Claims with Expense Payments ($000’s) – Dollar amount of expense payments made.
• Claims with Loss Payments ($000’s) – Dollar amount of loss payments made.
• Expense Payments ($000’s)/ Loss Payments ($000’s) – Expressed as a percentage of expense payments to total loss payments calculated by dividing Claims with Expense Payments ($000's) by Claims with Loss Payments ($000's).
• Claims with Expense Payments (Counts) – Number of claims with expense payments made.
• Claims with Loss Payments (Counts) – Number of claims with loss payments made.
• Expense Payments (Counts)/ Loss Payments (Counts) – Expressed as a percentage of claims with expense payments to total claims with loss payments calculated by dividing Claims with Expense Payments (Counts) by Claims with Loss Payments (Counts).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 159
256BSalvage & Subrogation
Establishes an average salvage and subrogation (recovery) rate for losses based on the amount of time since the claim was reported. The average is established on a percentage of total recoveries compared to payments and the number of claims with recoveries (frequency). The first part of the page lists the report criteria based on selected filters. Claims meeting the user-defined criteria from the Analysis Setup page will be included in the results. Results are displayed in a graphical chart depicting claim expense trends.
Figure 117: Salvage & Subrogation Page
Salvage and Subrogation (by Year/Quarter/Month)
Displays recovery information based on Report Year/Quarter/Month and Age of Claims. The ending month/year is selected, and time period options in the Analysis Setup include:
• Report Year – The year in which the claim was incurred, with selected month/year and prior seven year-ends.
• Report Quarter – The quarter in which the claim was incurred, with selected month/year and prior seven quarters.
• Report Month – The month in which the claim was incurred, with selected month/year and prior seven months.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 160
Age of Claims is organized into four time periods:
• 0-12 months
• 12-24 months
• 25-36 months
• Over 36 months
These time periods reflect the time passed since the claim was incurred. Results are displayed in $000’s and counts:
• Claims with Salvage and Subrogation Payments ($000’s) – Dollar amount of recovery payments made.
• Claims with Loss Payments ($000’s) – Dollar amount of loss payments made.
• Salvage and Subrogation Payments ($000’s) / Loss Payments ($000’s) – Expressed as a percentage of recovery payments to total loss payments calculated by dividing Claims with Recovery Payments ($000's) by Claims with Loss Payments ($000's).
• Claims with Salvage and Subrogation Payments (Counts) – Number of claims with recovery payments made.
• Claims with Loss Payments (Counts) – Number of claims with loss payments made.
• Loss Expense (Counts)/ Loss Payments (Counts) – Expressed as a percentage of claims with recovery payments to total claims with loss payments calculated by dividing Claims with Recovery Payments (Counts) by Claims with Loss Payments (Counts).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 161
257BTime Lag Measurements
The time lag measurement determines the expediency in reporting losses and closing claims. Established targets are used to measure the number of days from Accident Date to Report Date and Accident Date to Closure Date. The results are measured based upon the number and percentage of claims that exceed target. The first part of the page lists the report criteria based on selected filters. Claims meeting the user-defined criteria from the Analysis Setup page will be included in the results.
Figure 118: Time Lag Measurements
258BTime Periods
Ending month/year is selected, and time period options include:
• Time Period (by Years) – The year in which the claim was incurred, with selected month/year and prior 4 year-ends.
• Time Period (by Quarters) – The quarter in which the claim was incurred, with selected month/year and prior 16 quarters.
• Time Period (by Months) – The month in which the claim was incurred, with selected month/year and prior 48 months).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 162
259BMeasurement of Time Lags
The average number of days from either accident date to report date, or report date to closure date is displayed compared to the selected target number of days. Adjust the target level by entering a new number into either target box and click the Rescore Time Lag button.
These results are broken into eight columns of averages and percentages:
• Average Number of Days from Accident Date to Report Date.
• Target – Selected average number of days from accident date to report date for comparison to the actual average.
− Number of Claims Exceeding Target.
− Percentage of Claims Exceeding Target.
• Average Number of Days From Report Date to Closure Date.
• Target – Selected average number of days from report date to closure date for comparison to the actual average.
− Number of Claims Exceeding Target.
− Percentage of Claims Exceeding Target.
260BBand Definitions
• Claim Status – Provides results for years, quarters or months.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 163
35BOutput Selections
Saving an Analysis
To save an analysis for later use, click “Save” from the left hand menu.
The following popup box will appear.
Figure 119: Saving an Analysis
Enter in an Analysis Name and click Save. The analysis will be saved.
Figure 120: Naming a Saved Analysis
If this is not the analysis to be saved, click Cancel to return to the previous page.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 164
261BRetrieve
Analyses that are used periodically can be saved for future use. To retrieve a previously saved analysis, click on Retrieve in the side menu. A popup box will display the Analyses available, the User Name of the person who saved each analysis and the date of the last update.
Analyses are saved with the last filters and metrics chosen. When retrieving a saved analysis, the data displayed will represent the most current period, unless a prior period has been specified.
If this is not the screen you wanted, click the highlighted Cancel to be returned to the previous screen.
Figure 121: Retrieve Saved Analysis
Click on the highlighted analysis name to display the analysis on the screen.
Delete unnecessary analyses by marking the check box in front of the Analysis Name and clicking the highlighted Delete at the top or bottom of the box. A popup window will confirm the deletion.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 165
262BAdd to Dashboard from within an Application
Click Run before saving an analysis or adding it to the Dashboard. Click on Add to Dashboard from left side menu.
The Dashboard Wizard will be displayed in a separate screen.
Save the entire segment by checking the box on the far right side.
Enter in any scoring that may be needed.
Figure 122: Dashboard Wizard for Saving Pages
263B
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 166
Adding to the Dashboard Using the Wizard (including Scoring)
By assigning a score to a table, trends and goals can be more easily seen. Whichever cell or cells are selected in the Table will be scored when numbers have been entered into the Numeric Score Selections table. You can set the floor and ceiling levels for key performance indicators. The system automatically delivers an alert via e-mail and places an alarm on your Dashboard when these levels are triggered.
Figure 123: Adding Scoring to the Dashboard
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 167
1. Begin by selecting the criteria to be displayed on the Dashboard. Select specific columns or rows of data, specific tables, or one specific item. Multiple sections of data may be selected.
2. Next assign any scoring. By assigning a score to a table, trends and goals can be more easily noticed. Whichever cell or cells are selected in the Table will be scored when numbers have been entered into the Numeric Score Selections table. You can set the floor and ceiling levels for key performance indicators.
a. Enter the top and bottom scores at each end of the table and click the “Auto-Fill” button to have the application pro rate the number scores in the table as an added convenience.
b. The Data may include “Add Selected Filters Table to Dashboard”, or other “Add” properties that will allow you to add a graphic number and score between –4 and +4.
3. After making selections, enter in a Title for the analysis.
4. Click the Finish button and the analysis will be placed on the Dashboard on the My Analysis tab. This analysis will be updated to add each additional month as new data becomes available.
If this is not the analysis you want to save, click Cancel in the lower right hand corner to be returned to the previous page.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 168
264BCreate an Alert Via the Alert Wizard
An alert wizard is created to help set the alert parameters.
Figure 124: Alert Wizard
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 169
When you click Create an Alert on the left side menu, an Alert Wizard popup window will be displayed. This wizard is a mirror image of the page that sets the alert and allows multiple cells to be selected as alert triggers. When an alert parameter has been exceeded, you will be informed.
• Make selections either by checking the section title or selecting the individual check boxes. In the example, New Business was selected.
• Next set the Monthly Alert Selections located in the gray box directly underneath.
− Choose the relationship:
♦ > greater than
♦ >= greater than or equal to
♦ < less than
♦ <= less than or equal to
• Choose the value. Enter in any numeric value.
• Select who will be notified. Click on the E-mail button on the far left. A separate popup box will appear.
Figure 125: Alert E-mail screen
♦ Select the recipient’s name. You can select one or all.
♦ Enter in the subject line text.
♦ Enter in the message text.
♦ Click Submit. You will be returned to the Alert Wizard.
• After finalizing the selections, enter in a Title for the analysis. This can be found in the bottom left hand of the page.
• Click the Finish button and the analysis will be placed on the Dashboard under the Alerts section. This analysis will be updated to add each additional month as new data becomes available.
The alert exists on the Dashboard as a one-line entry showing the user defined name and date created. When the alert parameter is exceeded, an e-mail is forwarded to the creator and anyone else specified.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 170
If this is not the correct analysis to save, click Cancel in the lower right hand corner to be returned to the previous page.
265BExport to Microsoft Excel
You can export to a Microsoft Excel spreadsheet. Insight generates a CSV (Comma Delimited) file, providing data in a detailed data based on the selections in the analysis. The CSV file can be exported to a Microsoft Excel spreadsheet for additional analysis or to share with other members of the organization.
Figure 126: An Analysis in an Excel Spreadsheet
• To Export to a Microsoft Excel spreadsheet, click the Export to Microsoft Excel located on the left side menu.
• You will be asked if you want to save this or open it.
• To save, click the Save button and save this the same as any other Microsoft Excel spreadsheet.
• To open, click the open button. Your excel program will open and your data will be displayed in a spreadsheet that you can work with as you would with any Microsoft Excel spreadsheet.
NOTE You must have Microsoft Excel installed on your system to use this feature.
266BPrinting
The option to print is available on many pages in the Insight Monitor.
267BTo Print
• Click the Print button on the left hand menu. A separate popup window will be displayed with the requested page.
• Click on the highlighted Print this Window found at the bottom of the page.
If this is not the page you intended to print, click to highlighted Close Window to be returned to the previous page.
74B
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 171
36BWarning Messages
If available data does not fit the criteria selected, the page will be returned with a warning message placed at the top.
Figure 127: No Data Warning Message
The message will state why the request could not be fulfilled and will provide instructions on how to proceed.
For Example: “There was no data matching your selections. Please make new selections and try again.”
Warning message instructing you to rescore will appear in a red box located in the center of the page. The message will instruct you to click the Rescore Observed Rating button.
Figure 128: Rescore Warning Message
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 172
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 173
15BAppendix A
16BAvailable Reports
There is a wide range of available reports for many different departments. Below is a listing of the current available reports. Not all companies will have all of the listed reports. If it is not a written line of business, there will not be any need for the report nor will data be available to populate the report.
Report Name Frequency Target Audience Description
Agency Experience by Policy Year
Monthly Production
This report provides direct premium and loss experience based on all producers. This report provides Underwriting and Marketing Executives with loss experience results for direct business by producer. It helps to identify production sources that are most profitable and take steps in evaluating the type of business these producers are providing the company.
Agent Retention by Agent
Monthly Production
This report provides Production Staff and Executives with a summary of direct, ceded, and assumed premiums and the retention percent for each company and for each month of the calendar year. This report provides a comparison of Commission amounts on Direct, Ceded, and Assumed Premium and a Net Premium Retention Percentage by company.
Business Indicator by Producer
Monthly Comparison Executive
This report provides Underwriting, Marketing, Agency and Product Managers with the ability to compare and measure New Business, In Force and Retention statistics for current and previous time periods. Determine the trend of Current Month/Quarter/Year statistics for significant business indicators measuring size and growth of a book of business using this report.
Business Indicator by Underwriter
Monthly Comparison Executive
This report provides Underwriting, Marketing, Agency and Product Managers with the ability to compare and measure New Business, In Force and Retention statistics for current and previous time periods. Determine the trend of Current Month/Quarter/Year statistics for significant business indicators measuring size and growth of a book of business using this report.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 174
Report Name Frequency Target Audience Description
Business Trend by Company
Year To Date Production
This report provides trended results over the time dimension being analyzed. The Production Staff can identify operating results trended by month and broken down by line of business on a year to date basis. Trended summarized monthly results for all companies can be reviewed as well as specific months by Company.
Business Trend by Producer
Year To Date Production
This report provides trended results over the time dimension being analyzed. Use this report to identify trended operating results by Producer.
Business Trend by Underwriter
Year To Date Production
This report provides trended results over the time dimension being analyzed. The Underwriting and Management Staff can use this report to identify trended operating results for each month and view a monthly break down by Underwriter.
Catastrophe Claims by Catastrophe Description
Monthly Claims
This report provides Claims and Financial Staff with a detailed listing of claims that result from catastrophic events to assure proper claims staff workloads and reinsurance recoveries are obtained from catastrophic events.
Catastrophe Claims by Company
Monthly Claims
This report provides Underwriting, Financial, and Claims Executives with the costs related to losses resulting from an identified catastrophe. An analysis of claim costs attributable to an identified catastrophes. The report is used to monitor potential reinsurance recoveries, the number of needed claims adjusters and their locations.
Catastrophe Claims by Line of Business
Monthly Claims
This report provides costs related to losses resulting from an identified catastrophe to Underwriting, Financial, and Claims Executives. An analysis of claim costs attributable to an identified catastrophes. The report is used to monitor potential reinsurance recoveries, the number of needed claims adjusters and their locations.
Catastrophe Claims by Reinsurance Company
Monthly Claims
This report provides Underwriting, Financial, and Claims Executives with the costs related to losses resulting from an identified catastrophe. It is an analysis of claim costs attributable to an identified catastrophe. The report is used to monitor potential reinsurance recoveries, the number of needed claims adjusters and their locations.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 175
Report Name Frequency Target Audience Description
Claim Activity for all Producers
Monthly Claims Provides Claims with a detailed report of Allocated Loss Adjustment Expenses on claims.
Claim Expense Analysis Summary
Monthly Claims
Provides Claims and Actuarial with a detailed report of Allocated Loss Adjustment Expenses on claims. An analysis to assure proper management of Allocated Loss Adjustment Expenses is in compliance with targeted expense goals. The analysis allows for calculations of proper expense loading in rating factors.
Claim Feature by Adjuster Monthly Claims
This report provides a detailed listing of claims within the specified period to give Claims Staff an analysis of staffing and workload requirements to assure claims’ performance measurements are achieved.
Claims in Litigation by Adjuster
Monthly Claims
This report provides claims currently in litigation to identify, monitor, and manage litigation expenses. Claim Executives can analyze litigated claims to identify, monitor, and manage litigation expenses. Claim strategies can be developed to assure the cost effectiveness of litigating claims by measuring the cost of defending lawsuits in comparison to the Loss Reserves.
Claims in Salvage Summary
Monthly Claims
This report provides claims that involving salvage to identify, monitor, and manage salvage recovery. Claims Staff can analyze salvage claims to identify, monitor, and manage recovery. Claim strategies can be developed to assure the recovery rates are established and recognized within total incurred losses. These recoveries impact loss costs analysis and establishing proper rates.
Claims in Subrogation Summary
Monthly Claims
This report provides claims that involving Subrogation to identify, monitor and manage subrogation recovery. Claims Staff can analyze subrogation claims to identify, monitor, and manage recovery. Claim strategies can be developed to assure the recovery rates are established and recognized within total incurred losses. These recoveries impact loss costs analysis and establishing proper rates.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 176
Report Name Frequency Target Audience Description
Company and Line of Business Summary
Monthly Executive
This report provides a summary of premiums and losses for each company and line of business during the current month of the calendar year. This report allows executive to compare results by company and line of business for each month.
Company and State Summary by Month
Year To Date Executive
This report provides a summary of premiums and losses for each company and exposure state for each month to date of the calendar year. The report allows executives to compare results by company for each exposure state, which are trended to show YTD results.
Executive Summary-Line of Business by Month
Year To Date Executive
This report provides an in depth review of Premium and Loss information formatted to easily show YTD results by trending monthly information of premiums and losses by Company and Line of Business. This report helps Executives and Production Personnel identify potential trends by grouping monthly data, allowing easy evaluation of trends and patterns and quick identification of exceptional data.
Governing State Analysis for Commercial Lines
Monthly Executive
This report provides a summary of premiums, losses and policy activity for all commercial lines. Data is provided for each company and governing state aggregated each month of the calendar year. This report allows Executives and Management to compare results by company for each governing state, which are broken down by each Commercial Line of Business to show YTD results. New and Renewal Business can be compared to total premium amounts.
Governing State Analysis for Personal Lines
Monthly Executive
This report provides a summary of premiums, losses and policy activity for all personal lines. Data is provided for each company and governing state aggregated each month of the calendar year. This report allows Executives and Management to compare results by company for each governing state, which are broken down by each Personal Line of Business to show YTD results. New and Renewal Business can be compared to total premium amounts.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 177
Report Name Frequency Target
Audience Description
Large Loss over $50,000 by Cause of Loss
Monthly Loss Experience
This report provides Underwriting, Financial, and Claims Executives with a monthly listing of claims that have paid and reserve loss activity over $50,000 sorted by Company, Line of Business, Governing State, and Branch.
Line of Business by State
Monthly Comparison Executive
This report provides Executives a summary of premiums and losses in the current period compared to the prior period.
Loss Experience by Coverage
Monthly Executive
This report provides Underwriting, Agency and Product Managers with the ability to analyze Premium, Exposure, Loss and Catastrophe Loss, Severity, Frequency and Loss Ratio Statistics by Coverage Attributes. Analyze Premium and Exposure metrics and the impact of catastrophe losses as well as standard loss severity, frequency, rate indications and loss ratios by coverage.
Loss Paid and Reserve Activity
Monthly Loss Experience
Provides a monthly listing of claims that have paid and reserve loss activity sorted by Company/Claim Number. This report helps claims to identify claims that have paid or reserve activity and provides policy numbers, named insured, adjuster, coverage, date of loss, status, and loss amounts.
Net Premium by Branch
Monthly Comparison Production
This report provides Underwriting and Financial Executives with a summary of written and earned premiums reported for Direct, Ceded and Assumed during the current and prior period. An analysis of the use of reinsurance is achieved which may be used to assure the proper reinsurance structure and costs are obtained.
New and Renewal Business Summary
Monthly Comparison Executive
This report provides a time comparison and distribution of new, renewed and total policy premium amounts. These business metrics show the relationship between new, renewed and total book of business statistics. Underwriting, Marketing, and Product Managers can analyze new and renewal business and its distribution across a variety of dimensions will allow for a better comparison of the changes occurring in new business as it is written.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 178
Report Name Frequency Target
Audience Description
New and Renewal Experience
Monthly Executive
This report provides a comparison of new and renewal business distribution and new and renewal policy premium amounts. These business metrics show the relationship between new and renewal book of business statistics. Underwriting, Marketing, and Product Managers can analyze new and renewal business and its average premium and policy counts across a variety of dimensions will allow for a better comparison of the changes occurring in new and renewal business as it is written.
New Business Experience
Monthly Executive
This report provides a comparison of New and Retained Business Premium and Policy Count during the reporting period compared to the prior period. The report identifies the source of current premiums between New Business and Retained Business. It identifies potential areas for correction in either Marketing or Underwriting, if targeted goals or account size are not achieved.
New Business Premium Comparison
Monthly Comparison Executive
This report provides a comparison between new and inforce policy counts and average premium size for current and previous time periods. These new business metrics show specific changes in information for monitoring and managing new business during two time periods. An analysis of new business will allow better decisions: on the type of business being bound, the acceptability of the volume of new business, and average premium levels for the new business group.
New-Renewal Business Distribution
Monthly Comparison Production
This report provides a comparison of New and Retained Business Premium and Policy Count during the reporting period compared to the prior period. The report identifies the source of current premiums between New Business and Retained Business. It identifies potential areas for correction in either Marketing or Underwriting, if targeted goals or account size are not achieved.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 179
Report Name Frequency Target
Audience Description
Open Claims Monthly Claims
This report provides a detailed listing of open claims within the specified period broken down by company, adjuster name and number, and Line of Business. The Claims Staff will have an analysis of staffing and workload requirements to assure claims’ performance measurements are achieved.
Pending Loss Reserve
Monthly Loss Experience
To provide a listing of claims with reserves sorted by Company/Adjuster/Line of Business on a monthly basis. The report helps claims to identify individual claims with pending reserves and sorts them by Company/Adjuster/Line of Business.
Personal Auto New Business Average Premium by Producer
Monthly Production
This report provides the Production Staff with monthly results by producer to show trends in average written premium. Average premium can be tracked by geography to track trends in premium growth and identify problems or opportunities.
Policy Expiration by Producer
Monthly Production
To provide the Production and Claims Staff with a listing of policies that will be expiring three months from the current run date of the report. This report allows a producer to schedule policy activity for upcoming policy expiration and renewal time periods. Information includes loss and premium information for producer evaluation.
Premiums Written, Inforce, Earned and Unearned by Line
Monthly Financial-Actuarial
This report provides Underwriting and Financial Executives with a summary of written, inforce, earned and unearned premiums reported for Direct, Ceded and Assumed during the current and prior period. An analysis of the use of reinsurance is achieved by annual statement line on a direct, ceded, assumed and net basis.
Producer and Line of Business Summary
Monthly Production
Provide a monthly view of producer results by line of business. Underwriting can use this report to identify monthly operational results for each producer by line of business.
Producer and Line of Business Summary by Month
Year To Date Production
To provide a detailed listing of agency operating results by agent/line of business/ for each month on a year to date basis. Underwriting will use this report to identify results in total and for monthly trends by line of business for each agent.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 180
Report Name Frequency Target
Audience Description
Producer Claim Activity
Monthly Claims
This report provides the Claims Staff with a detailed listing of closed claim activity for Producers within the specified period An analysis of closed claim activity for different Producers. Claim strategies can be developed to assure objectives are being met at the Producer level.
Producer Closed Claim Activity
Monthly Claims
This report provides a detailed listing of claim activity for Producers within the specified period. The Claims Staff can analyze claim activity for different Producers. Claim strategies can be developed to assure objectives are being met at the Producer level.
Producer Inforce Monthly Production
To provide Production and Claims Staff with a listing of policies that are currently in-force as of the current run date of the report. This report allows a producer to identify in-force policies by line of business, showing effective and expiration dates, renewal term and Paid Loss and Written Premium Amounts.
REINCO Exposure by Agent
Monthly Claims
This report provides Claims and the Financial Staff with a detailed listing of ceded claims within the specified period. Provides a listing of claims that are recoverable from the appropriate reinsurance company based upon the treaty arrangement.
Reinsurance Monthly Financial-Actuarial
This report provides Underwriting and Financial Executives with ceded loss ratio information for the current period. A review of reinsurance profitability allows for analysis in the use of reinsurance for underwriting purposes. It can be utilized to assure that proper reinsurance structure and costs are achieved.
Reinsurance Loss Ratio Monthly Loss
Experience
This report provides Underwriting and Financial Executives with a summary of ceded premiums and losses reported for the current period. A review of the reinsurance profitability allows for an analysis in the use of reinsurance. It may be used to assure the proper reinsurance structure and costs are achieved.
Renewal Business Experience
Monthly Executive
This report will provide Production and Executive Staff with renewal information by producer to evaluate renewal business compared to all lines of business.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 181
Report Name Frequency Target
Audience Description
Renewal Business Experience Summary
Monthly Executive
This report will provide Production and Executive Staff with renewal information by producer to evaluate renewal. Renewal Business can be compared to total business to make sure that profitable renewal business is being renewed.
Subrogation and Salvage Monthly Loss
Experience
This report provides Claims and Production Staff with details associated with loss recoveries and compares them to total direct incurred losses. Comparisons of Direct Subrogation and Salvage Amounts to total Recoveries and to Total Direct Incurred Amount.
Top 10 Producer New Business Experience Report
Monthly Production
This report provides a summary of the new business production for the top ten producers for each state within a company. With this report, the Production Staff can determine which producers are performing better than others in meeting company goals.
Top 10 Producers by Written Premium for Company and State
Monthly Production
This report provides a summary of production for the top ten agencies within a company by state for a calendar month. At a glance, Production and Executive Staff can look at the performance of the top ten producing agents in the company.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 182
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 183
17BAppendix B
18BFilters
Appendix B describes the standard filters used in Insight. Unique filters can be selected at the time of installation or added later and are not included in this appendix. This Appendix also includes an example of a daily application, Claim Daily Detail.
• Corporate Summary, Corporate Detail and Claims Detail are used across all Lines of Business.
• Line of Business specific monthly applications are Homeowners, Personal Auto, Commercial Property and Auto, Businessowners, Garage, and General Liability.
Businessowners Filters Details
Underwriting Company
Rating Tier
Branch Office
Group Program
Who
Agency Name
Annual Statement Line
Monoline or Package
Coverage Category
Coverage
Standard Industry Code
Risk Grade Code
Business Start year
Number of Employees
Class Code
Type of Construction
Fire Protection Class
Number of Stories
Occupancy Type
Square Footage
Gross Receipts Range
IRPM Factor
What
Age of Policy
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 184
Businessowners Filters Details
When
Calendar Premium, Calendar Losses
Year Basis
Calendar Premium, Accident Losses
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by Month
Rolling Year by Month
Current
Rolling Year by Quarter
By Month(s)
By Quarter(s)
Custom
By Year(s)
Exposure State
Rating Territory
Governing State
Postal Code 3-Digit
Where
Postal Code 5-Digit
Direct/Ceded/Assumed
Active/Cancelled Policy
Additional Filters
New/Renewal Business
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 185
Claim Daily Detail Filters Details
Claim Office
Adjuster
Reinsurance Company
Who
Company
Claim Status
Cause of Loss
Suit Status
Company Catastrophe
National Catastrophe
Claim Closed Date
Line of Business
Annual Statement Line
Coverage
Coverage Part
Reinsurance Treaty
Group Program
What
Policy Type
When
Calendar Premium, Calendar Losses
Calendar Premium, Accident Losses
Year Basis
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by Month
Rolling Year by Month
Current
Rolling Year by Quarter
By Month(s)
By Quarter(s)
Custom
By Year(s)
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 186
Claim Daily Detail Filters Details
Accident State
Region
Postal Code 3-Digit
Postal Code 5-Digit
Suit State
Where
Suit County
Additional Filters Direct/Ceded/Assumed
Claim Detail Filters Details
Claim Office
Adjuster
Reinsurance Company
Who
Company
Cause of Loss
Incurred Amount
Claim Status
Suit Status
Company Catastrophe
National Catastrophe
Claim Closed Date
Days Claim Open
Line of Business
Annual Statement Line
Coverage
Coverage Part
Reinsurance Treaty
Group Program
What
Policy Type
When
Calendar Premium, Calendar Losses
Year Basis
Calendar Premium, Accident Losses
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 187
Claim Daily Detail Filters Details
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by Month
Rolling Year by Month
Current
Rolling Year by Quarter
By Month(s)
By Quarter(s)
Custom
By Year(s)
Accident State
Region
Postal Code 3-Digit
Postal Code 5-Digit
Suit State
Where
Suit County
Additional Filters Direct/Ceded/Assumed
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 188
Commercial Auto Filters Details
Underwriting Company
Rating Tier
Branch Office
Group Program
Who
Agency Name
Year Business Started
Standard Industry Code
Risk Grade Code
PMA Code
Annual Statement Line
Coverage
Class
Vehicle Make
Vehicle Model Year
Vehicle Cost New Brand
Gross Vehicle Weight
Radius of Use
Business Use Class
Policy Premium Range
What
Coverage Part Premium Range
When
Calendar Premium, Calendar Losses
Calendar Premium, Accident Losses
Year Basis
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by Month
Rolling Year by Month
Current
Rolling Year by Quarter
Custom By Month(s)
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 189
Commercial Auto By Quarter(s)
By Year(s)
Exposure State
Rating Territory
Governing State
Postal Code 3-Digit
Where
Postal Code 5-Digit
Direct/Ceded/Assumed
Active/Cancelled Policy
Additional Filters
New/Renewal Business
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 190
Commercial Property Filters Details
Underwriting Company
Rating Tier
Branch Office
Group Program
Who
Agency Name
Year Business Started
SIC Code
Risk Grade
PMA Code
Annual Statement Line
Coverage
Class
Construction Type
Fire Protection Class
Sprinkler Indicator
What
Vacant or Unoccupied Building
Square Footage of Building
Number of Stories in Building
Alarm System
Protection
Seasonal Indicator
EQ Class Construction
Earthquake Zone
Hazard Description
Sprinkler Leakage Coverage
Vandalism Coverage
Wind and Hail Coverage
Agreed Value Amount Range
Builders Risk Coverage
Policy Premium Range
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 191
Commercial Property Filters Details
When
Calendar Premium, Calendar Losses
Calendar Premium, Accident Losses
Year Basis
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by Month
Rolling Year by Month
Current
Rolling Year by Quarter
By Month(s)
By Quarter(s)
Custom
By Year(s)
Exposure State
Rating Territory
Governing State
Postal Code 3-Digit
Where
Postal Code 5-Digit
Additional Filters Direct/Ceded/Assumed
Active/Cancelled Policy
New/Renewal Business
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 192
Corporate Detail Filters Details
Underwriting Company
Rating Tier
Branch Office
Group Program
Who
Agency Name
Coverage Part
Additional Report Detail
Policy Type
Line of Business
Line of Business Sub Code
Personal or Commercial
What
Monoline or Package
When
Calendar Premium, Calendar Losses
Calendar Premium, Accident Losses
Year Basis
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by Month
Rolling Year by Month
Current
Rolling Year by Quarter
By Month(s)
By Quarter(s)
Custom
By Year(s)
Governing State
Postal Code 3-Digit
Where
Postal Code 5-Digit
Additional Filters Direct/Ceded/Assumed
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 193
Corporate Detail Filters Details
Active/Cancelled Policy
New/Renewal Business
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 194
Corporate Experience Summary Filters Details
Underwriting Company
Rating Tier
Branch Office
Group Program
269BWho
Agency Name
Line of Business
Line of Business Sub Code
Personal or Commercial
Monoline or Package
What
Policy Type
When
Calendar Premium, Calendar Losses
Calendar Premium, Accident Losses
Year Basis
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by Month
Rolling Year by Month
Current
Rolling Year by Quarter
By Month(s)
By Quarter(s)
Custom
By Year(s)
Where Governing State
Direct/Ceded/Assumed
Active/Cancelled Policy
Additional Filters
New/Renewal Business
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 195
Garage Filters Details
Underwriting Company
Rating Tier
Branch Office
Group Program
Who
Agency Name
Annual Statement Line
Monoline or Package
Coverage Category
Coverage
Standard Industry Code
Risk Grade Code
Business Start Year
Number of Employees
Class Code
Number of Drivers
Number of Dealer Plates
Garagekeepers Legal Liability
Inventory Value
IRPM Factor
Age of Policy
What
Premium Range
When
Calendar Premium, Calendar Losses
Calendar Premium, Accident Losses
Year Basis
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by Month
Rolling Year by Month
Current
Rolling Year by Quarter
Custom By Month(s)
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 196
Garage Filters Details
By Quarter(s)
By Year(s)
Exposure State
Rating Territory
Governing State
Postal Code 3-Digit
Where
Postal Code 5-Digit
Direct/Ceded/Assumed
Active/Cancelled Policy
Additional Filters
New/Renewal Business
General Liability Filters Details
Underwriting Company
Rating Tier
Branch Office
Group Program
Who
Agency Name
Year Business Started
SIC Code
Risk Grade Code
PMA Code
Annual Statement Line
Coverage
Class
Claims Made Indicator
Schedule Modification
Experience Modification
What
Policy Premium Range
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 197
General Liability Filters Details
Coverage Part Premium Range
Policy Age
When
Calendar Premium, Calendar Losses
Calendar Premium, Accident Losses
Year Basis
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by Month
Rolling Year by Month
Current
Rolling Year by Quarter
By Month(s)
By Quarter(s)
Custom
By Year(s)
Exposure State
Rating Territory
Governing State
Postal Code 3-Digit
Where
Postal Code 5-Digit
Direct/Ceded/Assumed
Active/Cancelled Policy
Additional Filters
New/Renewal Business
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 198
Homeowners Filters Details
Underwriting Company
Rating Tier
Branch Office
Group Program
Who
Agency Name
Annual Statement Line
Bureau Report Plan
Coverage
Policy Form
Dwelling Use
Construction Type
Year Built
Year Built Range
Fire Protection Class
Alarm System
Roof Improvement Year
Roof Improvement Year Range
Roof Material Type
Coastal Area
Dwelling Amount Range
Personal Property Amount Range
Business On Premises
Heat Source
Animal on Site
What
Type of Pool
When
Calendar Premium, Calendar Losses
Calendar Premium, Accident Losses
Year Basis
Policy Premium, Policy Losses
Current Month
Current
Current Quarter
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 199
Homeowners Filters Details
Current Quarter by Month
Year to Date by month
Rolling Year by Month
Rolling Year by Quarter
By Month(s)
By Quarter(s)
Custom
By Year(s)
Exposure State
Rating Territory
Governing State
Postal Code 3-Digit
Where
Postal Code 5-Digit
Direct/Ceded/Assumed
Active/Cancelled Policy
Additional Filters
New/Renewal Business
Homeowners Monitor Filters Monitor Details
Underwriting Company
Branch Office
Who
Producer
Coverage
Annual Line Statement
Program
Policy Form
What
Company Product
When
Six Months
Ending Month Year
Six Quarters
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 200
Homeowners Six Years
Current Month Load
Where Governing State
Exclude Loss Less Than Loss Amount Filters
Exclude Loss Less Than
Personal Auto Filters Details
Underwriting Company
Rating Tier
Branch Office
Group Program
Who
Agency Name
Type of Driver
Annual Statement Line
Gender
Coverage
Marital Status
Subline
Type of Vehicle Body
Policy Age
Driver Age Range
Vehicle Symbol Range
Model Year Range
Vehicle Use
Type of Garaging
Performance Category
Type of Cell Phone
Type of Anti-Theft Device
Class Code
What
Primary Class Code
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 201
Personal Auto Filters Details
Secondary Class Code
When
Calendar Premium, Calendar Losses
Calendar Premium, Accident Losses
Year Basis
Policy Premium, Policy Losses
Current Month
Current Quarter
Current Quarter by Month
Year to Date by month
Rolling Year by Month
Current
Rolling Year by Quarter
By Month(s)
By Quarter(s)
Custom
By Year(s)
Exposure State
Rating Territory
Governing State
Postal Code 3-Digit
Where
Postal Code 5-Digit
Direct/Ceded/Assumed
Active/Cancelled Policy
Additional Filters
New/Renewal Business
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 202
Personal Auto Monitor Filters Monitor Details
Underwriting Company
Branch Office
Who
Producer
Coverage What
Program
When
Six Months
Six Quarters
Ending Month Year
Six Years
Current Month Load
Where Governing State
Exclude Loss Less Than Loss Amount Filters
Exclude Loss Less Than
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 203
19BAppendix C
20BMetrics Appendix C describes the standard metrics used in Insight.
When setting-up queries in Analytics, you will select data from two areas:
• Metrics – Metrics represent calculated values, including premiums, losses, exposures, ratios, averages and counts.
• Filters – Filters represent elements by which the metrics can be analyzed, such as by line of business, agency, program, adjuster, class code and postal code. Filters are organized in a who, what, when, where format to facilitate ease of navigation. See Appendix B.
The following table lists metrics and describes the function or explains the formula used. It also provides the value of each metric.
Metrics Value
Description
Allocated Expense Reserve Change Additive Any change in the amount set aside to support
expense payments directly attributable to an individual claim or feature, including the initial Loss Reserve established, during a specific time period.
Allocated Expense Reserve Change Ratio Additive Allocated Expense Reserve Change divided by Earned Premium.
Average Alloc Expense Paid Per Claim Semi-Additive Snapshot
Paid Allocated Expense divided by Total Open Claims.
Average Cancellation Premium Additive Cancelled Premium Amount divided by Cancelled Policy Count
Average Combined Expenses Per Claim Semi-Additive Snapshot
(Paid Allocated Expense + Paid Unallocated Expense) divided by Total Open Claims
Average Effective Premium Additive Effective Premium Amount divided by Effective Policy Count.
Average Expiration Premium Additive Expired Premium Amount divided by Expired Policy Count
Average Inforce Premium Semi-Additive Snapshot
Inforce Premium Amount divided by Inforce Policy Count
Average Retained Premium Additive Retained Premium Amount divided by Retained Policy Count
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 204
Metrics Value
Description
Average Transaction Size Additive Written Premium Amount divided by Written Premium Policy Count.
Average Unalloc Expense Paid Per Claim Semi-Additive Snapshot
Paid Unallocated Expense divided by Total Open Claims.
Cancelled Policy Count
Additive The number of policies that are cancelled at the end of a specified evaluation period and active at the end of the prior evaluation period.
The formula for calculating the Cancelled Policy Count is as follows:
CancellationDate >= BOMDate and CancellationDate < EOMDate
Cancelled Premium Additive The final total written premium amount of policies
that is cancelled at the end of a specified evaluation period and active at the end of the prior evaluation period.
Cancelled Premium to Written Premium Additive Cancelled Premium divided by Written Premium.
Claim Feature Count Semi-Additive Distinct
The number of distinct features with transactional activity within an evaluation period.
Claim Occurrence Count Semi-Additive Distinct
The number of distinct claim occurrences with transactional activity within an evaluation period.
Claim Status Count Semi-Additive Distinct
The number of Open, Closed, and Reopened claims within an evaluation period.
Claim to Date Incurred Amount Semi-Additive Snapshot
The total amount of Incurred Losses since the claim was opened.
Claimant Count Semi-Additive Distinct
The number of distinct claimants with transactional activity within an evaluation period.
Claims Closed Additive The number of claim occurrences closed within an evaluation period.
Claims Opened Additive The number of claim occurrences opened within an evaluation period.
Combined Expense Reserve Change Additive Allocated Expense Reserve Change + Unallocated
Expense Reserve Change.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 205
Metrics Value
Description
Combined Expense Reserve Change Ratio Additive (Allocated Expense Reserve Change + Unallocated
Expense Reserve Change) divided by Earned Premium.
Combined Incurred Expense Additive Incurred Allocated Expense + Incurred Unallocated Expense.
Combined Incurred Expense Ratio Additive (Incurred Allocated Expense + Incurred Unallocated Expense) divided by Earned Premium.
Combined Incurred Loss and Recovery Additive Incurred Loss + Incurred Salvage + Incurred Subrogation + Incurred Deductible.
Combined Incurred Loss and Recovery Ratio
Additive (Incurred Loss + Incurred Salvage + Incurred Subrogation + Incurred Deductible) divided by Earned Premium.
Combined Incurred Loss, Expense and Recovery
Additive Incurred Loss + Incurred Allocated Expense + Incurred Unallocated Expense + Incurred Salvage + Incurred Subrogation + Incurred Deductible.
Combined Incurred Loss, Expense and Recovery Ratio
Additive (Incurred Loss + Incurred Allocated Expense + Incurred Unallocated Expense + Incurred Salvage + Incurred Subrogation + Incurred Deductible) divided by Earned Premium.
Combined Incurred Recovery Additive Incurred Salvage + Incurred Subrogation + Incurred Deductible.
Combined Incurred Recovery Ratio Additive (Incurred Salvage + Incurred Subrogation + Incurred Deductible) divided by Earned Premium.
Combined Incurred Recovery to Incurred Loss Ratio
Additive (Incurred Salvage + Incurred Subrogation + Incurred Deductible) divided by Incurred Loss.
Combined Loss and Expense Incurred Additive Incurred Loss + Incurred Allocated Expense + Incurred Unallocated Expense.
Combined Loss and Expense Incurred Ratio
Additive (Incurred Loss + Incurred Allocated Expense + Incurred Unallocated Expense) divided by Earned Premium.
Combined Loss and Expense Reserve Change
Additive Loss Reserve Change + Allocated Expense Reserve Change + Unallocated Expense Reserve Change.
Combined Loss and Expense Reserve Change Ratio
Additive (Loss Reserve Change + Allocated Expense Reserve Change + Unallocated Expense Reserve Change) divided by Earned Premium.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 206
Metrics Value
Description
Combined Loss and Recovery Reserve Change
Additive Loss Reserve Change + Salvage Reserve Change + Subrogation Reserve Change + Deductible Reserve Change.
Combined Loss and Recovery Reserve Change Ratio
Additive (Loss Reserve Change + Salvage Reserve Change + Subrogation Reserve Change + Deductible Reserve Change) divided by Earned Premium.
Combined Loss, Expense and Recovery Reserve Change
Additive Loss Reserve Change + Allocated Expense Reserve Change + Unallocated Expense Reserve Change + Salvage Reserve Change + Subrogation Reserve Change + Deductible Reserve Change.
Combined Loss, Expense and Recovery Reserve Change Ratio
Additive (Loss Reserve Change + Allocated Expense Reserve Change + Unallocated Expense Reserve Change + Salvage Reserve Change + Subrogation Reserve Change + Deductible Reserve Change) divided by Earned Premium.
Combined Outstanding Expense Reserve Semi-Additive Snapshot
Outstanding Allocated Expense Reserve + Outstanding Unallocated Expense Reserve.
Combined Outstanding Loss and Expense Reserve
Semi-Additive Snapshot
Outstanding Loss Reserve + Outstanding Allocated Expense Reserve + Outstanding Unallocated Expense Reserve.
Combined Outstanding Loss and Recovery Reserve
Semi-Additive Snapshot
Outstanding Loss Reserve + Outstanding Salvage Reserve + Outstanding Subrogation Reserve + Outstanding Deductible Reserve.
Combined Outstanding Loss, Expense and Recovery Reserve
Semi-Additive Snapshot
Outstanding Loss Reserve + Outstanding Allocated Expense Reserve + Outstanding Unallocated Expense Reserve + Outstanding Salvage Reserve + Outstanding Subrogation Reserve + Outstanding Deductible Reserve.
Combined Outstanding Recovery Reserve Semi-Additive
Snapshot Outstanding Salvage Reserve + Outstanding Subrogation Reserve + Outstanding Deductible Reserve.
Combined Paid Expense Ratio Additive (Paid Allocated Expense + Paid Unallocated Expense) divided by Earned Premium.
Combined Paid Loss and Expense Ratio Additive (Paid Loss + Paid Allocated Expense + Paid Unallocated Expense) divided by Earned Premium.
Combined Paid Loss and Recovery Ratio Additive (Paid Loss + Salvage Recovered + Subrogation
Recovered + Deductible Recovered) divided by Earned Premium.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 207
Metrics Value
Description
Combined Paid Loss, Paid Expense and Recovery Ratio
Additive (Paid Loss + Paid Allocated Expense + Paid Unallocated Expense + Salvage Recovered + Subrogation Recovered + Deductible Recovered) divided by Earned Premium.
Combined Recovery Ratio Additive (Salvage Recovered + Subrogation Recovered + Deductible Recovered) divided by Earned Premium.
Combined Recovery Reserve Change Additive Salvage Reserve Change + Subrogation Reserve Change + Deductible Reserve Change.
Combined Recovery Reserve Change Ratio
Additive (Salvage Reserve Change + Subrogation Reserve Change + Deductible Reserve Change) divided by Earned Premium.
Combined Recovery to Paid Loss Ratio Additive (Salvage Recovered + Subrogation Recovered + Deductible Recovered) divided by Paid Loss.
Commission Additive That portion of premium that is retained or paid as an acquisition expense.
Count Renewal Retention Additive Retained Policy Count divided by Expired Policy Count.
Deductible Recovered Additive The amount of compensation received from an entity
that is fully or partially liable for repayment of a deductible amount that has been incurred.
Deductible Recovered to Paid Loss Additive Deductible Recovered divided by Paid Loss.
Deductible Recovery Ratio Additive Deductible Recovered divided by Earned Premium.
Deductible Reserve Change
Additive Any change in the amount of compensation expected to be recovered from an entity that is fully or partially liable for repayment of a deductible amount that has been incurred, including the initial Loss Reserve established, during a specific time period.
Deductible Reserve Change Ratio Additive Deductible Reserve Change divided by Earned Premium.
Earned Composite Rate Additive Earned Premium divided by Earned Exposure.
Earned Exposure
Additive The amount of Written Exposure that has been realized as of a specific time period. Unearned exposure is calculated on a daily (1/365th) method, based on client specifications. Earned Exposure = Written Exposure - Unearned Exposure.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 208
Metrics Value
Description
Earned Premium
Additive The amount of written premium that has been realized as of a specific time period. Unearned premium is calculated on either a daily (1/365th) or a monthly (1/24th) method, based on client specifications. Earned Premium = Written Premium - Unearned Premium.
Earned Premium to Written Premium Additive Earned Premium divided by Written Premium.
Effective Policy Count
Additive The number of policies with an effective date within an evaluation period, and in an ending active status in that period.
Effective Policy Count is calculated as:
EffectiveDate >= BOMDate and EffectiveDate < EOMDate and (CancellationDate >= EOMDate or CancellationDate < EffectiveDate)
Effective Premium Additive The total written premium amount of policies with an
effective date within a specified evaluation period, calculated on a policy term basis using the Policy Effective Date.
Expenses/Incurred Amount Semi-Additive Snapshot
(Paid Allocated Adjustment Expense + Outstanding Loss Reserve) divided by Incurred Loss.
Expenses/Incurred Including Expenses Semi-Additive
Snapshot (Paid Allocated Adjustment Expense + Outstanding Loss Reserve) divided by (Incurred Loss + Incurred Allocated Expense).
Expired Policy Count
Additive The number of policies with an expiration date within an evaluation period, and in an ending active status in that period.
Expired Policy Count is calculated as:
ExpirationDate >= BOMDate and ExpirationDate < EOMDate and CancellationDate < EffectiveDate
Expired Premium Additive The total written premium amount of policies with an
expiration date within a specified evaluation period, calculated on a policy term basis using the Policy Expiration Date.
Future Written Premium Semi-Additive
Snapshot The amount of coverage-level transactions that have a Cycle (processing) Date in a specified evaluation period, but a Book Date in a future evaluation period.
Incurred Allocated Expense Additive The full amount of expenses directly attributable to
an individual claim, based on both amounts paid and reserves for estimated future payments, during a specific time period.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 209
Metrics Value
Description
Incurred Allocated Expense Ratio Additive Incurred Allocated Expense divided by Earned Premium.
Incurred Allocated Expense to Incurred Loss Ratio
Additive Incurred Allocated Expense divided by Incurred Loss.
Incurred Combined Expense to Incurred Loss Ratio
Additive (Incurred Allocated Expense + Incurred Unallocated Expense) divided by Incurred Loss.
Incurred Deductible
Additive The full amount of compensation expected to be recovered from an entity that is fully or partially liable for repayment of a deductible amount that has been incurred, based on both amounts recovered and reserves for estimated future recoveries, during a specific time period.
Incurred Deductible Ratio Additive Incurred Deductible divided by Earned Premium.
Incurred Deductible to Incurred Loss Ratio Additive Incurred Deductible divided by Incurred Loss.
Incurred Loss
Additive The full amount of a claim based on both amounts paid and recovered and reserves for estimated future payments and recoveries. Can be one of 3 methods based on client specifications:
1.) Paid Losses + Loss Reserve Change
2.) Paid Losses + Loss Reserve Change + Salvage Recovered + Salvage Reserve Change + Subrogation Recovered + Subrogation Reserve Change.
3.) Paid Losses + Loss Reserve Change + Salvage Recovered + Salvage Reserve Change + Subrogation Recovered + Subrogation Reserve Change + Deductible Recovered + Deductible Reserve Change.
Incurred Loss and Combined Expense to Earned Exposures
Additive (Incurred Loss + Incurred Allocated Expense + Incurred Unallocated Expense) divided by Earned Exposures.
Incurred Loss Ratio Additive Incurred Loss divided by Earned Premium.
Incurred Salvage
Additive The full amount expected to be recovered for the value of property taken over by an insurer to reduce its loss, based on both amounts recovered and reserves for estimated future recoveries, during a specific time period.
Incurred Salvage Ratio Additive Incurred Salvage divided by Earned Premium.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 210
Metrics Value
Description
Incurred Salvage to Incurred Loss Ratio Additive Incurred Salvage divided by Incurred Loss.
Incurred Subrogation
Additive The full amount of compensation expected to be recovered from an entity that is fully or partially liable for a claim that has been incurred, based on both amounts recovered and reserves for estimated future recoveries, during a specific time period.
Incurred Subrogation Ratio Additive Incurred Subrogation divided by Earned Premium.
Incurred Subrogation to Incurred Loss Ratio
Additive Incurred Subrogation divided by Incurred Loss.
Incurred Unallocated Expense
Additive The full amount of expense payments not directly attributable to an individual claim, but assigned to a transaction based on client specifications, and based on both amounts paid and reserves for estimated future payments, within a specific time period.
Incurred Unallocated Expense Ratio Additive Incurred Unallocated Expense divided by Earned Premium.
Incurred Unallocated Expense to Incurred Loss Ratio
Additive Incurred Unallocated Expense divided by Incurred Loss.
Inforce Policy Count
Semi-Additive Snapshot
Semi-Additive Distinct
The number of policies with an expiration date greater than the end of an evaluation period, an effective date in or prior to that evaluation period, and an ending active status within that period.
Inforce Policy Count is calculated as:
ExpirationDate >= EOMDate and EffectiveDate < EOMDate and (CancellationDate >= EOMDate or CancellationDate < EffectiveDate)
Inforce Premium
Semi-Additive Snapshot
The total written premium amount of policies that are active at the end of a specified evaluation period, have an effective date within or prior to the evaluation period, and an expiration date in a future evaluation period.
Inforce Premium to Written Premium Semi-Additive Snapshot
Inforce Premium divided by Written Premium.
Loss Reserve Change Additive Any change in the amounts set aside to support
payment of a claim, including the initial Loss Reserve established, during a specific time period.
Loss Reserve Change Ratio Additive Loss Reserve Change divided by Earned Premium.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 211
Metrics Value
Description
Loss Severity Semi-Additive Snapshot
Incurred Amount divided by Total Claim Open Count.
Outstanding Allocated Expense Reserve Semi-Additive Snapshot
The Allocated Expense reserve amount as of the end of a reporting period.
Outstanding Deductible Reserve Semi-Additive Snapshot
The deductible reserve amount as of the end of a reporting period.
Outstanding Loss Reserve Semi-Additive Snapshot
The loss reserve amount as of the end of a reporting period.
Outstanding Salvage Reserve Semi-Additive Snapshot
The salvage reserve amount as of the end of a reporting period.
Outstanding Subrogation Reserve Semi-Additive Snapshot
The subrogation reserve amount as of the end of a reporting period.
Outstanding Unallocated Expense Reserve Semi-Additive Snapshot
The Unallocated Expense reserve amount as of the end of a reporting period.
Paid Allocated Expense Additive The amount of expense payments directly
attributable to an individual claim during a specific time period.
Paid Allocated Expense Ratio Additive Paid Allocated Expense divided by Earned Premium.
Paid Allocated Expense to Paid Loss Ratio Additive Paid Allocated Expense divided by Paid Loss.
Paid Combined Expense Additive Paid Allocated Expense + Paid Unallocated Expense
Paid Combined Expense to Paid Loss Ratio
Additive (Paid Allocated Expense + Paid Unallocated Expense) divided by Paid Loss.
Paid Combined Loss and Recoveries Additive Paid Loss + Salvage Recovered + Subrogation Recovered + Deductible Recovered.
Paid Combined Loss, Paid Expense and Recoveries
Additive Paid Loss + Paid Allocated Expense + Paid Unallocated Expense + Salvage Recovered + Subrogation Recovered + Deductible Recovered.
Paid Loss Additive The amount of loss payments made (usually
excluding all recoveries) during a specific time period.
Paid Loss Ratio Additive Paid Loss divided by Earned Premium.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 212
Metrics Value
Description
Paid Unallocated Expense Additive The amount of expense payments not directly
attributable to an individual claim, but assigned to a transaction based on client specifications, within a specific time period.
Paid Unallocated Expense Ratio Additive Paid Unallocated Expense divided by Earned Premium.
Paid Unallocated Expense to Paid Loss Ratio
Additive Paid Unallocated Expense divided by Paid Loss.
Policy Count Semi-Additive Distinct
Number of policies grouped by active or cancelled status at the end of an evaluation period.
Premium Renewal Retention Additive Retained Premium divided by Expired Premium.
Processed Premium Additive The amount of coverage-level transactions that have
a Cycle (processing) Date in a specified evaluation period.
Recoveries/Paid Losses Additive Recoveries divided by Paid Loss.
Retained Policy Count
Additive The number of policies with an expiration date and an ending active status within an evaluation period, and an effective date and an ending active status within that period.
Retained Policy Count is calculated as:
(ExpirationDate >= BOMDate and ExpirationDate < EOMDate and CancellationDate < EffectiveDate) AND (EffectiveDate >= BOMDate and EffectiveDate < EOMDate and (CancellationDate >= EOMDate or CancellationDate < EffectiveDate))
Retained Premium Additive The total written premium amount of inforce policies
with an expiration and effective date within a specified evaluation period, calculated on a policy term basis using the Policy Expiration Date.
Retained Premium to Effective Premium Additive Retained Premium divided by Effective Premium.
Salvage Recovered Additive The value of property taken over by an insurer to reduce its loss.
Salvage Recovery Ratio Additive Salvage Recovered divided by Earned Premium.
Salvage Recovered to Paid Loss Ratio Additive Salvage Recovered divided by Paid Loss.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 213
Metrics Value
Description
Salvage Reserve Change Additive Any change in the amounts expected to be
recovered for the value of property taken over by an insurer to reduce its loss, including the initial Loss Reserve established, during a specific time period.
Salvage Reserve Change Ratio Additive Salvage Reserve Change divided by Earned Premium.
Subrogation Recovered Additive The amount of compensation received from an entity
that is fully or partially liable for a claim that has been incurred.
Subrogation Recovered to Paid Loss Additive Subrogation Recovered divided by Paid Loss.
Subrogation Recovery Ratio Additive Subrogation Recovered divided by Earned Premium.
Subrogation Reserve Change
Additive Any change in the amounts of compensation expected to be recovered from an entity that is fully or partially liable for a claim that has been incurred, including the initial Loss Reserve established, during a specific time period.
Subrogation Reserve Change Ratio Additive Subrogation Reserve Change divided by Earned Premium.
Total Open Claims Semi-Additive Snapshot
The number of claim occurrences remaining open at the end of an evaluation period.
Unallocated Expense Reserve Change
Additive Any change in the amount set aside to support expense payments not directly attributable to an individual claim or feature, but assigned to a transaction based on client specifications, including the initial Loss Reserve established, during a specific time period.
Unallocated Expense Reserve Change Ratio
Additive Unallocated Expense Reserve Change divided by Earned Premium.
Written Exposure Additive The measure of the unit of risk assumed by an
insurer, expressed as specified by the client, but usually based on individual units such as vehicles, structures, payroll, etc.
Written Premium
Additive The amounts charged to policyholders for insurance coverage. Calculation is based on the aggregation of all coverage-level transactions based on the Book Date (the accounting date when transactions are recognized).
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 214
Metrics Value
Description
Written Premium Policy Count Additive The number of policies containing written premium within an evaluation period.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 215
21BAppendix D
22BFailure to Display Popups
Popups are screens that automatically open when you click on a web site or a hyperlink. Popups frequently are annoying ads and many users don’t want popups appearing on their system so they install popup blockers. Popup blocker programs will severely limit any type of auxiliary screen from being displayed. Insight contains many information screens that are critical for users to view but are considered auxiliary screens by popup blocker programs.
You may not even be aware you have a popup blocker installed because popup blockers are included in newer versions of Windows including XP/SP2, many popular browser toolbars and other Internet service software.
NOTE If at any time you are unsure how to enable popups, please contact your system administrator.
The three main popup blockers will be discussed here.
Microsoft Windows XP
If you have installed Service Pack 2, then you have a popup blocker on your Internet Explorer.
To turn it off:
Step 1. Open an Internet Explorer window.
Step 2. Click on Tools in the menu.
Step 3. Click on Internet Options.
Step 4. Click on the Privacy tab.
Step 5. Uncheck Block Popups.
Step 6. Click OK to save your changes.
This will allow popups to be displayed.
270BGoogle Toolbar
The Google Toolbar is an add-on feature for Internet Explorer.
To disable the Google popup blocker:
Step 1. Open an Internet Explorer window.
Step 2. Click on the Blocking Popups button.
Step 3. Select Site Popups Allowed.
Step 4. Click OK to save your changes.
This will allow popups to be displayed.
272BNOTE You also can check your failed popups option and select to add Insight.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 216
Yahoo toolbar
Yahoo likewise has a toolbar that is an add-on feature for Internet Explorer.
Step 1: Open an Internet Explorer window.
Step 2: On your Yahoo toolbar, click the popup blocker option arrow. This is the down arrow beside the popup blocker icon.
Step 3: Click on "Always Allow Pop-Ups From..."
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 217
Step 4: Locate the Insight URL from the Sources of Recently Blocked Pop-Ups: list. Click on it.
If you are unsure of the Insight Link, contact your system administrator.
Step 5: Click Allow.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 218
Step 6: Click OK. This will allow Insight to display popups.
Click Close to close the window and save your entry.
273BNOTE Internet service software, such as AOL, also includes popup blockers. As do many security programs, such as McAfee and Norton. It is recommended that you consult the manufactures instructions for disabling popup blocker.
If any of these solutions fail to produce the desired results, contact your system administrator for further assistance.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 219
271BTrusted Sites
You also can add Insight to your Trusted Sites.
To Add Insight to your Trusted Sites:
Step 1. Open an Internet Explorer window.
Step 2. Click on Tools in the menu.
Step 3. Click on Internet Options.
Step 4. Click on the Security tab.
Step 5. Click on Trusted Sites.
Step 6. Click on the Sites button. A separate window will be displayed.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 220
Step 7. Enter in your Insight site. If you do not know your Insight site, ask your system administrator.
Step 8. Click Add. The Insight site will be listed below.
Step 9. Click OK to save your selections and close the window.
This will allow auxiliary screens from Insight to open.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 221
23BGlossary
This glossary defines the terms and abbreviations commonly used within the Insight Application
Suite and formulas for counts, ratios, and averages.
Field Definition/Formula
Accident Losses “When” filter available in the Claim Detail application. Measures all losses based on the actual loss date and accumulates losses to the valuation (‘as of’) date.
Accident Month Case Incurred Loss
Measures Incurred Loss occurring within a given month on an accident year basis. Formula is Paid Loss (minus paid recoveries) + loss reserve amounts (both changes in reserves and initial reserves).
Accident Year Number of Losses A count of all claim occurrences (not features) on an accident year basis.
Accident Month Loss Severity
The average amount of loss per claim occurrence on an accident year/quarter/month basis The formula is: accident year case incurred loss amount ÷ accident year number of losses (claim occurrences)
Alert
A mechanism for notifying users that a data condition has been met. Users can define a variety of conditions to serve as the trigger for an Alert (ex: all Claim Occurrences by Adjuster where Paid Loss > $10,000). Alerts can be created within each Analytics Category and within each Monitor application.
Allocated Expense Loss Ratio Allocated Loss Adjustment Expenses ÷ Loss Adjustment Expense Amounts
Allocated Expense Paid to Paid Loss Ratio Allocated LAE Amount ÷ Paid Loss Amount
Allocated Expense Reserves to All Reserves
Allocated Loss Expense Reserves (both changes in reserves and initial reserves) ÷ All Loss Reserves (Allocated + Unallocated)
Allocated Expense Ratio All Allocated Loss Adjustment Expenses ÷ All Loss Adjustment Expense Amounts (Allocated and Unallocated)
Allocated Expense/Incurred Ratio All Allocated Loss Adjustment Expenses ÷ Incurred Losses excluding Expenses
Allocated Loss Adjustment Expense
The amount of change to loss adjustment expenses that can be directly tied to a given claim occurrence or feature and analyzed within a given time period.
Analytics
Application that enables users to run a variety of queries on an ‘ad hoc’ basis. Users select Filters and Metrics segmented by Who, What, When, Where that are unique to each Category.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 222
Field Definition/Formula
Application A software module that is designed to address a specific business requirement. The three core Insight applications are: Reports, Analytics and Monitors.
Average Allocated Expense Paid Per Claim Allocated Expenses ÷ Total Claim Occurrence Count
Average Loss Severity Incurred Losses ÷ Total Open Claim Count
Average Policy Size Written Premium ÷ Total policy count
Bands A range used to group data results (ex: Policy Age [0-12 months]; Incurred Loss [$0 - $1,000]. In Claims Monitor band parameters are configurable on the Setup screen to define the range of Incurred Losses.
Benchmarking Establishes a system of comparisons to measure performance
Book Date
Used to calculate Written Premium, Losses, Reserves, Expenses and Recoveries on a Calendar Year basis. Book Date is defined as the accounting month in which premiums and losses are recognized. Book Date is not displayed in the applications, but is used to calculate various metrics in the background.
Burning Costs by Band
A metric on the Inflation Rate analysis screen in Claims Monitor that calculates Paid Combined Expenses (ALAE + ULAE) by Claims Reported Year and groups the results by Incurred Loss ranges (bands). The results are evaluated as of the Ending Date, which is the “2nd Valuation Date” selected from the Analysis Setup screen.
Calendar/Accident Case Incurred Loss Ratio
The relationship between incurred loss amounts and earned premium expressed as a percentage on an accident year/quarter/month basis. The formula is: accident year case incurred loss amount ÷ calendar year earned premium
Calendar Premium, Calendar Year Losses
“When” filter available in the Analytics application. Measures Premiums and Losses on a Calendar Year based on when the information was keyed-in to the source system.
Calendar Premium/Accident Year Losses
“When” filter available in the Analytics application. Measures Premiums on a Calendar Year based on when the information was keyed-in to the source system and Losses on an Accident Year based on the actual loss date and accumulating Losses to the valuation (‘as of’) date.
Calendar Year Earned Exposure
The amount of written exposure that may be recognized as earned for a given time period on a calendar year/quarter/month basis. Exposures are earned using the daily method. For each day a one-year policy is in force, an insurer earns 1/365th of the annual premium.
Case Incurred Loss Amounts
Provides results at two valuation dates and displays the total change
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 223
Field Definition/Formula
Ceiling The highest dollar amount you want considered for your analysis
Claim Bands Separates incurred losses on a claim occurrence level by bands, which are dollar amount ranges (ex: $0-$1,000)
Claim Counts
A metric in the Claims Monitor application that counts the number of claim occurrences reported within a user-defined date range. The analysis results are compared between to evaluation dates (ex: as of January 2006 vs. as of July 2006) to measure loss development over time
Claim Reported Losses “When” filter available in the Claim Detail application. Measures all losses based on the date the loss was actually reported to the insured and accumulates losses to the valuation (‘as of’) date.
Claim Status Available in the Claim Detail application Claim Status provides results for Open, Closed and Reopened claims as of the evaluation period
Claims Monitor
Application that measures key claims facts, such as loss reserve accuracy and changes over time, claim expense, time lag and recovery factors to help establish claim service standards and develop claim operations excellence.
Composite Weight An analysis in the Profile Monitor application, this column provides the option to apply a weight to each attribute allowing for a score that is composite weighted for all attributes (the bottom row of the Summary page table)
Conformed Dimension A common dimension (filter) that is shared across multiple data marts and applications, (i.e., Company, Branch, Agent, etc.)
Conforming Feature A feature that is included in every application such as Printing, K-Mail, Save/Restore Analysis, etc.
Corporate Experience Summary A category within the Analytics application that provides top level data summarization of both policies and claims, such as Inforce Policy Counts, Open Claims, Closed Claims and Premiums/Losses, across all line of business.
Counts by Band
A metric on the Inflation Rate analysis screen in Claims Monitor that counts the number of claim occurrences by Claims Reported Year and groups the results by Incurred Loss ranges (bands). The results are evaluated as of the Ending Date, which is the “2nd Valuation Date” selected from the Analysis Setup screen.
Current Incurred Amount Current total value of the claim, less any expenses
Cycle Date The date when data was entered or modified in the source system and is used as the Valuation Date in the Insight applications. Cycle Date is not displayed in the applications, but is used to calculate various metrics in the background.
Data Mart A set of "Query Ready" tables designed to support specific analytical requirements. Data marts contact fact (metric) and dimension (filter) tables and are segmented by application and by line of business.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 224
Field Definition/Formula
Dimension An attribute or characteristic that can be used to categorize or filter data
Drill Across An analysis technique that revels more facts or metrics related to a given piece of information
Drill Down An analysis technique that filters a particular data attribute down to a lower level (ex: Written Premium by Broker)
Drill Up The reverse of a Drill Down that returns the user to a higher-level of analysis
Executive Summary A compilation of information deemed important to an executive.
Exposure Basis Code The exposure basis is the extent of risk as measured by various metrics depending on the coverage being exposed.
Exposure Earned Premium Fact or Metric
The earned premium that is actually exposed to loss during a specified period of time. To develop this earned premium, the date on which premiums were booked is disregarded. The portion of the written premium exposed to loss (earned) is allocated to the exposure period whether the premiums were booked in a prior period, during the current period, or after the period. The exposure earned premium eliminates the deficiency contained in accounting earned premium that results from timing problems in the recording of the premium.
Facultative Commission Percent The percentage of premium the ceding company retains as a commission from the reinsurer.
Floor The lowest dollar amount you want considered for analysis
Frequency Relativity A metric in the Loss Monitor application, this calculation is the division of loss frequency amounts by the Aggregate (Average) Loss Frequency Amounts
Incurred Loss Including LAE The estimated value of the total loss for the selected time period including loss expenses. Incurred Loss including LAE = Paid Loss + Loss Reserves + Paid Combined Expenses – Paid Recoveries
Inflation Rate An analysis in the Claims Monitor application that measures year-over-year % increase in average Incurred Loss per claim occurrence. Also evaluates Incurred Loss (excluding LAE) and claim counts by Loss Year.
Large List Box
A large list box will contain all the available selections with the ability to either include or exclude individually or collectively. Large lists boxes are displayed as a separate window. Move selections between included and excluded sections by doing the following:
To move individual items: 1. Select the items to be moved by using the list box
options. 2. Click the Select Items button (icon here) to move the
highlighted items. 3. Click the OK button to finalize the selection.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 225
Field Definition/Formula To Move all items:
1. Click the Select All button (icon here) to move all items.2. Click the OK button to finalize the selection.
List Boxes
A List Box is a drop down list of all your available options. The following selection options are available: - Mouse click for selecting one item at a time
- Control key + mouse click for selecting or deselecting
multiple items at a time
- Shift key + mouse click for selecting a range of items in a
list box.
Note: To deselect items, hold down the control key, point and left mouse click each item to deselect.
Loss Frequency by Earned Exposure
The number of claims ÷ the number of earned exposures (ex: number of claim occurrences per hundred car years for collision coverage).
Loss Monitor Application that measures loss experience, including Aging and Relativity analysis, by Loss Ratio, Loss Frequency and Loss Severity. There are separate Loss Monitor applications for each line of business.
Loss Reserve Accuracy By Claim Count
Measures Incurred Loss change between two evaluation periods for all claims reported within a specified time period. The purpose is to analyze the number of claims where Incurred Loss increases or decreases between the two evaluation periods.
Loss Reserve Accuracy By Dollar Amount
Measures Incurred Loss change between two evaluation periods for all claims reported within a specified time period. The purpose is to analyze the change in Incurred Loss between the two evaluation periods.
Loss State / Province The State or Province in which the claim actually occurred
Observed Count
An analysis Profile Monitor that measures inforce counts as of the current month based upon the Attribute selected from the Analysis Setup screen. (ex: the Observed Count for the Attribute ‘Type of Vehicle Body’ is the number of Inforce Vehicles grouped by ‘Type of Vehicle Body’).
Observed Percent An analysis in the Profile Monitor application that divides the Observed Count for each Attribute by the Total Inforce count
Observed Rating
An algorithm in the Profile Monitor application that scores the Preferred Counts versus the Observed Counts to demonstrate how the preferred inforce counts measure to the actual inforce counts for analysis purposes. The Observed Rating is used in the Variation from Profile analysis.
Paid Combined Expenses Allocated LAE Amount + Unallocated LAE Amount over a given time period
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 226
Field Definition/Formula
Percentage of Claim Costs By Band
A metric on the Inflation Rate analysis screen in Claims Monitor that calculates the percentage of “Burning Costs” (see definition) by Incurred Loss band relative to the Burning Costs for all Incurred Loss bands within a Claims Reported Year. The results are grouped by Incurred Loss ranges (bands) and are evaluated as of the Ending Date, which is the “2nd Valuation Date” selected from the Analysis Setup screen.
Percentage of Claim Counts by Band
A metric on the Inflation Rate analysis screen in Claims Monitor that calculates the percentage of Claim Counts (see ‘Counts by Band’ definition) by Incurred Loss band relative to Claims Counts for all Incurred Loss bands within a Claims Reported Year. The results are grouped by Incurred Loss ranges (bands) and are evaluated as of the Ending Date, which is the “2nd Valuation Date” selected from the Analysis Setup screen.
Policy Premium, Policy Year Losses
Represents premium and loss data based on the policy effective period. The ‘effective’ period is calculated on a policy term basis using the Policy Effective Date.
Policy Transaction Amount The amount of any transaction processed for a policy. All policy amounts in the applications (premiums, exposures, etc.) are an aggregation of individual policy transaction amounts.
Preference Direction
Available on the Profile Template screen in Profile Monitor the Preference Direction is used in conjunction with the Preferred Percent to represent the preferred (not actual) percentage increase or decrease in Inforce Counts by Attribute. Up Arrow - More is Better Sideways Arrow - Neutral or no Impact Down Arrow - Less is Better
Preferred Count Available on the Profile Template screen in Profile Monitor the Preferred Count is calculated after clicking the ‘Rescore Observed Rating’ button by multiplying the Preferred Percent by the Total Observed Count.
Preferred Percentage Available on the Profile Template screen in Profile Monitor the Preferred Percentage is defined by the user as the preferred (not actual) percentage breakdown of Inforce Counts by Attribute.
Profile Monitor Application that measures the profile characteristics of inforce, new and expiring business to help analyze the change on a goal-seeking basis and minimize adverse selection.
Recoveries Salvage Recovered + Subrogation Recovered
Recoveries to Incurred Including LAE Ratio
(Salvage Recovered + Subrogation Recovered) ÷ (Incurred Loss + Total Loss Adjustment Expense [ALAE + ULAE])
Recoveries to Incurred Ratio (Salvage Recovered + Subrogation Recovered) ÷ Incurred Loss not including Expenses
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 227
Field Definition/Formula
Relativity Analysis in Loss Monitor that measures Loss Ratio, Loss Frequency and Loss Severity for each Policy Age relative to all Policy Ages within a given Calendar Month.
Reserve Loss Ratio Loss Reserve Amount ÷ Earned Premium Amount for a given evaluation period
Retention Monitor Application that measures retention trends, customer and agency loyalty
Salvage The value of property taken over by an insurer to reduce its loss.
Salvage Reserve Amount The estimated value of property taken over by an insurer to reduce its loss. Salvage Reserve includes both Initial Salvage Reserves and Change in Salvage Reserves within the evaluation period.
Scorecard An assembly of scores in Profile Monitor combined into a comprehensive presentation.
Scoring Analysis in Profile Monitor that enables users to overlay preferences versus current observations to establish goals and benchmarking
Scoring Presentation Scores are illustrated using colors or symbols for the purpose of quick interpretation
Scrap Rate
Analysis in Retention Monitor that measures the percentage of policies which are no longer active during the first three months of being issued. Results are calculated for new policies that are issued using the Original Inception Date, or Original Effective Date.
State / Province Defined as the Governing State or Province where the policy was written
Subrogation The amount of recovery that the insurance company has collected.
Subrogation Reserve Amount The estimated amount of recovery the insurance company will collect. Subrogation Reserve includes both Initial Subrogation Reserves and Change in Subrogation Reserves within the evaluation period.
Suit State/Province The state or province in which the litigation has been filed. This can be different fro the policyholder’s state/province or exposure state/province.
Tenured Retention Analysis in Retention Monitor that provides both counts and percentages of policies that are still active at least 48 months after the Original Inception Date as of the end of any given measurement month/year.
Unallocated Expenses Paid to Paid Loss
(Initial Unallocated Expenses + Change in Allocated Expenses) ÷ Paid Loss
Unallocated Expense Reserves to All Reserves
Unallocated Reserves ÷ (Allocated Reserves + Unallocated Reserves)
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 228
Field Definition/Formula
Valuation Date The date from which data is evaluated. An “as of” date. Example: Incurred Losses for 2005 - 2006 valued as of 12/31/2006. The valuation date is 12/31/2006.
Valuation Period A point in time from which data is evaluated. An “as of” date. Example: Incurred Losses for 2005 - 2006 valued as of 12/31/2006. The valuation period is 12 months.
Views
User defined presentation of information in the Insight applications. Sample views include: Chart Data set Report Scorecard
Warehouse
A central repository for all policy and claims transactions loaded from various source systems. Transactional data in the Warehouse has been standardized into common format and is aggregated prior to being loaded into the Insight applications.
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 229
24BIndex
A
About Alerts on Dashboard ..............................27 Background Results on Dashboard .......29 My Analyses on Dashboard ...................28 Reports on Dashboard...........................28
Accessing Reports...................................................31
Accident Month Case Incurred Loss Loss Ratio Aging..................................103 Severity Aging......................................111
Accident Month Loss Severity Analyzing..............................................111 Severity Aging......................................112 Severity Relativity ................................113
Accident Month Number of Losses Frequency Aging..................................108 Severity Aging......................................111
Accident Year Data Loss Triangles........................................82
Accident Year Loss Severity Loss Monitor.........................................118
Accident Year Triangles ............................82 Action Bar
Definitions for Analytics..........................42 Active Alert
Icon ........................................................26 Active Policies
Retention Trend ...................................125 Add to Dashboard
Analytics.................................................42 Button.....................................................28
Adding Alerts to Dashboard ...............................27 Analyses to Dashboard..................89, 165 My Analyses to Dashboard ....................28 Pages to Dashboard Using Wizard......166 Report/Chart Titles.................................61 Reports to Dashboard............................28 Summary to Dashboard .........................29
Additional Filters ........................................47 Additive
Icon ........................................................62 Adverse Selection....................................140 Adverse Selection Columns
Attribute Overview................................142 Profile Monitor Summary .....................145
Age of Claims Time Periods................................158, 160
Agency Experience by Policy Year Report.................................................. 173
Agency Performance Profile Monitor ..................................... 131
Agent Retention by Agent Report.................................................. 173
Aggregate Loss Severity Amount ......................... 113
Aggregate Loss Ratio ............................. 106 Alarm
Alerts on Dashboard ............................. 27 Alert Selections
Selecting................................................ 91 Alert Wizard ............................................ 168
Creating................................................. 91 Alerts
Active on Dashboard............................. 27 Adding to Dashboard ............................ 27 Deleting ................................................. 27 Editing ................................................... 27 Icon........................................................ 26 On Dashboard....................................... 27 Tab ........................................................ 27 Viewing.................................................. 27
Always Current Claims Monitor .................................... 148
Analyses Adding to Dashboard .................... 89, 165 Base Options......................................... 50 Deleting ............................................... 164 Filters..................................................... 46 Loss Triangles ....................................... 82 Naming ................................................ 163 Opening................................................. 84 Output Tabs........................................... 70 Previewing............................................. 63 Retieving ............................................. 164 Running ................................................. 63 Running New......................................... 82 Saved Details ...................................... 164 Saving ........................................... 86, 163 Selecting a Category............................. 40 Selecting Current Year.......................... 52 Sending Through E-mail ....................... 93 Setting Up in Monitors........................... 98 Setup ..................................................... 46 Values ................................................. 148 Year Basis Options ............................... 50
Analysis Categories Analytics ................................................ 41
Analysis Setup
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 230
Claims Monitor .....................................147 Loss Monitor.........................................101 Profile Monitor ......................................132 Retention Monitor.................................119 Summary Page ....................115, 129, 144
Analysis Summary...............................57, 60 Analytics
Alert Wizard............................................91 Analysis Categories ...............................41 Analysis Summary ...........................57, 60 Chart Area..............................................70 Chart Tab ...............................................70 Corporate Detail .....................................41 Corporate Experience Summary............41 Custom Filter..........................................53 Data Area View ......................................71 Data Tab ................................................71 Datamart ................................................39 Developing Analyses .............................40 Drill Down Level ...............................70, 71 Drill Info ..................................................45 Drill Information......................................44 Drill Options............................................44 Expanding View .....................................43 Features .................................................39 Filters .....................................................46 Graph .....................................................44 Icons for Summary Analyses .................62 Introduction ................................14, 18, 39 Line of Business.....................................41 Line of Business Detail ..........................41 Metrics..............................................39, 54 Output Selections...................................84 Previewing an Analyses.........................63 Print Option ............................................44 Reports...................................................87 Resize Option.........................................44 Running a New Analysis ........................82 Running Analyses ..................................63 Saving Analyses ....................................86 Screen Definitions..................................44 Selecting Filters .....................................47 Setting up Analyses ...............................40 Setup......................................................46 SQL Analyses ........................................81 Summary................................................57 Tab Option .............................................44 Title Bar............................................44, 45 Top Bar Menu Definitions ......................42 Warning Message ..................................95
Analyzing Accident Month Loss Severity..............111
Annual Retention Rate Retention Monitor.................................130 Tenured Retention ...............................128
Application Layer .......................................17
Applications Suite Application Layer................................... 17
arc Reports.................................................. 37
Assigning Scores ................................................. 166
At the Beginning Tenured Retention .............................. 128
At the End of Tenure Tenured Retention .............................. 128
Attribute Attribute Overview............................... 142
Attribute Overview................................... 142 Attribute Preferences
Setting in Profile Monitor ..................... 133 Attribute Value
Profile Template .................................. 135 Variation from Profile........................... 138
Attributes Monitor Filters........................................ 99 Scoring ................................................ 142
Available Reports.................................... 173 Average
Loss Severity....................................... 112 Average Claim Expense ......................... 157 Average Number of Days
Claims ................................................. 162 Average Salvage and Subrogation......... 159
B
Background Results About on Dashboard ............................. 29
Background Results Icon........................................................ 26
Background Results Tab ........................................................ 29
Band Claims Monitor .................................... 147 Definitions............................................ 149 Individual Claim Detail......................... 155
Band Definitions Inflation Rate ....................................... 156 Loss Reserve Accuracy ...................... 151 Time Lag Measurement ...................... 162
Band Locations ....................................... 149 Band Parameter Setup ........................... 148 Basis Options
Filters..................................................... 50 Book Month
New Business Retention ..................... 123 Retention Trend................................... 125 Scrap Rate .......................................... 121 Tenured Retention .............................. 127
Book of Business
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 231
Measuring Changes.............................131 Burning Costs by Brand
Inflation Rate........................................156 Business
Comparing............................................138 Business Indicator by Producer
Report ..................................................173 Business Indicator by Underwriter
Report ..................................................173 Business Trend by Company
Report ..................................................174 Business Trend by Producer
Report ..................................................174 Business Trend by Underwriter
Report ..................................................174 Businessowners
Filters ...................................................183 Buttons
Add to Dashboard ............................28, 42 Analytics.................................................42 Delete...................................27, 28, 29, 30 E-mail .....................................................42 Export Analysis ......................................42 Groups ...................................................32 Login ......................................................21 Logout ....................................................23 New Analysis..........................................42 Open Analysis ........................................42 Print List .................................................33 Report Types..........................................32 Run Analysis ..........................................42 Run Report.............................................42 Save Analysis.........................................42 Search....................................................32 Send Me My Password ..........................22 Setup......................................................42 Source....................................................32 Subscribe ...............................................33 Unsubscribe ...........................................33
C
Calendar Month Earned Exposure Frequency Aging..................................107
Calendar Month Earned Premium Loss Ratio Aging..................................103
Calendar Premium-Accident Losses Filters .....................................................50
Calendar/Accident Case Incurred Loss Ratio Loss Ratio Aging..................................103 Loss Ratio Relativity ............................105
Calendar/Accident Year Case Incurred Loss Ratio Loss Monitor.........................................116
Cancel
Icon........................................................ 62 Case Incurred Loss Amounts
Loss Reserve Accuracy ...................... 151 Catastrophe Claims by Catastrophe
Description Report.................................................. 174
Catastrophe Claims by Company Report.................................................. 174
Catastrophe Claims by Line of Business Report.................................................. 174
Catastrophe Claims by Reinsurance Company Report.................................................. 174
Category Analytics ................................................ 40
Ceiling Loss Monitor Analyses ........................ 101
Change in Profile Columns Attribute Overview....................... 142, 143 Profile Monitor Summary..................... 145
Changing Password............................................... 23 Profile Template .................................. 134
Chart Area View........................................ 70 Chart Tab
Analytics ................................................ 70 Check box
Select All ............................................... 26 Claim Activity for all Producers
Report.................................................. 175 Claim Bands............................................ 148
Loss Reserve Accuracy .............. 151, 153 Claim Count
Loss Reserve Accuracy ...................... 153 Claim Counts
Loss Reserve Accuracy ...................... 153 Claim Counts and Incurred Loss Values by
Band Inflation Rate ....................................... 156
Claim Daily Detail Filters................................................... 185
Claim Detail............................................. 155 Filters................................................... 186
Claim Expense........................................ 157 Claim Expense (by Year/Quarter/Month)
Claim Expense .................................... 158 Claim Expense Analysis Summary
Report.................................................. 175 Claim Feature by Adjuster
Report.................................................. 175 Claim Status
Loss Reserve Accuracy .............. 151, 153 Time Lag Measurement ...................... 162
Claims in Litigation by Adjuster Report.................................................. 175
Claims in Salvage Summary
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 232
Report ..................................................175 Claims in Subrogation Summary
Report ..................................................175 Claims Monitor...................................97, 147
Analysis Setup .....................................147 Band Definitions...........................151, 162 Claim Expense.....................................157 Creating New Analyses........................147 Inflation Rate........................................156 Loss Reserve Accuracy by Claim Count
..........................................................153 Loss Reserve Accuracy by Dollar Amount
..........................................................151 Salvage and Subrogation.....................159 Time Lag Measurement .......................161
Claims Reported From Claims Monitor .....................................147
Claims Reported From Ending Profile Monitor ......................................148
Claims Valued as of 1st Valuation Date Claims Monitor .....................................148
Claims Valued as of 2nd Valuation Date Claims Monitor .....................................148
Claims with Expense Payments Claim Expense.....................................158
Claims with Loss Payments Claim Expense.....................................158 Salvage and Subrogation.....................160
Claims with Salvage and Subrogation Payments Salvage and Subrogation.....................160
Clearing Temporary Files .....................................15
Clicking Reports Documentation .........................35
Close Window Command...............................................29
Comma Delimited Files Exporting Reports ..................................88 Exporting to Excel ................................170
Commercial Auto Filters ...................................................188
Commercial Property Filters ...................................................190
Company and Line of Business Summary Report ..................................................176
Company and State Summary by Month Report ..................................................176
Comparisons Variation from Profile ...........................138
Composite Score .....................................142 Adverse Selection ................................140
Composite Score Table Adverse Selection ................................141
Composite Weight ...................................142 Attribute Overview................................142
Condense Information Icon........................................................ 26
Corporate Detail Analytics ................................................ 41 Filters................................................... 192
Corporate Experience Summary Analytics ................................................ 41 Filters................................................... 194
Count Icon........................................................ 62
Counts by Band Inflation Rate ....................................... 156
Create an Alert........................................ 169 Analytics ................................................ 42 Buttons .................................................. 42
Creating Alert Wizard................................... 91, 168 New Analyses in Claims Monitor......... 147 New Analyses in Loss Monitor ............ 101 New Analyses in Profile Monitor ......... 132 New Analyses in Retention Monitor .... 119
CSV Exporting Reports ................................. 88
CSV Files Exporting to Excel ............................... 170
Current Year Options Filters..................................................... 52
Custom Filter ...................................................... 53
D
Dash Reports.................................................. 35
Dashboard Adding Alert Selections ......................... 92 Adding Analyses.................................... 89 Adding Summary................. 115, 129, 144 Alerts ............................................. 27, 169 Background Results .............................. 29 Icons...................................................... 26 Introduction................................ 14, 18, 25 My Analyses.......................................... 28 Populated .............................................. 30 Reports.................................................. 28 Saving Analyses For ..................... 90, 167 Tabs ...................................................... 27 Updates ................................................. 25 Viewing Loss Monitor Summary. 116, 129,
144 Dashboard Wizard
Selecting Options ................................ 165 Data Area View......................................... 71 Data Layer ................................................ 17 Data Tab
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 233
Analytics.................................................71 Datamarts
Analytics.................................................39 Default Setting
Timeout ..................................................14 Defaults
Category.................................................40 Defining
Filters .....................................................48 View .......................................................58
Delete Button...................................27, 28, 29, 30 Icon ........................................................26
Deleting Alerts ......................................................27 Analyses.........................................85, 164 My Analyses...........................................29 Reports.............................................28, 34 Summary................................................30
Details Viewing Individual Claims ....................155
Developing Analyses in Analytics .............................40 Loss Triangles........................................82
Distorted Numbers Loss Amount Filters .............................101
doc Reports...................................................36
Documentation Reports.............................................35, 36
Dollar Icon ........................................................62
Dollar Amount Loss Reserve Accuracy .......................151
Downward Change by number of Bands Loss Reserve Accuracy .......................154
Downward Change by Number of Bands Loss Reserve Accuracy .......................152
Drill down Policy or Claim Count Metrics................71
Drill Down Level...................................70, 71 Drill Info
Analytics.................................................45 Drill Information
Analytics.................................................44 Drill Options
Analytics.................................................44
E
Editing Alerts ......................................................27 My Analyses...........................................29 Reports...................................................28 Summary................................................30
Edition Notice.............................................. 2 E-mail ........................................................ 93
Analytics ................................................ 42 Entering
Report/Chart Titles ................................ 61 Entering Tenure
Retention Monitor ................................ 130 Tenured Retention .............................. 128
Example Dashboard............................................. 30 Loss Frequency................................... 117 Loss Ratio ........................................... 116 Loss Severity....................................... 118 Profile Monitor Summary..................... 145
Executive Summary-Line of Business by Month Report.................................................. 176
Expand Information Icon........................................................ 26
Expanding View....................................................... 43
Expediency in Reporting Claims ................................................. 161
Expense Payments Claim Expense .................................... 158
Expiring Business Attribute Overview............................... 143 Profile Monitor Summary..................... 146
Expiring Business Period 1 Vs Period 2 Attribute Overview............................... 143 Profile Monitor Summary..................... 145
Export Analysis Analytics ................................................ 42
Exporting CSV to Excel ....................................... 170 Reports to Excel .................................... 88 To Microsoft Excel............................... 170
F
Features Analytics ................................................ 39 System .................................................. 14
Filter Basis Options ........................................ 50 Calendar Premium-Accident Losses..... 50 Current Year.......................................... 52 Custom.................................................. 53 Icon........................................................ 62 Options for When .................................. 49 Range.................................................... 53 Year Basis Options ............................... 50
Filtering Monitors................................................. 99
Filters
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 234
Analytics.............................18, 39, 46, 203 Defining ..................................................48 Loss Amount ........................................101 Monitor ...................................................98 Monitors .................................................99 Selecting ..........................................46, 49 Selecting for Claims Monitor Analyses 147 Selecting for Loss Monitor Analyses....101 Selecting for Profile Monitor Analyses .132 Selecting for Retention Monitor Analyses
..........................................................119 What.......................................................39 When......................................................39 Where.....................................................39 Who........................................................39
Filters Details LOB..............................................183, 203
Filters/Details and Metrics Used.............................................183, 203
First Year Survival Ratio..........................124 Floor
Loss Monitor Analyses.........................101 Format
Report, PDF ...........................................31 Formula
Icon ........................................................62 Frequency................................................159 Frequency Aging......................................107 Frequency Relativity ........................109, 110 From 10 to 12 Months
New Business Retention......................124 From 13 to 24 Months
Retention Trend ...................................126 From 25 to 36 Months
Retention Trend ...................................126 From 37 to 48 Months
Retention Trend ...................................126 From 4 to 6 Months
New Business Retention......................124 From 7 to 12 Months
Retention Trend ...................................126 From 7 to 9 Months
New Business Retention......................124
G
Garage Filters ...................................................195
General Liability Filters ...................................................196
Glossary...................................................221 Governing State Analysis for Commercial
Lines Report ..................................................176
Governing State Analysis for Personal Lines
Report.................................................. 176 Graph
Analytics ................................................ 44 Groups
Reports.................................................. 35 Reports Filtering.................................... 32
H
Help Introduction............................................ 14 Password............................................... 22 User Name ............................................ 22
Hist Reports.................................................. 35
Historical Increases or Decreases Measuring............................................ 156
Historical Policy Retention Measuring............................................ 119
Historical Reports Viewing.................................................. 37
Homeowners Filters................................................... 198 Monitor Filters...................................... 199
I
Icons Dashboard............................................. 26 Summary Analyses ............................... 62
Inactive Policies Scrap Rate .......................................... 121
Incurred Loss Amount Claims Monitor .................................... 147
Incurred Loss Changes Measuring.................................... 151, 153
Inflation Rate........................................... 156 Band Definitions .................................. 156
Inflation Summary Inflation Rate ....................................... 156
Inforce Business (Current Month) Profile Template .................................. 135
Inforce Policies Frequency Aging ................................. 107
Inforce Policy Current Counts .................................... 133
Information Accident Month Loss Severity............. 113 Frequency Aging ................................. 108 Frequency Relativity............................ 110 Loss Ratio Relativity............................ 106 Lost Policy ................................... 121, 123 Policy Retention .................................. 125 Severity Aging ..................................... 112
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 235
Severity Relativity ................................114 Tenured Retention Policy.....................127
Information Management Suite Data Layer..............................................17
Insight Introduction ............................................17
Introduction Analytics.................................................18 Insight.....................................................17 Monitors .................................................18 Reports.............................................19, 31
K
Keywords Searching Reports .................................32
L
Large Loss over $50,000 by Cause of Loss Report ..................................................177
Leaving Tenure Retention Monitor.................................130 Tenured Retention ...............................128
Legend Loss Reserve Accuracy .......................152 Loss Reserve Accuracy .......................154
Line of Business Analytics.................................................41 By State Report....................................177
Line of Business Detail Analytics.................................................41
Linking E-mail .....................................................93
Links Doc from Reports...................................36
Load Date Reports...................................................32
Login ..........................................................21 Login Help..................................................22 Logout........................................................23
Introduction ............................................14 Loss Amount Filters.................................101 Loss Expense
Salvage and Subrogation.....................160 Loss Experience
Measuring ............................................100 Loss Experience by Coverage
Report ..................................................177 Loss Frequency
Example ...............................................117 Loss Frequency Per Exposure Unit
Loss Monitor.........................................117 Loss Frequency per Month
Frequency Aging ................................. 108 Loss Frequency Per Month
Frequency Relativity............................ 110 Loss Monitor ............................................. 97
About ................................................... 100 Analysis Setup..................................... 101 Creating New Analyses....................... 101 Dashbaord Summary .......... 116, 129, 144 Frequency Aging ................................. 107 Frequency Relativity............................ 109 Loss Ratio Aging ................................. 103 Loss Ratio Relativity............................ 105 Output Format ..................................... 102 Severity Aging ..................................... 111 Severity Relativity................................ 113
Loss Monitor Analyses Ceiling ................................................. 101 Floor .................................................... 101
Loss Paid and Reserve Activity Report.................................................. 177
Loss Payments Claim Expense .................................... 158 Salvage and Subrogation.................... 160
Loss Ratio Example .............................................. 116
Loss Ratio Aging..................................... 103 Loss Ratio Relativity ............................... 105
Loss Ratio Relativity............................ 106 Loss Reserve Accuracy .................. 151, 153
Band Definitions................................ 153 Claim Detail ......................................... 155
Loss Severity Average ............................................... 112 Example .............................................. 118
Loss Severity Amount Average ............................................... 113
Loss Triangles........................................... 82 Columns ................................................ 83 Setting Up.............................................. 82
Lost Policy Information .................................. 121, 123
M
Main Menu Options................................. 14 Measurement Month/Year
Tenured Retention .............................. 128 Measurement of Time Lags ................. 162 Measuring
Changes in Book of Business ............. 131 Claims ................................................. 147 Historical Increases or Decreases ...... 156 Incurred Loss Changes Between
Evaluation Periods........................... 151 Incurred Loss Changes Over Time ..... 153
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 236
Retention Trends .................................119 Underwriting and Loss Experience ......100 Variation Between Time Periods..........140
Message Warning................................................171
Metric Details LOB..............................................183, 203
Metrics Analytics...........................................18, 39 Introduction ............................................54 Selecting ................................................56 Viewing Selected ...................................57
Microsoft Excel Exporting Reports ..................................88 Exporting To.........................................170
Monitor Basics ...........................................98 Monitors
Filters .....................................................99 introduction.............................................97 Introduction ......................................14, 18 Summary on Dashboard ........................29
Monthly Alert Selections Setting ..................................................169
My Analyses About on Dashboard ..............................28 Tab .........................................................28
My Analyses Adding to Dashboard .............................28
My Analyses Viewing...................................................29
My Analyses Editing ....................................................29
My Analyses Deleting ..................................................29
My Settings Introduction ............................................14
N
Naming Analyses...............................................163
Navigating Insight.....................................................14
Navigation Reports...................................................32
Net Change Tenured Retention ...............................128
Net Premium by Branch Report ..................................................177
New (Originating Month) to 6 Months Retention Trend ...................................126
New Analysis Analytics.................................................42
New and Expiring Business Tables Adverse Selection ................................140
New and Renewal Business Summary Report.................................................. 177
New and Renewal Experience Report.................................................. 178
New and Retained Business Distribution Report.................................................. 178
New Business Attribute Overview............................... 143 Profile Monitor Summary..................... 146
New Business + Expiring Business Period 1 Attribute Overview............................... 143 Profile Monitor Summary..................... 145
New Business + Expiring Business Period 2 Attribute Overview............................... 143 Profile Monitor Summary..................... 145
New Business Experience Summary Report.................................................. 178
New Business Period 1 Vs Period 2 Attribute Overview............................... 143 Profile Monitor Summary..................... 145
New Business Premium Comparison Report.................................................. 178
New Business Retention......................... 123 Lost Policy ........................................... 123
New to 48 Months Retention Trend................................... 126
Non-Additive Icon........................................................ 62
Number of Lost Policies Scrap Rate .......................................... 122
Number of Tenured Policies Tenured Retention .............................. 128
Numeric Score Selections ...................... 166
O
Observed Count...................................... 133 Variation from Profile........................... 138
Observed Count – Observed Count Profile Template .................................. 135
Observed Percent ................................... 133 Profile Template .................................. 135 Variation from Profile........................... 139
Observed Rating Profile Template .................................. 136 Variation from Profile........................... 139
Open Analysis Analytics ................................................ 42
Open Claims Report.................................................. 179
Opening Analyses................................................ 84
Original Effective Date Scrap Rate .......................................... 122
Originating Month
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 237
Scrap Rate ...........................................122 Originating Month to 3 Months
New Business Retention......................124 Originating Month/Year
New Business Retention......................124 Retention Trend ...................................126 Scrap Rate ...........................................122
Output Selection in Analytics .............................84
Output Format Loss Monitor.........................................102 Retention Monitor.................................120
Output Tabs Analyses.................................................70
P
Password ...................................................21 Changing................................................23
Pending Loss Reserve Report ..................................................179
Percentage of Claim Cost by Band Inflation Rate........................................156
Percentage of Claim Counts by Band Inflation Rate........................................156
Personal Auto Filters ...................................................200 Monitor Filters ......................................202
Personal Auto New Business Average Premium by Producer Report ..................................................179
Policies New Business Retention......................123
Policies Issued New Business Retention......................124 Scrap Rate ...........................................122
Policies Remaining Active Retention Trend ...................................126
Policies Remaining After 12 months New Business Retention......................124
Policies Remaining After 12 Months New Business Retention......................124 Retention Monitor.................................130
Policies Retained Scrap Rate ...........................................122
Policies Retained by Count & Percentage New Business Retention......................124
Policy Inforce Counts......................................133
Policy and Claim Count Metrics drill down................................................71
Policy Counts Tenured Retention ...............................127
Policy Expiration by Producer Report ..................................................179
Popup Blockers......................................... 13 Preference Direction
Profile Template .................................. 135 Setting ................................................. 133 Variation from Profile........................... 138
Preferred Count Profile Template .................................. 136 Variation from Profile........................... 139
Preferred Percent Profile Template .................................. 135 Setting ................................................. 133 Variation from Profile........................... 139
Premiums Written, Inforce, Earned and Unearned by Line Report.................................................. 179
Previewing Analyses................................................ 63
Print List Button .................................................... 33
Print Option Analytics ................................................ 44
Print this window Command........................................ 29, 33
Printing.................................................... 170 Producer and Line of Business Summary
Report.................................................. 179 Producer and Line of Business Summary by
Month Report.................................................. 179
Producer Claim Activity Report.................................................. 180
Producer Closed Claim Activity Report.................................................. 180
Producer Inforce Report.................................................. 180
Profile Monitor................................... 97, 131 Adverse Selection ............................... 140 Analysis Setup..................................... 132 Attribute Overview............................... 142 Creating New Analyses....................... 132 Profile Template .................................. 133 Report Outputs .................................... 133 Summary Example.............................. 145 Variation from Profile........................... 138
Profile Template...................................... 133 Changes .............................................. 134
R
Range Filter ...................................................... 53
Ratio Icon........................................................ 62
Recipients E-mail .................................................... 94
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 238
Recovery Rate.........................................159 REINCO Exposure by Agent
Report ..................................................180 Reinsurance
Report ..................................................180 Reinsurance Loss Ratio
Report ..................................................180 Relativity
Frequency Relativity ............................109 Loss Ratio Relativity ............................105 Severity Relativity ................................113
Remaining within Band Loss Reserve Accuracy .......................152 Loss Reserve Accuracy .......................154
Remove Icon ........................................................62
Renewal Business Experience Report ..................................................180
Renewal Business Experience Summary Report ..................................................181
Report Icon ........................................................26 Subscribing To .......................................34 Unsubscribing ........................................34
Report Identification Number Reports...................................................35
Report Month Claim Expense.....................................158 Salvage and Subrogation.....................159
Report Name Clicking...................................................35 Reports...................................................35
Report Quarter Claim Expense.....................................158 Salvage and Subrogation.....................159
Report Types Reports Filtering.....................................32
Report Year Claim Expense.....................................158 Salvage and Subrogation.....................159
Report/Chart Titles.......................................................61
Reporting Claim Expendiency ..............................161
Reports About on Dashboard ..............................28 Accessing...............................................31 Adding to Dashboard .............................28 Analytics.................................................87 Arc..........................................................37 Archived .................................................37 Available...............................................173 Deleting ............................................28, 34 Documentation.................................35, 36 Editing ....................................................28 Exporting to Excel ..................................88
Generated ............................................. 31 Introduction................................ 14, 19, 31 Load Date.............................................. 32 Main Screen .......................................... 35 Navigation ............................................. 32 Print List ................................................ 33 Printing .................................................. 36 Printing Archived ................................... 37 Printing Report Documentation ............. 36 Saving ................................................... 36 Saving Archived .................................... 37 Saving Report Documentation .............. 36 Searching .............................................. 32 Subscribe .............................................. 33 Tab ........................................................ 28 Top Bar Menu........................................ 32 Unsubscribe .......................................... 33 Viewing............................................ 28, 35 Viewing Historical Reports .................... 37
Reports Documentation Clicking.................................................. 35
Requirements System .................................................. 13
Resize Option Analytics ................................................ 44
Results Loss Triangles ....................................... 83
Retained Policy Information .......................................... 125
Retention Monitor.............................. 97, 119 Analysis Setup..................................... 119 Creating New Analyses....................... 119 Output Format ..................................... 120
Retention Trend ...................................... 125 Retained Policy ................................... 125
Retrieving Analyses.............................................. 164 Saved Analysis...................................... 84
row count limits ......................................... 65 Run Analysis
Analytics ................................................ 42 Run Report
Analytics ................................................ 42 Running
Analyses.......................................... 40, 63 New Analysis......................................... 82 SQL Analyses........................................ 81
S
Salvage and Subrogation ....................... 159 Salvage and Subrogation Payments
Salvage and Subrogation.................... 160 Sample Listing of Reports....................... 173 Save Analysis
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 239
Analytics.................................................42 Saving
Analyses.........................................86, 163 Analyses to Dashboard..........................89
Scoring Dahsboard Reports........................90, 167
Scoring Ratings .......................................142 Scrap Rate...............................................122
Lost Policy............................................121 Retention Monitor.........................121, 130
Screen Definitions Analytics.................................................44
Search Keywords for Reports ............................32 Reports Tool Bar....................................32
Searching Reports...................................................32
Second Month Scrap Rate ...........................................122
Sector Change Loss Reserve Accuracy ...............152, 154
Sector Drift Loss Reserve Accuracy .......................154
Security Icon ........................................................62
Select All Indicator .................................................26
Selecting Alert Selections ......................................91 Analyses Filters......................................47 Analyses Time Frame ............................47 Filters ...............................................46, 49 Filters for Claims Monitor Analyses .....147 Filters for Loss Monitor Analyses.........101 Filters for Profile Monitor Analyses ......132 Filters for Retention Monitor Analyses.119 Metrics....................................................56 Recipients for E-mail ..............................94
Semi-Additive Icon ..................................................62, 74
Send Me My Password..............................22 Setting
Alert Parameters ..................................168 Attribute Preferences in Profile Monitor
..........................................................133 Monthly Alert Selections ......................169 Preference Direction ............................133 Preferred Percent.................................133
Setup Analyses in Analytics .............................40 Analysis....................... 101, 119, 132, 147 Analytics...........................................42, 46 Band Parameter...................................148 Loss Triangles........................................82
Severity Aging..........................................111 Severity Relativity ............................113, 114
Shared Features ....................................... 14 Snapshot
Icon........................................................ 62 Source
Reports.................................................. 35 Reports Filtering.................................... 32
SQL Analyses ........................................... 81 Standard Filters/Details and Metrics183, 203 Subrogation and Salvage
Report.................................................. 181 Subscribe
Button .................................................... 33 Subscribing To
Report.................................................... 34 Summary
Adding to Dashboard ............................ 29 Analytics ................................................ 57 Deleting ................................................. 30 Editing ................................................... 30 Viewing.................................................. 29
Summary Analyses Icons...................................................... 62
Summary Selection Loss Monitor........................ 115, 129, 144 Monitor Filters........................................ 98
Support ..................................................... 12 Survival Ratio
First Year............................................. 124 System Requirements .............................. 13
T
Tab Option Analytics ................................................ 44
Tabs Alerts ..................................................... 27 Analytics ................................................ 70 Background Results .............................. 29 Dashboard............................................. 27 My Analyses.......................................... 28 Reports.................................................. 28
Temporary Files ........................................ 15 Tenured Retention .................................. 127
Tenured Retention Policy.................... 127 Tenured Retention Policy
Information .......................................... 127 Third Month
Scrap Rate .......................................... 122 Time
Basis Options ........................................ 50 Filter Options ......................................... 49 Range Filters ......................................... 53
Time Frames Claims Monitor .................................... 147
Time Lag Measurement.......................... 161
Oracle Insurance Insight User Guide
Oracle Insurance Insight User Guide Version 5.1.0 240
Time Periods Age of Claims...............................158, 160 Measuring Variation .............................140 Time Lag Measurement .......................161
Timeout......................................................14 Title
Report/Chart...........................................61 Title Bar
Analytics...........................................44, 45 Top 10 Producer New Business Experience
Report Report ..................................................181
Top 10 Producers by Written Premium for Company and State Report ..................................................181
Top Bar Menu Reports...................................................32
Total Scrap Rate ...........................................122
Total Change Loss Reserve Accuracy .......................151 Loss Reserve Accuracy .......................153
Total Drift Loss Reserve Accuracy .......................152 Loss Reserve Accuracy .......................154
Trends Retention..............................................119
Types Reports...................................................35
U
Underwriting Measuring ............................................100
Unsubscribe Button.....................................................33 Report ....................................................34
Updating Dashboard..............................................25
Upward Change by number of Bands Loss Reserve Accuracy .......................154
Upward Change by Number of Bands Loss Reserve Accuracy .......................151
User Name.................................................21
V
Values Claim Bands........................................ 149
Variation Columns Attribute Overview............................... 143 Profile Monitor Summary..................... 146
Variation from Profile .............................. 138 View
Chart Area ............................................. 70 Data Area .............................................. 71 Defining ................................................. 58 Expanding ............................................. 43
View Tab ................................................... 57 Viewing
Alerts ..................................................... 27 Historical Reports.................................. 37 Individual Claims ................................. 155 Loss Monitor Summary on Dashboard116,
129, 144 My Analyses.......................................... 29 Reports............................................ 28, 35 Selected Filters...................................... 57 Summary ............................................... 29
W
Warning Messages ........................... 95, 171 What
Filter ...................................................... 47 Monitor Filters........................................ 98
When Filter ...................................................... 47 Filter Options ......................................... 49 Monitor Filters........................................ 98
Where Filter ...................................................... 47 Monitor Filters........................................ 98
Who Filter ...................................................... 47 Monitor Filters........................................ 98
Y
Year Basis Options Filters..................................................... 50