{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["insurancearrangement","insuranceclaimthread","individual","IndRelationShip","PartyTimeLine"],"not_rendered":{"external_links":1,"defined_names":5},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"insurancearrangement","index":0,"n_rows":57,"n_cols":6,"rows_kept":57,"merged":[[0,0,0,1],[0,2,0,3]],"flags":["formulas_cached_only"]}
["目的表insurancearrangement",null,"来源"]
["iaid ","'保单ID'","自增",null," "]
["policyno ","保险单号 INSURANCEINFO.CONTNO'","INSURANCEINFO","CONTNO"," "]
["pano "," '投保单号 INSURANCEINFO.PRTNO'","INSURANCEINFO","PRTNO"," "]
["agrmntage "," '保险期限'",null,null," "]
["pbinst "," '受益分配方式'",null,null," "]
["pwcomp "," '承保分公司 HEALTH_INSURANCE_LISTING.AGENTGROUPAREA 营业区HEALTH_INSURANCE_LISTING.AGENTGROUP 营业部'","HEALTH_INSURANCE_LISTING","HEALTH_INSURANCE_LISTING.AGENTGROUPAREA 营业区HEALTH_INSURANCE_LISTING.AGENTGROUP 营业部'"," "]
["pindate "," '起保日期 POLICY_INFORMATION.CVALIDATE'","POLICY_INFORMATION","CVALIDATE"," "]
["pmdate "," '终保日期 POLICY_INFORMATION.ENDDATE'","POLICY_INFORMATION","ENDDATE"," "]
["pisdate "," '签单日期 INSURANCEINFO.SIGNDATE'","INSURANCEINFO","SIGNDATE"," "]
["padate "," '投保日期 INSURANCEINFO.POLAPPLYDATE'","INSURANCEINFO","POLAPPLYDATE"," "]
["renewaldate "," '续保日期'",null,null," "]
["norenewal "," '续保次数 POLICY_INFORMATION.PAYCOUNT'","POLICY_INFORMATION","PAYCOUNT"," "]
["policytype "," '保单类型 PERSONAL_INSURANCE.CONTTYPE","PERSONAL_INSURANCE","CONTTYPE","需上游给出类型枚举值'"," "]
["schannel "," '销售渠道 HEALTH_INSURANCE_LISTING.SALECHANNELS'","HEALTH_INSURANCE_LISTING","SALECHANNELS"]
["bsource "," '业务来源'",null,null," "]
["policystate "," '保单状态 保单包括投保单的所处的状态，例如：录入、生效、批单等'","INSURANCEINFO","appflag"]
["topay "," '缴费类型'",null,null," "]
["payment "," '缴费方式 POLICY_INFORMATION.PAYINTV'","POLICY_INFORMATION","PAYINTV"," "]
["risk "," '总保额 HEALTH_INSURANCE_LISTING.AMNT(测试环境中，此表保单数据量较其他表如：POLICY_INFORMATION，INSURANCEINFO 缺少至少一个数据量级)'","HEALTH_INSURANCE_LISTING","AMNT"," "]
["prem "," '总保费 INSURANCEINFO.PREM'","INSURANCEINFO","PREM"," "]
["currency "," '币种'",null,null," "]
["npdate "," '下次缴费日期'",null,null," "]
["soinsured "," '被保人数 HEALTH_GROUP_LISTING.PEOPLES3","HEALTH_GROUP_LISTING","PEOPLES3","团单'"," "]
["bsinsured "," '基本保额 保险合同条款费率表中载明的单位保额。比如中国人寿的康宁终身保险就是这样，如果购买的基本保险金额是10万的话，那么大病的保险金额就是基本保险金额的2倍即20万；'",null,null," "]
["insurvalue "," '保单价值 保单价值，即保单现金价值。是指带有储蓄性质的人身bai保险单所具有的价值。保险人为履行合同责任通常提存责任准备金，如果您中途退保，即以该保单的责任准备金作为给付解约的退还金。被保险人要求解约或退保时，寿险公司应该发还的金额。在长期寿险契约中，保险人为履行契约责任，通常需要提存一定数额的责任准备金。当被保险人于保险有效期内因故要求解约或退保时，保险人按规定，将提存的责任准备金减去解约扣除后的余额退还给被保险人，这部分余额即解约金，亦即退保时保单所具有的现金价值。'"]
["applicantid "," '投保人 根据POLICY_INFORMATION.CUSTOMERNO关联individual上游客户号，再找到individualid'","POLICY_INFORMATION","根据POLICY_INFORMATION.CUSTOMERNO关联individual上游客户号，再找到individualid"," "]
["appname "," '投保人名称 POLICY_INFORMATION.NAME'","POLICY_INFORMATION","NAME"," "]
["appphone "," '投保人手机'",null,null," "]
["appcertid "," '投保人证件号码 POLICY_INFORMATION.IDNO'","POLICY_INFORMATION","IDNO"," "]
["insuredid "," '主被保险人'",null,null," "]
["insname "," '主被保险人名称 POLICY_INFORMATION.INSUREDNAME'","POLICY_INFORMATION","INSUREDNAME"," "]
["insphone "," '主被保险人手机'",null,null," "]
["inscertid "," '主被保险人证件号码 POLICY_INFORMATION.INSUREDIDNO'","POLICY_INFORMATION","INSUREDIDNO"," "]
["productid "," '险种代码 POLICY_INFORMATION.RISKCODE'","POLICY_INFORMATION","RISKCODE"," "]
["productname "," '险种名称 INSURANCEINFO.RISKNAME'","INSURANCEINFO","RISKNAME"," "]
["salesperson "," '业务员'",null,null," "]
["spname "," '业务员名称 HEALTH_INSURANCE_LISTING.AGENTCODE'",null,null," "]
["iaccount "," '所属保险账户'",null,null," "]
["branchcode "," '机构代码'",null,null," "]
["policybelong "," '业绩归属 POLICY_INFORMATION.SALECOM'","POLICY_INFORMATION","SALECOM"," "]
["agentchannel "," '代理渠道 INSURANCEINFO.SELLTYPE'","INSURANCEINFO","SELLTYPE"," "]
["agentorg "," '代理机构'",null,null," "]
["regtype "," '户籍类型'",null,null," "]
["pincome "," '个人年收入'",null,null," "]
["fincome "," '家庭年收入'",null,null," "]
["incomesource "," '收入来源'",null,null," "]
["socialinsurance "," '是否有社保'",null,null," "]
["oipolicy "," '是否投保其他保险公司'",null,null," "]
["oicompany "," '其他保险公司'",null,null," "]
["oicproduct "," '其他保险公司险种'",null,null," "]
["oiamount "," '其他保险公司保额'",null,null," "]
["drinking "," '是否饮酒'",null,null," "]
["dfavor "," '饮酒喜好'",null,null," "]
["poservice "," '是否保全 投保人持有保单是否在AUDIT_EDORLIST.CONTNO存在'","AUDIT_EDORLIST","投保人持有保单是否在AUDIT_EDORLIST.CONTNO存在"," "]
["payendyear "," '缴费年期 POLICY_INFORMATION.PAYENDYEAR'","POLICY_INFORMATION","PAYENDYEAR"," "]
[{"$nulls":4}," "]

