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

1、通用语义层数据模型建设思路12021/8/26内容提纲内容演讲人备注第一部分：通用语义层概述：回顾以往数据仓库模型设计思路：什么是通用语义层：通用语义层能解决什么问题：通用语义层有哪些特点第二部分：如何设计通用语义层第三部分：项目案例说明第四部分：实践课：虚拟场景下设计通用语义层下次课程安排第五部分：附录：相关文档模板下次课程安排22021/8/26内容提纲内容演讲人备注第一部分：通用语义层概述：回顾以往数据仓库模型设计思路：什么是通用语义层：通用语义层能解决什么问题：通用语义层有哪些特点第二部分：如何设计通用语义层第三部分：项目案例说明第四部分：实践课：虚拟场景下设计通用语义层下次课程安排第

2、五部分：附录：相关文档模板下次课程安排32021/8/26 回顾数据仓库数据架构演变过程1.0 实施方法特点：源数据一般直接抽取到缓冲层，缓冲层逻辑上在细分为全量区、增量区；基于缓冲层（当时叫ODS层）加工数据集市，集市分为明细汇总表、高粒度的汇总表；用户应用多集中在报表统计；个险银保团险电销财务接口文件缓冲层，（ODS）个险、银保、团险、财务、电销等数据集市（DM）明细汇总表，高度汇总表固定报表灵活查询多维分析1.5 实施方法特点：缓冲层与数据集市模型设计思路与以往类似；整合层，参考了IBM的IIW、TD的FS_LDM模型，进行客户化；或者据此设计公司内部的企业模型；用户应用多样化，充分利用

3、BI工具分析功能；管理驾驶舱实际上是仪表盘+固定报表个险银保团险电销财务接口文件缓冲层，（ODS）个险、银保、团险、财务、电销等数据集市（DM）明细汇总表DM1，高度汇总表DM2固定报表灵活查询多维分析整合层（DW）统一建模管理驾驶舱42021/8/26 增量信息难以捕获，造成模型设计难以保存历史，造成了模型设计有些“四不象”，实际上并没有学习到行业模型的精髓项项目困目困难难、困惑、困惑项目实施过程中遇到的困难、困惑ETL过程设计简单，代理主键的使用、更新与维护混乱数据集市一般根据应用来设计，集市表成“碎片”，且指标多次重复计算，集市之间存在误差（可能因为维度、指标口径不明确、加工频度、刷新频

4、度、脚本错误等）数据集市根据实际需要分为明细汇总表、轻粒度汇总表、高度汇总表，至于为何这么分，并没有讲出所以然来整合层按照范式的要求进行存储，在计算集市时，非常的不方便，效率低下，因此常将一些常见的维度信息关联好，存储起来，集市计算时使用52021/8/26以往数据仓库类项目模型设计成果示例当事人当事人事件事件协议协议集市模型，这里甚至没有分层集市模型，这里甚至没有分层困惑困惑！62021/8/26当前，数据仓库最佳实践之数据架构2.0 实施方法特点：总结以往项目经验，规划出较为实用的一层，通用语义层，将基础指标的计算、维度梳理预处理，将多表关联处理成冗余的宽表，解决实际问题；提炼建模方法论，

5、指导项目实际操作；少走弯路。个险银保团险电销财务接口文件缓冲层，（缓冲区、转换映射区、基础数据区）个险、银保、团险、财务、电销等数据集市（DM）分主题汇总（考虑复用）、特定应用汇总固定报表灵活查询多维分析通用语义层（存储明细数据、可多次复用的数据，解决维度与指标一致性的问题）管理驾驶舱制式报告动态报表资产接口文件72021/8/26内容提纲内容演讲人备注第一部分：通用语义层概述：回顾以往数据仓库模型设计思路：什么是通用语义层：通用语义层能解决什么问题：通用语义层有哪些特点第二部分：如何设计通用语义层第三部分：项目案例说明第四部分：实践课：虚拟场景下设计通用语义层下次课程安排第五部分：附录：相关

6、文档模板下次课程安排82021/8/26通用语义层起源与BO通用语义层（Common Semantic Layer），检称CSL， 最早起源与BO，目的在于让业务用户能够通过自己的业务术语，自由安全的访问、分析以及分享信息的技术，其特点是：业务用户自主操作提高用户对于各种企业数据的操作体验提供一致可信的数据，确保同一业务术语的引用能够贯穿整个企业让所有的商务智能工具都可以使用（只能用于BO）让信息部门可以控制和确保信息访问的安全性92021/8/26通用语义层带来的价值简洁一致的用户体验，让业务用户可以简便的访问企业内的数据；减少企业的培训成本；保障业务用户始终使用可信的信息业务用户自创式创建

7、各种商务智能的内容可重用的查询、计算、参数、过滤条件、值列表简化用户使用为普通用户提供了一个简化的界面，访问复杂的企业数据降低BI项目的投入成本，保护现有IT数据投资扩展现有的BI平台的安全模式支持多数据源的语义层，提高服务质量支持完整BI项目生命周期，项目开发、测试、投产语义层与数据源的变化相同步支持和扩展数据库的安全性预定义的可重用的查询、参数、过滤、计算、值列表等给业务用户带来的价值给业务用户带来的价值给给IT 用户带来的价值用户带来的价值102021/8/26语义层过于复杂，难以理解，尤其是新老人员交替，沟通成本很高语义层的设计成果不能在多个BI工具中使用，过于依赖BI工具.重用程度不

8、高语义层的扩展于与分拆影响较大，难以后期维护，为了降低影响范围，大多是在原来基础上，新增其他功能，致其复杂度越来越高；BO中的通用中的通用语义层实践语义层实践中遇到了一系列的中遇到了一系列的问题问题如如何解决这些问题呢？ 即能够享有通用语义层带来的价值，又能够规避这些问题。112021/8/26经经过过敏思苦想、群策群力，敏思苦想、群策群力，终终于有了答案。于有了答案。敏思苦想群策群力奔走相告豁然开朗使用ETL的方式，将BO中的语义层搬到数据库中，简化加工逻辑、提供可扩展性和可复用性122021/8/26现现在，我在，我们来们来重新定重新定义义通用通用语义层语义层通用语义层模型设计基于业务（如

9、保险）核心价值链上的核心业务对象和业务事件，采用维度总线架构思想来构建；业务对象通常用维度实现，业务事件通常用事实表实现，按照事实表的不同类型分为：累计快照事实表、周期快照事实表、交易基础事实表。通用语义模型设计面向管理决策和经营分析，是公共维度和共性基础指标的实现载体，支持80%以上的共性应用需求；通用语义模型设计采用维度化的逆范式设计模式，通常采用以下策略： 预连接处理：按照总线架构维度和事实表的要求，将分散在多张相关实体表的数据属性进行预连接操作，使相关的维度尽可能组织在特定的维表或者事实表，如保单维、保单责任维、代理人维、客户维、赔案维等； 预计算处理：按照总线架构维度和事实表的要求，

10、对事实表中的基础指标进行加工计算，保证基础指标逻辑加工的“Golden Copy”，如保单事件、核保事件、保全事件、查勘事件、理赔事件等； 汇总处理：针对共性的复杂指标，按照对应的维度进行提前聚合处理，以保证共性复杂指标逻辑加工的“Golden Copy”，避免重复加工，提供数据一致性和响应效率，如保单层面指标汇总，机构层面指标汇总，产品层面指标汇总，代理人层面指标汇总，客户层面指标汇总等；通用语义层模型的粒度尽可能保留到最细交易粒度（汇总处理除外），以保持模型间的连通性，并能够最大程度、最快速地响应新需求；132021/8/26以Sysbase 的IWS模型为指导思想，进行通用语义层设计核心

11、主题：Life Policy EventLife Claim Transactions关键度量主题：Life Policy Key MeasuresLife Policy Costs Key MeasuresLife Agency Channel Key MeasuresLife Agent Channel Key MeasuresLife Product Costs Key MeasuresLife Underwriting Costs Key MeasuresLife Claim Summary （实际上也是Key Measures ）其他应用主题视图：Life Quotations &a

12、mp; ProposalsLife New BusinessIWS模型主题主要分为事件表和度量表142021/8/26Policy ID = Policy IDPromotional Episode ID = Promotional Episode IDInsurance Policy Properties ID = Insurance Policy Properties IDISO Currency ID = ISO Currency IDPayment Category ID = Payment Category IDEntity ID = Insured Participant IDGe

13、ographic ID = Issued Geographic IDEntity ID = Previous Insurance Carrier IDEntity ID = Insurance Agent IDEntity ID = Insurance Agency IDEntity ID = Insurance Group IDProduct ID = Product IDCore Reporting Structure ID = Agent Reporting Structure IDLife Insurance Policy Rating ID = Policy Rating IDLif

14、e Insurance Policy Features ID = Life Insurance Policy Features IDEntity ID = Entity IDPersonal Behavior Score ID = Personal Behavior Score IDGeographic ID = Geographic IDDemographics ID = Demographics IDPeriod ID = Policy Event Date Period IDDemographics ID = Demographics IDFinancial Scores ID = Fi

15、nancial Scores IDGeographic ID = Geographic IDProfession ID = Profession IDPhysical Data ModelModel: InsurancePackage: Life Policy Event保单各类事件（除理赔）Diagram: Life Policy EventAuthor: ADMINDate: 2004/2/11 Version: 4.0.276Life Insurance Policy EventLife Insurance Policy EventPolicy IDPolicy Event IDPoli

16、cy Event Sequence NumberPolicy Event Date Period IDPolicy Event Type IDProduct IDPolicy Rating IDLife Insurance Policy Features IDInsurance Policy Properties IDInsured Participant IDInsurance Group IDUnderwriter IDUnderwriter Reporting Structure IDInsurance Agency IDInsurance Agent IDAgent Reporting

17、 Structure IDPrevious Insurance Carrier IDDemographics IDGeographic IDIssued Geographic IDPromotional Episode IDISO Currency IDReference ISO Currency IDPayment Category IDPolicy Transaction Written Premium AmountPolicy Coverage AmountReference Currency Policy Coverage AmountTransaction AmountReferen

18、ce Currency Transaction AmountCommission TypePolicy Transaction Commission AmountReference Currency Policy Commission AmountPolicy 1ST Year Commission AmountPolicy TermService Commission AmountPolicy Renewal CommissionSYB_IDSYB_IDSYB_COUNTSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDS

19、YB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_MONEYSYB_MONEYSYB_MONEYSYB_MONEYSYB_MONEYSYB_TYPESYB_MONEYSYB_MONEYSYB_MONEYSYB_INTSYB_MONEYSYB_MONEYPromotional Campaign EpisodePromotional Episode IDEpisode Reporting Structure IDActual Begin Date Period IDActual End Date Period

20、IDPromotion Campaign IDScheduled Begin DateScheduled End DateAll Entries IndicatorEpisode TypeEpisode NameEpisode IncentiveEpisode Desired Customer Target CountEpisode Actual Customer Target CountEpisode Budgeted CostEpisode Actual CostCampaign Media TypeRedemption MechanismEpisode Effectiveness Rat

21、ingEpisode Estimated Revenue GenerationEpisode Estimated Customer GenerationCredited RevenueCredited Customer GenerationSelection CriteriaSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_DATESYB_DATESYB_INDICATORSYB_TYPESYB_NAMESYB_LONGSTRINGSYB_COUNTSYB_COUNTSYB_MONEYSYB_MONEYSYB_CLASSIFICATIONSYB_TYPESYB_NAMESYB

22、_MONEYSYB_COUNTSYB_MONEYSYB_COUNTSYB_VERYLONGSTRINGLife Insured Participant ProfileEntity Profile IDEntity IDCustomer Since Date Period IDProfession IDPsychographics IDDemographics IDPrimary Address IDAsset IDLanguage IDPersonal Behavior Score IDAffiliation IDFinancial Scores IDGeographic IDContact

23、Instruction IDBegin Date Period IDEnd Date Period IDProduct Ownership IDReporting Structure IDUsage Profile IDQuick Reporting Profile IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDSYB_IDInsured ParticipantEntity IDEntity Category

24、NameEntity Unique IDOrigin DatePrefixFirst NameSecond NameThird NameSuffixNational IdentifierGroupRelationship StatusPrimary Telephone NumberFax NumberEmail AddressLife StatusSYB_IDSYB_NAMESYB_LEGACY_IDSYB_DATESYB_ABBREVIATIONSYB_NAMESYB_NAMESYB_NAMESYB_SHORTSTRINGSYB_TAX_IDSYB_CATEGORYSYB_SHORTSTRI

25、NGSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILSYB_SHORTSTRINGInsurance GroupEntity IDOrigin DateFirst NameSecond NameThird NamePrimary ClassificationSecondary ClassificationNational IdentifierPrimary Telephone NumberSecondary Telephone NumberFax NumberEmail AddressSYB_IDSYB_DATESYB_NAMESYB_NAMESYB_NAMESYB_CLASSI

26、FICATIONSYB_CLASSIFICATIONSYB_TAX_IDSYB_TEL_NBRSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILInsurance CarrierEntity IDOrigin DateFirst NameSecond NameThird NamePrimary ClassificationSecondary ClassificationNational IdentifierPrimary Telephone NumberSecondary Telephone NumberFax NumberEmail AddressSYB_IDSYB_DATESY

