通用語義層數(shù)據(jù)建模方法論V10-public

1、通用語義層數(shù)據(jù)模型建設(shè)思路內(nèi)容提綱內(nèi)容演講人備注第一部分：通用語義層概述：回顧以往數(shù)據(jù)倉庫模型設(shè)計思路：什么是通用語義層：通用語義層能解決什么問題：通用語義層有哪些特點第二部分：如何設(shè)計通用語義層第三部分：項目案例說明第四部分：實踐課：虛擬場景下設(shè)計通用語義層下次課程安排第五部分：附錄：相關(guān)文檔模板下次課程安排內(nèi)容提綱內(nèi)容演講人備注第一部分：通用語義層概述：回顧以往數(shù)據(jù)倉庫模型設(shè)計思路：什么是通用語義層：通用語義層能解決什么問題：通用語義層有哪些特點第二部分：如何設(shè)計通用語義層第三部分：項目案例說明第四部分：實踐課：虛擬場景下設(shè)計通用語義層下次課程安排第五部分：附錄：相關(guān)文檔模板下次課程安排

2、回顧數(shù)據(jù)倉庫數(shù)據(jù)架構(gòu)演變過程1.0 實施方法特點：源數(shù)據(jù)一般直接抽取到緩沖層，緩沖層邏輯上在細(xì)分為全量區(qū)、增量區(qū)；基于緩沖層（當(dāng)時叫ODS層）加工數(shù)據(jù)集市，集市分為明細(xì)匯總表、高粒度的匯總表；用戶應(yīng)用多集中在報表統(tǒng)計；個險銀保團(tuán)險電銷財務(wù)接口文件緩沖層，（ODS）個險、銀保、團(tuán)險、財務(wù)、電銷等數(shù)據(jù)集市（DM）明細(xì)匯總表，高度匯總表固定報表靈活查詢多維分析1.5 實施方法特點：緩沖層與數(shù)據(jù)集市模型設(shè)計思路與以往類似；整合層，參考了IBM的IIW、TD的FS_LDM模型，進(jìn)行客戶化；或者據(jù)此設(shè)計公司內(nèi)部的企業(yè)模型；用戶應(yīng)用多樣化，充分利用BI工具分析功能；管理駕駛艙實際上是儀表盤+固定報表個險銀保

3、團(tuán)險電銷財務(wù)接口文件緩沖層，（ODS）個險、銀保、團(tuán)險、財務(wù)、電銷等數(shù)據(jù)集市（DM）明細(xì)匯總表DM1，高度匯總表DM2固定報表靈活查詢多維分析整合層（DW）統(tǒng)一建模管理駕駛艙 增量信息難以捕獲，造成模型設(shè)計難以保存歷史，造成了模型設(shè)計有些“四不象”，實際上并沒有學(xué)習(xí)到行業(yè)模型的精髓項項目困目困難難、困惑、困惑項目實施過程中遇到的困難、困惑ETL過程設(shè)計簡單，代理主鍵的使用、更新與維護(hù)混亂數(shù)據(jù)集市一般根據(jù)應(yīng)用來設(shè)計，集市表成“碎片”，且指標(biāo)多次重復(fù)計算，集市之間存在誤差（可能因為維度、指標(biāo)口徑不明確、加工頻度、刷新頻度、腳本錯誤等）數(shù)據(jù)集市根據(jù)實際需要分為明細(xì)匯總表、輕粒度匯總表、高度匯總表，至

4、于為何這么分，并沒有講出所以然來整合層按照范式的要求進(jìn)行存儲，在計算集市時，非常的不方便，效率低下，因此常將一些常見的維度信息關(guān)聯(lián)好，存儲起來，集市計算時使用以往數(shù)據(jù)倉庫類項目模型設(shè)計成果示例當(dāng)事人當(dāng)事人事件事件協(xié)議協(xié)議集市模型，這里甚至沒有分層集市模型，這里甚至沒有分層困惑困惑！當(dāng)前，數(shù)據(jù)倉庫最佳實踐之?dāng)?shù)據(jù)架構(gòu)2.0 實施方法特點：總結(jié)以往項目經(jīng)驗，規(guī)劃出較為實用的一層，通用語義層，將基礎(chǔ)指標(biāo)的計算、維度梳理預(yù)處理，將多表關(guān)聯(lián)處理成冗余的寬表，解決實際問題；提煉建模方法論，指導(dǎo)項目實際操作；少走彎路。個險銀保團(tuán)險電銷財務(wù)接口文件緩沖層，（緩沖區(qū)、轉(zhuǎn)換映射區(qū)、基礎(chǔ)數(shù)據(jù)區(qū)）個險、銀保、團(tuán)險、財務(wù)