{"sheet":"insuranceclaimthread","index":1,"n_rows":43,"n_cols":5,"rows_kept":43,"merged":[[0,0,0,1],[0,2,0,3],[42,1,48,3]],"flags":["formulas_cached_only"]}
["目的表insurancearrangement(理赔)",null,"来源"]
["ICThreadID","'保险理赔Id'"]
["CRNo","'立案号'"]
["CompanyNo","'公司代码'"]
["PolicyNo","'保险单号","INSURANCE_CLAIM","CONTNO"]
["ApplicantID","'投保人ID'",null,"根据保单号查询出"]
["AppName","'投保人名称'",null,"根据保单号查询出"]
["AppPhone","'投保人手机'",null,"根据保单号查询出"]
["AppCertID","'投保人证件号码'",null,"根据保单号查询出"]
["CNNo","'报案号'"]
["LossTime","损失发生时间","INSURANCE_CLAIM","RISKDATE"]
["RPID","'报案人'"]
["RPName","'报案人名称'"]
["RPPhone","'报案人电话'"]
["LPID","'出险人","INSURANCE_CLAIM","根据INSUREDNO获取indid'"]
["LPName","'出险人名称'","INSURANCE_CLAIM","insuredname"]
["CNDate","'报案日期","INSURANCE_CLAIM","RPTDATE"]
["LossDescribe","'损失原因","INSURANCE_CLAIM","案件发生的原因LLOCCURREASON'"]
["CRDate","'立案日期","INSURANCE_CLAIM","RGTDATE"]
["CNDescribe","'报案描述","INSURANCE_CLAIM","ACCIDENTDETAIL"]
["ClaimStatus","理赔状态","INSURANCE_CLAIM","案件的状态，例如：录入、已立案等'"]
["CSDate","'理赔状态日期'"]
["RelationShip","'报案人与出险人关系'"]
["CCNo1","'赔案号1","INSURANCE_CLAIM","CLMNO 时间最近的","INSURANCE_CLAIM 和AUDIT_CLAIM_INSURANCE区别不大"]
["CCStatus1","'赔案状态1'",null,"llclaimstate"]
["CCSDate1","'赔案状态日期1'"]
["ProductID1","'险种代码1","INSURANCE_CLAIM","riskcode"]
["CCAMT1","'赔付金额1","INSURANCE_CLAIM","riskname"]
["CCNo2","'赔案号2'","INSURANCE_CLAIM","CLMNO 时间第二近的"]
["CCStatus2","'赔案状态2'",null,"llclaimstate"]
["CCSDate2","'赔案状态日期2'"]
["ProductID2","'险种代码2'","INSURANCE_CLAIM","riskcode"]
["CCAMT2","'赔付金额2'","INSURANCE_CLAIM","riskname"]
["BranchCode","'机构代码'"]
["ClaimCaseStatus","'案件状态","INSURANCE_CLAIM_HEALTH","LLCLAIMSTATE"]
["CREATED_BY","'创建人'"]
["CREATED_TIME","'创建时间'"]
["UPDATED_BY","'更新人'"]
["UPDATED_TIME","'更新时间'"]
[]
[]
[]
[null,"个人理赔表insurance_claim 根据（ contno  '保单号', clmno '赔案号' ）去重后 \n  一个保单对应多个 赔案"]

{"sheet":"individual","index":2,"n_rows":277,"n_cols":5,"rows_kept":277,"merged":[[0,0,0,1],[0,2,0,3]],"flags":["formulas_cached_only"]}
["目的表individual(个人信息)",null,"来源"]
["IndID","个体ID'",null,"自动生成"]
["CustID","'客户号",null,"本系统统一生成的全司范围的唯一标识'"]
["SCustID","'上游客户号","policy_information","customerno，insuredno","上游系统的客户ID'"]
["Name","'名称","policy_information","CUSTOMER_NAME，insuredname"]
["Birthday","'出生日期","policy_information","BIRTHDATE，insuredbirthday"]
["NOBirth","'出生国家'"]
["SOBirth","'出生省份'"]
["COBirth","'出生城市'"]
["Dday","'死亡日期'"]
["Gender","性别GB/T 2261.1-2003规定的一位数字代码执行，前三位填充G00:G000:未知的性别G001:男性G002:女性G009:未说明的性别","policy_information","GENDERcode codename0男1女"]
["Ethnic","'民族'"]
["Nation","'国籍'"]
["HomeAdress","籍贯","HEALTH_INSURANCE_LISTING","APPNTHOMEADDRESS'"]
["RegResidence","'户口所在地'"]
["MaritalStat","婚姻状况一对多'"]
["MaritalStatDate","婚姻状况日期一对多'"]
["Offspring","'生育状况'"]
["Support","'赡养状况'"]
["EmpStat","就业状况一对多'"]
["EmpStatDate","就业状况日期一对多'"]
["RAID","'联系地址'"]
["RAL","'联系地址不分段'"]
["AL","'曾用地址不分段'"]
["COAdress","'地址登录数量'"]
["PMPhone","常用手机正在使用的手机'"]
["Mhone1","'曾用手机1'"]
["Mhone2","'曾用手机2'"]
["SOPhone","'手机登录数量'"]
["Height","'身高'"]
["Weight","'体重'"]
["CIllness","'当前疾病'"]
["PIllness","'曾患疾病'"]
["BMI","'BMI体制指数'"]
["FMHistory","'家族病史'"]
["EvaDate","'健康评估日期'"]
["COHEvaluation","'健康评估登录数量'"]
["HPhone","'家庭电话'"]
["OccupationId","职业代码","HEALTH_INSURANCE_LISTING",".APPNTOCCUPATIONNAME代码'"]
["Occupation","职业名称","HEALTH_INSURANCE_LISTING",".APPNTOCCUPATIONNAME名称'"]
["Odate","职业时间一对多'"]
["Employer","'工作单位'"]
["WPhone","'工作电话'"]
["EmpDate","'工作单位时间'"]
["LEmployer","'曾经工作单位'"]
["IDCard","身份证 身份证1 护照2 军人证（军官证）3 驾照4 户口本5 学生证6 工作证7 出生证8 其它9 无证件A 士兵证B 回乡证C 临时身份证D 警官证E 台胞证F 港、澳通行证I 外国人永久居留身份证J 港澳台居民居住证K 港澳居民居住证M 台湾居民居住证","policy_information",".ID_NO，insuredidno"]
["Passport","'护照'","policy_information",".ID_NO，insuredidno"]
["Dlicense","'驾驶证'","policy_information",".ID_NO，insuredidno"]
["Education","'最高学历'"]
["University","'毕业学校'"]
["Edate","'学历时间'"]
["Wechat","'微信'"]
["Weibo","'微博'"]
["Email","'邮箱'"]
["QQ","'QQ'"]
["Tiktok","'抖音'"]
["SAccount1","'社交账号1'"]
["SA1Cat","'社交账号1类别'"]
["SAccount2","'社交账号2'"]
["SA2Cat","'社交账号2类别'"]
["CType","首选联系方式手机，微信，微博，邮箱，QQ，抖音，其他'"]
["Father","'父亲","policy_information",".INSUREDNAME","policy_information.RELATION:投保人与被保人关系'"]
["Mother","'母亲'","policy_information",".INSUREDNAME","policy_information.RELATION:投保人与被保人关系'"]
["Mate","'配偶'","policy_information",".INSUREDNAME","policy_information.RELATION:投保人与被保人关系'"]
["child1","'子女1'","policy_information",".INSUREDNAME","policy_information.RELATION:投保人与被保人关系'"]
["child2","'子女2'","policy_information",".INSUREDNAME","policy_information.RELATION:投保人与被保人关系'"]
["COChild","'子女登录数量'"]
["RPID","'房产'"]
["RPDescribe","'房产描述'"]
["CORP","'房产登录数量'"]
["VID","'车辆'"]
["VDescribe","'车辆描述'"]
["COVehicle","'车辆登录数量'"]
["Anniversary1","'纪念日1'"]
["A1Describe","'纪念日1类型'"]
["Anniversary2","'纪念日2'"]
["A2Describe","'纪念日2类型'"]
["SOAnniversary","'纪念日登录数量'"]
["CustType","'客户类型'"]
["BankName","'开户银行'"]
["TOBankCard","银行卡类型如：master、visa、银联等。'"]
["AccName","'账户名'"]
["BankAccNo","'银行帐号'"]
["COBAccount","'账户登录数量'"]
["SOTLIRisk","'传统寿险种保额合计'"]
["SOAIRisk","'意外类险种保额合计'"]
["SOSIIRisk","'重疾类险种保额合计'"]
["SOMCIRisk","'医疗费用类险种保额合计'"]
["SOMEIRisk","'医疗补贴类险种保额合计'"]
["SOEFIRisk","'教育金类险种保额合计'"]
["SOPIRisk","'养老金类险种保额合计'"]
["SOWMIRisk","'财富管理险种保额合计'"]
["CustClass","'客户等级","T_CUSTOMER_CLASS.",".CLASS_VALUE","钻石2 白金3 黄金4 普通0 无"]
["ConValue","'贡献度分'","T_CUSTOMER_CLASS."]
["Awarded3","'家庭加分'","T_CUSTOMER_CLASS."]
["Awarded2","'续期加分'","T_CUSTOMER_CLASS."]
["Awarded1","'保单加分'","T_CUSTOMER_CLASS."]
["SOValue","'总分值'","T_CUSTOMER_CLASS."]
["EndDate","'客户等级失效日期'","T_CUSTOMER_CLASS."]
["SystemTag1","'系统标签域1'"]
["SystemTag2","'系统标签域2'"]
["SystemTag3","'系统标签域3'"]
["SystemTag4","'系统标签域4'"]
["SystemTag5","'系统标签域5'"]
["COCommunication","'接触次数'"]
["LCDate","'最近接触时间'"]
["LCType","'最近接触类型'"]
["COComplaint","投诉次数当前客户投保保单相关投诉，包括非本人投诉'"]
["LCPTDate","最近投诉时间当前客户投保保单相关投诉，包括非本人投诉'"]
["LCPTReason","最近投诉原因当前客户投保保单相关投诉，包括非本人投诉'"]
["LCPTLink","最近投诉环节当前客户投保保单相关投诉，包括非本人投诉'"]
["LCPTResult","最近投诉处理结果当前客户投保保单相关投诉，包括非本人投诉'"]
["LCPTDuration","'最近投诉处理时长"]
["LCPTPerson","'最近投诉人'"]
["SOPPremium","'累计已缴保费'"]
["LAPPDate","'最近投保日期'"]
["CNDate","'最近报案日期'"]
["CNStatus","'最近报案状态'"]
["COClaim","'赔付次数'"]
["SOClaim","'赔付总额'"]
["COCNotification","'报案登录数量'"]
["FADate","首次投保日期，当前客户为投保人时'"]
["LADate","最近投保日期"]
["LPNo","'最近保险单号"]
["LPState","'最近保单状态"]
["LPName","'最近投保险种名称"]
["COPolicy","'保单登录数量'"]
["IAccNo1","'保险账户1'"]
["IAccName1","'保险账户1名称'"]
["IAccNo2","'保险账户2'"]
["IAccName2","'保险账户2名称'"]
["IAccNo3","'保险账户3'"]
["IAccName3","'保险账户3名称'"]
["SOIAccount1","'保险账户1余额'"]
["SOIAccount2","'保险账户2余额'"]
["SOIAccount3","'保险账户3余额'"]
["COIAccount","'保险账户登录数量'"]
["HOMEID","家庭号大数据平台HOME_NETWORK'"]
["BranchCode","机构代码数据归属机构，用于权限控制'"]
["CustState","客户状态party可能会合并导致当前记录不再可用'"]
["DataSource","'数据来源'"]
["Smoking","吸烟情况从不、戒烟、吸烟'"]
["Drinking","饮酒情况从不、戒酒、饮酒'"]
["Hobby1","'兴趣爱好1'"]
["Hobby2","'兴趣爱好2'"]
["Hobby3","'兴趣爱好3'"]
["PIncome","'个人年收入'"]
["FIncome","'家庭年收入'"]
["IncomeSource","'收入来源'"]
["SIStatus","'社保情况'"]
["NOVPolicy","'有效保单件数'"]
["NOIVPolicy","'失效保单件数'"]
["PRIMARY"]
["CREATED_BY","'创建人'"]
["CREATED_TIME","'创建时间'"]
["UPDATED_BY","'更新人'"]
["UPDATED_TIME","'更新时间'"]
[" Label1","与上游一致","无,Individual.Education"]
[" Label2","与上游一致","Individual.Occupation"]
[" Label3","60后、70后等","Individual.Birthday，已有出生日期字段再显示这个标签的意义何在？"]
[" Label4","0-10，11-20，21-30等","Individual.Birthday，已有出生日期字段再显示这个标签的意义何在？"]
[" Label5","省、直辖市：江苏、北京、上海等","只有收件地址且无记录，已有地址字段再显示这个标签的意义何在？"]
[" Label6","市：苏州市、南京市等","只有收件地址且无记录，已有地址字段再显示这个标签的意义何在？"]
[" Label7","省、直辖市：江苏、北京、上海等","无,需要提供查询服务"]
[" Label8","省、直辖市：江苏、北京、上海等","无"]
[" Label9","已婚，未婚","无，Individual.MaritalStat"]
[" Label10","无子女，1个，2个以上","可从IndRelationShip获取"]
[" Label11","近5年有治疗，近5年无治疗","无"]
[" Label12","饮酒、不饮酒","无，Individual.Drinking"]
[" Label13","吸烟，不吸烟","无，Individual.Smoking"]
[" Label14","有先天性疾病，无先天性疾病","无，Individual.Cdiseases"]
[" Label15","患过重大疾病，未患过重大疾病","无，Individual.FMHistory"]
[" Label16","家族有遗传病史，家族无遗传病史","无，Individual.FMHistory"]
[" Label17","正在怀孕，未正在怀孕","无，Individual.Pregnancy"]
[" Label18","有早产、过期产、难产情况，无早产、过期产、难产情况","无"]
[" Label19","新生婴儿有先天疾病，新生婴儿无先天疾病","无"]
[" Label20","进行危险性运动，未进行危险性运动","无"]
[" Label21","10万以下，10-20万，20-30万，30万以上","无,Individual.Pincome，已有年收入字段再显示这个标签的意义何在？"]
[" Label22","无车，1辆车，2辆车以上","无，Individual.COVehicle"]
[" Label23","无房，1套房，2套房以上","无，Individual.CORP"]
[" Label24","持有寿险有效保单，未持有寿险有效保单","可从InsuranceArrangement获取"]
[" Label25","无保单，1件保单，2件保单以上","可从InsuranceArrangement获取"]
[" Label26","有贷款，无贷款","AUDIT_LN_LIST，InsuranceArrangement.LoanMoney"]
[" Label27","有极短意保单，无极短意保单","哪些险种属于极短意险，NOSTInsurance"]
[" Label28","有极短险保单，无极短险保单","哪些险种属于极短险保单，NOSTInsurance"]
[" Label29","有趸交保单，无趸交保单","NOSPInsurance，POLICY_INFORMATION.PAYINTV='趸缴',PREMIUM_LIST.PAYMENT_PERIOD='一次交清'"]
[" Label30","仅本人投保，本人已投保，本人未投保","Iself"]
[" Label31","仅父母投保，父母已投保，父母未投保","Iparent"]
[" Label32","仅子女投保，子女已投保，子女未·投保","Ichildren"]
[" Label33","仅配偶投保，配偶已投保，配偶未投保","Imate"]
[" Label34","建议字段显示具体金额，不用标签","上游可获得的类型：detail_list2.RISKTYPE:寿险，健康险 ，意外险 ;detail_list2.RISK_DESIGN_TYPE:万能,传统险,分红"]
[" Label35","建议字段显示具体金额，不用标签","无"]
[" Label36","建议字段显示具体金额，不用标签","无"]
[" Label37","建议字段显示具体金额，不用标签","无"]
[" Label38","建议字段显示具体金额，不用标签","无"]
[" Label39","建议字段显示具体金额，不用标签","无"]
[" Label40","建议字段显示具体金额，不用标签","无"]
[" Label41","建议字段显示具体金额，不用标签","无"]
[" Label42","建议字段显示具体金额，不用标签"]
[" Label43","仅有1年期短险保单，有1年期短险保单"]
[" Label44","有失效保单，无失效保单","NOIVPolicy"]
[" Label45","有缴费期满长险保单，无缴费期满长险保单","POLICY_INFORMATION:paycount= payendyear AND riskperiod='长期险'"]
[" Label46","有续期缴费的保单，无续期缴费的保单"]
[" Label47","有责任期满的保单,无责任期满的保单"]
[" Label48","建议字段显示具体内容，不用标签","FADate"]
[" Label49","建议字段显示具体内容，不用标签","LAPPDate"]
[" Label50","建议字段显示具体内容，不用标签","LPChannel，InsuranceArrangement.AgentChannel"]
[" Label51","建议字段显示具体内容，不用标签","LPOrg,InsuranceArrangement.AgentOrg"]
[" Label52","建议字段显示具体内容，不用标签","FAChannel"]
[" Label53","建议字段显示具体内容，不用标签","FAOrg"]
[" Label54","建议字段显示具体内容，不用标签","LPState"]
[" Label55","建议字段显示具体内容，不用标签","LPOSType"]
[" Label56","有退保保单，无退保保单","如何判断？"]
[" Label57","建议字段显示具体内容，不用标签","无"]
[" Label58","建议字段显示具体内容，不用标签","无"]
[" Label59","建议字段显示具体内容，不用标签","InsuranceClaimThread.ClaimCaseStatus"]
[" Label60",null,"无"]
[" Label61",null,"如何判断？"]
[" Label62",null,"无"]
[" Label63",null,"无"]
[" Label64",null,"无"]
[" Label65","一单寿险客户，非一单寿险客户"]
[" Label66","缴费期满客户，非缴费期满客户","POLICY_INFORMATION:paycount= payendyear"]
[" Label67","生日与司庆日同天，生日不与司庆日同天"]
[" Label68","持有有效保单，未持有有效保单"]
[" Label69",null,"Individual.CustClass"]
[" Label70",null,"Individual.LCType"]
[" Label71",null,"Individual.LCMethod"]
[" Label72",null,"PartyTimeLine.Scenario"]
[" Label73",null,"无"]
[" Label74",null,"无"]
[" Label75",null,"无"]
[" Label76",null,"无"]
[" Label77","本人生日临近"]
[" Label78","父母生日临近"]
[" Label79","子女生日临近"]
[" Label80","有咨询产品，未咨询产品","无"]
[" Label81","有咨询理赔，未咨询理赔","无"]
[" Label82","有浏览产品，未浏览产品","无"]
[" Label83","有浏览文章，未浏览文章","无"]
[" Label84","有进行线上微服务，未进行线上微服务","无"]
[" Label85","有参与线上活动，未参与线上活动","无"]
[" Label86","有参与线下活动，未参与线下活动","无"]
[" Label87",null,"无"]
[" Label88","临期缴费","判断逻辑不详"]
[" Label89","到期缴费","判断逻辑不详"]
[" Label90","续期中止，正常续期","判断逻辑不详"]
[" Label91","失效客户，有效客户","判断逻辑不详"]
[" Label92",null,"判断逻辑不详"]
[" Label93",null,"判断逻辑不详"]
[" Label94",null,"判断逻辑不详"]
[" Label95",null,"判断逻辑不详"]
[" Label96","大龄"]
[" Label97","高龄"]
[" Label98","敏感职业"]
[" Label99","公司内部人员","无"]
[" Label100","公司销售人员","无"]
[" Label101","长通话","判断逻辑不详"]
[" Label102","方言","判断逻辑不详"]
[" Label103","要求较多","判断逻辑不详"]
[" Label104","易投诉升级","判断逻辑不详"]
[" Label105","高频投诉","判断逻辑不详"]
[" Label106","重大投诉影响","判断逻辑不详"]
[" Label107","高金额"]
[" Label108","最近理赔结案"]
[" Label109","理赔报案追踪"]
[" Label110","理赔处理中"]
[" Label111","最近保全完成","判断逻辑不详"]
[" Label112","保全处理中"]
[" Label113","生存金未领","判断逻辑不详"]
[" Label114","转账失败","判断逻辑不详"]
[" Label115","红利垫缴还款","判断逻辑不详"]
[" Label116","保单贷款到期","判断逻辑不详"]
[" Label117","宽限期","判断逻辑不详"]
[" Label118","续期扣费在途","判断逻辑不详"]
[" Label119","稳定交费","判断逻辑不详"]
[" Label120","重点银行","判断逻辑不详"]