27、B_NAMESYB_NAMESYB_NAMESYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_TAX_IDSYB_TEL_NBRSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILPayment CategoryPayment Category IDPayment MethodPayment FrequencyAll Entries Indicator实 际 缴 费 方 式SYB_IDSYB_CATEGORYSYB_TYPESYB_INDICATORLife Insurance Policy FeaturesLife Insurance Policy F

28、eatures IDReinsurance IndicatorPolicy Assignment IndicatorAutomatic Indexation IndicatorAutomatic Premium Indexation BasisAdvice Given IndicatorParticpating IndicatorWithdrawal IndicatorJoint Life BasisJoint Life IndicatorAutomatic Benefit Indexation BasisCritical Illness IndicatorTrust IndicatorSch

29、ool Fees Plan IndicatorAssociated Life Cover IndicatorWaiver of Premium Indicator共 保 标 志SYB_IDSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_SHORTSTRINGSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_SHORTSTRINGSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORInsuran

30、ce PolicyPolicy IDCustomer NamePolicy NumberPolicy Risk GradePolicy Start DatePolicy End DateSIC CodeProgram CodeClass CodeISO ClassReinsurance CodeCoverage CodeIRPM FactorAll Entries Indicator保 单 来 源Column_16SYB_IDSYB_NAMESYB_LEGACY_IDSYB_CODESYB_DATESYB_DATESYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_

31、CLASSIFICATIONSYB_CLASSIFICATIONSYB_CATEGORYSYB_CLASSIFICATIONSYB_NUMERICSYB_INDICATORInsurance AgentEntity IDEntity Subcategory NameEntity Unique IDFirst NameSecond NameThird NameNational IdentifierPrimary Telephone NumberSecondary Telephone NumberFax NumberEmail AddressSYB_IDSYB_NAMESYB_LEGACY_IDS

32、YB_NAMESYB_NAMESYB_NAMESYB_TAX_IDSYB_TEL_NBRSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILInsurance Agent Reporting StructureCore Reporting Structure IDChannel Entity IDManagement Unit IDChannel Ceased Trading DateBegin DateEnd DateCost Center IndicatorProfit Center IndicatorBooking Unit IndicatorAssociation Categ

33、oryDistrictHolding CompanyOrganization TypeOrganization NameAreaRegionTeam TypeTeamPerson NamePerson GradePerson TypeChannel CategoryChannel TypeChannel SubcategoryChannel NameChannel CityChannel PostcodeRevenue or Cost Center IndicatorAll Entries IndicatorSYB_IDSYB_IDSYB_IDSYB_DATESYB_DATESYB_DATES

34、YB_INDICATORSYB_INDICATORSYB_INDICATORSYB_CATEGORYSYB_CODESYB_NAMESYB_TYPESYB_NAMESYB_NAMESYB_NAMESYB_TYPESYB_NAMESYB_NAMESYB_CODESYB_TYPESYB_CATEGORYSYB_CATEGORYSYB_CATEGORYSYB_NAMESYB_NAMESYB_POSTALCODESYB_INDICATORSYB_INDICATORLife Insurance Policy PropertiesInsurance Policy Properties IDPolicy C

35、overage Amount BandPolicy Term BandPolicy Premium BandSYB_IDSYB_BANDSYB_BANDSYB_BANDInsurance AgencyEntity IDEntity Subcategory NameEntity Unique IDOrigin DateFirst NameSecond NameThird NamePrimary ClassificationSecondary ClassificationNational IdentifierPrimary Telephone NumberSecondary Telephone N

36、umberFax NumberEmail AddressEmployee Management Unit IndicatorSYB_IDSYB_NAMESYB_LEGACY_IDSYB_DATESYB_NAMESYB_NAMESYB_NAMESYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_TAX_IDSYB_TEL_NBRSYB_TEL_NBRSYB_TEL_NBRSYB_EMAILSYB_INDICATORCurrencyISO Currency IDCurrency Short NameCurrency Long NameCountry NameISO Nu

37、meric Country CodeISO Alpha Currency CodeAll Entries IndicatorSYB_IDSYB_SHORTSTRINGSYB_LONGSTRINGSYB_NAMESYB_CODESYB_CODESYB_INDICATORLife Policy RatingLife Insurance Policy Rating IDGenderAge BandHazardous Occupation IndicatorHazardous Activity IndicatorPoor Health IndicatorSmoker classificationPol