5、、電銷等數(shù)據(jù)集市（DM）分主題匯總（考慮復(fù)用）、特定應(yīng)用匯總固定報表靈活查詢多維分析通用語義層（存儲明細(xì)數(shù)據(jù)、可多次復(fù)用的數(shù)據(jù)，解決維度與指標(biāo)一致性的問題）管理駕駛艙制式報告動態(tài)報表資產(chǎn)接口文件內(nèi)容提綱內(nèi)容演講人備注第一部分：通用語義層概述：回顧以往數(shù)據(jù)倉庫模型設(shè)計思路：什么是通用語義層：通用語義層能解決什么問題：通用語義層有哪些特點第二部分：如何設(shè)計通用語義層第三部分：項目案例說明第四部分：實踐課：虛擬場景下設(shè)計通用語義層下次課程安排第五部分：附錄：相關(guān)文檔模板下次課程安排通用語義層起源與BO通用語義層（Common Semantic Layer），檢稱CSL， 最早起源與BO，目的在于讓業(yè)

6、務(wù)用戶能夠通過自己的業(yè)務(wù)術(shù)語，自由安全的訪問、分析以及分享信息的技術(shù)，其特點是：業(yè)務(wù)用戶自主操作提高用戶對于各種企業(yè)數(shù)據(jù)的操作體驗提供一致可信的數(shù)據(jù)，確保同一業(yè)務(wù)術(shù)語的引用能夠貫穿整個企業(yè)讓所有的商務(wù)智能工具都可以使用（只能用于BO）讓信息部門可以控制和確保信息訪問的安全性通用語義層帶來的價值簡潔一致的用戶體驗，讓業(yè)務(wù)用戶可以簡便的訪問企業(yè)內(nèi)的數(shù)據(jù)；減少企業(yè)的培訓(xùn)成本；保障業(yè)務(wù)用戶始終使用可信的信息業(yè)務(wù)用戶自創(chuàng)式創(chuàng)建各種商務(wù)智能的內(nèi)容可重用的查詢、計算、參數(shù)、過濾條件、值列表簡化用戶使用為普通用戶提供了一個簡化的界面，訪問復(fù)雜的企業(yè)數(shù)據(jù)降低BI項目的投入成本，保護(hù)現(xiàn)有IT數(shù)據(jù)投資擴(kuò)展現(xiàn)有的BI

7、平臺的安全模式支持多數(shù)據(jù)源的語義層，提高服務(wù)質(zhì)量支持完整BI項目生命周期，項目開發(fā)、測試、投產(chǎn)語義層與數(shù)據(jù)源的變化相同步支持和擴(kuò)展數(shù)據(jù)庫的安全性預(yù)定義的可重用的查詢、參數(shù)、過濾、計算、值列表等給業(yè)務(wù)用戶帶來的價值給業(yè)務(wù)用戶帶來的價值給給IT 用戶帶來的價值用戶帶來的價值語義層過于復(fù)雜，難以理解，尤其是新老人員交替，溝通成本很高語義層的設(shè)計成果不能在多個BI工具中使用，過于依賴BI工具.重用程度不高語義層的擴(kuò)展于與分拆影響較大，難以后期維護(hù)，為了降低影響范圍，大多是在原來基礎(chǔ)上，新增其他功能，致其復(fù)雜度越來越高；BO中的通用中的通用語義層實踐語義層實踐中遇到了一系列的中遇到了一系列的問題問題如如

8、何解決這些問題呢？ 即能夠享有通用語義層帶來的價值，又能夠規(guī)避這些問題。經(jīng)經(jīng)過過敏思苦想、群策群力，敏思苦想、群策群力，終終于有了答案。于有了答案。敏思苦想群策群力奔走相告豁然開朗使用ETL的方式，將BO中的語義層搬到數(shù)據(jù)庫中，簡化加工邏輯、提供可擴(kuò)展性和可復(fù)用性現(xiàn)現(xiàn)在，我在，我們來們來重新定重新定義義通用通用語義層語義層通用語義層模型設(shè)計基于業(yè)務(wù)（如保險）核心價值鏈上的核心業(yè)務(wù)對象和業(yè)務(wù)事件，采用維度總線架構(gòu)思想來構(gòu)建；業(yè)務(wù)對象通常用維度實現(xiàn)，業(yè)務(wù)事件通常用事實表實現(xiàn)，按照事實表的不同類型分為：累計快照事實表、周期快照事實表、交易基礎(chǔ)事實表。通用語義模型設(shè)計面向管理決策和經(jīng)營分析，是公共維度

9、和共性基礎(chǔ)指標(biāo)的實現(xiàn)載體，支持80%以上的共性應(yīng)用需求；通用語義模型設(shè)計采用維度化的逆范式設(shè)計模式，通常采用以下策略： 預(yù)連接處理：按照總線架構(gòu)維度和事實表的要求，將分散在多張相關(guān)實體表的數(shù)據(jù)屬性進(jìn)行預(yù)連接操作，使相關(guān)的維度盡可能組織在特定的維表或者事實表，如保單維、保單責(zé)任維、代理人維、客戶維、賠案維等； 預(yù)計算處理：按照總線架構(gòu)維度和事實表的要求，對事實表中的基礎(chǔ)指標(biāo)進(jìn)行加工計算，保證基礎(chǔ)指標(biāo)邏輯加工的“Golden Copy”，如保單事件、核保事件、保全事件、查勘事件、理賠事件等； 匯總處理：針對共性的復(fù)雜指標(biāo)，按照對應(yīng)的維度進(jìn)行提前聚合處理，以保證共性復(fù)雜指標(biāo)邏輯加工的“Golden

10、Copy”，避免重復(fù)加工，提供數(shù)據(jù)一致性和響應(yīng)效率，如保單層面指標(biāo)匯總，機(jī)構(gòu)層面指標(biāo)匯總，產(chǎn)品層面指標(biāo)匯總，代理人層面指標(biāo)匯總，客戶層面指標(biāo)匯總等；通用語義層模型的粒度盡可能保留到最細(xì)交易粒度（匯總處理除外），以保持模型間的連通性，并能夠最大程度、最快速地響應(yīng)新需求；以Sysbase 的IWS模型為指導(dǎo)思想，進(jìn)行通用語義層設(shè)計核心主題：Life Policy EventLife Claim Transactions關(guān)鍵度量主題：Life Policy Key MeasuresLife Policy Costs Key MeasuresLife Agency Channel Key Measur

11、esLife Agent Channel Key MeasuresLife Product Costs Key MeasuresLife Underwriting Costs Key MeasuresLife Claim Summary （實際上也是Key Measures ）其他應(yīng)用主題視圖：Life Quotations & ProposalsLife New BusinessIWS模型主題主要分為事件表和度量表Policy ID = Policy IDPromotional Episode ID = Promotional Episode IDInsurance Policy P

12、roperties ID = Insurance Policy Properties IDISO Currency ID = ISO Currency IDPayment Category ID = Payment Category IDEntity ID = Insured Participant IDGeographic ID = Issued Geographic IDEntity ID = Previous Insurance Carrier IDEntity ID = Insurance Agent IDEntity ID = Insurance Agency IDEntity ID

13、 = Insurance Group IDProduct ID = Product IDCore Reporting Structure ID = Agent Reporting Structure IDLife Insurance Policy Rating ID = Policy Rating IDLife Insurance Policy Features ID = Life Insurance Policy Features IDEntity ID = Entity IDPersonal Behavior Score ID = Personal Behavior Score IDGeo

14、graphic ID = Geographic IDDemographics ID = Demographics IDPeriod ID = Policy Event Date Period IDDemographics ID = Demographics IDFinancial Scores ID = Financial Scores IDGeographic ID = Geographic IDProfession ID = Profession IDPhysical Data ModelModel: InsurancePackage: Life Policy Event保單各類事件（除理

15、賠）Diagram: Life Policy EventAuthor: ADMINDate: 2004/2/11 Version: 4.0.276Life Insurance Policy EventLife Insurance Policy EventPolicy IDPolicy Event IDPolicy Event Sequence NumberPolicy Event Date Period IDPolicy Event Type IDProduct IDPolicy Rating IDLife Insurance Policy Features IDInsurance Polic

