第1页 / 共710页
第2页 / 共710页
第3页 / 共710页
第4页 / 共710页
第5页 / 共710页
第6页 / 共710页
第7页 / 共710页
第8页 / 共710页
最新的Teradata FS-LDM模型V10.0版本的参考手册 BOOK-1.pdf
Cover Page
Copyright Page
Revision Record
Release History
Table of Contents
List of Figures
Figure 5-1 FS-LDM Extensions
Figure 7-1 Data Model Levels
Figure 7-2 Subject Area Data Model
Figure 7-3 Banking Conceptual Model
Figure 8-1 Banking - Party.Party Type
Figure 8-2 Banking - Party.Business Party
Figure 8-3 Banking - Party.Score and Rating
Figure 8-4 Banking - Party Asset.Party Asset Role
Figure 8-5 Banking - Party Asset.Asset Inspection
Figure 8-6 Banking - Product.Overview
Figure 8-7 Banking - Product.Basel 1 Risk Weight
Figure 8-8 Banking - Product.Feature
Figure 8-9 Banking - Product.Feature Subtype
Figure 8-10 Banking - Product.Feature/Feature
Figure 8-11 Banking - Product.Party Feature
Figure 8-12 Banking - Agreement.Agreement Subtype Detail
Figure 8-13 Banking - Agreement.Overview and Summary
Figure 8-14 Banking - Agreement.Account Groups
Figure 8-15 Banking - Agreement.Asset
Figure 8-16 Banking - Agreement.Automatic Payments
Figure 8-17 Banking - Agreement.Card-Access Device
Figure 8-18 Banking - Agreement.Risk Mitigant Agreement - Exposure Agreement Relationships
Figure 8-19 Banking - Agreement.Loan, Collateral Agreement, and Collateral Item Overlaps
Figure 8-20 Banking - Agreement.Collateral Overview
Figure 8-21 Banking - Agreement.Collateral Item
Figure 8-22 Banking - Agreement.Risk Mitigant Agreement
Figure 8-23 Banking - Exposure Agreements Related to Risk Mitigant Agreements Mitigant Agreement Type
Figure 8-24 Banking - Agreement. Risk Mitigant Agmt to Exposure Agmt
Figure 8-25 Banking - Risk Mitigant Agreement Related to Collateral Item
Figure 8-26 Banking - Agreement.Risk Mitigant Agmt to Collateral Item
Figure 8-27 Banking - Agreement.Collateral Item to Exposure Agmt
Figure 8-28 Banking - Agreement.Collateral Seniority
Figure 8-29 Banking - Agreement.Collateral Value and Haircut
Figure 8-30 Banking - Agreement.Haircuts and Adjustments
Figure 8-31 Banking - Agreement.Loan and Credit Agreement
Figure 8-32 Banking - Agreement.Deposit and Cash Management
Figure 8-33 Banking - Agreement.Factoring - Purchased Receivable
Figure 8-34 Banking - Agreement.Financial Agreement Japan
Figure 8-35 Banking - Agreement.Nostro and Vostro Accounts
Figure 8-36 Banking - Agreement.Foreign Exchange
Figure 8-37 Banking - Agreement.Interest Based Agreement
Figure 8-38 Banking - Agreement.Leasing
Figure 8-39 Banking - Agreement.Letter of Credit and Letter of Guarantee
Figure 8-40 Banking - Agreement.Other Financial Services
Figure 8-41 Banking - Agreement.Party Roles
Figure 8-42 Banking - Agreement.Passbook
Figure 8-43 Banking - Agreement.Product and Feature
Figure 8-44 Banking - Agreement.Provisions
Figure 8-45 Banking - Agreement.Score and Rating
Figure 8-46 Banking - Agreement.Securitization
Figure 8-47 Check Event Scenario Flow
Figure 8-48 Banking - Event.Overview
Figure 8-49 Banking - Event.Check
Figure 8-50 Banking - Event.Card - Authorization - Purchase - Settlement
Figure 8-51 Banking - FM.Asset Account
Figure 8-52 Banking - FM.Expense Account
Figure 8-53 Banking - FM.Liability Account
Figure 8-54 Banking - FM.Revenue Account
Figure 8-55 Example of Credit Card Balance Segments and Conditions
Figure 8-56 Relationship of One Feature to Another Feature for Balance Segments
Figure 8-57 Banking - Cross Subject Area - Credit Card Balance Segment
Figure 8-58 Banking - Cross Subject Area.Models and Risk Grades
Figure 8-59 Banking - Risk.Basel Approach and Asset Class
Figure 8-60 Banking - Credit Risk.Basel Approach
Figure 8-61 Banking - Credit Risk.Agreement Relationships
Figure 8-62 Banking - Credit Risk.Pools
Figure 8-63 Banking - Credit Risk.Metric and Scenario
Figure 8-64 Banking - Risk.Basel Pillar 3
Figure 8-65 Banking - Risk.Parameter Tables
Figure 8-66 Banking - Operational Risk.Basic Indicator
Figure 8-67 Banking - Operational Risk.Standardized Approach
Figure 8-68 Banking - Operational Risk.Advanced Measurement Approach
Figure 8-69 Banking - Market Risk.Interest Rate Risk
Figure 8-70 Banking - Market Risk.Equity Risk
Figure 8-71 Banking - Market Risk.Foreign Exchange Risk
Figure 8-72 Banking - Market Risk.Commodity Risk
Figure 8-73 Banking - Market Risk.Option Risk
Figure 8-74 Banking - Market Risk.Time Band
Figure 8-75 Banking - Market Risk.Sensitivity
Figure 8-76 Banking - Market Risk.Internal Models - Risk Factors
Figure 8-77 Banking - Market Risk.Internal Models - Stress Test
Figure 8-78 Banking - Market Risk.Internal Models - Value at Risk
Figure 8-79 Banking - Market Risk.Parameter
Figure 9-1 FS-LDM Extensions
Figure 10-1 Business Context Model
Figure 10-2 Closed Loop Market Strategy
Figure 10-3 FS-LDM Insurance Extension Business Scope
Figure 11-1 Data Model Levels
Figure 11-2 Subject Area Data Model
Figure 11-3 Insurance Conceptual Data Model
Figure 12-1 Insurance - Party.Overview
Figure 12-2 Insurance - Party.Relationship and History
Figure 12-3 Insurance - Party.Agent
Figure 12-4 Insurance - Party.Driving History
Figure 12-5 Insurance - Party.Provider
Figure 12-6 Insurance - Party.Insured Party - Provider
Figure 12-7 Insurance - Party.Party Risk
Figure 12-8 Insurance - Party Asset.Party Assets
Figure 12-9 Insurance - Party Asset.Party Asset Risk
Figure 12-10 Insurance - Party Asset.Insurable Interest
Figure 12-11 Insurance - Party Asset.Salvage
Figure 12-12 Insurance - Product.Overview
Figure 12-13 Insurance - Product.Features
Figure 12-14 Insurance - Product.Feature Subtyping
Figure 12-15 Insurance - Product.Feature Relations
Figure 12-16 Insurance - Agreement.Overview
Figure 12-17 Insurance - Agreement.Underwriting
Figure 12-18 Insurance - Agreement.Insurance Agreement Type
Figure 12-19 Insurance - Agreement.Status and History
Figure 12-20 Insurance - Agreement.Metric and Premium
Figure 12-21 Insurance - Agreement.Reinsurance
Figure 12-22 Insurance - Agreement.Agreement Risk
Figure 12-23 Insurance - Agreement.Product and Feature
Figure 12-24 Insurance - Agreement.Application, Quotation, and Party
Figure 12-25 Insurance - Agreement.Agreement, Application, Quotation and Asset
Figure 12-26 Insurance - Agreement.Asset and Feature
Figure 12-27 Insurance - Agreement.Party and Feature
Figure 12-28 Insurance - Agreement.External Insurance Policy
Figure 12-29 Insurance - Claim.Claim Overview
Figure 12-30 Insurance - Claim.Claim Service Status History
Figure 12-31 Insurance - Claim.Claim, Coverage and Service
Figure 12-32 Insurance - Claim.Claim Amount and Related Claims
Figure 12-33 Insurance - Claim.Claim Authorization
Figure 12-34 Insurance - Claim.Claim and Assets
Figure 12-35 Insurance - Claim.Claim and Party
Figure 12-36 Insurance - Claim.Cost Recovery
Figure 12-37 Insurance - Claim.Score
Figure 12-38 Insurance - Claim.Subrogation
Figure 12-39 Insurance - Claim.Text
Figure 12-40 Insurance - Event.Overview
Figure 12-41 Insurance - Event.Event and Claim
Figure 12-42 Insurance - Event.Claim and Adjudication
Figure 12-43 Insurance - Event.Insurance Payment
Figure 12-44 Insurance - Event.Commission
Figure 12-45 Insurance - FM.Asset Account
Figure 12-46 Insurance - FM.Expense Account
Figure 12-47 Insurance - FM.Liability Account
Figure 12-48 Insurance - FM.Revenue Account
Figure 12-49 Insurance Function View - Behavior Based Pricing 12 171
Figure 13-1 FS-LDM Extensions
Figure 15-1 Data Model Levels
Figure 15-2 Subject Area Model
Figure 15-3 Investment Conceptual Data Model
Figure 16-1 Investment - Party.Subtypes
Figure 16-2 Investment - Party.Investment Objective
Figure 16-3 Investment - Product.Overview
Figure 16-4 Investment - Product.Financial Instrument
Figure 16-5 Investment - Product.Instrument Identification
Figure 16-6 Investment - Product.Features
Figure 16-7 Investment - Product.Investment Product Type
Figure 16-8 Investment - Product.Bond
Figure 16-9 Investment - Product.Stock
Figure 16-10 Investment - Product.Option
Figure 16-11 Investment - Product.Derivative
Figure 16-12 Investment - Product.Money Market
Figure 16-13 Investment - Product.Asset Backed Security
Figure 16-14 Investment - Product.Service
Figure 16-15 Investment - Product.Real Estate Investment Trust
Figure 16-16 Investment - Product.Market Quotes
Figure 16-17 Investment - Product.Party
Figure 16-18 Investment - Product.Risk
Figure 16-19 Investment - Agreement.Overview
Figure 16-20 Investment - Agreement.Investment Agreement Type 16 77
Figure 16-21 Investment - Agreement.Derivatives
Figure 16-22 Investment - Agreement.Swap
Figure 16-23 Investment - Agreement.Interest Rate Swap
Figure 16-24 Investment - Agreement.Credit Derivatives
Figure 16-25 Investment - Agreement.Money Market
Figure 16-26 Investment - Agreement.Holding and Position
Figure 16-27 Investment - Agreement.Party and Portfolio
Figure 16-28 Investment - Agreement.Portfolio Details
Figure 16-29 Investment - Agreement.Portfolio and Application 16 109
Figure 16-30 Investment - Agreement.Repurchase Agreement
Figure 16-31 Investment - Agreement.Settlement Instruction
Figure 16-32 Investment - Event.Subtyping
Figure 16-33 Investment - Event.Event-Event Relationships
Figure 16-34 Investment - Event.Financial Events
Figure 16-35 Investment - Event.Party and Geographical Area
Figure 16-36 Investment - Event.Settlement
Figure 16-37 Investment - Event.Trade and Mark to Market
Figure 16-38 Investment - Event.Corporate Action
List of Tables
Table 8-1 Financial Document Item Examples
Table 8-2 Letter of Credit and Letter of Guarantee Entity Information
Table 8-3 Check Event Scenario
Table 8-4 Check Event Scenario Subtype Entity Interrelation
Table 8-5 Purchase Event Scenario
Table 8-6 Purchase Event Scenario Subtype Entity Interrelation
Table 10-1 Business Problems Addressed by the CRMs for Life Insurance
Table 12-1 Entities for Agreement, Application, and Quotation 12 78
Table 16-1 Investment - Agreement.Foreign Exchange Swap Leg Example
Chapter 5 - Banking Extension
About this Chapter
What is the Teradata Financial Services Logical Data Model Banking Extension?
Introduction
Fit with other Teradata FS-LDM Extensions
Chapter 6 - Banking Extension – Business Value
About this Chapter
Business Context
Business Questions
Chapter 7 - Banking Extension – High Level Data Models
About this Chapter
Model Levels
Subject Area Data Model
Conceptual Level Data Model
Party and Party Asset
Product
Agreement
Event
Campaign
Chapter 8 - Banking Extension – Detailed Data Model Description
About this Chapter
Party Subject Area
Party Type
Business Party
Score and Rating
Party Asset Subject Area
Party Asset Role
Asset Inspection
Product Subject Area
Product Overview
Basel I Risk Weight
Feature
Feature Subtype
Feature/Feature
Party Feature
Agreement Subject Area
Agreement - Agreement Subtype
Agreement Overview and Summary
Account Groups
Asset
Automatic Payments
Card-Access Device
Collateral and Risk Mitigation
Conceptual Level Overview - Risk Mitigation
Collateral Item
Risk Mitigant Agreement
Seniority
Collateral Value and Haircuts
Haircuts and Adjustments
Loan and Credit Agreement
Deposit and Cash Management
Factoring, Purchased Receivable and Collection
Financial Agreement Japan
Foreign Exchange
Interest Based Agreement
Leasing
Letter of Credit and Letter of Guarantee
Other Financial Services
Party Roles
Passbook
Product and Feature
Provisions
Score and Rating
Securitization Agreement
Event Subject Area
Event Overview
Check
Card-Authorization-Purchase-Settlement
Finance Subject Area
Asset Account
Expense Account
Liability Account
Revenue Account
Cross Subject Area
Background
Models and Risk Grades
Risk Management
Basel II Credit Risk Management
Basel Approach and Asset Class
Risk Agreement Relationships
Credit Risk Pools
Credit Risk Metric and Scenarios
Basel Pillar 3 Reporting
Basel II Parameters
Basel II Operational Risk
Market Risk
Standardized Method - Interest Rate Risk
Standardized Method - Equity Risk
Standardized Method - Foreign Exchange Risk
Standardized Method - Commodities Risk
Standardized Method - Options
Standardized Method - Time Band
Internal Models - Risk Factors (Sensitivity)
Internal Models - Market Risk Factors
Internal Models - Stress Test
Internal Models - Value at Risk
Market Risk Parameter
Chapter 9 - Insurance Extension
About this Chapter
What is the Teradata Financial Services Logical Data Model Insurance Extension?
Introduction
Fit with other Teradata FS-LDM Extensions
Chapter 10 - Insurance Extension – Business Value
About this Chapter
Business Context
Business Objective
Business Scope of FS-LDM Insurance Extension
Business Questions
General Business Questions
Life Insurance Business Questions
Property and Casualty Insurance Business Questions
Life Insurance Scenarios
Chapter 11 - Insurance Extension – High Level Data Models
About this Chapter
Model Levels
Subject Area Model
Subject Area Model Diagram Description
Conceptual Level Data Model
Party
Party Asset
Product
Agreement
Events
Claim and Event
Chapter 12 - Insurance Extension – Detailed Data Model Description
About this Chapter
Party Subject Area
Party Overview
Relationship and History
Agent
Party Driving History
Party Provider
Insured Party - Provider
Party Risk
Party Asset Subject Area
Party Assets
Party Asset Risk
Party Asset Insurable Interest
Party Asset Salvage
Product Subject Area
Product Overview
Features
Feature Subtyping
Feature Relations
Agreement Subject Area
Agreement Overview
Underwriting
Insurance Agreement Type
Status and History
Metric and Premium
Reinsurance
Agreement Risk
Product and Feature
Agreement Application, Quotation, and Party
Agreement, Application, Quotation, and Asset
Asset and Feature
Party and Feature
External Insurance Policy
Claim Subject Area
Claim Service Status History
Claim, Coverage and Service
Claim Amount and Related Claims
Claim Authorization
Claim and Assets
Claim and Party
Claim Cost Recovery
Claim Score
Claim Subrogation
Claim Text
Event Subject Area
Event Overview
Event and Claim
Claim and Adjudication
Insurance Payment
Commission
Finance Subject Area
Asset Account
Expense Account
Liability Account
Revenue Account
Insurance Function View
Insurance - Function View - Behavior Based Pricing
Chapter 13 - Investment Extension
About this Chapter
What is the Teradata Financial Services Logical Data Model Investment Extension?
Introduction
Fit with other Teradata FS-LDM Extensions
Chapter 14 - Investment Extension – Business Value
About this Chapter
Business Context
Business Objective
Business Scope of FS-LDM Investment Extension
Business Questions
Chapter 15 - Investment Extension – High Level Data Models
About this Chapter
Model Levels
Subject Area Model
Subject Area Model Diagram Description
Conceptual Level Data Model
Party
Product
Agreement
Event
Chapter 16 - Investment Extension – Detailed Data Model Description
About this Chapter
Party Subject Area
Party Subtypes
Investment Objective
Product Subject Area
Product Overview
Financial Instrument
Instrument Identification
Features
Investment Product Type
Bond
Stock
Option
Derivative
Money Market
Asset Backed Security
Service
Real Estate Investment Trust
Market Quotes
Party
Risk
Agreement Subject Area
Agreement Overview
Investment Agreement Type
Derivatives
Swap
Interest Rate Swap
Credit Derivative
Money Market
Investment Holding and Position
Party and Portfolio
Portfolio Details
Portfolio and Application
Repurchase Agreement
Settlement Instructions
Event Subject Area
Investment Event Subtyping
Event-Event Relationships
Financial Events
Party and Geographical Area
Settlement
Trade and Mark to Market
Corporate Action
Teradata Financial
Services Logical
Data Model
Release 10.00.00
For Financial Institutions and
Insurance Companies
Reference Guide
Book 2 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-9317-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.
AllFusion and ERwin Data Modeler are registered trademarks of Computer Associates, Inc.
Dun & Bradstreet and D&B are trademarks of Dun & Bradstreet, 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-2007 by Teradata Corporation
All Rights Reserved.
Teradata Confidential and Trade Secret
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
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret
iii
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
Teradata Financial Services Logical Data Model Reference Guide Release 10.00.00
Campaign subject area – Opportunity, Proposal,
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
9.0
December 2007
Foundation
Banking
Insurance
10.0
March 2009
Foundation
Investments
Banking
Insurance
iv
Contents
Revision Record ................................................................................................................iii
Release History......................................................................................................................................iii
List of Figures ...................................................................................................................xi
List of Tables .....................................................................................................................xv
Chapter 5 .........................................................................................................................5-1
Banking Extension ..................................................................................................................... 5-1
About this Chapter...............................................................................................................................5-1
What is the Teradata Financial Services Logical Data Model Banking Extension?............................5-3
Introduction...................................................................................................................................5-3
Fit with other Teradata FS-LDM Extensions.......................................................................................5-5
Chapter 6 .........................................................................................................................6-1
Banking Extension – Business Value........................................................................................ 6-1
About this Chapter...............................................................................................................................6-1
Business Context .................................................................................................................................6-3
Business Questions..............................................................................................................................6-5
Chapter 7 .........................................................................................................................7-1
Banking Extension – High Level Data Models........................................................................ 7-1
About this Chapter...............................................................................................................................7-1
Model Levels.......................................................................................................................................7-3
Subject Area Data Model ....................................................................................................................7-5
Conceptual Level Data Model.............................................................................................................7-7
Party and Party Asset ....................................................................................................................7-9
Product .......................................................................................................................................7-10
Agreement...................................................................................................................................7-11
.......................................................................................................................................7-14
Event
Campaign....................................................................................................................................7-15
Chapter 8 .........................................................................................................................8-1
Banking Extension – Detailed Data Model Description......................................................... 8-1
About this Chapter...............................................................................................................................8-1
Party Subject Area ...............................................................................................................................8-3
Party Type .....................................................................................................................................8-4
Business Party...............................................................................................................................8-6
Score and Rating.........................................................................................................................8-10
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret
v
Teradata Financial Services Logical Data Model Reference Guide Release 10.00.00
Party Asset Subject Area ...................................................................................................................8-13
Party Asset Role..........................................................................................................................8-14
Asset Inspection..........................................................................................................................8-16
Product Subject Area .........................................................................................................................8-17
Product Overview .......................................................................................................................8-18
Basel I Risk Weight.....................................................................................................................8-23
Feature .......................................................................................................................................8-25
Feature Subtype ..........................................................................................................................8-29
Feature/Feature ...........................................................................................................................8-33
Party Feature...............................................................................................................................8-34
Agreement Subject Area....................................................................................................................8-35
Agreement - Agreement Subtype................................................................................................8-36
Agreement Overview and Summary...........................................................................................8-43
Account Groups ..........................................................................................................................8-49
.......................................................................................................................................8-53
Asset
Automatic Payments ...................................................................................................................8-57
Card-Access Device....................................................................................................................8-59
Collateral and Risk Mitigation....................................................................................................8-65
Conceptual Level Overview - Risk Mitigation...........................................................................8-73
Collateral Item ............................................................................................................................8-77
Risk Mitigant Agreement............................................................................................................8-79
Seniority......................................................................................................................................8-89
Collateral Value and Haircuts .....................................................................................................8-91
Haircuts and Adjustments ...........................................................................................................8-95
Loan and Credit Agreement........................................................................................................8-97
Deposit and Cash Management ................................................................................................8-101
Factoring, Purchased Receivable and Collection......................................................................8-103
Financial Agreement Japan....................................................................................................... 8-111
Foreign Exchange .....................................................................................................................8-112
Interest Based Agreement .........................................................................................................8-117
Leasing .....................................................................................................................................8-118
Letter of Credit and Letter of Guarantee...................................................................................8-120
Other Financial Services...........................................................................................................8-127
Party Roles................................................................................................................................8-129
Passbook ...................................................................................................................................8-131
Product and Feature ..................................................................................................................8-132
Provisions..................................................................................................................................8-139
Score and Rating.......................................................................................................................8-143
Securitization Agreement..........................................................................................................8-147
Event Subject Area ..........................................................................................................................8-153
Event Overview ........................................................................................................................8-154
.....................................................................................................................................8-159
Check
Card-Authorization-Purchase-Settlement .................................................................................8-161
Finance Subject Area.......................................................................................................................8-167
Asset Account ...........................................................................................................................8-168
Expense Account.......................................................................................................................8-171
Liability Account ......................................................................................................................8-172
Revenue Account ......................................................................................................................8-175
Cross Subject Area ..........................................................................................................................8-177
vi
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret
Contents
Background...............................................................................................................................8-177
Models and Risk Grades ...........................................................................................................8-185
Risk Management............................................................................................................................8-189
Basel II Credit Risk Management.............................................................................................8-190
Basel Approach and Asset Class ...............................................................................................8-195
Risk Agreement Relationships..................................................................................................8-201
Credit Risk Pools ......................................................................................................................8-205
Credit Risk Metric and Scenarios .............................................................................................8-209
Basel Pillar 3 Reporting............................................................................................................8-213
Basel II Parameters ...................................................................................................................8-217
Basel II Operational Risk..........................................................................................................8-225
Market Risk...............................................................................................................................8-231
Standardized Method - Interest Rate Risk ................................................................................8-232
Standardized Method - Equity Risk..........................................................................................8-237
Standardized Method - Foreign Exchange Risk........................................................................8-241
Standardized Method - Commodities Risk ...............................................................................8-245
Standardized Method - Options ................................................................................................8-249
Standardized Method - Time Band ...........................................................................................8-253
Internal Models - Risk Factors (Sensitivity).............................................................................8-255
Internal Models - Market Risk Factors .....................................................................................8-257
Internal Models - Stress Test.....................................................................................................8-261
Internal Models - Value at Risk.................................................................................................8-263
Market Risk Parameter .............................................................................................................8-267
Chapter 9 .........................................................................................................................9-1
Insurance Extension .................................................................................................................. 9-1
About this Chapter...............................................................................................................................9-1
What is the Teradata Financial Services Logical Data Model Insurance Extension?..........................9-3
Introduction...................................................................................................................................9-3
Fit with other Teradata FS-LDM Extensions.......................................................................................9-5
Chapter 10 .....................................................................................................................10-1
Insurance Extension – Business Value ................................................................................... 10-1
About this Chapter.............................................................................................................................10-1
Business Context ...............................................................................................................................10-3
Business Objective ............................................................................................................................10-5
Business Scope of FS-LDM Insurance Extension.............................................................................10-7
Business Questions............................................................................................................................10-9
General Business Questions......................................................................................................10-10
Life Insurance Business Questions ...........................................................................................10-11
Property and Casualty Insurance Business Questions ..............................................................10-14
Life Insurance Scenarios .................................................................................................................10-17
Chapter 11 .....................................................................................................................11-1
Insurance Extension – High Level Data Models................................................................... 11-1
About this Chapter.............................................................................................................................11-1
Model Levels.....................................................................................................................................11-3
Subject Area Model...........................................................................................................................11-5
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
Subject Area Model Diagram Description..................................................................................11-5
Conceptual Level Data Model...........................................................................................................11-7
.......................................................................................................................................11-9
Party
Party Asset ................................................................................................................................11-10
Product ..................................................................................................................................... 11-11
Agreement.................................................................................................................................11-12
.....................................................................................................................................11-14
Events
Claim and Event........................................................................................................................11-15
Chapter 12 .....................................................................................................................12-1
Insurance Extension – Detailed Data Model Description .................................................... 12-1
About this Chapter.............................................................................................................................12-1
Party Subject Area .............................................................................................................................12-3
Party Overview ...........................................................................................................................12-4
Relationship and History.............................................................................................................12-5
.......................................................................................................................................12-9
Agent
Party Driving History................................................................................................................12-13
Party Provider ...........................................................................................................................12-14
Insured Party - Provider............................................................................................................12-16
Party Risk..................................................................................................................................12-17
Party Asset Subject Area .................................................................................................................12-21
Party Assets...............................................................................................................................12-22
Party Asset Risk ........................................................................................................................12-27
Party Asset Insurable Interest....................................................................................................12-31
Party Asset Salvage...................................................................................................................12-35
Product Subject Area .......................................................................................................................12-39
Product Overview .....................................................................................................................12-40
Features.....................................................................................................................................12-42
Feature Subtyping .....................................................................................................................12-47
Feature Relations ......................................................................................................................12-50
Agreement Subject Area..................................................................................................................12-51
Agreement Overview................................................................................................................12-52
Underwriting.............................................................................................................................12-57
Insurance Agreement Type........................................................................................................12-58
Status and History.....................................................................................................................12-60
Metric and Premium .................................................................................................................12-62
Reinsurance...............................................................................................................................12-67
Agreement Risk ........................................................................................................................12-71
Product and Feature ..................................................................................................................12-75
Agreement Application, Quotation, and Party..........................................................................12-81
Agreement, Application, Quotation, and Asset.........................................................................12-85
Asset and Feature......................................................................................................................12-89
Party and Feature ......................................................................................................................12-93
External Insurance Policy .........................................................................................................12-97
Claim Subject Area........................................................................................................................12-101
Claim Service Status History ..................................................................................................12-105
Claim, Coverage and Service..................................................................................................12-109
Claim Amount and Related Claims.........................................................................................12-113
Claim Authorization................................................................................................................12-117
viii
Copyright © 1995-2009 by Teradata Corporation
All Rights Reserved
Teradata Confidential and Trade Secret
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
