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

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

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

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

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

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

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

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

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

10、Copy”，避免重復加工，提供數據一致性和響應效率，如保單層面指標匯總，機構層面指標匯總，產品層面指標匯總，代理人層面指標匯總，客戶層面指標匯總等；通用語義層模型的粒度盡可能保留到最細交易粒度（匯總處理除外），以保持模型間的連通性，并能夠最大程度、最快速地響應新需求；以Sysbase 的IWS模型為指導思想，進行通用語義層設計核心主題：Life Policy EventLife Claim Transactions關鍵度量主題：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 ）其他應用主題視圖：Life Quotations & ProposalsLife New BusinessIWS模型主題主要分為事件表和度量表Policy ID = Policy IDPromotional Episode ID = Promotional Episode IDInsurance Policy Prope

12、rties 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 = I

13、nsurance 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 IDGeograp

14、hic 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保單各類事件（除理賠）Di

15、agram: 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 Policy Pr

16、operties 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 Currency

17、 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 Commissio

18、n 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_MONEYSYB_

19、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 Customer T

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

21、DSYB_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 IDProfession

22、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_IDS

23、YB_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 Numb

24、erEmail 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 Cla

25、ssificationNational 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 NamePri

26、mary 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 IDPaym

27、ent 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 IndicatorParti

28、cpating IndicatorWithdrawal IndicatorJoint Life BasisJoint Life IndicatorAutomatic Benefit Indexation BasisCritical Illness IndicatorTrust IndicatorSchool Fees Plan IndicatorAssociated Life Cover IndicatorWaiver of Premium Indicator共 保 標 志SYB_IDSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_SHORTSTRINGS

29、YB_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 CodeC

30、overage 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 Unique ID

31、First 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 Enti

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

33、nel 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_CATEGOR

34、YSYB_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 IDO

35、rigin 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_CLASSI

36、FICATIONSYB_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 Rat

37、ingLife Insurance Policy Rating IDGenderAge BandHazardous Occupation IndicatorHazardous Activity IndicatorPoor Health IndicatorSmoker classificationPolicy Rating CategoryPolicy Rating Category DescriptionPrefered rating indicatorOccupation Class CodeImpairment Rating CodeDrinker Indicator標 準 件 標 志SY

38、B_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_BANDSYB_B

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

40、 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 Unit

41、County 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_ABBREVIATIONS

42、YB_ABBREVIATIONSYB_ABBREVIATIONSYB_NAMESYB_NAMESYB_ABBREVIATIONSYB_ABBREVIATIONSYB_ABBREVIATIONSYB_ABBREVIATIONSYB_SHORTSTRINGSYB_CODESYB_CODESYB_CODESYB_INDICATORLife Insurance ProductProduct IDProduct Begin DateProduct End DateProduct Accounting ClassificationProduct Market SegmentProduct LineProd

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

44、STRINGSYB_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_VERYLONGSTRINGSYB

45、_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_IDSYB

46、_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 Date

47、Postal 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_LONGSTRIN

48、GSYB_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 Tim

49、e 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_DATESY

50、B_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 Time

51、 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 = Ent

52、ity 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 IDPerio

53、d 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 Properties

54、 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: Insuranc

55、ePackage: Life Policy Key Measures 保單各類指標匯總快照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 RatioSY

56、B_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 Struct

57、ure 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 Period I

58、DStart 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 AmountR

59、eference 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 Value

60、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