38、icy Rating CategoryPolicy Rating Category DescriptionPrefered rating indicatorOccupation Class CodeImpairment Rating CodeDrinker Indicator标 准 件 标 志SYB_IDSYB_TYPESYB_BANDSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_CLASSIFICATIONSYB_CATEGORYSYB_VERYLONGSTRINGSYB_INDICATORSYB_CODESYB_CODEBehavior Scores

39、Personal Behavior Score IDPersonal Behavior Score 1 BandPersonal Behavior Score N BandAll Entries IndicatorRFM CodeRFM DescriptionSYB_IDSYB_BANDSYB_BANDSYB_INDICATORSYB_CODESYB_LONGSTRINGIssued GeographyGeographic IDBegin DateEnd DatePostal CodeCityPostal Code PrefixHazardous Weather Area IndicatorS

40、torm Hazard IndicatorFlood Hazard IndicatorTornado Hazard IndicatorHurricane Hazard IndicatorEarthquake Hazard IndicatorDisease Hazard IndicatorRadon Hazard IndicatorEnvironmental Hazard IndicatorOther Hazard IndicatorDMA CodeSMSA CodeState Province AreaTelevision RegionNational Radio AreaLocal Radi

41、o AreaGeographic RegionCountryContinent Abbreviated NameSubcontinent Abbreviated NameCensus TractCensus Block GroupEconomic RegionCity Political UnitCounty Political UnitState Province Political UnitAll Entries IndicatorSYB_IDSYB_DATESYB_DATESYB_POSTALCODESYB_NAMESYB_CODESYB_INDICATORSYB_INDICATORSY

42、B_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_INDICATORSYB_CODESYB_CODESYB_LONGSTRINGSYB_ABBREVIATIONSYB_ABBREVIATIONSYB_ABBREVIATIONSYB_NAMESYB_NAMESYB_ABBREVIATIONSYB_ABBREVIATIONSYB_ABBREVIATIONSYB_ABBREVIATIONSYB_SHORTSTRINGSYB_CODESYB_CODESYB_CODES

43、YB_INDICATORLife Insurance ProductProduct IDProduct Begin DateProduct End DateProduct Accounting ClassificationProduct Market SegmentProduct LineProduct GroupProduct CodeProduct NameProduct TypeProduct ClassProduct CategoryProduct SubcategoryProduct Variant CodeProduct VariantGroup Individual Indica

44、torParticipating IndicatorProfitability BandAll Entries IndicatorSYB_IDSYB_DATESYB_DATESYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_CLASSIFICATIONSYB_LONGSTRINGSYB_CODESYB_VERYLONGSTRINGSYB_CATEGORYSYB_LONGSTRINGSYB_CATEGORYSYB_CATEGORYSYB_CODESYB_LONGSTRINGSYB_INDICATORSYB_INDICATORSYB_BANDSYB_INDICATOR

45、Sales Event TypeCore Event Type IDCore Event Type Short NameCore Event Type NameCore Event Type Subtype Short NameSYB_IDSYB_NAMESYB_VERYLONGSTRINGSYB_NAMEReference CurrencyISO Currency IDCurrency Short NameCurrency Long NameCountry NameISO Numeric Country CodeISO Alpha Currency CodeAll Entries Indic

46、atorSYB_IDSYB_SHORTSTRINGSYB_LONGSTRINGSYB_NAMESYB_CODESYB_CODESYB_INDICATORTime PeriodPeriod IDDate Not ApplicablePeriod DateDay Full Name.SYB_IDSYB_FLAGSYB_DATESYB_DAYUnderwriterEntity IDEntity Unique IDFirst NameSecond Name.SYB_IDSYB_LEGACY_IDSYB_NAMESYB_NAMEUnderwriter Reporting StructureCore Re

47、porting Structure IDChannel Entity IDManagement Unit IDChannel Ceased Trading Date.SYB_IDSYB_IDSYB_IDSYB_DATEGeographyGeographic IDBegin DateEnd DatePostal Code.SYB_IDSYB_DATESYB_DATESYB_POSTALCODEDemographicsDemographics IDDemographics TypeDisposable Income BandIncome Band.SYB_IDSYB_TYPESYB_BANDSYB

48、_BANDProfessionProfession IDProfession GroupProfession IndustryProfession NameProfession CodeProfession TitleAll Entries IndicatorSYB_IDSYB_LONGSTRINGSYB_LONGSTRINGSYB_LONGSTRINGSYB_CODESYB_SHORTSTRINGSYB_INDICATORFinancial ScoresFinancial Scores IDInternal Financial Score BandExperian Score BandSco