{"sheet":"IndRelationShip","index":3,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[0,0,0,1],[0,2,0,3]],"flags":["formulas_cached_only"]}
["目的表IndRelationShip",null,"来源"]
["IRSID","'个体关系ID'"]
["RSType","关系类型 其他、配偶、祖父母、外祖父母、祖孙、外祖孙、本人、父母、子女'","POLICY_INFORMATION"]
["IndID1","'个体1'","individual","indid"]
["Name1","'个体1名称'","POLICY_INFORMATION"]
["Mphone1","'个体1手机'","POLICY_INFORMATION"]
["IDCard1","'个体1证件号码'","POLICY_INFORMATION"]
["Role1","个体1角色 父亲、母亲、儿子、女儿、妻子、丈夫'"]
["IndID2","'个体2'","individual","indid"]
["Name2","'个体2名称'","POLICY_INFORMATION"]
["Mphone2","'个体2手机'","POLICY_INFORMATION"]
["IDCard2","'个体2证件号码'","POLICY_INFORMATION"]
["Role2","个体2角色 父亲、母亲、儿子、女儿、妻子、丈夫'","POLICY_INFORMATION"]
["RSSTime","'开始时间'","POLICY_INFORMATION"]
["RSETime","'结束时间'"]
["RSDescribe","'关系描述'"]
["CREATED_BY","'创建人'"]
["CREATED_TIME","'创建时间'"]
["UPDATED_BY","'更新人'"]
["UPDATED_TIME","'更新时间'"]

