Teradata Financial
Services Logical
Data Model
Release 10.00.00
For Financial Institutions and
Insurance Companies
Appendices
Book 1 of 2
IMPORTANT
PROCEEDING
CAREFULLY READ THE FOLLOWING NOTICE BEFORE
THE INFORMATION CONTAINED IN THIS DOCUMENT CONSTITUTES CONFIDENTIAL,
TRADE SECRET
INTELLECTUAL PROPERTY OF TERADATA CORPORATION
(TERADATA). You may access or use this document and the information contained herein only to
the extent that such access and/or use has been expressly authorized by Teradata through signed
written agreement(s) between you and Teradata, and you have paid all applicable fees due to
Teradata under such agreement(s). No permission or license rights will be implied. If you are not
such a Teradata-authorized user then you are not permitted or licensed to use or access this
document or the information contained herein unless and until you have the prior written consent
of Teradata to do so and all fees due therefore have been paid to Teradata. If you are uncertain
whether you are a Teradata-authorized user, please check the applicable written agreement(s) with
Teradata and/or call your Teradata account representative to confirm that you are a Teradata -
authorized user before you use or access this document or the information contained herein. By
proceeding with access or use of this document or the information contained herein, you are
representing that you are a Teradata-authorized user as described above and that you will comply
with the requirements of such applicable written agreement(s) with Teradata.
Copyright © 1995-2009 by Teradata Corporation.
All Rights Reserved.
Teradata Confidential and Trade Secret
B035-9318-039A
March 2009
The product described in this book is a licensed product of Teradata Corporation.
Teradata and Teradata Corporation are registered trademarks of Teradata Corporation. Teradata continually improves
products as new technologies and components become available. Teradata, therefore, reserves the right to change
specifications without prior notice. All features, functions, and operations described herein may not be marketed in all parts of
the world. Consult your Teradata representative or Teradata.com for more information.
Acxiom is a registered trademark of Acxiom RTC Inc.
ERwin and ERwin/Web Publisher are registered trademarks of Computer Associates, Inc.
Other brand and product names appearing in this publication are the trademarks or registered trademarks of their respective
holders.
THE INFORMATION CONTAINED IN THIS DOCUMENT IS PROVIDED ON AN AS-IS BASIS, WITHOUT WARRANTY OF ANY KIND,
EITHER EXPRESSED OR IMPLIED, INCLUDING THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR
PURPOSE, OR NONINFRINGEMENT. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES, SO THE
ABOVE EXCLUSION MAY NOT APPLY TO YOU. IN NO EVENT WILL TERADATA CORPORATION (TERADATA) BE LIABLE FOR ANY
INDIRECT, DIRECT, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS OR LOST SAVINGS, EVEN
IF EXPRESSLY ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
The information contained in this document may contain references or cross-references to features, functions, products, or
services that are not announced or available in your country. Such references do not imply that Teradata intends to announce
such features, functions, products, or services in your country. Please consult your local Teradata representative for those
features, functions, products, or services available in your country.
Information contained in this document may contain technical inaccuracies or typographical errors. Information may be
changed or updated without notice. Teradata may also make improvements or changes in the products or services described in
this information at any time without notice.
To maintain the quality of our products and services, we would like your comments on the accuracy, clarity, organization,
and value of this document. Please e-mail: Data.Modeling@Teradata.com
Any comments or materials (collectively referred to as “Feedback”) sent to Teradata will be deemed non-confidential.
Teradata will have no obligation of any kind with respect to Feedback and will be free to use, reproduce, disclose, exhibit,
display, transform, create derivative works of and distribute the Feedback and derivative works thereof without limitation on
a royalty-free basis. Further, Teradata will be free to use any ideas, concepts, know-how or techniques contained in such
Feedback for any purpose whatsoever, including developing, manufacturing, or marketing products or services incorporating
Feedback.
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved.
Teradata Confidential and Trade Secret
Release History
Release
2.1
3.0
4.0
5.0
6.0
7.0
8.0
Date
May, 1999
November, 1999
November, 2000
November, 2001
November, 2002
May, 2004
June 2006
9.0
December 2007
Foundation
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret
iii
Revision Record
Sections
Description of Change
All
All
All
All
Page iv
All
All
All
All
All
All
All
All
All
All
All
Banking
Investment
Foundation
Original Customer Release; Retail Banking
Added P&C/Life Insurance and Multicurrency
Capabilities
Added Clickstream, Privacy, and Insurance
enhancements
Added Commercial Banking, Brokerage and
Credit Cards enhancements
Added Revision History table
Added Commercial Banking, Brokerage and
Credit Cards enhancements
Changes to reflect new entities
Combined all extensions into one document
Separated the Appendices into another document
Added Financial Management and Health
Insurance functions
Entity/Attribute naming standard changes
Miscellaneous enhancements
Changes to reflect new entities
Added changes driven by Basel II that affect
Party, Agreement, and Party Asset
Added Finance, Privacy, Model Score and
Campaign enhancements
Miscellaneous enhancements
Changes to Risk Management including Market
Risk, Credit Risk, Risk Mitigation, Basel II Pillar
3 reporting and Basel II Parameters; Affects
Agreement and Product subject areas.
Financial Management additions to support
subledger information for Accounts Payable,
Accounts Receivable, Procurement, Fixed Assets,
and Project Accounting; Affects the Finance
subject area
Campaign subject area – Opportunity, Proposal,
Teradata Financial Services Logical Data Model Appendices Release 10.00.00
Cell and Step;
Event subject area – Interactive Voice
Recognition Navigation
Unstructured Text
Legal Action
Anti Money Laundering, Credit Card Balance
Segment and Access Device
Enterprise Risk Management; Salvage and
Subrogation; Behavior Based Pricing; Coverage
Level Premium
Human Capital Management, Case Management,
Advertisement Orders, clickstream for Integrated
Web Intelligence
Enhancements to Party, Product, Agreement and
Event subject areas to support investment banking
Application checklists, credit card types, Japanese
banking
Case management
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret
Banking
Insurance
10.0
March 2009
Foundation
Investments
Banking
Insurance
iv
Contents
Revision Record ................................................................................................................iii
Release History......................................................................................................................................iii
List of Tables ....................................................................................................................vii
Appendix A.....................................................................................................................A-1
Parent-Child Relationships...................................................................................................... A-1
About this Appendix...........................................................................................................................A-1
Appendix B..................................................................................................................... B-1
Migrated Attribute Cross Reference Table..............................................................................B-1
About this Appendix........................................................................................................................... B-1
Appendix B.....................................................................................................................C-1
Migrated Attribute Cross Reference Table............................................................................. C-1
About this Appendix........................................................................................................................... C-1
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret
v
Teradata Financial Services Logical Data Model Appendices Release 10.00.00
vi
This page intentionally left blank.
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret
List of Tables
Table A-1 Parent-Child Relationships ......................................................................................................A-3
Table B-1 Migrated Attribute Cross Reference Table ..............................................................................B-3
Table C-1 Entity Definitions.....................................................................................................................C-3
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret
vii
Teradata Financial Services Logical Data Model Reference Guide Release 10.00.00
This page intentionally left blank.
viii
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret