RWAServer/DBScript/张艳杰/002-DML.sql

-- 公共部门管理
delete from RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST;
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国国家铁路集团有限公司','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中华人民共和国铁道部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('交通运输部管理的国家铁路局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家融资担保基金有限责任公司','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('工业和信息化部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('政协全国委员会办公厅','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('全国人大常委会办公厅机关','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家自然科学基金委员会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家发展改革委','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('人力资源社会保障部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国证监会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家金融监督管理总局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家外汇管理局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('全国社会保障基金理事会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('民政部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('海关总署','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国务院参事室','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国记协','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国务院发展研究中心','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家消防救援局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家药品监督管理局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家市场监督管理总局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家知识产权局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家统计局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家邮政局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家机关事务管理局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家铁路局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国邮政集团有限公司','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国务院办公厅','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国民用航空局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('商务部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中华全国供销合作总社','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('交通运输部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国残联','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国国际贸易促进委员会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国人民对外友好协会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中华全国归国华侨联合会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家国际发展合作署','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('外交部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('公安部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国计划生育协会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国老龄协会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家疾病预防控制局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家信访局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('农业农村部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国务院国资委','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家卫生健康委','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('司法部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国法学会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国气象局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('自然资源部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('最高人民检察院','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('最高人民法院','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国务院港澳事务办公室','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家医疗保障局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('北大荒农垦集团有限公司','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国红十字会总会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('全国妇联','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('水利部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中央机构编制委员会办公室','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家中医药管理局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家移民管理局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('共青团中央','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家档案局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('教育部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('审计署','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家能源局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家体育总局体育彩票管理中心','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国文学艺术界联合会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国福利彩票发行管理中心','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家民委','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国科学院','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家信息中心 公开信息','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('住房城乡建设部 公开信息','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国地质调查局自然资源综合调查指挥中心','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国地震局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家矿山安全监察局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('应急管理部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('税务系统','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家文物局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国社会科学院','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('生态环境部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中央党校（国家行政学院）','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('科学技术部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中华全国总工会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家林业和草原局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国地质调查局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家体育总局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国宋庆龄基金会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('新华通讯社','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('文化和旅游部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国科学技术协会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国出版集团有限公司','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国工程院','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('全国哲学社会科学工作办公室','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中央社会主义学院','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家粮食和物资储备局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('国家广播电视总局','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('全国工商联','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中国作家协会','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('中央广播电视总台','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');
INSERT INTO RWA_BDM_OBJ_CONF_OTHER_PUBLIC_ENTITY_LIST(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)VALUES('退役军人事务部','保证','S007','0.2','经国务院认定可视同我国主权的公共部门实体名单');





delete from RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST;
-- 合格多边开发银行
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)  VALUES('世界银行集团','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('亚洲开发银行','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('非洲开发银行','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('欧洲复兴开发银行','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('泛美开发银行','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('欧洲投资银行','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('欧洲投资基金','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('北欧投资银行','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('加勒比海开发银行','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('伊斯兰开发银行','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('欧洲理事会开发银行','合格多边开发银行','保证','S019',0,'');
insert into  RWA_BDM_OBJ_CONF_MULTILATERAL_DEVELOPMENT_BANKS_LIST(CUST_NAME,RATING,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE) VALUES('国际免疫融资机制','合格多边开发银行','保证','S019',0,'');



delete from RWA_BDM_OBJ_CONF_GENERAL_ENTITY;
-- 经金融监管总局认定的我国一般公共部门实体风险暴露
insert into RWA_BDM_OBJ_CONF_GENERAL_ENTITY(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)  VALUES('山西省融资再担保集团有限公司','保证','S008','0.5','');
insert into RWA_BDM_OBJ_CONF_GENERAL_ENTITY(CUST_NAME,CRM_FIRST_LEVEL,QUALFIED_CREDIT_TOOL_TYPE_NAME,EXEMPTION_WEIGHT,NOTE)  VALUES('山西省农业信贷融资担保有限公司','保证','S008','0.5','');






 -- 风险暴漏层级
 
 
 delete from RWA_CALC_CONF_RISKEXPOSURE;
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R00000000','风险暴漏层级','','0',NULL,'0');


INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R01000000','1.现金类资产','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R01010000','1.1现金（0%）','R01000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R01020000','1.2黄金（0%）','R01000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R01030000','1.3存放中国人民银行款项（0%）','R01000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02000000','2.对主权的风险暴露','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02010000','2.1对我国中央政府的风险暴露（0%）','R02000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02020000','2.2对中国人民银行的风险暴露（0%）','R02000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02030000','2.3对评级AA-（含）以上的国家或地区的中央政府和中央银行的风险暴露（0%）','R02000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02040000','2.4对评级AA-以下，A-（含）以上的国家或地区的中央政府和中央银行的风险暴露（20%）','R02000000','0',0.2,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02050000','2.5对评级A-以下，BBB-（含）以上的国家或地区的中央政府和中央银行的风险暴露（50%）','R02000000','0',0.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02060000','2.6对评级BBB-以下，B-（含）以上的国家或地区的中央政府和中央银行的风险暴露（100%）','R02000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02070000','2.7对评级B-以下的国家或地区的中央政府和中央银行的风险暴露（150%）','R02000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02080000','2.8对未评级的国家或地区的中央政府和中央银行的风险暴露（100%）','R02000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R02090000','2.9对国际清算银行、国际货币基金组织、欧洲中央银行、欧盟、欧洲稳定机制和欧洲金融稳定机制等的风险暴露（0%）','R02000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R03000000','3.对我国公共部门实体的风险暴露','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R03010000','3.1视同我国主权的公共部门实体风险暴露','R03000000','0',NULL,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R03010100','3.1.1对我国中央政府投资的金融资产管理公司为收购国有银行不良贷款而定向发行的债券（0%）','R03010000','0',0,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R03010200','3.1.2对省级（自治区、直辖市）及计划单列市人民政府的风险暴露','R03010000','0',NULL,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R03010201','3.1.2.1一般债券（10%）','R03010200','0',0.1,'4');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R03010202','3.1.2.2专项债券（20%）','R03010200','0',0.2,'4');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R03010203','3.1.2.3其他（仅用于并表填报）（20%）','R03010200','0',0.2,'4');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R03010300','3.1.3对除财政部和中国人民银行外，其他收入主要源于中央财政的公共部门实体的风险暴露（20%）','R03010000','0',0.2,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R03020000','3.2对经金融监管总局认定的我国一般公共部门实体风险暴露（50%）','R03000000','0',0.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R04000000','4.对我国开发性金融机构和政策性银行的风险暴露（不包括次级债权）（0%）','R00000000','1',0,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R05000000','5.对在其他国家或地区注册的公共部门实体的风险暴露','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R05010000','5.1对评级AA-（含）以上国家或地区注册的公共部门实体的风险暴露（20%）','R05000000','0',0.2,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R05020000','5.2对评级AA-以下，A-（含）以上国家或地区注册的公共部门实体的风险暴露（50%）','R05000000','0',0.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R05030000','5.3对评级A-以下，B-（含）以上国家或地区注册的公共部门实体的风险暴露（100%）','R05000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R05040000','5.4对评级B-以下国家或地区注册的公共部门实体的风险暴露（150%）','R05000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R05050000','5.5对未评级的国家或地区注册的公共部门实体的风险暴露（100%）','R05000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R06000000','6.对多边开发银行的风险暴露','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R06010000','6.1对合格多边开发银行的风险暴露（0%）','R06000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R06020000','6.2对评级AA-（含）以上的其他多边开发银行的风险暴露（20%）','R06000000','0',0.2,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R06030000','6.3对评级AA-以下，A-（含）以上的其他多边开发银行的风险暴露（30%）','R06000000','0',0.3,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R06040000','6.4对评级A-以下，BBB-（含）以上的其他多边开发银行的风险暴露（50%）','R06000000','0',0.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R06050000','6.5对评级BBB-以下，B-（含）以上的其他多边开发银行的风险暴露（100%）','R06000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R06060000','6.6对评级B-以下的其他多边开发银行的风险暴露（150%）','R06000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R06070000','6.7对未评级的其他多边开发银行的风险暴露（50%）','R06000000','0',0.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07000000','7.对境内外金融机构的风险暴露（不含次级债权）','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07010000','7.1对境内商业银行的风险暴露','R07000000','0',NULL,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07010100','7.1.1对境内商业银行原始期限三个月以内（含），或因跨境货物贸易而产生的原始期限六个月以内（含）的风险暴露（20%）','R07010000','0',0.2,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07010200','7.1.2对境内商业银行的其他风险暴露（40%）','R07010000','0',0.4,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07010300','7.1.3其他（仅用于并表填报）','R07010000','0',NULL,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07020000','7.2对境外商业银行的风险暴露','R07000000','0',NULL,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07020100','7.2.1对境外商业银行原始期限三个月以内（含），或因跨境商品贸易而产生的原始期限六个月以内（含）的风险暴露（20%）','R07020000','0',0.2,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07020200','7.2.2对境外商业银行的其他风险暴露（40%）','R07020000','0',0.4,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07020300','7.2.3对境外商业银行的其他风险暴露（50%）','R07020000','0',0.5,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07020400','7.2.4对境外商业银行的其他风险暴露（100%）','R07020000','0',1,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07020500','7.2.5对境外商业银行的其他风险暴露（150%）','R07020000','0',1.5,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R07030000','7.3对境内外其他金融机构的风险暴露（100%）','R07000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R08000000','8.对公司的风险暴露','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R08010000','8.1对中小企业的风险暴露（85%）','R08000000','0',0.85,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R08020000','8.2对小微企业的风险暴露（75%）','R08000000','0',0.75,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R08030000','8.3对其他一般公司的风险暴露（100%）','R08000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R08040000','8.4对公司的房产抵押追加贷款（150%）','R08000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R08050000','8.5其他（仅用于并表填报）','R08000000','0',NULL,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R09000000','9.对个人的风险暴露','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R09010000','9.1个人住房抵押贷款（50%）','R09000000','0',0.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R09020000','9.2个人房产的抵押贷款追加贷款（150%）','R09000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R09030000','9.3对监管零售个人风险暴露','R09000000','0',NULL,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R09030100','9.3.1对合格交易者个人风险暴露（45%）','R09030000','0',0.45,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R09030200','9.3.2对其他监管零售个人风险暴露（75%）','R09030000','0',0.75,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R09040000','9.4对其他个人风险暴露（100%）','R09000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R09050000','9.5其他（仅用于并表填报）','R09000000','0',NULL,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R10000000','10.房地产开发风险暴露','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R10010000','10.1对符合审慎要求的房地产开发风险暴露（100%）','R10000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R10020000','10.2对其他房地产开发风险暴露（150%）','R10000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R11000000','11.商业银行持有的不动产','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R11010000','11.1商业银行自用不动产（100%）','R11000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R11020000','11.2商业银行非自用不动产','R11000000','0',NULL,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R11020100','11.2.1因行使抵押权而持有并在法律规定处分期限内的非自用不动产（100%）','R11020000','0',1,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R11020200','11.2.2其他非自用不动产（400%）','R11020000','0',4,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R12000000','12.租赁资产余值(100%)','R00000000','1',1,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R13000000','13.股权','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R13010000','13.1对金融机构的股权投资（未扣除部分）（250%）','R13000000','0',2.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R13020000','13.2被动持有的对工商企业的股权投资在法律规定处分期限内（250%）','R13000000','0',2.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R13030000','13.3因市场化债转股持有的工商企业股权投资（250%）','R13000000','0',2.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R13040000','13.4对获得国家重大补贴，并受到政府监督的股权投资（250%）','R13000000','0',2.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R13050000','13.5对工商企业的其他股权投资（1250%）','R13000000','0',12.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R14000000','14.对次级债权（未扣除部分）','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R14010000','14.1对我国开发性金融机构和政策性银行的次级债权（未扣除部分）（100%）','R14000000','0',1,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R14020000','14.2对我国商业银行的次级债权（未扣除部分）（150%）','R14000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R14030000','14.3对我国其他金融机构的次级债权（未扣除部分）（150%）','R14000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R14040000','14.4持有全球系统重要性银行发行的总损失吸收能力（TLAC）债务工具（150%）','R14000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R14050000','14.5其他次级债权（150%）','R14000000','0',1.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15000000','15.其他','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15010000','15.1联行往来、外汇买卖及同城票据交换等零风险款项（0%）','R15000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15020000','15.2依赖于银行未来盈利的净递延税资产（未扣除部分）(250%)','R15000000','0',2.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030000','15.3其他表内资产','R15000000','0',NULL,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030100','15.3.1适用0%风险权重的资产','R15030000','0',0,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030200','15.3.2适用20%风险权重的资产','R15030000','0',0.2,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030300','15.3.3适用30%风险权重的资产','R15030000','0',0.3,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030400','15.3.4适用40%风险权重的资产','R15030000','0',0.4,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030500','15.3.5适用45%风险权重的资产','R15030000','0',0.45,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030600','15.3.6适用50%风险权重的资产','R15030000','0',0.5,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030700','15.3.7适用60%风险权重的资产','R15030000','0',0.6,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030800','15.3.8适用75%风险权重的资产','R15030000','0',0.75,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15030900','15.3.9适用85%风险权重的资产','R15030000','0',0.85,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15031000','15.3.10适用100%风险权重的资产','R15030000','0',1,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15031100','15.3.11适用150%风险权重的资产','R15030000','0',1.5,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15031200','15.3.12适用250%风险权重的资产','R15030000','0',2.5,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15031300','15.3.13适用400%风险权重的资产','R15030000','0',4,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R15031400','15.3.14适用1250%风险权重的资产','R15030000','0',12.5,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R16000000','16.证券、商品、外汇交易清算过程中形成的风险暴露','R00000000','1',NULL,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R16010000','16.1货款对付模式下','R16000000','0',NULL,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R16010100','16.1.1货款对付模式下4（含）个交易日以内（0%）','R16010000','0',0,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R16010200','16.1.2货款对付模式下5至15个交易日之间（100%）','R16010000','0',1,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R16010300','16.1.3货款对付模式下16至30个交易日之间（625%）','R16010000','0',6.25,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R16010400','16.1.4货款对付模式下31至45个交易日之间（937.5%）','R16010000','0',9.375,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R16010500','16.1.5货款对付模式下46个交易日以上（1250%）','R16010000','0',12.5,'3');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R16020000','16.2非货款对付模式下5（含）个交易日后（1250%）','R16000000','0',12.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R17000000','17.资产证券化表内项目','R00000000','1',0,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R18000000','18.资产管理产品项目（不含穿透法计量部分）','R00000000','1',0,'1');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R18010000','18.1使用授权基础法计量的资产管理产品','R18000000','0',0,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R18020000','18.2使用1250%方法计量的资产管理产品','R18000000','0',12.5,'2');
INSERT INTO RWA_CALC_CONF_RISKEXPOSURE(RISKEXPOSURE_NO,RISKEXPOSURE_NAME,RISKEXPOSURE_SUPER,RISKEXPOSURE_ISMINI,RISKEXPOSURE_WEIGHT,RISK_EXPOSE_CLASS_CODE)VALUES('R18030000','18.3杠杆调整','R18000000','0',NULL,'2');

 
 
 

 
 
 


-- 系统菜单

delete from sys_funinfo where FUNCCODE = 'M410000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M410000', '计量参数维护', '0', 0.000000000000000000000000000000, '0', NULL, 1.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M411000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M411000', '名单制管理参数配置', 'M410000', 1.000000000000000000000000000000, '0', NULL, 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M411001';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M411001', '公共部门实体清单管理', 'M411000', 1.000000000000000000000000000000, '1', '/ListOfPublicSector', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M411002';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M411002', '多边开发银行管理', 'M411000', 2.000000000000000000000000000000, '1', '/DevelopBankList', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M411003';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M411003', '金监局认定的公共部门实体管理', 'M411000', 1.000000000000000000000000000000, '1', '/GeneralSectorList', 3.000000000000000000000000000000, '', '4tailbranch', NULL);


delete from sys_funinfo where FUNCCODE = 'M412000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M412000', '房地产开发贷款重组标识维护', 'M410000', 1.000000000000000000000000000000, '1', '/realestate', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M413000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M413000', '业务配置', 'M410000', 1.000000000000000000000000000000, '1', '/bussiness', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M414000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M414000', '产品配置', 'M410000', 1.000000000000000000000000000000, '1', '/product_list', 2.000000000000000000000000000000, '', '4tailbranch', NULL);


delete from sys_funinfo where FUNCCODE = 'M510000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M510000', '总账取数', '0', 0.000000000000000000000000000000, '0', NULL, 1.000000000000000000000000000000, '', '4tailbranch', NULL);
delete from sys_funinfo where FUNCCODE = 'M510001';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M510001', '总账科目计量表内外项目定义', 'M510000', 1.000000000000000000000000000000, '1', '/product/rule', 2.000000000000000000000000000000, '', '4tailbranch', NULL);


delete from sys_funinfo where FUNCCODE = 'M110000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M110000', '数据补录', '0', 1.000000000000000000000000000000, '0', NULL, 1.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M110001';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M110001', '数据补录模板定义', 'M110000', 1.000000000000000000000000000000, '1', '/supplementtemplatedefine', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M110002';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M110002', '数据补录任务管理', 'M110000', 1.000000000000000000000000000000, '1', '/supplementtaskmanagement', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M110003';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M110003', '数据补录', 'M110000', 1.000000000000000000000000000000, '1', '/datasupplementation', 2.000000000000000000000000000000, '', '4tailbranch', NULL);


delete from sys_funinfo where FUNCCODE = 'M200000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200000', '数据质量管理', '0', 1.000000000000000000000000000000, '0', NULL, 1.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200100';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200100', '源数据查询', 'M200000', 1.000000000000000000000000000000, '0', NULL, 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200101';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200101', '信贷表', 'M200100', 1.000000000000000000000000000000, '1', '/fcLoan', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200102';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200102', '银承、保函、信用证等表外业务', 'M200100', 1.000000000000000000000000000000, '1', '/fcOffSheet', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200103';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200103', '承诺表', 'M200100', 1.000000000000000000000000000000, '1', '/fcCommitment', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200104';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200104', '回购表', 'M200100', 1.000000000000000000000000000000, '1', '/ffRepo', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200105';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200105', '汇率信息表', 'M200100', 1.000000000000000000000000000000, '1', '/itItfRate', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200106';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200106', '总账科目余额表', 'M200100', 1.000000000000000000000000000000, '1', '/faGlBalanceSheet', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200107';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200107', '客户基本信息表', 'M200100', 1.000000000000000000000000000000, '1', '/CustomerTable', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200108';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200108', '抵质押表', 'M200100', 1.000000000000000000000000000000, '1', '/CollateralTable', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200109';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200109', '保证表', 'M200100', 1.000000000000000000000000000000, '1', '/GuaranteeTable', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200110';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200110', '回购关联信息表', 'M200100', 1.000000000000000000000000000000, '1', '/RepoRelatedTable', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200111';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200111', '缓释品与债项关系表', 'M200100', 1.000000000000000000000000000000, '1', '/PledgeRelatedTable', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200112';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200112', '票据表', 'M200100', 1.000000000000000000000000000000, '1', '/DiscountTable', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200113';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200113', '信用卡表', 'M200100', 1.000000000000000000000000000000, '1', '/OnCreditCard', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200114';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200114', '信用卡未使用额度表', 'M200100', 1.000000000000000000000000000000, '1', '/OffCreditCard', 3.000000000000000000000000000000, '', '4tailbranch', NULL);


delete from sys_funinfo where FUNCCODE = 'M200115';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200115', '存拆放表', 'M200100', 1.000000000000000000000000000000, '1', '/InterbankDepositOrLendingTable', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200116';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200116', '债券投资表', 'M200100', 1.000000000000000000000000000000, '1', '/BondInvestment', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200117';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200117', '非标投资表', 'M200100', 1.000000000000000000000000000000, '1', '/NonStandardInvestment', 3.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200200';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200200', '源数据范围管理', 'M200000', 1.000000000000000000000000000000, '1', '/datascopemanage', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M200300';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M200300', '数据质量检查规则定义', 'M200000', 1.000000000000000000000000000000, '1', '/dataqualityruledefine', 2.000000000000000000000000000000, '', '4tailbranch', NULL);


delete from sys_funinfo where FUNCCODE = 'M610000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M610000', '风险暴露分类配置', '0', 1.000000000000000000000000000000, '0', NULL, 1.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M611000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M611000', '风险暴露分类信息维护', 'M610000', 1.000000000000000000000000000000, '1', '/info', 2.000000000000000000000000000000, '', '4tailbranch', NULL);


delete from sys_funinfo where FUNCCODE = 'M710000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M710000', '合格缓释认定', '0', 1.000000000000000000000000000000, '0', NULL, 1.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M710001';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M710001', '合格缓释认定配置', 'M710000', 1.000000000000000000000000000000, '1', '/releasetoolinfo', 2.000000000000000000000000000000, '', '4tailbranch', NULL);


delete from sys_funinfo where FUNCCODE = 'M800000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M800000', '信用风险RWA计量', '0', 1.000000000000000000000000000000, '0', NULL, 1.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M810000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M810000', '阶段信息配置', 'M800000', 1.000000000000000000000000000000, '1', '/stageinformation', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M820000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M820000', '计量任务管理', 'M800000', 1.000000000000000000000000000000, '1', '/meteringmanagement', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M830000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M830000', '计量参数定义', 'M800000', 1.000000000000000000000000000000, '1', '/meteringparamdefine', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M840000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M840000', '计量任务执行管理', 'M800000', 1.000000000000000000000000000000, '1', '/meteringtaskexecute', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M850000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M850000', '信用风险RWA计量规则定义', 'M800000', 1.000000000000000000000000000000, '1', '/creditriskmeteringrule', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M900000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M900000', '报表定义工具', '0', 1.000000000000000000000000000000, '0', NULL, 1.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M910000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M910000', '报表填报配置', 'M900000', 1.000000000000000000000000000000, '1', '/reportfillingconfig', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M920000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M920000', '报表参数定义', 'M900000', 1.000000000000000000000000000000, '1', '/reportparamdefine', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M930000';
INSERT INTO sys_funinfo
(FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE)
VALUES('M930000', '报表结果查询', 'M900000', 1.000000000000000000000000000000, '1', '/reportresultquery', 2.000000000000000000000000000000, '', '4tailbranch', NULL);

delete from sys_funinfo where FUNCCODE = 'M120000';
INSERT INTO sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) VALUES('M120000', '内部管理类报表', '0', 1.000000000000000000000000000000, '0', NULL, 1.000000000000000000000000000000, '', '4tailbranch', NULL);
delete from sys_funinfo where FUNCCODE = 'M120001';
INSERT INTO sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) VALUES('M120001', '各经营机构信用风险资本占用综合监控表', 'M120000', 1.000000000000000000000000000000, '1', '/capitaloccupymonitor', 2.000000000000000000000000000000, '', '4tailbranch', NULL);
delete from sys_funinfo where FUNCCODE = 'M120002';
INSERT INTO sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) VALUES('M120002', '各客户经理信用风险资本占用综合监控表', 'M120000', 1.000000000000000000000000000000, '1', '/accountmanagercreditriskoccupy', 2.000000000000000000000000000000, '', '4tailbranch', NULL);
delete from sys_funinfo where FUNCCODE = 'M120003';
INSERT INTO sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) VALUES('M120003', '对公贷款前十大客户', 'M120000', 1.000000000000000000000000000000, '1', '/corporateloanscustomerstop10', 2.000000000000000000000000000000, '', '4tailbranch', NULL);
delete from sys_funinfo where FUNCCODE = 'M120004';
INSERT INTO sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) VALUES('M120004', '各产品信用风险资本占用综合监控表', 'M120000', 1.000000000000000000000000000000, '1', '/productcreditriskcapitaloccupy', 2.000000000000000000000000000000, '', '4tailbranch', NULL);
delete from sys_funinfo where FUNCCODE = 'M120005';
INSERT INTO sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) VALUES('M120005', '各产品大类信用风险资本占用综合监控表', 'M120000', 1.000000000000000000000000000000, '1', '/producttypecreditriskcapitaloccupy', 2.000000000000000000000000000000, '', '4tailbranch', NULL);
delete from sys_funinfo where FUNCCODE = 'M120006';
INSERT INTO sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) VALUES('M120006', '对公贷款（表内）各行业信用风险加权资产构成分析表', 'M120000', 1.000000000000000000000000000000, '1', '/withintablecorporateloans', 2.000000000000000000000000000000, '', '4tailbranch', NULL);
delete from sys_funinfo where FUNCCODE = 'M120007';
INSERT INTO sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) VALUES('M120007', '多维度信用风险加权资产构成分析表', 'M120000', 1.000000000000000000000000000000, '1', '/multidimensionalcreditrisk', 2.000000000000000000000000000000, '', '4tailbranch', NULL);




-- 权限
delete from sys_funorginfo where FUNCCODE ='M110000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M110000', '000000');
delete from sys_funorginfo where FUNCCODE ='M110001';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M110001', '000000');
delete from sys_funorginfo where FUNCCODE ='M110002';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M110002', '000000');
delete from sys_funorginfo where FUNCCODE ='M110003';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M110003', '000000');
delete from sys_funorginfo where FUNCCODE ='M410000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M410000', '000000');
delete from sys_funorginfo where FUNCCODE ='M411000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M411000', '000000');
delete from sys_funorginfo where FUNCCODE ='M411001';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M411001', '000000');
delete from sys_funorginfo where FUNCCODE ='M411002';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M411002', '000000');
delete from sys_funorginfo where FUNCCODE ='M411003';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M411003', '000000');
delete from sys_funorginfo where FUNCCODE ='M412000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M412000', '000000');
delete from sys_funorginfo where FUNCCODE ='M413000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M413000', '000000');
delete from sys_funorginfo where FUNCCODE ='M414000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M414000', '000000');
delete from sys_funorginfo where FUNCCODE ='M510000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M510000', '000000');
delete from sys_funorginfo where FUNCCODE ='M510001';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M510001', '000000');
delete from sys_funorginfo where FUNCCODE ='M200000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200000', '000000');
delete from sys_funorginfo where FUNCCODE ='M200100';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200100', '000000');
delete from sys_funorginfo where FUNCCODE ='M200101';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200101', '000000');
delete from sys_funorginfo where FUNCCODE ='M200102';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200102', '000000');
delete from sys_funorginfo where FUNCCODE ='M200103';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200103', '000000');
delete from sys_funorginfo where FUNCCODE ='M200104';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200104', '000000');
delete from sys_funorginfo where FUNCCODE ='M200105';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200105', '000000');
delete from sys_funorginfo where FUNCCODE ='M200106';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200106', '000000');
delete from sys_funorginfo where FUNCCODE ='M200107';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200107', '000000');
delete from sys_funorginfo where FUNCCODE ='M200108';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200108', '000000');
delete from sys_funorginfo where FUNCCODE ='M200109';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200109', '000000');
delete from sys_funorginfo where FUNCCODE ='M200110';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200110', '000000');
delete from sys_funorginfo where FUNCCODE ='M200111';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200111', '000000');
delete from sys_funorginfo where FUNCCODE ='M200112';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200112', '000000');
delete from sys_funorginfo where FUNCCODE ='M200113';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200113', '000000');
delete from sys_funorginfo where FUNCCODE ='M200114';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200114', '000000');
delete from sys_funorginfo where FUNCCODE ='M200115';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200115', '000000');
delete from sys_funorginfo where FUNCCODE ='M200116';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200116', '000000');
delete from sys_funorginfo where FUNCCODE ='M200117';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200117', '000000');
delete from sys_funorginfo where FUNCCODE ='M200200';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200200', '000000');
delete from sys_funorginfo where FUNCCODE ='M200300';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M200300', '000000');
delete from sys_funorginfo where FUNCCODE ='M610000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M610000', '000000');
delete from sys_funorginfo where FUNCCODE ='M611000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M611000', '000000');
delete from sys_funorginfo where FUNCCODE ='M710000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M710000', '000000');
delete from sys_funorginfo where FUNCCODE ='M710001';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M710001', '000000');
delete from sys_funorginfo where FUNCCODE ='M800000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M800000', '000000');
delete from sys_funorginfo where FUNCCODE ='M810000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M810000', '000000');
delete from sys_funorginfo where FUNCCODE ='M820000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M820000', '000000');
delete from sys_funorginfo where FUNCCODE ='M830000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M830000', '000000');
delete from sys_funorginfo where FUNCCODE ='M840000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M840000', '000000');
delete from sys_funorginfo where FUNCCODE ='M850000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M850000', '000000');
delete from sys_funorginfo where FUNCCODE ='M900000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M900000', '000000');
delete from sys_funorginfo where FUNCCODE ='M910000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M910000', '000000');
delete from sys_funorginfo where FUNCCODE ='M920000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M920000', '000000');
delete from sys_funorginfo where FUNCCODE ='M930000';
INSERT INTO sys_funorginfo
(FUNCCODE, ORGCODE)
VALUES('M930000', '000000');

delete from sys_funorginfo where FUNCCODE ='M120000';
INSERT INTO sys_funorginfo (FUNCCODE, ORGCODE) VALUES('M120000', '000000');
delete from sys_funorginfo where FUNCCODE ='M120001';
INSERT INTO sys_funorginfo (FUNCCODE, ORGCODE) VALUES('M120001', '000000');
delete from sys_funorginfo where FUNCCODE ='M120002';
INSERT INTO sys_funorginfo (FUNCCODE, ORGCODE) VALUES('M120002', '000000');
delete from sys_funorginfo where FUNCCODE ='M120003';
INSERT INTO sys_funorginfo (FUNCCODE, ORGCODE) VALUES('M120003', '000000');
delete from sys_funorginfo where FUNCCODE ='M120004';
INSERT INTO sys_funorginfo (FUNCCODE, ORGCODE) VALUES('M120004', '000000');
delete from sys_funorginfo where FUNCCODE ='M120005';
INSERT INTO sys_funorginfo (FUNCCODE, ORGCODE) VALUES('M120005', '000000');
delete from sys_funorginfo where FUNCCODE ='M120006';
INSERT INTO sys_funorginfo (FUNCCODE, ORGCODE) VALUES('M120006', '000000');
delete from sys_funorginfo where FUNCCODE ='M120007';
INSERT INTO sys_funorginfo (FUNCCODE, ORGCODE) VALUES('M120007', '000000');