{"sheet":"PartyTimeLine","index":4,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,0,1,1],[0,2,0,8],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9]],"flags":["formulas_cached_only"]}
["目的表PartyTimeLine参与方事件",null,"来源"]
[null,null,"保全audit_edorlist",null,"edorinfo",null,"理赔insuranceclaimthread",null,"保单InsuranceArrangement"]
["TripID","旅程ID"]
["PartyID","参与方ID","audit_edorlist","根据contno(保单号)字段去查找","edorinfo","根据contno(保单号)字段去查找","insuranceclaimthread","applicantid","InsuranceArrangement","ApplicantID "]
["Name","参与方名称","audit_edorlist","appntname","edorinfo","根据contno(保单号)字段去查找","insuranceclaimthread","appname","InsuranceArrangement","AppName "]
["PCertID","参与方证件号码","audit_edorlist","根据contno(保单号)字段去查找","edorinfo","lcidno","insuranceclaimthread","appcertid","InsuranceArrangement","AppPhone"]
["PPhone","参与方手机","audit_edorlist","根据contno(保单号)字段去查找","edorinfo","根据contno(保单号)字段去查找","insuranceclaimthread","appphone","InsuranceArrangement","AppCertID "]
["PRole","参与方角色 投保人、被保人、受益人",null,"投保人",{"$nulls":3},"投保人",null,"投保人"]
["Scenario","场景 投保 保全 报案 咨询 投诉 其他",null,"保全",{"$nulls":3},"报案",null,"投保"]
["SDate","发生日期","audit_edorlist","cusappdate 客户申请日期","edorinfo","EDORAPPDATE","insuranceclaimthread","crdate（立案日期）","InsuranceArrangement","PADate （投保日期）"]
["ThreadID","关联ID 可关联至更详细信息，如保单ID、报案ID等","audit_edorlist","edoracceptno 保全受理号","edorinfo",null,"insuranceclaimthread","icthreadid（理赔id）","InsuranceArrangement","PANo （投保单）"]
["ParentID","父ID 如报案对应的保单ID","audit_edorlist","contno","edorinfo","contno","insuranceclaimthread","policyno（保单）","InsuranceArrangement","PolicyNo （保险）"]
["Describe","描述"]
["Channel","来源"]
["EndDate","完成日期","audit_edorlist","edorvalidate 保全生效日期","edorinfo","EDORCVALIDATE","insuranceclaimthread","csdate理赔状态日期","InsuranceArrangement","PMDate （终保日期）"]
["CREATED_BY","'创建人'"]
["CREATED_TIME","'创建时间'"]
["UPDATED_BY","'更新人'"]
["UPDATED_TIME","'更新时间'"]