49、re N BandProfitability Index BandDebt Income Ratio BandAll Entries IndicatorSYB_IDSYB_BANDSYB_BANDSYB_BANDSYB_BANDSYB_BANDSYB_INDICATORBegin Date Time PeriodPeriod IDDate Not ApplicablePeriod DateDay Full Name.SYB_IDSYB_FLAGSYB_DATESYB_DAYCustomer Since Date Time PeriodPeriod IDDate Not ApplicablePe

50、riod DateDay Full Name.SYB_IDSYB_FLAGSYB_DATESYB_DAYEnd Date Time PeriodPeriod IDDate Not ApplicablePeriod DateDay Full Name.SYB_IDSYB_FLAGSYB_DATESYB_DAYMonth ID = Month IDPolicy Life Cycle Status ID = Policy Life Cycle Status IDPayment Category ID = Payment Category IDPolicy ID = Policy IDLife Ins

51、urance Policy Rating ID = Policy Rating IDISO Currency ID = ISO Currency IDEntity ID = Insured Participant IDUnderwriting Time ID = Underwriting Time IDLife Insurance Company Underwriting Time = Life Insurance Company Underwriting TimeCore Reporting Structure ID = Agency Reporting Structure IDPeriod

52、 ID = Application Received Date Period IDPeriod ID = Application Date Period IDPersonal Behavior Score ID = Personal Behavior Score IDEntity ID = Entity IDPeriod ID = Maturity Date Period IDPeriod ID = Start Payment PeriodPeriod ID = Option Date Period IDPeriod ID = Determination Date Period IDGeogr

53、aphic ID = Issued Geographic IDCore Reporting Structure ID = Agent Reporting Structure IDEntity ID = Insurance Carrier IDProduct ID = Product IDPeriod ID = Continuing Eligiblity DatePeriod ID = Conversion Option Expiration DateEntity ID = Insurance Group IDEntity ID = Insurance Agent IDEntity ID = I

54、nsurance Agency IDPeriod ID = Renewal Date Period IDPeriod ID = Expiration Date Period IDInsurance Policy Properties ID = Insurance Policy Properties IDLife Insurance Policy Features ID = Life Insurance Policy Features IDDemographics ID = Demographics IDGeographic ID = Geographic IDDemographics ID =

55、 Demographics IDFinancial Scores ID = Financial Scores IDGeographic ID = Geographic IDProfession ID = Profession IDPhysical Data ModelModel: InsurancePackage: Life Policy Key Measures 保单各类指标汇总快照Diagram: Life Policy Key MeasuresAuthor: ADMINDate: 2004/2/11 Version: 4.0.276Life Insurance Policy Key Me

56、asuresLife Insurance Company Underwriting TimeLife Insurance Company Underwriting TimeAverage Company Underwriting TimeUnderwriter to Company RatioSYB_IDSYB_COUNTSYB_RATIOLife Policy Key MeasuresPolicy IDMonth IDProduct IDInsured Participant IDLife Insurance Policy Features IDInsurance Policy Proper

57、ties IDPolicy Rating IDPolicy Life Cycle Status IDPayment Category IDInsurance Carrier IDInsurance Group IDInsurance Agency IDAgency Reporting Structure IDInsurance Agent IDAgent Reporting Structure IDUnderwriter IDUnderwriter Reporting Structure IDGeographic IDIssued Geographic IDDemographics IDExp

58、iration Date Period IDRenewal Date Period IDPolicy Start Date Period IDPolicy Termination DateConversion Option Expiration DateMaturity Date Period IDStart Payment PeriodContinuing Eligiblity DateApplication Date Period IDApplication Received Date Period IDDetermination Date Period IDOption Date Per

59、iod IDISO Currency IDReference ISO Currency IDUnderwriting Time IDLife Insurance Company Underwriting TimeSingle Premium AmountAnnual Premium AmountReference Currency Annual Premium AmountMonthly Premium AmountReferency Currency Monthly Premium AmountMonthly Earned Premium AmountReference Currency M

60、onthly Earned Premium AmountAnnual Earned Premium AmountReference Currency Annual Earned Premium AmountAccounting Value of the PolicySurrender Value of the PolicyWritten Loss RatioEarned Loss RatioTotal Number of Payments to DateTotal Payment Amount to DateReinsure AmountAnnuity RateFunds Under Manageme