16、y Properties IDInsured Participant IDInsurance Group IDUnderwriter IDUnderwriter Reporting Structure IDInsurance Agency IDInsurance Agent IDAgent Reporting Structure IDPrevious Insurance Carrier IDDemographics IDGeographic IDIssued Geographic IDPromotional Episode IDISO Currency IDReference ISO Curr

17、ency IDPayment Category IDPolicy Transaction Written Premium AmountPolicy Coverage AmountReference Currency Policy Coverage AmountTransaction AmountReference Currency Transaction AmountCommission TypePolicy Transaction Commission AmountReference Currency Policy Commission AmountPolicy 1ST Year Commi

18、ssion AmountPolicy TermService Commission AmountPolicy Renewal CommissionSYB_IDSYB_IDSYB_COUNTSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_MONEYSYB_MONEYSYB_MONEYSYB_MONEYSYB_MONEYSYB_TYPESYB_MONEYSYB_MONEYSYB_MONEY

19、SYB_INTSYB_MONEYSYB_MONEYPromotional Campaign EpisodePromotional Episode IDEpisode Reporting Structure IDActual Begin Date Period IDActual End Date Period IDPromotion Campaign IDScheduled Begin DateScheduled End DateAll Entries IndicatorEpisode TypeEpisode NameEpisode IncentiveEpisode Desired Custom

20、er Target CountEpisode Actual Customer Target CountEpisode Budgeted CostEpisode Actual CostCampaign Media TypeRedemption MechanismEpisode Effectiveness RatingEpisode Estimated Revenue GenerationEpisode Estimated Customer GenerationCredited RevenueCredited Customer GenerationSelection CriteriaSYB_IDS

21、YB_IDSYB_IDSYB_IDSYB_IDSYB_DATESYB_DATESYB_INDICATORSYB_TYPESYB_NAMESYB_LONGSTRINGSYB_COUNTSYB_COUNTSYB_MONEYSYB_MONEYSYB_CLASSIFICATIONSYB_TYPESYB_NAMESYB_MONEYSYB_COUNTSYB_MONEYSYB_COUNTSYB_VERYLONGSTRINGLife Insured Participant ProfileEntity Profile IDEntity IDCustomer Since Date Period IDProfess

22、ion IDPsychographics IDDemographics IDPrimary Address IDAsset IDLanguage IDPersonal Behavior Score IDAffiliation IDFinancial Scores IDGeographic IDContact Instruction IDBegin Date Period IDEnd Date Period IDProduct Ownership IDReporting Structure IDUsage Profile IDQuick Reporting Profile IDSYB_IDSYB

23、_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDInsured ParticipantEntity IDEntity Category NameEntity Unique IDOrigin DatePrefixFirst NameSecond NameThird NameSuffixNational IdentifierGroupRelationship StatusPrimary Telephone NumberFax

24、NumberEmail AddressLife StatusSYB_IDSYB_NAMESYB_LEGACY_IDSYB_DATESYB_ABBREVIATIONSYB_NAMESYB_NAMESYB_NAMESYB_SHORTSTRINGSYB_TAX_IDSYB_CATEGORYSYB_SHORTSTRINGSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILSYB_SHORTSTRINGInsurance GroupEntity IDOrigin DateFirst NameSecond NameThird NamePrimary ClassificationSecondary

25、 ClassificationNational IdentifierPrimary Telephone NumberSecondary Telephone NumberFax NumberEmail AddressSYB_IDSYB_DATESYB_NAMESYB_NAMESYB_NAMESYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_TAX_IDSYB_TEL_NBRSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILInsurance CarrierEntity IDOrigin DateFirst NameSecond NameThird Nam

26、ePrimary ClassificationSecondary ClassificationNational IdentifierPrimary Telephone NumberSecondary Telephone NumberFax NumberEmail AddressSYB_IDSYB_DATESYB_NAMESYB_NAMESYB_NAMESYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_TAX_IDSYB_TEL_NBRSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILPayment CategoryPayment Category ID

27、Payment MethodPayment FrequencyAll Entries Indicator實 際 繳 費 方 式SYB_IDSYB_CATEGORYSYB_TYPESYB_INDICATORLife Insurance Policy FeaturesLife Insurance Policy Features IDReinsurance IndicatorPolicy Assignment IndicatorAutomatic Indexation IndicatorAutomatic Premium Indexation BasisAdvice Given IndicatorP

28、articpating IndicatorWithdrawal IndicatorJoint Life BasisJoint Life IndicatorAutomatic Benefit Indexation BasisCritical Illness IndicatorTrust IndicatorSchool Fees Plan IndicatorAssociated Life Cover IndicatorWaiver of Premium Indicator共 保 標(biāo) 志SYB_IDSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_SHORTSTR

29、INGSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_SHORTSTRINGSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORInsurance PolicyPolicy IDCustomer NamePolicy NumberPolicy Risk GradePolicy Start DatePolicy End DateSIC CodeProgram CodeClass CodeISO ClassReinsurance C

30、odeCoverage CodeIRPM FactorAll Entries Indicator保 單 來 源Column_16SYB_IDSYB_NAMESYB_LEGACY_IDSYB_CODESYB_DATESYB_DATESYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_CATEGORYSYB_CLASSIFICATIONSYB_NUMERICSYB_INDICATORInsurance AgentEntity IDEntity Subcategory NameEntity Uniqu

31、e IDFirst NameSecond NameThird NameNational IdentifierPrimary Telephone NumberSecondary Telephone NumberFax NumberEmail AddressSYB_IDSYB_NAMESYB_LEGACY_IDSYB_NAMESYB_NAMESYB_NAMESYB_TAX_IDSYB_TEL_NBRSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILInsurance Agent Reporting StructureCore Reporting Structure IDChannel

32、Entity IDManagement Unit IDChannel Ceased Trading DateBegin DateEnd DateCost Center IndicatorProfit Center IndicatorBooking Unit IndicatorAssociation CategoryDistrictHolding CompanyOrganization TypeOrganization NameAreaRegionTeam TypeTeamPerson NamePerson GradePerson TypeChannel CategoryChannel Type

33、Channel SubcategoryChannel NameChannel CityChannel PostcodeRevenue or Cost Center IndicatorAll Entries IndicatorSYB_IDSYB_IDSYB_IDSYB_DATESYB_DATESYB_DATESYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_CATEGORYSYB_CODESYB_NAMESYB_TYPESYB_NAMESYB_NAMESYB_NAMESYB_TYPESYB_NAMESYB_NAMESYB_CODESYB_TYPESYB_CAT

34、EGORYSYB_CATEGORYSYB_CATEGORYSYB_NAMESYB_NAMESYB_POSTALCODESYB_INDICATORSYB_INDICATORLife Insurance Policy PropertiesInsurance Policy Properties IDPolicy Coverage Amount BandPolicy Term BandPolicy Premium BandSYB_IDSYB_BANDSYB_BANDSYB_BANDInsurance AgencyEntity IDEntity Subcategory NameEntity Unique

35、 IDOrigin DateFirst NameSecond NameThird NamePrimary ClassificationSecondary ClassificationNational IdentifierPrimary Telephone NumberSecondary Telephone NumberFax NumberEmail AddressEmployee Management Unit IndicatorSYB_IDSYB_NAMESYB_LEGACY_IDSYB_DATESYB_NAMESYB_NAMESYB_NAMESYB_CLASSIFICATIONSYB_CL

36、ASSIFICATIONSYB_TAX_IDSYB_TEL_NBRSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILSYB_INDICATORCurrencyISO Currency IDCurrency Short NameCurrency Long NameCountry NameISO Numeric Country CodeISO Alpha Currency CodeAll Entries IndicatorSYB_IDSYB_SHORTSTRINGSYB_LONGSTRINGSYB_NAMESYB_CODESYB_CODESYB_INDICATORLife Policy

37、 RatingLife Insurance Policy Rating IDGenderAge BandHazardous Occupation IndicatorHazardous Activity IndicatorPoor Health IndicatorSmoker classificationPolicy Rating CategoryPolicy Rating Category DescriptionPrefered rating indicatorOccupation Class CodeImpairment Rating CodeDrinker Indicator標(biāo) 準(zhǔn) 件 標(biāo)

38、 志SYB_IDSYB_TYPESYB_BANDSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_CLASSIFICATIONSYB_CATEGORYSYB_VERYLONGSTRINGSYB_INDICATORSYB_CODESYB_CODEBehavior ScoresPersonal Behavior Score IDPersonal Behavior Score 1 BandPersonal Behavior Score N BandAll Entries IndicatorRFM CodeRFM DescriptionSYB_IDSYB_BANDS

39、YB_BANDSYB_INDICATORSYB_CODESYB_LONGSTRINGIssued GeographyGeographic IDBegin DateEnd DatePostal CodeCityPostal Code PrefixHazardous Weather Area IndicatorStorm Hazard IndicatorFlood Hazard IndicatorTornado Hazard IndicatorHurricane Hazard IndicatorEarthquake Hazard IndicatorDisease Hazard IndicatorR

40、adon Hazard IndicatorEnvironmental Hazard IndicatorOther Hazard IndicatorDMA CodeSMSA CodeState Province AreaTelevision RegionNational Radio AreaLocal Radio AreaGeographic RegionCountryContinent Abbreviated NameSubcontinent Abbreviated NameCensus TractCensus Block GroupEconomic RegionCity Political

41、UnitCounty Political UnitState Province Political UnitAll Entries IndicatorSYB_IDSYB_DATESYB_DATESYB_POSTALCODESYB_NAMESYB_CODESYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_CODESYB_CODESYB_LONGSTRINGSYB_ABBREVIAT

42、IONSYB_ABBREVIATIONSYB_ABBREVIATIONSYB_NAMESYB_NAMESYB_ABBREVIATIONSYB_ABBREVIATIONSYB_ABBREVIATIONSYB_ABBREVIATIONSYB_SHORTSTRINGSYB_CODESYB_CODESYB_CODESYB_INDICATORLife Insurance ProductProduct IDProduct Begin DateProduct End DateProduct Accounting ClassificationProduct Market SegmentProduct Line

43、Product GroupProduct CodeProduct NameProduct TypeProduct ClassProduct CategoryProduct SubcategoryProduct Variant CodeProduct VariantGroup Individual IndicatorParticipating IndicatorProfitability BandAll Entries IndicatorSYB_IDSYB_DATESYB_DATESYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_

44、LONGSTRINGSYB_CODESYB_VERYLONGSTRINGSYB_CATEGORYSYB_LONGSTRINGSYB_CATEGORYSYB_CATEGORYSYB_CODESYB_LONGSTRINGSYB_INDICATORSYB_INDICATORSYB_BANDSYB_INDICATORSales Event TypeCore Event Type IDCore Event Type Short NameCore Event Type NameCore Event Type Subtype Short NameSYB_IDSYB_NAMESYB_VERYLONGSTRIN

45、GSYB_NAMEReference CurrencyISO Currency IDCurrency Short NameCurrency Long NameCountry NameISO Numeric Country CodeISO Alpha Currency CodeAll Entries IndicatorSYB_IDSYB_SHORTSTRINGSYB_LONGSTRINGSYB_NAMESYB_CODESYB_CODESYB_INDICATORTime PeriodPeriod IDDate Not ApplicablePeriod DateDay Full Name.SYB_I

46、DSYB_FLAGSYB_DATESYB_DAYUnderwriterEntity IDEntity Unique IDFirst NameSecond Name.SYB_IDSYB_LEGACY_IDSYB_NAMESYB_NAMEUnderwriter Reporting StructureCore Reporting Structure IDChannel Entity IDManagement Unit IDChannel Ceased Trading Date.SYB_IDSYB_IDSYB_IDSYB_DATEGeographyGeographic IDBegin DateEnd

47、DatePostal Code.SYB_IDSYB_DATESYB_DATESYB_POSTALCODEDemographicsDemographics IDDemographics TypeDisposable Income BandIncome Band.SYB_IDSYB_TYPESYB_BANDSYB_BANDProfessionProfession IDProfession GroupProfession IndustryProfession NameProfession CodeProfession TitleAll Entries IndicatorSYB_IDSYB_LONGS

48、TRINGSYB_LONGSTRINGSYB_LONGSTRINGSYB_CODESYB_SHORTSTRINGSYB_INDICATORFinancial ScoresFinancial Scores IDInternal Financial Score BandExperian Score BandScore N BandProfitability Index BandDebt Income Ratio BandAll Entries IndicatorSYB_IDSYB_BANDSYB_BANDSYB_BANDSYB_BANDSYB_BANDSYB_INDICATORBegin Date

