通用语义层数据建模方法论 V1.0-public

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 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共 保 标 志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标 准 件 标

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 保单各类指标汇总快照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