-- 序号管理
delete from sys_innercode where SYSINCODE = 'PARAMNO';
INSERT INTO sys_innercode
(SYSINCODE, SYSINNAME, SYSLENGTH, CONSECUTIVE, SYSCURCODE, FIXEDVALUE, AUTORULE, CLEARRULE, MADATE)
VALUES('PARAMNO', '参数编号', 3.000000000000000000000000000000, '1', 5, NULL, 'yyyyMMdd', 'year', '2024-12-31');

delete from sys_innercode where SYSINCODE = 'RELEASETOOLRULE';
INSERT INTO sys_innercode
(SYSINCODE, SYSINNAME, SYSLENGTH, CONSECUTIVE, SYSCURCODE, FIXEDVALUE, AUTORULE, CLEARRULE, MADATE)
VALUES('RELEASETOOLRULE', '合格缓释认定规则编号', 3.000000000000000000000000000000, '1', 34, NULL, NULL, 'year', '2024-12-31');

delete from sys_innercode where SYSINCODE = 'TEMPLATEVERIFYRU';
INSERT INTO sys_innercode
(SYSINCODE, SYSINNAME, SYSLENGTH, CONSECUTIVE, SYSCURCODE, FIXEDVALUE, AUTORULE, CLEARRULE, MADATE)
VALUES('TEMPLATEVERIFYRU', '规则编号', 18.000000000000000000000000000000, '1', 33, NULL, 'yyyy', 'year', '2024-12-31');