ANNOUNCEMENT Attend the P&C Information Day meeting on 9/26 in New Brunswick, NJ for an in-depth review of the initiative, model, and industry usage.
The artifacts below were developed by the OMG P&C Workgroup over a six year timeframe. The workgroup was comprised of over 50 organizations. These deliverables/artifacts are “Open Community” and represent the OMG Approved version of this workgroup. The roadmap for the “way forward” is referenced in the P&C Data Model Submission document listed below. All organizations interested in joining the workgroup are welcome. Questions and comments can be directed to this workgroup’s leads or OMG.
Property and Casualty Data Model – OMG Approved Submission
- Adobe Acrobat Publication (13-04-04_p_c_data_model_submission.pdf) - read the background, requirements and Guidelines & Standards, and view the ‘print’ version of the Models in a Conceptual model and 14 subject areas in Logical and Physical views, with definitions and a Glossary (269 pages).
- PowerPoint Presentation (13-09-00_omg_pc_data_model_publication.pptx) - How to Access the OMG Wiki Site and Direct Hyperlink Shortcuts to the key Documents; document to save and/or send on to others.
P&C Data Model Documents Imbedded or Illustrated in the Submission. 1st Time viewers may want to open first four documents before opening the Full Submission
- Word Publication (13-04-08_p_c_conceptual_data_model_overview.docx) – view the high-level data model identifying major entities and relationships of importance to the P&C business.
- PowerPoint Presentation (13-04-12_p_c_data_model_c-l-p_diagrams.pptx) - Summary with the Conceptual Model Entity Level overview followed by the major subject areas in Entity Level, Logical and Physical views.
- Excel Publication (13-04-07_p_c_data_model_glossary_of_terms.xlsx) – view the key definition of insurance and data model terms that are relevant to the Data Model.
- HTML Model View (13-04-09_p_c_logical_data_model_r1.0_web_pub_v4.zip) - For readers without ERwin to view the data model diagrams and definitions in a browser. This is a true zip file; download and “Extract all files”, and then click on the 1st file in the folder to run the Table of Contents browser: ~P&C LDM Web Pub Table of Contents.htm in Internet Explorer or your default browser.
- ERwin Definition (13-04-10_p_c_logical_data_model_r1.0_erwin_r7.3.11.erwin.zip) – view the Logical representation of the data models definition in the data modeling tool, ERwin, for users of this tool.
- Excel Workbook (13-04-11_p_c_logical_data_model_workbook.xlsx) - view, sort, lookup, compare the Logical data model object definitions presented in a set of Excel spreadsheets.
- ERwin Definition (13-04-13_p_c_physical_data_model_r1.0_erwin_r7.3.11_sql-server.erwin.zip) - view the Physical representation of the data models definition in the data modeling tool, ERwin, for users of this tool.
- Excel Workbook (13-04-14_p_c_physical_data_model_workbook.xlsx) - view, sort, lookup, compare the Physical data model object definitions presented in a set of Excel spreadsheets.
- DDL File (13-04-15_p_c_physical_data_model_ddl_sql_server.ddl.zip) – Open and view the models as a Data Definition Language file.
- XML Definition (13-04-06_p_c_ldm_r1.0.xml.zip) - Logical data model definition in standard technical interchange XML, useable for import into other tools.
NOTE: Other than the HTML file, Open -Save Files with the “.zip” extension then rename and remove the .zip as these are not Zipped files. Security will not allow ‘native-named’ .erwin, .xml or .ddl files to be downloaded.
Property and Casualty (P&C) carriers need to be more agile in their operations, processes and decision making in order to sustain a growth-oriented enterprise and successfully compete in a networked world – by and large, this is not the case today. Challenges that carriers face in a 24×7 globally dispersed world range from regulatory changes, profitable growth, and everything in between. These challenges demand an accurate understanding of the enterprise assets (e.g., People, Process, and Technology) and the inter-dependencies among these assets. Business stakeholders want the products and services to be delivered better, cheaper and faster in the midst of the inherent challenges of dealing with legacy systems. Furthermore, the Internet drives the need to define more loosely coupled, interoperable business processes and associated software components executable in distributed and heterogeneous environments.
In order to support the much needed agility, business functions and associated processes must be supported by semantically accurate and reusable Information (data and its associated metadata). Information modeled and/or mapped to domain specific standards further enhances its value and interoperability. Service Oriented Architecture (SOA) is often touted as the solution that will enable agility, coupled with XML based domain standards used in exchanging information internally and externally. However, the domain specific XML standards often cater to an inter-enterprise exchange of data and offer very little, if any, semantic richness and traceability to production databases and applications.
To develop Standard “Reference Model” in the form of Information Models for the P&C insurance industry. Ultimately these Models and their supporting artifacts can be reused and/or extended to other related domains like Life and Reinsurance. P&C carriers would utilize the information models towards development of P&C business services to better understand and automate their business processes and functions with the objective of continuous improvement and creating a more agile business environment.
Organizations that develop their own XML Schemas using Schema editors risk having the XML tags not in sync with the core business concepts. By developing an XML Schema model using the MDA approach preserves semantic accuracy and consistency; but, also preserves critical data modeling features (e.g., Primary/Foreign keys, relationships into ID and IDRefs in the XML Schema). Maintenance of XML Schemas generated from these models is easier, less time consuming, and less costly.
The stated required deliverables for the P&C Data Model Working Group (WG) are:
- Glossary of P&C Business Terms and accompanying metadata (source, version, format as well as Party, Party Role, Address for example)
- Conceptual Data Model representing P&C business concepts with a target audience of business Subject Matter Experts, data modelers and business analysts for example.
- Attributed Logical (ER) Data Model with appropriate identifiers, logical data types and relationships as appropriate.
- Traceability of P&C Business Terms to models (and model elements) listed above as well as valid semantic variations where applicable (synonyms, geographical variations etc.).
The P&C Data Model Working Group (WG) is focused mainly on the regulated USA Property and Casualty insurance industry for both Personal and Commercial lines. The ceded reinsurance view is included; but, the reinsurer view is not. The WG initial submission focused on the data and models needed to support New Business, Policy Administration, and Claims.
P&C Standard- Approach - The OMG P&C WG has embarked upon applying the proven Model Driven Architecture approach to development of a set of P&C Information Models traceable from an accepted set of business-driven concepts (e.g., Claims, Policy). We recognize that there are several providers and consumers of such business concepts in an insurance enterprise. Therefore, the proposed P&C Information Models must accommodate the need to represent the same business concept visually and otherwise via a set of Models targeted for a variety of providers and consumers. The Request for Proposal solicits input for ‘Information Models’ to address the data management needs of the P&C Insurance Community.
The WG intends to leverage and collaborate with the following:
- Intellectual property and artifacts donated by participating carriers, consulting firms, and technology vendors.
- OMG’s standards that support Information modeling (e.g., Common Warehouse Metamodel, CWM/Information Management Metamodel, Ontology Definition Metamodel, Semantics of Business Vocabulary, and Rules-SBVR).
- Open Source Community and ACORD.
- Develop models of P&C Business ‘Services’ and ‘Business Events’ in collaboration with OMG SOA Special Interest Group (SIG).
Bill Jenkins, Managing Partner, Agile Insurance Analytics, firstname.lastname@example.org
Tom Ford, Partner, LiquidHub, email@example.com
Ken Berk, Vice President of Business Development, Object Management Group, firstname.lastname@example.org
ACORD, http://www.acord.org (Association for Cooperative Operations Research and Development) is a global, nonprofit insurance association whose mission is to facilitate the development and use of standards for the insurance, reinsurance and related financial services industries