一、基本概念

指标：指标指业务中需要关注的目标值，比如客户的年龄、性别、年收入等。

模型：模型是一系列指标的组合，对指标值进行进一步计算得出想要的结果。

执行模型：执行模型时会先获取模型关联的所有指标的配置信息。遍历指标配置，根据配置获取并计算指标值，之后再根据模型与指标的关联配置对指标值进行自定义的计算得出想要的结果。所有指标值和指标结果都会添加进模型执行的参数params中，key为指标编号，value为指标值或指标结果。指标结果会覆盖指标值。所以在后执行的指标执行过程中可以获取到之前所有的指标结果。

二、环境部署

1、数据库增加对应的表

第四章 模型引擎集成与配置 - 图1

PS:建表语句详见附件

  1. --模型指标组信息表
  2. CREATE TABLE TB_PUB_BM_CONF_GROUPS  ( 
  3.     GROUP_CODE             VARCHAR2(10 BYTE) NULL,
  4.     GROUP_NAME             VARCHAR2(50 BYTE) NULL,
  5.     GROUP_VALUE            NUMBER(20,2) NULL,
  6.     GROUP_WEIGHTS          NUMBER(20,2) NULL,
  7.     MODEL_ID               VARCHAR2(32 BYTE) NULL,
  8.     CREATE_USER_ACCOUNT    VARCHAR2(32 BYTE) NULL,
  9.     CREATE_USER_NAME       VARCHAR2(100 BYTE) NULL,
  10.     CREATE_TIME            VARCHAR2(50 BYTE) NULL,
  11.     UPDATE_TIME            VARCHAR2(50 BYTE) NULL,
  12.     TRUNC_NO               NUMBER NULL,
  13.     DEL_FLAG               VARCHAR2(1 BYTE) NULL,
  14.     DATA_CHAN              VARCHAR2(3 BYTE) NULL,
  15.     BANK_CODE              VARCHAR2(16 BYTE) NULL,
  16.     UUID                   VARCHAR2(32 BYTE) NOT NULL,
  17.     CONSTRAINT PK_TB_PUB_BM_CONF_GROUPS PRIMARY KEY(UUID)
  18. );
  19. COMMENT ON TABLE TB_PUB_BM_CONF_GROUPS IS '模型指标组信息表';
  20. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.GROUP_CODE IS '指标组代码';
  21. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.GROUP_NAME IS '指标组名称';
  22. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.GROUP_VALUE IS '指标组分值';
  23. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.GROUP_WEIGHTS IS '指标组权重';
  24. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.MODEL_ID IS '模型id';
  25. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.CREATE_USER_ACCOUNT IS '创建人工号';
  26. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.CREATE_USER_NAME IS '创建人姓名';
  27. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.CREATE_TIME IS '创建时间';
  28. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.UPDATE_TIME IS '更新时间';
  29. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.TRUNC_NO IS '版本号';
  30. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.DEL_FLAG IS '删除标识';
  31. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.DATA_CHAN IS '数据源';
  32. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.BANK_CODE IS '法人号';
  33. COMMENT ON COLUMN TB_PUB_BM_CONF_GROUPS.UUID IS 'uuid';
  35. --模型配置表
  36. CREATE TABLE TB_PUB_BM_CONF_MODEL  ( 
  37.     MODEL_CODE             VARCHAR2(60 BYTE) NULL,
  38.     MODEL_NAME             VARCHAR2(100 BYTE) NULL,
  39.     MODEL_TYPE             VARCHAR2(10 BYTE) NULL,
  40.     CUS_KIND               VARCHAR2(1 BYTE) NULL,
  41.     BL_CUS_TYPE            VARCHAR2(10 BYTE) NULL,
  42.     ENABLE_FLAG            VARCHAR2(2 BYTE) NULL,
  43.     MODEL_CAL_TYPE         VARCHAR2(1 BYTE) NULL,
  44.     MODEL_FORMULA          VARCHAR2(300 BYTE) NULL,
  45.     BMVERSION              VARCHAR2(5 BYTE) NULL,
  46.     EFFECTIVE_TIME         TIMESTAMP(6) NULL,
  47.     FAILURE_TIME           TIMESTAMP(6) NULL,
  48.     CREATE_USER_ACCOUNT    VARCHAR2(32 BYTE) NULL,
  49.     CREATE_USER_NAME       VARCHAR2(100 BYTE) NULL,
  50.     CREATE_TIME            VARCHAR2(50 BYTE) NULL,
  51.     UPDATE_TIME            VARCHAR2(50 BYTE) NULL,
  52.     TRUNC_NO               NUMBER NULL,
  53.     DEL_FLAG               VARCHAR2(1 BYTE) NULL,
  54.     DATA_CHAN              VARCHAR2(3 BYTE) NULL,
  55.     BANK_CODE              VARCHAR2(16 BYTE) NULL,
  56.     UUID                   VARCHAR2(32 BYTE) NOT NULL,
  57.     CONSTRAINT PK_TB_PUB_BM_CONF_MODEL PRIMARY KEY(UUID)
  58. );
  59. COMMENT ON TABLE TB_PUB_BM_CONF_MODEL IS '模型配置表';
  60. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.MODEL_CODE IS '模型代码';
  61. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.MODEL_NAME IS '模型名称';
  62. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.MODEL_TYPE IS '模型类型';
  63. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.CUS_KIND IS '公私标志';
  64. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.BL_CUS_TYPE IS '所属客户类型';
  65. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.ENABLE_FLAG IS '生效标志';
  66. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.MODEL_CAL_TYPE IS '模型计算类型';
  67. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.MODEL_FORMULA IS '模型计算公式';
  68. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.BMVERSION IS '模型版本号';
  69. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.EFFECTIVE_TIME IS '模型生效时间';
  70. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.FAILURE_TIME IS '模型失效时间';
  71. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.CREATE_USER_ACCOUNT IS '创建柜员编号';
  72. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.CREATE_USER_NAME IS '创建柜员姓名';
  73. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.CREATE_TIME IS '创建日期';
  74. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.UPDATE_TIME IS '更新日期';
  75. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.TRUNC_NO IS '版本号（乐观锁）';
  76. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.DEL_FLAG IS '删除标志，0：否，1：是';
  77. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.DATA_CHAN IS '数据源';
  78. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.BANK_CODE IS '银行编号';
  79. COMMENT ON COLUMN TB_PUB_BM_CONF_MODEL.UUID IS 'UUID';
  80. CREATE UNIQUE INDEX INX_MODEL_MODEL_CODE
  81.     ON TB_PUB_BM_CONF_MODEL(MODEL_CODE);
  83. --模型指标规则配置表
  84. CREATE TABLE TB_PUB_BM_CONF_RELATION  ( 
  85.     MODEL_ID                VARCHAR2(32 BYTE) NULL,
  86.     GROUP_ID                VARCHAR2(32 BYTE) NULL,
  87.     INDEX_ID                VARCHAR2(32 BYTE) NULL,
  88.     PARENT_ID               VARCHAR2(32 BYTE) NULL,
  89.     INDEX_EXEC_TYPE         VARCHAR2(1 BYTE) NULL,
  90.     INDEX_VARIABLE          VARCHAR2(1000 BYTE) NULL,
  91.     INDEX_STANDARD_VALUE    NUMBER NULL,
  92.     INDEX_STANDARD_SCORE    NUMBER NULL,
  93.     IS_RESULT               VARCHAR2(1 BYTE) NULL,
  94.     MODEL_TAG               VARCHAR2(200 BYTE) NULL,
  95.     RAL_ORDER               NUMBER NULL,
  96.     RULE_ID                 VARCHAR2(32 BYTE) NULL,
  97.     RULE_PARAMS             VARCHAR2(2000 BYTE) NULL,
  98.     VALID_DAYS              NUMBER NULL,
  99.     HIDDEN_FLAG             VARCHAR2(1 BYTE) NULL,
  100.     ENABLE_FLAG             VARCHAR2(1 BYTE) NULL,
  101.     TRANSITION              VARCHAR2(1 BYTE) NULL,
  102.     DESC_MESSAGE            VARCHAR2(1000 BYTE) NULL,
  103.     EXEC_FREQUENCY          VARCHAR2(10 BYTE) NULL,
  104.     EXEC_WAY                VARCHAR2(1 BYTE) NULL,
  105.     INDEX_WEIGHTS           NUMBER(20,2) NULL,
  106.     CREATE_USER_ACCOUNT     VARCHAR2(32 BYTE) NULL,
  107.     CREATE_USER_NAME        VARCHAR2(100 BYTE) NULL,
  108.     CREATE_TIME             VARCHAR2(50 BYTE) NULL,
  109.     UPDATE_TIME             VARCHAR2(50 BYTE) NULL,
  110.     TRUNC_NO                NUMBER NULL,
  111.     DEL_FLAG                VARCHAR2(1 BYTE) NULL,
  112.     DATA_CHAN               VARCHAR2(3 BYTE) NULL,
  113.     BANK_CODE               VARCHAR2(16 BYTE) NULL,
  114.     UUID                    VARCHAR2(32 BYTE) NOT NULL,
  115.     CONSTRAINT PK_TB_PUB_BM_CONF_RELATION PRIMARY KEY(UUID)
  116. );
  117. COMMENT ON TABLE TB_PUB_BM_CONF_RELATION IS '模型指标规则配置表';
  118. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.MODEL_ID IS '模型ID';
  119. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.GROUP_ID IS '指标组ID';
  120. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.INDEX_ID IS '指标ID';
  121. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.PARENT_ID IS '父节点';
  122. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.INDEX_EXEC_TYPE IS '指标结果计算类型';
  123. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.INDEX_VARIABLE IS '指标变量';
  124. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.INDEX_STANDARD_VALUE IS '指标标准值';
  125. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.INDEX_STANDARD_SCORE IS '指标标准分';
  126. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.IS_RESULT IS '执行结果是否返回';
  127. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.MODEL_TAG IS '评级模版标签';
  128. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.RAL_ORDER IS '关系顺序';
  129. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.RULE_ID IS '规则ID';
  130. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.RULE_PARAMS IS '执行参数';
  131. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.VALID_DAYS IS '数据有效期（天）';
  132. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.HIDDEN_FLAG IS '是否隐藏';
  133. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.ENABLE_FLAG IS '是否启用';
  134. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.TRANSITION IS '是否过渡';
  135. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.DESC_MESSAGE IS '提示信息';
  136. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.EXEC_FREQUENCY IS '指标执行频率';
  137. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.EXEC_WAY IS '指标执行方式';
  138. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.INDEX_WEIGHTS IS '指标权重';
  139. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.CREATE_USER_ACCOUNT IS '创建柜员编号';
  140. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.CREATE_USER_NAME IS '创建柜员姓名';
  141. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.CREATE_TIME IS '创建日期';
  142. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.UPDATE_TIME IS '更新日期';
  143. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.TRUNC_NO IS '版本号（乐观锁）';
  144. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.DEL_FLAG IS '删除标志，0：否，1：是';
  145. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.DATA_CHAN IS '数据源';
  146. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.BANK_CODE IS '银行编号';
  147. COMMENT ON COLUMN TB_PUB_BM_CONF_RELATION.UUID IS 'UUID';
  148. CREATE INDEX IDX_TB_PUB_BM_CONF_RELATION
  149.     ON TB_PUB_BM_CONF_RELATION(INDEX_ID);
  150. CREATE INDEX INX_CONF_RELATION_MODEL_ID
  151.     ON TB_PUB_BM_CONF_RELATION(MODEL_ID);
  153. --规则配置表
  154. CREATE TABLE TB_PUB_BM_CONF_RULE  ( 
  155.     RULE_CODE              VARCHAR2(60 BYTE) NULL,
  156.     RULE_NAME              VARCHAR2(100 BYTE) NULL,
  157.     RULE_FORMULA           VARCHAR2(2000 BYTE) NULL,
  158.     RULE_TYPE              VARCHAR2(300 BYTE) NULL,
  159.     RULE_VALUE             VARCHAR2(32 BYTE) NULL,
  160.     RULE_PRIORITY          VARCHAR2(1 BYTE) NULL,
  161.     RULE_TEMPLATE          VARCHAR2(2000 BYTE) NULL,
  162.     INDEX_ID               VARCHAR2(32 BYTE) NULL,
  163.     CREATE_USER_ACCOUNT    VARCHAR2(32 BYTE) NULL,
  164.     CREATE_USER_NAME       VARCHAR2(100 BYTE) NULL,
  165.     CREATE_TIME            VARCHAR2(50 BYTE) NULL,
  166.     UPDATE_TIME            VARCHAR2(50 BYTE) NULL,
  167.     TRUNC_NO               NUMBER NULL,
  168.     DEL_FLAG               VARCHAR2(1 BYTE) NULL,
  169.     DATA_CHAN              VARCHAR2(3 BYTE) NULL,
  170.     BANK_CODE              VARCHAR2(16 BYTE) NULL,
  171.     UUID                   VARCHAR2(32 BYTE) NOT NULL,
  172.     CONSTRAINT PK_TB_PUB_BM_CONF_RULE PRIMARY KEY(UUID)
  173. );
  174. COMMENT ON TABLE TB_PUB_BM_CONF_RULE IS '规则配置表';
  175. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.RULE_CODE IS '规则代码';
  176. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.RULE_NAME IS '规则名称';
  177. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.RULE_FORMULA IS '规则公式';
  178. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.RULE_TYPE IS '规则类型';
  179. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.RULE_VALUE IS '规则值';
  180. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.RULE_PRIORITY IS '规则优先级';
  181. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.RULE_TEMPLATE IS '规则模板描述';
  182. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.INDEX_ID IS '指标ID';
  183. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.CREATE_USER_ACCOUNT IS '创建柜员编号';
  184. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.CREATE_USER_NAME IS '创建柜员姓名';
  185. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.CREATE_TIME IS '创建日期';
  186. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.UPDATE_TIME IS '更新日期';
  187. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.TRUNC_NO IS '版本号（乐观锁）';
  188. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.DEL_FLAG IS '删除标志，0：否，1：是';
  189. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.DATA_CHAN IS '数据源';
  190. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.BANK_CODE IS '银行编号';
  191. COMMENT ON COLUMN TB_PUB_BM_CONF_RULE.UUID IS 'UUID';
  192. CREATE INDEX INX_CONF_RULE_RULE_CODE
  193.     ON TB_PUB_BM_CONF_RULE(RULE_CODE);
  195. --模型指标结果存储表
  196. CREATE TABLE TB_PUB_BM_INDEX_STORE  ( 
  197.     MODEL_STORE_ID         VARCHAR2(32 BYTE) NULL,
  198.     INDEX_CODE             VARCHAR2(100 BYTE) NULL,
  199.     INDEX_EXEC_PARAM       VARCHAR2(500 BYTE) NULL,
  200.     INDEX_MODEL_VALUE      VARCHAR2(100 BYTE) NULL,
  201.     INDEX_VALUE            VARCHAR2(1000 BYTE) NULL,
  202.     REL_ID                 VARCHAR2(32 BYTE) NULL,
  203.     EXEC_OR                NUMBER NULL,
  204.     CREATE_USER_ACCOUNT    VARCHAR2(32 BYTE) NULL,
  205.     CREATE_USER_NAME       VARCHAR2(100 BYTE) NULL,
  206.     CREATE_TIME            VARCHAR2(50 BYTE) NULL,
  207.     UPDATE_TIME            VARCHAR2(50 BYTE) NULL,
  208.     TRUNC_NO               NUMBER NULL,
  209.     DEL_FLAG               VARCHAR2(1 BYTE) NULL,
  210.     DATA_CHAN              VARCHAR2(3 BYTE) NULL,
  211.     BANK_CODE              VARCHAR2(16 BYTE) NULL,
  212.     UUID                   VARCHAR2(32 BYTE) NOT NULL,
  213.     FINANCIAL_INFO_ID      VARCHAR2(150 BYTE) NULL,
  214.     CONSTRAINT PK_TB_PUB_BM_INDEX_STORE PRIMARY KEY(UUID)
  215. );
  216. COMMENT ON TABLE TB_PUB_BM_INDEX_STORE IS '模型指标结果存储';
  217. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.MODEL_STORE_ID IS '模型结果ID';
  218. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.INDEX_CODE IS '指标代码';
  219. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.INDEX_EXEC_PARAM IS '指标过程参数';
  220. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.INDEX_MODEL_VALUE IS '指标得分';
  221. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.INDEX_VALUE IS '指标值';
  222. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.REL_ID IS '关系ID';
  223. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.EXEC_OR IS '执行顺序';
  224. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.CREATE_USER_ACCOUNT IS '创建柜员编号';
  225. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.CREATE_USER_NAME IS '创建柜员姓名';
  226. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.CREATE_TIME IS '创建日期';
  227. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.UPDATE_TIME IS '更新日期';
  228. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.TRUNC_NO IS '版本号（乐观锁）';
  229. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.DEL_FLAG IS '删除标志，0：否，1：是';
  230. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.DATA_CHAN IS '数据源';
  231. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.BANK_CODE IS '银行编号';
  232. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.UUID IS 'UUID';
  233. COMMENT ON COLUMN TB_PUB_BM_INDEX_STORE.FINANCIAL_INFO_ID IS '财务报表ID';
  234. CREATE INDEX INX_RAT_BM_INDEX_STORE_MODEL_STORE_ID
  235.     ON TB_PUB_BM_INDEX_STORE(MODEL_STORE_ID);
  237. --模型结果存储表
  238. CREATE TABLE TB_PUB_BM_MODEL_STORE  ( 
  239.     APP_ID          VARCHAR2(32 BYTE) NULL,
  240.     BMVERSION       VARCHAR2(5 BYTE) NULL,
  241.     MODEL_DATE      CHAR(8 BYTE) NULL,
  242.     MODEL_DIC_NO    VARCHAR2(32 BYTE) NULL,
  243.     MODEL_LEVEL     VARCHAR2(32 BYTE) NULL,
  244.     MODEL_NAME      VARCHAR2(200 BYTE) NULL,
  245.     MODEL_SCORE     VARCHAR2(500 BYTE) NULL,
  246.     CREATE_TIME     VARCHAR2(50 BYTE) NULL,
  247.     UPDATE_TIME     VARCHAR2(50 BYTE) NULL,
  248.     TRUNC_NO        NUMBER NULL,
  249.     DEL_FLAG        VARCHAR2(1 BYTE) NULL,
  250.     DATA_CHAN       VARCHAR2(3 BYTE) NULL,
  251.     BANK_CODE       VARCHAR2(16 BYTE) NULL,
  252.     UUID            VARCHAR2(32 BYTE) NOT NULL,
  253.     CONSTRAINT PK_TB_PUB_BM_MODEL_STORE PRIMARY KEY(UUID)
  254. );
  255. COMMENT ON TABLE TB_PUB_BM_MODEL_STORE IS '模型结果存储';
  256. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.APP_ID IS '业务ID';
  257. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.BMVERSION IS '模型版本号';
  258. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.MODEL_DATE IS '模型制定日期';
  259. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.MODEL_DIC_NO IS '模型字典';
  260. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.MODEL_LEVEL IS '模型等级';
  261. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.MODEL_NAME IS '模型名称';
  262. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.MODEL_SCORE IS '模型得分';
  263. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.CREATE_TIME IS '创建日期';
  264. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.UPDATE_TIME IS '更新日期';
  265. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.TRUNC_NO IS '版本号（乐观锁）';
  266. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.DEL_FLAG IS '删除标志，0：否，1：是';
  267. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.DATA_CHAN IS '数据源';
  268. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.BANK_CODE IS '银行编号';
  269. COMMENT ON COLUMN TB_PUB_BM_MODEL_STORE.UUID IS 'UUID';
  270. CREATE INDEX INX_RAT_BM_MODEL_STORE_APP_ID
  271.     ON TB_PUB_BM_MODEL_STORE(APP_ID);
  273. --规则表数据
  274. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  275.   VALUES('R0050', '前置条件(字符不相同,小于等于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-10-02 16:21:24', '2018-10-02 16:23:21', 1, NULL, NULL, NULL, '3fca27344e689cd13fe0f5e1ebc3d788');
  276. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  277.   VALUES('R0051', '前置条件(字符不相同,大于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}大于等于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-10-02 16:21:24', '2018-10-02 16:23:21', 1, NULL, NULL, NULL, '3fe2e565cacb95973fe1dde3bbc7778f');
  278. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  279.   VALUES('R0052', '前置条件(字符不相同,大于等于且小于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}大于等于{startValue}并且小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:24', '2018-10-02 16:23:21', 1, NULL, NULL, NULL, '3fd43aa87550eaa23fee3a3c7478e8f2');
  280. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  281.   VALUES('R0053', '前置条件(字符不相同,小于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}小于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fc80d301a6034c03fef0abe157c2af8');
  282. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  283.   VALUES('R0054', '前置条件(字符不相同,大于)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}大于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fecfcf9f9f3f3e83fe544ea89d513aa');
  284. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  285.   VALUES('R0055', '前置条件(字符不相同,等于)', 'checkedBefor,targetBefor,checkedValue,targetValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}为{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fcf1e3e3c7c78f93f79e033c06780cf');
  286. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  287.   VALUES('R0056', '前置条件(字符不相同,字符相同)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}为{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fd57b2af655ecac3fcbd837b06f60df');
  288. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  289.   VALUES('R0057', '前置条件(字符不相同,字符不相同)', 'checkedBefor,targetBefor,checkedValue,targetValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}不为{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fee937d26fa4df53fd6b32d665accb6');
  290. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  291.   VALUES('R0078', '前置条件(大于等于且小于等于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}大于等于{targetBefor}时，如果{checkedValue}小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791BB5B0EE053AE8D050AD265');
  292. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  293.   VALUES('R0077', '前置条件(大于等于且大于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}大于等于{targetBefor}时，如果{checkedValue}大于等于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791BA5B0EE053AE8D050AD265');
  294. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  295.   VALUES('R0076', '前置条件(小于且小于等于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}小于{targetBefor}时，如果{checkedValue}小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791B95B0EE053AE8D050AD265');
  296. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  297.   VALUES('R0075', '前置条件(小于且大于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}小于{targetBefor}时，如果{checkedValue}大于等于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791B85B0EE053AE8D050AD265');
  298. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  299.   VALUES('R0074', '前置条件(小于且小于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}小于{targetBefor}时，如果{checkedValue}小于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791B75B0EE053AE8D050AD265');
  300. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  301.   VALUES('R0073', '前置条件(大于且小于等于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}大于{targetBefor}时，如果{checkedValue}小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791B65B0EE053AE8D050AD265');
  302. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  303.   VALUES('R0072', '前置条件(大于且大于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}大于{targetBefor}时，如果{checkedValue}大于等于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791B55B0EE053AE8D050AD265');
  304. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  305.   VALUES('R0071', '前置条件(大于且小于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}大于{targetBefor}时，如果{checkedValue}小于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791B45B0EE053AE8D050AD265');
  306. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  307.   VALUES('R0070', '前置条件(大于且大于)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}大于{targetBefor}时，如果{checkedValue}大于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791B35B0EE053AE8D050AD265');
  308. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  309.   VALUES('R0079', '前置条件(小于等于且小于等于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}小于等于{targetBefor}时，如果{checkedValue}小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-26 15:41:07', '2018-09-26 15:41:07', 1, NULL, NULL, NULL, '936C1D5791BC5B0EE053AE8D050AD265');
  310. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  311.   VALUES('R0065', '前置条件(字符不相同,小于且大于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}小于{startValue}并且大于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '938904D52168646CE053AE8D050A8BD4');
  312. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  313.   VALUES('R0064', '前置条件(字符不相同,大于且小于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}大于{startValue}并且小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '938904D52167646CE053AE8D050A8BD4');
  314. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  315.   VALUES('R0063', '前置条件(字符不相同,大于且小于)', 'checkedBefor,targetBefor,checkedValue,startValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}不等于{targetBefor}时，如果{checkedValue}大于{startValue}并且小于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '938904D52166646CE053AE8D050A8BD4');
  316. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  317.   VALUES('R0062', '前置条件(字符相同,小于且大于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}小于{startValue}并且大于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '938904D52165646CE053AE8D050A8BD4');
  318. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  319.   VALUES('R0061', '前置条件(字符相同,大于且小于等于', 'checkedBefor,targetBefor,checkedValue,startValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}大于{startValue}并且小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '938904D52164646CE053AE8D050A8BD4');
  320. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  321.   VALUES('R0060', '前置条件(字符相同,大于且小于)', 'checkedBefor,targetBefor,checkedValue,startValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}大于{startValue}并且小于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '938904D52163646CE053AE8D050A8BD');
  322. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  323.   VALUES('R0021', '数字在范围内(a,b)', 'checkedValue,startValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}大于{startValue}并且小于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53481');
  324. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  325.   VALUES('R0022', '数字在范围内[a,b]', 'checkedValue,startValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}大于等于{startValue}并且小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53482');
  326. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  327.   VALUES('R0023', '数字在范围内[a,b)', 'checkedValue,startValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}大于等于{startValue}并且小于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53483');
  328. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  329.   VALUES('R0026', '是否不为空(含NULL)', 'checkedValue,value', 'rule', '1', '1', '如果{checkedValue}不为空，那么，结果是{flag}', NULL, '1', 'admin', '2018-10-12 23:06:09', '2018-10-12 23:06:24', 1, NULL, NULL, NULL, '3fc8f931f263e4c83fc2e925d24ba497');
  330. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  331.   VALUES('R0031', '小于等于或大于等于', 'checkedValue,startValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}小于等于{startValue}或者大于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-20 11:13:03', '2018-09-25 22:15:51', 1, NULL, NULL, NULL, '3fc60f2c1e583cb03fa5482a905520aa');
  332. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  333.   VALUES('R0032', '小于等于或大于', 'checkedValue,startValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}小于等于{startValue}或者大于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-20 11:13:03', '2018-09-25 22:15:51', 1, NULL, NULL, NULL, '3fd09ca1394272853fe8eaf1d5e3abc7');
  334. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  335.   VALUES('R0033', '小于或大于等于', 'checkedValue,startValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}小于{startValue}或者大于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-20 11:13:03', '2018-09-25 22:15:51', 1, NULL, NULL, NULL, '3fdaa235446a88d53fce923d247a48f5');
  336. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  337.   VALUES('R0034', '小于或大于', 'checkedValue,startValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}小于{startValue}或者大于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-20 11:13:03', '2018-09-25 22:15:51', 1, NULL, NULL, NULL, '3fd5d62bac5758af3fdbb6b76d6edade');
  338. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  339.   VALUES('R0040', '前置条件(字符相同,小于等于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-10-02 16:21:24', '2018-10-02 16:23:21', 1, NULL, NULL, NULL, '3fef88ff11fe23fc3fc9a9335266a4cd');
  340. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  341.   VALUES('R0041', '前置条件(字符相同,大于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}大于等于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-10-02 16:21:24', '2018-10-02 16:23:21', 1, NULL, NULL, NULL, '3fd958b2b16562cb3fe445688ad115a2');
  342. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  343.   VALUES('R0042', '前置条件(字符相同,大于等于且小于等于)', 'checkedBefor,targetBefor,checkedValue,startValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}大于等于{startValue}并且小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-10-02 16:21:24', '2018-10-02 16:23:21', 1, NULL, NULL, NULL, '3fc6dd2dba5b74b73fe7f3efe7dfcfc0');
  344. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  345.   VALUES('R0001', '字符串是否相等', 'checkedValue,targetValue,value', 'rule', '1', '1', '如果{checkedValue}为{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53484');
  346. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  347.   VALUES('R0002', '字符串是否不相等', 'checkedValue,targetValue,value', 'rule', '1', '1', '如果{checkedValue}不为{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53485');
  348. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  349.   VALUES('R0003', '字符是否包含', 'checkedValue,targetValue,value', 'rule', '1', '1', '如果{checkedValue}包含于{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53486');
  350. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  351.   VALUES('R0004', '数字是否相等', 'checkedValue,targetValue,value', 'rule', '1', '1', '如果{checkedValue}等于{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-20 11:13:41', '2018-09-20 11:13:41', 1, NULL, NULL, NULL, '7f62ed9754d043e4864297494b7c24a5');
  352. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  353.   VALUES('R0005', '数字是否不相等', 'checkedValue,targetValue,value', 'rule', '1', '1', '如果{checkedValue}不等于{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53487');
  354. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  355.   VALUES('R0006', '大于', 'checkedValue,startValue,value', 'rule', '1', '1', '如果{checkedValue}大于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-20 11:13:03', '2018-09-25 22:15:51', 1, NULL, NULL, NULL, 'eacaddb5d3844340801246c9ed0d130b');
  356. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  357.   VALUES('R0007', '小于', 'checkedValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}小于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-20 11:13:03', '2018-12-29 13:59:58', 1, NULL, NULL, NULL, 'eacaddb5d3844340801246c9ed0d130c');
  358. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  359.   VALUES('R0008', '大于等于', 'checkedValue,startValue,value', 'rule', '1', '1', '如果{checkedValue}大于等于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-20 11:13:03', '2018-09-25 22:15:51', 1, NULL, NULL, NULL, 'eacaddb5d3844340801246c9ed0d130d');
  360. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  361.   VALUES('R0009', '小于等于', 'checkedValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-20 11:13:03', '2018-09-25 22:15:51', 1, NULL, NULL, NULL, 'eacaddb5d3844340801246c9ed0d130e');
  362. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  363.   VALUES('R0010', '是否包含', 'checkedValue,targetValue,value', 'rule', '1', '1', '如果{checkedValue}包含于{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53489');
  364. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  365.   VALUES('R0011', '是否不包含', 'checkedValue,targetValue,value', 'rule', '1', '1', '如果{checkedValue}不包含于{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53494');
  366. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  367.   VALUES('R0012', '是数字', 'checkedValue,value', 'rule', '1', '1', '如果{checkedValue}是数字，那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53490');
  368. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  369.   VALUES('R0013', '不是数字', 'checkedValue,value', 'rule', '1', '1', '如果{checkedValue}不是数字，那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53491');
  370. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  371.   VALUES('R0014', '是整数', 'checkedValue,value', 'rule', '1', '1', '如果{checkedValue}是整数，那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53492');
  372. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  373.   VALUES('R0015', '身份证合法', 'checkedValue,value', 'rule', '1', '1', '如果{checkedValue}合法，那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53493');
  374. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  375.   VALUES('R0018', '是否存在', 'checkedValue,value', 'rule', '1', '1', '如果{checkedValue}此记录为空，那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:39:35', '2018-09-19 15:39:35', 1, NULL, NULL, NULL, 'ffd9a27b63354575ba9ba5b2376b5e47');
  376. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  377.   VALUES('R0019', '是否为空(含NULL)', 'checkedValue,value', 'rule', '1', '1', '如果{checkedValue}为空，那么，结果是{flag}', NULL, '1', 'admin', '2018-10-12 23:06:09', '2018-10-12 23:06:24', 1, NULL, NULL, NULL, 'a376156143344ab5b4c5d546b87d9f78');
  378. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  379.   VALUES('R0020', '数字在范围内(a,b]', 'checkedValue,startValue,endValue,value', 'rule', '1', '1', '如果{checkedValue}大于{startValue}并且小于等于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '5086ced7db8a46d08d0b18b220b53488');
  380. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  381.   VALUES('R0043', '前置条件(字符相同,小于)', 'checkedBefor,targetBefor,checkedValue,endValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}小于{endValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fc7652eca5d94bb3fe44ea89d513aa2');
  382. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  383.   VALUES('R0044', '前置条件(字符相同,大于)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}大于{startValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fd649ac935926b23fe5ae2b5c56b8ad');
  384. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  385.   VALUES('R0045', '前置条件(字符相同,等于)', 'checkedBefor,targetBefor,checkedValue,targetValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}为{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fde513ca27944f33fe51cea39d473a9');
  386. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  387.   VALUES('R0046', '前置条件(字符相同,字符相同)', 'checkedBefor,targetBefor,checkedValue,startValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}为{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fe7b1ef63dec7be3fd15b22b6456c8b');
  388. INSERT INTO TB_PUB_BM_CONF_RULE(RULE_CODE, RULE_NAME, RULE_FORMULA, RULE_TYPE, RULE_VALUE, RULE_PRIORITY, RULE_TEMPLATE, INDEX_ID, CREATE_USER_ACCOUNT, CREATE_USER_NAME, CREATE_TIME, UPDATE_TIME, TRUNC_NO, DEL_FLAG, DATA_CHAN, BANK_CODE, UUID)
  389.   VALUES('R0047', '前置条件(字符相同,字符不相同)', 'checkedBefor,targetBefor,checkedValue,targetValue,value', 'rule', '1', '1', '当{checkedBefor}等于{targetBefor}时，如果{checkedValue}不为{targetValue}那么，结果是{flag}', NULL, '1', 'admin', '2018-09-19 15:41:07', '2018-09-19 15:41:07', 1, NULL, NULL, NULL, '3fed343a6874d0ea3fbe483c907920f2');

规则配置表有写好的规则需要一起挪过去，规则配置表里的规则编号需要和xml里配置的rule标签里的id属性对应。

2、项目集成模型引擎

项目依赖中增加以下依赖：

  1. <dependency>
  2.     <groupId>com.git.easyloan.model</groupId>
  3.     <artifactId>model-controller</artifactId>
  4.     <version>1.3.0-SNAPSHOT</version>
  5. </dependency>

代码中增加规则配置文件，如果没有引入则规则配置文件。

第四章 模型引擎集成与配置 - 图2

如果使用前置条件需要引入condition标签，检查子系统下conditions.xml 是否有这些配置

第四章 模型引擎集成与配置 - 图3

3、添加页面配置菜单

Sql可以导出netloan现有的根据自己的需求自己 配置到想要的目录下

第四章 模型引擎集成与配置 - 图4

前端页面（menu_component）配置固定值

menu_params需要配置成自己子系统的路径

第四章 模型引擎集成与配置 - 图5

第四章 模型引擎集成与配置 - 图6

4、配置接口与模型映射关系

接口controller 方法上添加@ModelManager（parameter={“模型id”}），parameter省略时查找mapping注解内的路径去除“\”，@PostMapping（“\CRD030020”）取CRD030020。

第四章 模型引擎集成与配置 - 图7

添加模型与接口映射记录，model_cd为模型uuid，交易码为接口编号，如果调用时传入法人号和机构号则取法人和机构下的规则，如果调用接口时不传则查找所有。

第四章 模型引擎集成与配置 - 图8

5、代码内部调用模型

第四章 模型引擎集成与配置 - 图9

三、配置方式

1、指标配置

第四章 模型引擎集成与配置 - 图10

指标命名规则ZB_子系统代码_业务关键字_指标字段

如：ZB_CSM_PARTY_INFO

在信贷系统“参数管理-模型指标管理”菜单中配置指标，指标为各个子系统共用，指标一旦被模型关联后将不能被修改和删除，如需修改删除需要先解绑。

指标配置主要分两部分：

  1. 取值方式：取值方式配置指标的信息源。分为rest服务取值和无取值（socket服务暂不支持）。无取值是指需要的数据已经在模型执行的参数中无需额外取值。如配置rest服务取值，则需要在服务编号中填写服务路径（如http://EASYLOAN-XXX/xxx）。调用结果会放在params的中，key为indexMap，类型为javacommon.easytools.json.JSON。在服务入参中填写需要的参数。参数多个用逗号分隔。参数可以是变量名，变量名会直接作为参数名，参数值会在params中取。可以用“=”给变量赋值为一个常量。如果需要更换参数名请使用“变量名->参数名”的形式。
  2. 指标计算类型：对指标的信息源进行计算得出指标值。有直接取值、无计算、后台程序计算、四则运算四种方式。
    1. 无计算不进行任何操作。
    2. 直接取值会在params和服务调用结果中取值。取值的变量名需要填在取值关键字中。如果都没有会赋值为指标默认值中填写的值，如果取值关键字为多个指标默认值的个数需要与取值关键字个数一致，使用”,”隔开，如取值关键字为param1,param2,param3,指标默认值为,01, 为参数param2设置默认值，指标默认值留空则全部不设置默认值。
    3. 后台程序计算需要在公式/路径中填写完整类名。执行类需要有parse方法，此方法提供一个map类参数，可以拿到执行模型时的params参数。
    4. 四则运算在公式/路径中填写表达式，如“变量1+变量2*4”。变量值在params和服务调用结果中取，都没有计为零。

Rest服务取值服务编号配置详细说明

第四章 模型引擎集成与配置 - 图11

服务编号可配置类型：

1、http://localhost/XXXX/{id}

参数在模型调用参数params中取值

对应程序后台接口

第四章 模型引擎集成与配置 - 图12

  1. http://localhost/XXXX

参数在服务入参字段获取，多个参数用逗号隔开，key值通过>改名

第四章 模型引擎集成与配置 - 图13

对应后台接口

第四章 模型引擎集成与配置 - 图14

注意：此请求类型也会将请求参数放在请求体内，对应后台代码：

第四章 模型引擎集成与配置 - 图15

  1. http://localhost/XXXX

服务入参和请求地址都配有参数 则拼接为此种请求类型，信贷项目内比较少见

2、模型配置

如授信类型配置方法：

添加以子系统名为前缀加_MODEL_TYPE字典项

第四章 模型引擎集成与配置 - 图16

1、添加模型

第四章 模型引擎集成与配置 - 图17

模型代码命名规则：MD_接口编号 如：MD_CRD030010

模型名称命名规则：服务标准化 如：MD_CRD030010

第四章 模型引擎集成与配置 - 图18

2、关联指标

在各子系统菜单中配置模型。先在模型管理中新增模型。再在模型设置中配置关联指标。

第四章 模型引擎集成与配置 - 图19

第四章 模型引擎集成与配置 - 图20

点击关联指标。

关联指标主要配置指标结果计算类型。

分为无需计算、样本数据、后台程序计算、四则运算。

点击保存左侧树中会添加所选指标。

在树中选择指标进行详细配置。

第四章 模型引擎集成与配置 - 图21

点击修改配置可以修改关联配置。

第四章 模型引擎集成与配置 - 图22

  1. 无需计算：不做任何操作，将指标值作为指标结果（一般作为过渡指标使用，如请求客户子系统获取partyId放入模型参数内，供后续指标使用）。
  2. 后台程序计算：在程序路径中填写完整类名。执行类需实现IndexParse。计算结果请保存在params中，使用指标编号作为key，以供后续使用。

如果指标也配置为后台计算则会先调用指标配置的后台方法再调用模型关联时配置的方法，四则运算也一样。

  1. 四则运算：在运算公式中填写表达式。变量值在params中取。
  2. 样本数据：

第四章 模型引擎集成与配置 - 图23

在下方添加样本数据选择规则类型并填写样本配置。可以添加多个规则。会依次执行。样本配置可以填写常量和变量名，变量值会在params中取。配置变量时支持baseInfo.partyName多层级取值，如果params参数内包含有baseInfo对象，partyName在baseInfo对象内，可以使用这种方法。

点击输入框右侧的圈可以切换到参数选择。参数在上方参数管理中配置。

第四章 模型引擎集成与配置 - 图24

将样本数据中用到的数添加为参数，使更具有可读性

第四章 模型引擎集成与配置 - 图25

注意：多个样本比较时，只要有一个样本为通过那么这个指标就为通过，一般我们配置准入型模型时仅使用一个样本数据，且不使用指标标准值、标准分、指标值，只考虑这个指标是否通过。

参数的值会取参数代码在params中的值。结果可以填写表达式需要以“Formula:”开头。变量在params中取，还会额外添加三个可用变量“StandardValue”指标标准值、“StandardScore”指标标准分、“ActualValue”指标值。标准值和标准分在关联配置中填写。表达式的计算结果不会超过标准分，结果会在计算结果和标准分中取小的那个。

关联配置的中的指标变量会保存在params中，key为indexVar。如果需要可以在后台程序中使用。

3、指标变量字段用法

指标变量可以配置为json格式内容，后台会根据配置临时替换对应指标各个字段，作用范围为本模型内有效。

如配置为：

{“servParam”:”baseInfo.uuid>uuid”,”servCode”:”127.0.0.1:8101/tbCsmParty/getPartyById”}

则是临时替换指标中的服务入参和服务编号两个字段。

第四章 模型引擎集成与配置 - 图26

服务编号字段仅推荐测试时方便调用本地服务使用。正规环境除替换路径中的变量外（如http://EASYLOAN-CREDIT/tbApplication/{id}）,其他情况不推荐使用。

3、指标配置中遇到的问题和解决方法

Rest服务请求地址访问失败。

可以根据打印处理的地址判断出请求地址和参数是否配置正确，请求参数是否正确取到值，如果是本地测试请求地址为http://EASYLOAN-CREDIT/tbCreditAccount类型，则需要确认本地服务是否正常在注册中心注册，注册中心是否有此服务。

样本数据对比失败，提示某参数[null]。

请检查参数关联内配置的变量对应的服务入参或本指标之前的指标是有值或正常取到了相应的值。

执行样本数据对比时提示指标规则执行失败，找不到规则公式。

请根据样本数据配置的规则id，检查规则配置文件内是否配置改规则，如果规则id有对应配置则检查规则配置checkType是否有对应的java类，添加相应配置可解决此问题。

第四章 模型引擎集成与配置 - 图27

第四章 模型引擎集成与配置 - 图28

附件
附件
附件
附件
附件
附件