49、 Time PeriodPeriod IDDate Not ApplicablePeriod DateDay Full Name.SYB_IDSYB_FLAGSYB_DATESYB_DAYCustomer Since Date Time PeriodPeriod IDDate Not ApplicablePeriod DateDay Full Name.SYB_IDSYB_FLAGSYB_DATESYB_DAYEnd Date Time PeriodPeriod IDDate Not ApplicablePeriod DateDay Full Name.SYB_IDSYB_FLAGSYB_DA

50、TESYB_DAYMonth ID = Month IDPolicy Life Cycle Status ID = Policy Life Cycle Status IDPayment Category ID = Payment Category IDPolicy ID = Policy IDLife Insurance Policy Rating ID = Policy Rating IDISO Currency ID = ISO Currency IDEntity ID = Insured Participant IDUnderwriting Time ID = Underwriting

51、Time IDLife Insurance Company Underwriting Time = Life Insurance Company Underwriting TimeCore Reporting Structure ID = Agency Reporting Structure IDPeriod ID = Application Received Date Period IDPeriod ID = Application Date Period IDPersonal Behavior Score ID = Personal Behavior Score IDEntity ID =

52、 Entity IDPeriod ID = Maturity Date Period IDPeriod ID = Start Payment PeriodPeriod ID = Option Date Period IDPeriod ID = Determination Date Period IDGeographic ID = Issued Geographic IDCore Reporting Structure ID = Agent Reporting Structure IDEntity ID = Insurance Carrier IDProduct ID = Product IDP

53、eriod ID = Continuing Eligiblity DatePeriod ID = Conversion Option Expiration DateEntity ID = Insurance Group IDEntity ID = Insurance Agent IDEntity ID = Insurance Agency IDPeriod ID = Renewal Date Period IDPeriod ID = Expiration Date Period IDInsurance Policy Properties ID = Insurance Policy Proper

54、ties IDLife Insurance Policy Features ID = Life Insurance Policy Features IDDemographics ID = Demographics IDGeographic ID = Geographic IDDemographics ID = Demographics IDFinancial Scores ID = Financial Scores IDGeographic ID = Geographic IDProfession ID = Profession IDPhysical Data ModelModel: Insu

55、rancePackage: Life Policy Key Measures 保單各類指標(biāo)匯總快照Diagram: Life Policy Key MeasuresAuthor: ADMINDate: 2004/2/11 Version: 4.0.276Life Insurance Policy Key MeasuresLife Insurance Company Underwriting TimeLife Insurance Company Underwriting TimeAverage Company Underwriting TimeUnderwriter to Company Rat

56、ioSYB_IDSYB_COUNTSYB_RATIOLife Policy Key MeasuresPolicy IDMonth IDProduct IDInsured Participant IDLife Insurance Policy Features IDInsurance Policy Properties IDPolicy Rating IDPolicy Life Cycle Status IDPayment Category IDInsurance Carrier IDInsurance Group IDInsurance Agency IDAgency Reporting St

57、ructure IDInsurance Agent IDAgent Reporting Structure IDUnderwriter IDUnderwriter Reporting Structure IDGeographic IDIssued Geographic IDDemographics IDExpiration Date Period IDRenewal Date Period IDPolicy Start Date Period IDPolicy Termination DateConversion Option Expiration DateMaturity Date Peri

58、od IDStart Payment PeriodContinuing Eligiblity DateApplication Date Period IDApplication Received Date Period IDDetermination Date Period IDOption Date Period IDISO Currency IDReference ISO Currency IDUnderwriting Time IDLife Insurance Company Underwriting TimeSingle Premium AmountAnnual Premium Amo

59、untReference Currency Annual Premium AmountMonthly Premium AmountReferency Currency Monthly Premium AmountMonthly Earned Premium AmountReference Currency Monthly Earned Premium AmountAnnual Earned Premium AmountReference Currency Annual Earned Premium AmountAccounting Value of the PolicySurrender Va

60、lue of the PolicyWritten Loss RatioEarned Loss RatioTotal Number of Payments to DateTotal Payment Amount to DateReinsure AmountAnnuity RateFunds Under ManagementOther FundsSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_ID