1-- Create table
create table CC_MARKET_EVENT
(
pk_id VARCHAR2(48),
cust_id VARCHAR2(48),
cust_name VARCHAR2(100),
market_id VARCHAR2(48),
market_name VARCHAR2(48),
strt_date VARCHAR2(10),
end_date VARCHAR2(10),
data_dt VARCHAR2(10)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column CC_MARKET_EVENT.pk_id
is '主键';
comment on column CC_MARKET_EVENT.cust_id
is '客户号';
comment on column CC_MARKET_EVENT.cust_name
is '客户名称';
comment on column CC_MARKET_EVENT.market_id
is '管护人';
comment on column CC_MARKET_EVENT.market_name
is '管护人姓名';
comment on column CC_MARKET_EVENT.strt_date
is '开始日期';
comment on column CC_MARKET_EVENT.end_date
is '结束日期';
comment on column CC_MARKET_EVENT.data_dt
is '数据日期 ';
2-- Create table
create table CC_STAT_VISITOR_SIGN
(
emp_id VARCHAR2(48),
accp_emp_id VARCHAR2(48),
cust_id VARCHAR2(48),
cust_name VARCHAR2(100),
visitor_purpose VARCHAR2(100),
sign_dt VARCHAR2(10),
data_dt VARCHAR2(10),
pk_id VARCHAR2(100)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column CC_STAT_VISITOR_SIGN.emp_id
is '主拜访人';
comment on column CC_STAT_VISITOR_SIGN.accp_emp_id
is '协同拜访人';
comment on column CC_STAT_VISITOR_SIGN.cust_id
is '客户号';
comment on column CC_STAT_VISITOR_SIGN.cust_name
is '客户名称';
comment on column CC_STAT_VISITOR_SIGN.visitor_purpose
is '拜访目的';
comment on column CC_STAT_VISITOR_SIGN.sign_dt
is '拜访日期';
comment on column CC_STAT_VISITOR_SIGN.data_dt
is '数据日期';
comment on column CC_STAT_VISITOR_SIGN.pk_id
is '主键';
3-- Create table
create table CC_SYS_EMPLOYEES
(
emp_no VARCHAR2(48),
emp_name VARCHAR2(48),
org_id VARCHAR2(48),
stus VARCHAR2(2),
job_id VARCHAR2(100),
data_dt VARCHAR2(10)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
4-- Create table
create table ORG_TREE_MAPPING
(
org_id VARCHAR2(10),
org_name VARCHAR2(100),
org_lvl VARCHAR2(10),
org_stus VARCHAR2(10),
admin_org_id VARCHAR2(10)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column ORG_TREE_MAPPING.org_id
is '机构号';
comment on column ORG_TREE_MAPPING.org_name
is '机构名称';
comment on column ORG_TREE_MAPPING.org_lvl
is '机构等级';
comment on column ORG_TREE_MAPPING.org_stus
is '机构状态';
comment on column ORG_TREE_MAPPING.admin_org_id
is '上级机构';
prompt Importing table CC_MARKET_EVENT...
set feedback off
set define off
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('02FA1D11BAFABF9D464D6E278', '0000', '光邦有限责任公司', '', '潘石屹', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('32827FDE6EA1DD98D41E8C8071', '0000', '吉凡有限责任公司', '', '王石', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('87B72BBE4E0C41159BF25464C5CC68F4', '0000', '达识有限责任公司', '', '蒋锡培', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('50EA2866F12C494DAE016520B75EF9B0', '0000', '梦本有限责任公司', '', '向文波', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('AF3FCADBC1227E7BF', '0000', '博京有限责任公司', '', '牛根生', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('76D6077C82E04DD2815ED8990D', '0000', '百纽有限责任公司', '', '熊晓鸽', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('8D53EF1D70DF4C7F879AA7AFBAF17140', '0000', '赛事有限责任公司', '', '王冉', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('6D948FE4A3FEF3F559B9D9E2A4', '0000', '网丝有限责任公司', '', '于清教', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C2E0FBE6F6B84CA5AB9939F33F', '0000', '达尚有限责任公司', '', '谢清海', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('94D5F44A3BF7428D8EBF294E3D86F7DF', '0000', '明成有限责任公司', '', '刘旗辉', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('8A49438FA9B29C1EB8BFFA07', '0000', '易惠有限责任公司', '', '刘步尘', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('0FC22EBE199F85B6C87AAB583F', '0000', '坚鑫有限责任公司', '', '陈达夫', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('39ADDBB1FDE445F3E7BE30', '0000', '顿开有限责任公司', '', '船长', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('EAD54478A9EA4FE75CC912BCE', '0000', '奥惠有限责任公司', '', '叶茂中', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('0A49E5AEABDDDAE98AB4F588', '0000', '新具有限责任公司', '', '李士福', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('DB34995A7798BFC', '0000', '宇立有限责任公司', '', '王进生', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('01E058DB2DDEFCC', '0000', '太鑫有限责任公司', '', '任志强', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('1883D197F29343B5BE468CE8A3', '0000', '莱风有限责任公司', '', '付伟', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('3D5963E10C334DED6331CEBC94', '0000', '相智有限责任公司', '', '孙虹钢', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('62351A54FAAC7B0BFFA835FD85', '0000', '金系有限责任公司', '', '宋新宇', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('6A963C5979FB4FF2BE57BDCCB3', '0000', '京亿有限责任公司', '', '王微', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('30257D17C9E71EAE2BBB2', '0000', '力智有限责任公司', '', '翁向东', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('8F9B88744E584BDD857F75674AC3954D', '0000', '涛建有限责任公司', '', '周济谱', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('63C9FF6BC2C3B1B20E7D1', '0000', '庆铁有限责任公司', '', '袁岳', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('CA95D5A2913B4EDEA67EBD', '0000', '辉诺有限责任公司', '', '成君忆', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('60E86053A4C54480BAF26E0C', '0000', '览相有限责任公司', '', '艾学蛟', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('BADA2C85962', '0000', '凡诺有限责任公司', '', '雷永军', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('0A6F4C2FBC1A98FF4B7DEFF5', '0000', '频亚有限责任公司', '', '刘秋华', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('184F1426EACBE84EAE8B811', '0000', '尼迪有限责任公司', '', '宋炜', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('FF3F5C9A71DE4B6EB05EB6455F4309B5', '0000', '清爱有限责任公司', '', '刘东华', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('5C182D2792F643C489F8C9E0CC5BE0CD', '0000', '天复有限责任公司', '', '科特勒', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C3C02D0FCBBFEE1A9A548CC0', '0000', '成特有限责任公司', '', '陈志列', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('BC3BEE958D156F2DDA97A8C7', '0000', '和优有限责任公司', '', '张巨峰', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E0CD5D44F990EF3402EC20CB24', '0000', '玉营有限责任公司', '', '姚日来', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('80D9FC968DF24EA6AB0BF1351DC1E36D', '0000', '派佳有限责任公司', '', '李朝曙', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('AE7739A546E24ED14F36A82272', '0000', '仕正有限责任公司', '', '刘兴亮', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('72F16A40D90642AEAEC8D2AAC4AF5E10', '0000', '正妙有限责任公司', '', '梦琪', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E74935F28CCF4DAA8F5D4FA79', '0000', '富旭有限责任公司', '', '忆柳', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('6C57B28AA7774F22ACBDA93FB15BD437', '0000', '木先有限责任公司', '', '之桃', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('1EC86D13AEFEE', '0000', '茂友有限责任公司', '', '慕青', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C3F2504B9D8ED76C117FBD6CDE', '0000', '领码有限责任公司', '', '问兰', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('5B824DCD50CA4AC2AEF2C1533', '0000', '速腾有限责任公司', '', '尔岚', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('B67EB3001CAECCFC7590D8D5B0', '0000', '春鸿有限责任公司', '', '元 香', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('8F7A117D487D4A42853C637C7C4B9A8E', '0000', '联相有限责任公司', '', '初夏', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('88B33E3DB6B24AE1A5945EDD8A2226A1', '0000', '木圆有限责任公司', '', '沛菡', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('D08E7FC31D07404F90EE9BE46F8009BE', '0000', '尚具发展有限公司', '', '傲珊', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('B260B5ACEFA3DF4B35675', '0000', '高赛有限责任公司', '', '曼文', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C1FC681C73A9E30B00D72', '0000', '长蓝有限责任公司', '', '乐菱', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E0EB0E9E485D4E5DA4CFF73005', '0000', '览驰有限责任公司', '', '痴珊', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E34EB24006A06C92D8E4614B2C', '0000', '码庆发展有限公司', '', '恨玉', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('9BF2C34F33BD2638C4504F46FB', '0000', '百川有限责任公司', '', '惜文', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('3BF8B7BB5BA11804C489E65C63', '0000', '顺大有限责任公司', '', '香寒', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('D7795CB1550C448C8FB2A036C6B4E183', '0000', '诗亿发展有限公司', '', '新柔', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('CA4E59CCC1EC4BBD87CD7EA', '0000', '翔百有限责任公司', '', '语蓉', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('0A0A8DB545BA4DD0BED426F8B3E97706', '0000', '实川有限责任公司', '', '海安', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('58B358F6AC2C4DD1BC948F765ECFE76C', '0000', '裕实有限责任公司', '', '夜蓉', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('60CA718FFBC2559FC87AF6', '0000', '仕日发展有限公司', '', '涵柏', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('80E2E7EFEC294CF096A328FF4C8F0FFD', '0000', '电娇有限责任公司', '', '水桃', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('DDBF27F09993FB', '0000', '飞尼有限责任公司', '', '醉蓝', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('19A80BEB0E5744DD8A3BF7AD', '0000', '惠集有限责任公司', '', '春儿', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('7FB46BD1CD4B4968AA903BA52425D00D', '0000', '爱贵发展有限公司', '', '语琴', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C4F57AC45D2EC2E', '0000', '优盛有限责任公司', '', '从彤', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('2576DC7C52CA457FBBF8D14C91EC8550', '0000', '欣基有限责任公司', '', '傲晴', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('9E0DD1A7B6DE4BED3010BF3237', '0000', '爱森发展有限公司', '', '语兰', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('58C72872F04B4086A7965C06D62C857E', '0000', '晶旺有限责任公司', '', '又菱', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('AD292BAEF07C3A55CD129', '0000', '玉志发展有限公司', '', '凤嘉慕', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('75B42E0071C7484CAB6DF2CBEAE77540', '0000', '欧冠有限责任公司', '', '碧彤', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('DB3530ECC2C341D0945C9CACC5D36829', '0000', '双成有限责任公司', '', '元霜', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('FC81CC59EBFCB54C1F6A71B7', '0000', '皇健发展有限公司', '', '怜梦', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('038F94C078EE26B4B', '0000', '典和有限责任公司', '', '紫寒', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('0D3A5FD9A9858A43FC18B61', '0000', '迪庆有限责任公司', '', '妙彤', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('8D8CBA46D1B96E7F9C6A096343', '0000', '益驰发展有限公司', '', '曼易', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('DAAFE3421A97E0F0C39', '0000', '汉爱有限责任公司', '', '南莲', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('5CC17766BCFB59F3D808E8967', '0000', '和盈有限责任公司', '', '紫翠', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('36262F8AEBC07F29E2A031FF7', '0000', '雅力有限责任公司', '', '雨寒', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('CCC12690A78D49A699AA1B2D0F', '0000', '实斯发展有限公司', '', '易烟', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('EFFF00F24D044B32A2E98880F69DD1BC', '0000', '财营有限责任公司', '', '如萱', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('04AA606ECAC64C1DBE40C7E4CC', '0000', '子佩有限责任公司', '', '若南', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('6B923CDFCEB64C38AF1E8518DF', '0000', '真百发展有限公司', '', '寻真', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('A042E099166AD8153A', '0000', '具硕有限责任公司', '', '晓亦', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('2A390CDE9FE24E938DE7B8F48C24C364', '0000', '维原有限责任公司', '', '向珊', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('0AFA641F6BBD1F29D210DF7EF', '0000', '海真有限责任公司', '', '慕灵', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('4E86953AADA3154A7887EA66', '0000', '豪妙发展有限公司', '', '以蕊', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('479F7668D6DD41CD9A91BAD3E2F28F47', '0000', '时新有限责任公司', '', '寻雁', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('1011E15BCFBC74D0A7D776E32C', '0000', '倍妙有限责任公司', '', '映易', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('AC3F13C9D1AC4B5EB84B976D0CC437B6', '0000', '驰缘发展有限公司', '', '雪柳', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E1CAFF56AFC9EB505EE', '0000', '士坚有限责任公司', '', '王展鹏', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C4524FE2133A4EBF58E8C918', '0000', '和元有限责任公司', '', '王哲瀚', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('7CCAAD97BFBC86EA828D', '0000', '旋和有限责任公司', '', '姚正德', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('F3CCBC21132B46BFB721CEDCE2EDC192', '0000', '瑞浩发展有限公司', '', '蒋志行', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C01C2430BC1B406A96B3911B9FC59410', '0000', '明翔有限责任公司', '', '蒋志学', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('81D1F8CA8B82A99AA09EA95', '0000', '美名有限责任公司', '', '姚正浩', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('7AAD93226D45412E94D8DFCCECFC49FD', '0000', '吉码发展有限公司', '', '姚正豪', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('1E80212D82A0498FAB9F626B9A1D81DF', '0000', '优斯有限责任公司', '', '王哲茂', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('884D3B864D234A77811EBE37', '0000', '洁飞有限责任公司', '', '王哲圣', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('967B4AEAAC3BA341FDAFC5', '0000', '东彩有限责任公司', '', '王哲彦', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('2A66B7953AE9455F97AF33622C9FB368', '0000', '志语发展有限公司', '', '崔振海', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('27FB2BA1375B4B44B3F39D9C0C0403E3', '0000', '纳实有限责任公司', '', '崔振国', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('51FD9CC3B8C44567BAC730FDEF038CE3', '0000', '吉圆有限责任公司', '', '崔正诚', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('DF4FD5AE194A4A5E8D3655B95555EE3E', '0000', '月霆有限责任公司', '', '崔正初', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('9BBDD48379F64BBCA26E485F0', '0000', '爱用发展有限公司', '', '王正平', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('5BCFE4F31A8302E09084C54EB', '0000', '环太有限责任公司', '', '孙正奇', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('BA9BA4DA8BBF495E9E54FA88D', '0000', '福卓有限责任公司', '', '孙正青', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('969E52EDE6804DC70461CA6FE7', '0000', '和邦发展有限公司', '', '谢子墨', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('056BDE1B9CE44A6F991C4A276B8AA9F5', '0000', '系环有限责任公司', '', '谢子平', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E372B7EFA396F622AFB6F3094B', '0000', '旋展有限责任公司', '', '孙正卿', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('AE2011E5CD9CFA', '0000', '磊邦有限责任公司', '', '孙正文', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E179ABAD5B4E4CA29868F6066E467B27', '0000', '火赛发展有限公司', '', '杨正雅', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('42FF9F3032CB459DA6C0542DDF6F85BE', '0000', '好雷有限责任公司', '', '杨正阳', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('02DC9F4140A6D0CE62E55FC068', '0000', '磊频有限责任公司', '', '孙正祥', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('AD19D0C7DCB46A2BA', '0000', '财雅发展有限公司', '', '孙正信', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('51D48D65974C49489BA20B0B92673AEE', '0000', '隆宇有限责任公司', '', '杨正业', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('AEFE021AB8B440B1A658E25E3881AD71', '0000', '速雅有限责任公司', '', '杨正谊', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('59EA947D0DB6BA63', '0000', '佩佳有限责任公司', '', '杨正真', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('F6B1020C5BA4AB67CB67F82FD1', '0000', '安百发展有限公司', '', '黄正志', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('46E054A3E40A430D9FBDF8C6F4A2B93C', '0000', '巨远有限责任公司', '', '黄志诚', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('52798A62CCCA277CF85264E3D', '0000', '宏智有限责任公司', '', '黄志新', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C1FE8EC7E7FB4776A07DBE088EAFC85C', '0000', '恒智发展有限公司', '', '俞天空', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('84EB1283E50B49E7923EF0D', '0000', '方诚有限责任公司', '', '蒋志尚', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('5A4C41464D1148EB9F602EDA1', '0000', '凤太有限责任公司', '', '黄志勇', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('61A4585E66C44FEBFC65EEBE1', '0000', '尔智有限责任公司', '', '黄志明', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('55DA4C2B2E9C4C8BB0105B5E27C1BFBC', '0000', '凌长发展有限公司', '', '黄志国', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('62E4E4A4AF2F44C1A1E9B86C0E7260C5', '0000', '远信有限责任公司', '', '蒋志专', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('F4102E7D165B4803B6750D7C9CC00E2C', '0000', '运翔有限责任公司', '', '蒋志文', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('4EFA64AB9BFA', '0000', '营和发展有限公司', '', '陈志用', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('ECC71F7FE14B41B48A1E75D9F0575BF1', '0000', '成白有限责任公司', '', '陈志泽', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('604B0AC7B95E4906A206FAA89A08E206', '0000', '月通有限责任公司', '', '向致远', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('4DE86EFE1F5947A0B222E91EF18B849D', '0000', '泰讯有限责任公司', '', '向智明', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('AC1A97A7EAD4F', '0000', '优复发展有限公司', '', '向智鑫', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('69BAC4028E0D4A7AA67B98D80AA72DDE', '0000', '相彩有限责任公司', '', '陈志业', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('EB9355D534A54609B372CBBFB5DF95F1', '0000', '宝嘉有限责任公司', '', '陈志义', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('9AF1BDC3EAB1D7C87A18FE49D', '0000', '裕来发展有限公司', '', '向智勇', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('BBCF8A28EAC04652A3C32B7E06489C43', '0000', '光亿有限责任公司', '', '向智敏', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('8A60DC4EFEB3F10A2A', '0000', '腾赛有限责任公司', '', '向子安', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('21A4B98855BD4FB5A9B4750A62592A6C', '0000', '佳诗发展有限公司', '', '谢子晋', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('7105EC5D2BB9409AB85EAAFC2DA05FD9', '0000', '辉星发展有限公司', '', '谢子民', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('A2E3C6777C584E75933E95125D976E52', '0000', '尔元发展有限公司', '', '向智志', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('073D5FB95F30449A92C821BAA281A420', '0000', '铁领发展有限公司', '', '向智渊', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('7BADFA870AFC4D17D6A0AD', '0000', '博典发展有限公司', '', '谢子明', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('14AF18E7D49647BE9E7E6EC3C', '0000', '铭驰发展有限公司', '', '王文斌', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E4DDEED1BA5ACFA8F996E70C2', '0000', '风事发展有限公司', '', '谢子默', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('B475EEDDA1A74E4084CC75B6280A968C', '0000', '坚建发展有限公司', '', '赵静曼', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('CF56E4E30AF7494F7', '0000', '旭开发展有限公司', '', '钱凡旋', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('CF0404A0A9F4A56897B7857E2', '0000', '嘉达发展有限公司', '', '孙以亦', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('428A9BD879ADC876C65629E60C', '0000', '讯坚发展有限公司', '', '李念露', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('46A857BEBBBEFA48D2004A3231', '0000', '旺啸发展有限公司', '', '周芷蕾', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('21ABAC6B22A340A0ADD26179B031E752', '0000', '吉典发展有限公司', '', '吴千兰', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('7CEE0A45B5BA477A9927AD612C', '0000', '码冠发展有限公司', '', '郑新波', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C3DE4D68F1374CF69AF77C33B8A9410C', '0000', '大德发展有限公司', '', '王代真', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('B87F2BDFB9EDF59210', '0000', '洲旭发展有限公司', '', '冯新蕾', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('F374F4F7E88F789A15B5B930B', '0000', '益盛发展有限公司', '', '陈雁玉', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('F3153A25F8874F94B63F7BADF351CBC4', '0000', '帝隆发展有限公司', '', '褚冷卉', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('AD58C0E7BFFD47DDBE82DD9B25A03AE0', '0000', '力月发展有限公司', '', '卫紫山', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('32B76298BEB7433D9C9B26DF12D4D0CD', '0000', '涛江发展有限公司', '', '蒋千琴', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('6057F1F351B64C37BCF2F515F4E2A575', '0000', '联奥发展有限公司', '', '沈恨天', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('D2BFC98C21804F68B4F0FDCAFC', '0000', '盈讯发展有限公司', '', '韩傲芙', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('B70BDCF3AC3B4D40A68B5542AB0DB211', '0000', '好金发展有限公司', '', '杨盼山', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('FB6F0A22FCCB64AF0B', '0000', '亿霆发展有限公司', '', '朱怀蝶', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('D2B3EBF34E2A4F5BBA3CB0DBAF14AA26', '0000', '湖润发展有限公司', '', '秦冰兰', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E87DA11BA09D43E2BC9DBD20DBF25C20', '0000', '宝跃发展有限公司', '', '尤山柏', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('8BF9E00EC6ED4C7893A5AE1155E7888B', '0000', '维拓发展有限公司', '', '许翠萱', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('FA52270C783B450CAA3E9DFDC7', '0000', '开火发展有限公司', '', '何恨松', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('937BBFC1CFA93CED376C7F6C4D', '0000', '金茂发展有限公司', '', '吕美丽', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('BE3A92EADB7D4DC282D5592B6EB1A7E1', '0000', '宜亿发展有限公司', '', '施从南', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('435EA0B3D1F14C5EB2FA4FBC27D9C8E7', '0000', '营本发展有限公司', '', '张白易', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('87D10B76A6EF41EFAB19F7C3F9831B6C', '0000', '曼拓发展有限公司', '', '孔问筠', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('E1DB8BCEBD86FFED5DCBDAD58A', '0000', '铭联发展有限公司', '', '曹如霜', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('3518E920DAAF4D2896E64ADCA1', '0000', '林涛发展有限公司', '', '严半芹', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('1445DE6A66FE40DB87C193AB16', '0000', '安拓发展有限公司', '', '华丹珍', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C2D1DB1AB9F61EA79E5D66E', '0000', '展啸发展有限公司', '', '金冰彤', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('8AB547CF3A9EFD8F98ABB058DB', '0000', '汇友发展有限公司', '', '魏亦寒', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('1C9E0397DF967BD3ABD18A3F1E', '0000', '发诚发展有限公司', '', '陶落花', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('B38E038DC5DA4BDEBADA8D2C8', '0000', '德真发展有限公司', '', '姜怜云', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('58E34AD3EA6E', '0000', '火用发展有限公司', '', '戚寻文', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('86E4F2E278EFC743D8E48935', '0000', '盈佩发展有限公司', '', '谢乐丹', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('1E93616EFE044A6EB9DF991D00', '0000', '仕木发展有限公司', '', '邹翠柔', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('B51A4B3A84884B578DF171A8AFFB7821', '0000', '倍旺发展有限公司', '', '喻谷山', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('2B0A772EE2984C078E7B36CE56', '0000', '频信发展有限公司', '', '柏之瑶', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('1C8BAB3241FAD2F2DA1405BF6', '0000', '缘聚发展有限公司', '', '水冰露', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('1DFA5B13A0C8408CAE5D26DCE82C6D17', '0000', '贸圆发展有限公司', '', '窦尔珍', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('370DBDD292E5F4C74F0', '0000', '帝冠发展有限公司', '', '章谷雪', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('5CF5847DE0A3421D9AB23F3E962B669F', '0000', '同西发展有限公司', '', '云乐萱', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('A8DCAC91B91D4B74B72AA657CC4C4BF7', '0000', '瑞扬发展有限公司', '', '苏涵菡', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('375F45E72EEE6B93A4D7AB', '0000', '顺宇发展有限公司', '', '潘宏远', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C463EA8E10A34932BC0E89005DAAE36B', '0000', '铁清发展有限公司', '', '葛子瑜', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('C5E49DDAE8E649CE964C6CCBDB3E85CF', '0000', '克罗发展有限公司', '', '奚英逸', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('4BEBC9BFD545F4EE938AF', '0000', '欣航发展有限公司', '', '范翔飞', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('F2F7BFB4336F4A25B6F99CCD8BF1F5E2', '0000', '基超发展有限公司', '', '彭英才', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('B7D2DDE9DAA744B38AFC4EB52F9A0B3F', '0000', '梦华发展有限公司', '', '郎鸿博', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('70CCB849C3364E1AB60206CD0C88F76C', '0000', '志远发展有限公司', '', '鲁志专', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('75D0CB34AFBD4CDABD2B8C84F0', '0000', '诚木发展有限公司', '', '韦弘方', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('76CC4E4C08D746B2AE88D13EB', '0000', '涛宏发展有限公司', '', '昌志尚', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('8EC0C8DA05BB2AD0EE9C7895B9', '0000', '优坚发展有限公司', '', '马风睿', '2021-10-15', '9999-12-31', '2020-10-15');
insert into CC_MARKET_EVENT (PK_ID, CUST_ID, CUST_NAME, MARKET_ID, MARKET_NAME, STRT_DATE, END_DATE, DATA_DT)
values ('F073BA82ADE709DBDD3F525B', '0000', '德天发展有限公司', '', '苗振荣', '2021-10-15', '9999-12-31', '2020-10-15');
prompt Done.
2、
prompt Importing table CC_STAT_VISITOR_SIGN...
set feedback off
set define off
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '双成有限责任公司', '易收宝微信认证,国际业务', '2021-05-27', '2021-10-10', '8DCD68B0CA5D4C9BB8C25AD5090C4D98');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '典和有限责任公司', '模拟利润,贷款', '2021-05-27', '2021-10-10', 'A0F83C1F626C43A6B8B3BA4BABF3C8F8');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '汉爱有限责任公司', '好生意,国际业务', '2021-05-27', '2021-10-10', '22B5B76BE37A43669D5986B4F0691E52');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '和盈有限责任公司', '客户维护,财资大管家', '2021-05-27', '2021-10-10', '6BE4B84B09D846BFBBC7FF22E4B1CE54');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '财营有限责任公司', '财资大管家', '2021-05-28', '2021-10-10', 'ADEBE84065A1511C15E1EF6102');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,,,', '0000', '子佩有限责任公司', '国际业务,好生意收款', '2021-05-28', '2021-10-10', '0B24104E61AC6AD432DAD18CAF');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '具硕有限责任公司', '托管业务', '2021-05-28', '2021-10-10', 'C08FC70DA380C55EF60A2A5B53');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '海真有限责任公司', '代发工资', '2021-05-28', '2021-10-10', 'CAE86B7789B948CD9C2E788C763F25EC');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '时新有限责任公司', '模拟利润', '2021-05-28', '2021-10-10', 'E0D1BA048CD3451E9CD195DC46E121B6');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '13149,,', '0000', '磊邦有限责任公司', '中间业务', '2021-05-29', '2021-10-10', '9E01737FAE86C4152BC4CE0DA7');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '磊频有限责任公司', '票据业务', '2021-05-29', '2021-10-10', '8D97601A14AFB2BF5C2C17D5C4');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '隆宇有限责任公司', '办理易收宝,易收宝开通', '2021-05-29', '2021-10-10', 'C3082FA59C6E4434B700CF2FEA');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '速雅有限责任公司', '好生意,模拟利润', '2021-05-29', '2021-10-10', '6C1F1579F5CA4B75833A7E72F30EF879');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '巨远有限责任公司', '贷款,存款', '2021-05-29', '2021-10-10', '36C37806CD4F41089D18BEC00A');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '宏智有限责任公司', '易收宝开通,国际业务', '2021-05-30', '2021-10-10', '8A5BBEDAA852F');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '士坚有限责任公司', '客户维护', '2021-05-30', '2021-10-10', '1D248CEEE6A4DBD6F2D2D9995E');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '和元有限责任公司', '易收宝微信认证,国际业务', '2021-05-30', '2021-10-10', 'E1DC41AAB33CEC5');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '旋和有限责任公司', '模拟利润,贷款', '2021-05-30', '2021-10-10', '3D7DFE9CA6BD42F5B793B5D3480E3F55');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,,', '0000', '美名有限责任公司', '国际业务,贷款', '2021-05-31', '2021-10-10', '158C08642C3D497DA4E8895E4A1DBEF0');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '优斯有限责任公司', '财资大管家,贷款', '2021-05-31', '2021-10-10', '11E0BA934F9B412CBCC8948');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '东彩有限责任公司', '老客户维护,财资大管家', '2021-05-31', '2021-10-10', '6DBF14C5E1BB4983B3CAF568B');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '纳实有限责任公司', '托管业务,财资大管家', '2021-05-31', '2021-10-10', 'DDCD7EE2CA996B2765E13');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '吉圆有限责任公司', '中间业务,老客户维护', '2021-05-31', '2021-10-10', '54CA96492FAEDC02');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,,', '0000', '环太有限责任公司', '开通票据提醒,中间业务', '2021-05-31', '2021-10-10', 'EF8A8413FD0241A6A33602EA7F3A0339');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '福卓有限责任公司', '贷款,开通票据提醒', '2021-06-01', '2021-10-10', '1DC74A61F06B4A51A49C4CBFA4D18B02');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '旋展有限责任公司', '国际业务', '2021-06-01', '2021-10-10', 'A56B655A786A4024AB6A186A1C2CAE04');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '和盈有限责任公司', '托管业务', '2021-06-01', '2021-10-10', 'E595E49ABBE07E2BE382A9730');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '财营有限责任公司', '代发工资', '2021-06-01', '2021-10-10', 'B7A58CE9034A47098D4F1B8C50EC68A5');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '子佩有限责任公司', '模拟利润', '2021-06-01', '2021-10-10', '1044E43F6E9C451F8EDF6E4FDA');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '海真有限责任公司', '票据业务', '2021-06-02', '2021-10-10', '7DE2B44730BEF9DA5A');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '时新有限责任公司', '办理易收宝,易收宝开通', '2021-06-02', '2021-10-10', '5D8F46C9E42C4CF78B9E6AD01880A0DF');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '士坚有限责任公司', '好生意,模拟利润', '2021-06-02', '2021-10-10', '4C72E1015D4B47E9A73D3BBEACA4002D');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '和元有限责任公司', '贷款,存款', '2021-06-02', '2021-10-10', '570D4CB83547D2C3B19BFB');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '旋和有限责任公司', '易收宝开通,国际业务', '2021-06-02', '2021-10-10', 'D8216CFB66B28F1C4230B8FF47');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', null, '0000', '优斯有限责任公司', '易收宝微信认证,国际业务', '2021-06-02', '2021-10-10', '6B4071B1B4C7565C6ED2C');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,,', '0000', '力月发展有限公司', '模拟利润,贷款', '2021-06-02', '2021-10-10', 'C8F808FE5E0A4CC78343E86179BDC0DF');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '联奥发展有限公司', '国际业务,贷款', '2021-06-02', '2021-10-10', '870BB2429CBAEEBF39EDD87328');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '营和发展有限公司', '易收宝微信认证', '2021-06-02', '2021-10-10', 'D332DA127E764BEC89CFF1C18CF00B4F');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '优复发展有限公司', '国际业务,好生意收款', '2021-06-03', '2021-10-10', '6FE4635AECAC3C1E6B9F6E7631');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '裕来发展有限公司', '托管业务', '2021-06-03', '2021-10-10', 'F0BAA5A4BFEF8D02D139A44A38');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '铭驰发展有限公司', '模拟利润', '2021-06-03', '2021-10-10', '9234E6879ABD56C');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '旭开发展有限公司', '新客户维护', '2021-06-03', '2021-10-10', 'DE09A46B0A28F9674C55AF345');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '吉典发展有限公司', '开通票据提醒', '2021-06-03', '2021-10-10', 'E69F1D33EB044D6DAD7846DFDD005796');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '洲旭发展有限公司', '新客户维护', '2021-06-04', '2021-10-10', '5CDBD8F0AFED4429A40CF8E9EDC4FB40');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '涛江发展有限公司', '国际业务,好生意收款,托管业务', '2021-06-04', '2021-10-10', 'E3A0264E54AF41DC9347D83330C3366D');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '维拓发展有限公司', '代发工资,模拟利润', '2021-06-04', '2021-10-10', 'ADAF134B42BA6BC3E5DF7E66F2');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '宜亿发展有限公司', '存款', '2021-06-04', '2021-10-10', 'C75A0A11E84E407CABD90EDDE1');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '坚鑫有限责任公司', '维护客户', '2021-05-08', '2021-10-10', '0307E85E35C54985A4C62429FE5982E3');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '林涛发展有限公司', '易收宝开通,国际业务,好生意收款', '2021-06-04', '2021-10-10', 'D277D451F3A9A');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '汇友发展有限公司', '贷款', '2021-06-04', '2021-10-10', 'C20636E8CC0E49B0A9ED8253EE24B0A9');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '盈佩发展有限公司', '模拟利润', '2021-06-04', '2021-10-10', '8AB8C063302A416F873B272B9E7B3DF1');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '缘聚发展有限公司', '开通票据提醒', '2021-06-05', '2021-10-10', '41D1EE2EDFC6EF9031F504A5');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '同西发展有限公司', '办理易收宝,易收宝开通', '2021-06-05', '2021-10-10', '3C0E4F5B88B345CC8F4F16A5F01FDBA2');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '克罗发展有限公司', '好生意,模拟利润', '2021-06-05', '2021-10-10', '30BCABAD1E144B6F80BA930CFF795FC6');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '梦华发展有限公司', '贷款,存款', '2021-06-05', '2021-10-10', 'B987BC7638F5481F86F59038BBB09D2F');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '优坚发展有限公司', '易收宝开通,国际业务', '2021-06-05', '2021-10-10', 'BEB43ABA4F75B20415A770B');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '具硕有限责任公司', '中间业务', '2021-06-02', '2021-10-10', 'DB94BA098C2240B2AC508BE62DC67351');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '美名有限责任公司', '客户维护', '2021-06-02', '2021-10-10', '7DFE7B2633D941E5BD50C6D85A0AD88F');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '辉星发展有限公司', '代发工资', '2021-06-03', '2021-10-10', 'DE12A3ACD8A04C8AB4CD8DE93508A9BA');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '好金发展有限公司', '托管业务,好生意收款', '2021-06-04', '2021-10-10', 'FA9B08FF56FA4265A6FE8340E6E6FC57');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '达尚有限责任公司', '维护客户', '2021-05-02', '2021-10-10', 'CB54274EEC94B8E7A2662F31DD');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '达尚有限责任公司', '维护客户', '2021-05-03', '2021-10-10', '661C3733F66846FFABD86FDD2CE0CD9C');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '坚鑫有限责任公司', '维护客户', '2021-05-04', '2021-10-10', 'AD3DB87181C84DB9853A8AF199B33D56');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '坚鑫有限责任公司', '维护客户', '2021-05-09', '2021-10-10', '4AE1E48D38B34D6A8A9C1FE3F9708A09');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '吉凡有限责任公司', '易收宝', '2021-05-01', '2021-10-10', '900BB6FD4BA642BABC019E44D9293E86');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '达识有限责任公司', '好生意', '2021-05-01', '2021-10-10', '0406D1DDE3604AF6860EDE141FDC2F9D');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '博京有限责任公司', '易收宝开通', '2021-05-02', '2021-10-10', '04ED5FD951B34872A0CBA1602C9A40BD');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '百纽有限责任公司', '易收宝微信认证', '2021-05-03', '2021-10-10', '1801CB69A19DD73E52B37C38');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '赛事有限责任公司', '国际业务,好生意收款', '2021-05-04', '2021-10-10', 'DF651EB41D4B4A128BBD5920AA7DD758');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '达尚有限责任公司', '托管业务', '2021-05-05', '2021-10-10', 'D0286D2C34D24F98A7BD336BF4EF2F61');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '明成有限责任公司', '代发工资', '2021-05-06', '2021-10-10', 'BCE666F56AAF44E9AEEDC0C2F3DEF035');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '坚鑫有限责任公司', '模拟利润', '2021-05-07', '2021-10-10', '1FC87DC293FD43CEBF1B9EDDA6');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '顿开有限责任公司', '中间业务', '2021-05-08', '2021-10-10', 'B61B901D2F4546D4A4EEEA02AEE43114');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '奥惠有限责任公司', '票据业务', '2021-05-09', '2021-10-10', '40AB26A14C644CC7733F0864F0');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '宇立有限责任公司', '理财', '2021-05-10', '2021-10-10', '2881AA496EADF5C978BB5FBE5E');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,,', '0000', '太鑫有限责任公司', '存款', '2021-05-11', '2021-10-10', '64D3DE7ED9296E1DACE');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '相智有限责任公司', '办理易收宝', '2021-05-12', '2021-10-10', '8BAF08DBD1CB6BA4172A9C72C4');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '金系有限责任公司', '贷款，国际贷款', '2021-05-13', '2021-10-10', 'C592EA59CFFC4D14AB9063C65F23BD95');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '京亿有限责任公司', '上市理财', '2021-05-14', '2021-10-10', 'F5F4D73D050C479EA611B7B5FEEAB5A8');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '涛建有限责任公司', '开通票据提醒', '2021-05-15', '2021-10-10', 'D7FD3389AA3C49BBFE2F1925');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '庆铁有限责任公司', '反洗钱提醒', '2021-05-16', '2021-10-10', 'B6B5D40ACF984C039D2E8A61E917CC7D');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '览相有限责任公司', '老客户维护', '2021-05-17', '2021-10-10', '0AEF30EB2C57081C5');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '凡诺有限责任公司', '新客户维护', '2021-05-18', '2021-10-10', '1CA57DBB9B8F40DEA60AE7E4A0FAE166');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '频亚有限责任公司', '存款', '2021-05-19', '2021-10-10', '712D0BBFBC46E5229CA88');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', null, '0000', '清爱有限责任公司', '存款', '2021-05-20', '2021-10-10', 'C9CEBE4CE99296DDC009E86D54');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '天复有限责任公司', '易收宝', '2021-05-21', '2021-10-10', '0E4BF38933C8DBED00402E');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '和优有限责任公司', '好生意', '2021-05-21', '2021-10-10', '5C666E00348C48CA904D4C3B81148FBF');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '玉营有限责任公司', '易收宝开通', '2021-05-21', '2021-10-10', 'B4FC46296D304DD29055EE4A0419BF26');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '仕正有限责任公司', '易收宝微信认证', '2021-05-21', '2021-10-10', '8F7DB00D9F844EB099DC1FBF79769A4E');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '长蓝有限责任公司', '国际业务,好生意收款', '2021-05-21', '2021-10-10', '328B9F18CB334AC2F1FC96E33A');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '览驰有限责任公司', '托管业务', '2021-05-22', '2021-10-10', '9489A817BA3B45FEA61467EF4D09A1AD');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', null, '0000', '顺大有限责任公司', '代发工资', '2021-05-23', '2021-10-10', 'E6A583AEFD2248DBB95CED97E8C67F20');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', null, '0000', '翔百有限责任公司', '模拟利润', '2021-05-23', '2021-10-10', '1EF582BE5C674D538F849FC07F1A5578');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', null, '0000', '和优有限责任公司', '新客户维护', '2021-05-23', '2021-10-10', '61221C8AE943E79DEE9EAFE1D');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', null, '0000', '玉营有限责任公司', '开通票据提醒', '2021-05-23', '2021-10-10', 'D2A0B935FBA9C78AC74CC');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', null, '0000', '仕正有限责任公司', '新客户维护', '2021-05-24', '2021-10-10', 'F4A71AE920DE4BAAB21AD2B71');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '正妙有限责任公司', '国际业务,好生意收款,托管业务', '2021-05-24', '2021-10-10', '82EB8D84047C4E40B7581EF10735F25E');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '富旭有限责任公司', '托管业务,好生意收款', '2021-05-24', '2021-10-10', '2F373AB72FBB4F77B2EF12FA6');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '茂友有限责任公司', '代发工资,模拟利润', '2021-05-24', '2021-10-10', 'A4D6996BCE82492DBE81888DC');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '领码有限责任公司', '存款', '2021-05-24', '2021-10-10', '62FD13478A9E5AADBD7A');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,', '0000', '春鸿有限责任公司', '易收宝开通,国际业务,好生意收款', '2021-05-25', '2021-10-10', '61F5A32FBBB49A5B2F896BE715');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '联相有限责任公司', '贷款', '2021-05-25', '2021-10-10', 'B759A53BFFE60');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '木圆有限责任公司', '模拟利润', '2021-05-25', '2021-10-10', '421E831BAEB018E3EC88A45BB8');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', '', '0000', '实川有限责任公司', '开通票据提醒', '2021-05-25', '2021-10-10', '6D640E6A4E4B4CCEBF876F6CFC');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '电娇有限责任公司', '办理易收宝,易收宝开通', '2021-05-25', '2021-10-10', '8979E3DC750B4366BA85A751DF290B59');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',,,', '0000', '飞尼有限责任公司', '好生意,模拟利润', '2021-05-26', '2021-10-10', '87C2C5B4AE07456E81DFDB0EFE8CDAE3');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '优盛有限责任公司', '贷款,存款', '2021-05-26', '2021-10-10', 'DC04DFE9524C48058B720EDF1');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '欣基有限责任公司', '易收宝开通,国际业务', '2021-05-26', '2021-10-10', '0CD75397D3AC48299A713C253D9C4C31');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('', ',', '0000', '欧冠有限责任公司', '客户维护', '2021-05-26', '2021-10-10', '675DAC5E652B4BFFBEF33FB44F5681C6');
prompt Done.
3、
prompt Importing table CC_SYS_EMPLOYEES...
set feedback off
set define off
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '柳长逸', 'D0377', '1', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '柳长逸', 'D0377', '1', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '凤嘉慕', 'D0382', '0', '项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '花飞雨', 'D0378', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '方天成', 'D0375', '1', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '俞天空', 'D0374', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '任开霁', 'D0377', '1', '票据业务经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '袁明珠', 'D0378', '1', '支行行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '如萱', 'D0323', '0', '信贷执行官', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '晓亦', 'D0325', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '以蕊', 'D0325', '0', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王展鹏', 'D0328', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '蒋志行', 'D0333', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '姚正豪', 'D0333', '0', '信贷执行官', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '崔振海', 'D0338', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '崔正初', 'D0340', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '孙正青', 'D0346', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '孙正文', 'D0346', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '孙正祥', 'D0349', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '杨正真', 'D0347', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '蒋志强', 'D0350', '0', '零售项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '黄志明', 'D0350', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '陈志用', 'D0352', '0', '零售项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向智鑫', 'D0356', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向智勇', 'D0356', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '谢子晋', 'D0357', '0', '理财经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '谢子明', 'D0357', '0', '助理经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '赵静曼', 'D0358', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '李念露', 'D0359', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王代真', 'D0359', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '褚冷卉', 'D0360', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '沈恨天', 'D0361', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '朱怀蝶', 'D0362', '0', '个人项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '何恨松', 'D0363', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '张白易', 'D0364', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '华丹珍', 'D0365', '0', '个人项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '陶落花', 'D0365', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '谢乐丹', 'D0366', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '水冰露', 'D0367', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '云乐萱', 'D0368', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '葛子瑜', 'D0369', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '郎鸿博', 'D0370', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '昌志尚', 'D0373', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '凤嘉慕', 'D0382', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '任开霁', 'D0377', '1', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '潘石屹', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王石', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '蒋锡培', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向文波', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '牛根生', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '熊晓鸽', 'D0290', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王冉', 'D0290', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '于清教', 'D0290', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '谢清海', 'D0291', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '刘旗辉', 'D0291', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '刘步尘', 'D0291', '0', '理财经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '陈达夫', 'D0291', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '船长', 'D0291', '0', '内控经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '叶茂中', 'D0291', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '李士福', 'D0291', '0', '助理经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王进生', 'D0291', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '任志强', 'D0291', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '付伟', 'D0291', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '孙虹钢', 'D0292', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '宋新宇', 'D0292', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王微', 'D0292', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '翁向东', 'D0292', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '周济谱', 'D0292', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '袁岳', 'D0292', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '成君忆', 'D0292', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '艾学蛟', 'D0293', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '雷永军', 'D0293', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '刘秋华', 'D0293', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '宋炜', 'D0293', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '刘东华', 'D0293', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '科特勒', 'D0293', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '陈志列', 'D0293', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '张巨峰', 'D0294', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '姚日来', 'D0294', '0', '信息科技部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '李朝曙', 'D0294', '0', '财信部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '刘兴亮', 'D0294', '0', '零售营销管理部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '梦琪', 'D0294', '0', '资产托管部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '忆柳', 'D0294', '0', '信贷科长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '之桃', 'D0294', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '慕青', 'D0295', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '问兰', 'D0295', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '尔岚', 'D0295', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '元 香', 'D0295', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '初夏', 'D0295', '0', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '沛菡', 'D0295', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '傲珊', 'D0326', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '曼文', 'D0326', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '乐菱', 'D0326', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '痴珊', 'D0326', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '恨玉', 'D0326', '0', '运营经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '惜文', 'D0326', '0', '客户管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '香寒', 'D0326', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '新柔', 'D0330', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '语蓉', 'D0330', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '海安', 'D0330', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '夜蓉', 'D0330', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '涵柏', 'D0330', '0', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '水桃', 'D0330', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '醉蓝', 'D0330', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '春儿', 'D0345', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '语琴', 'D0345', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '从彤', 'D0345', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '傲晴', 'D0345', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '语兰', 'D0345', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '又菱', 'D0345', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '碧彤', 'D0345', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '元霜', 'D0345', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '怜梦', 'D0348', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '紫寒', 'D0348', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '妙彤', 'D0348', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '曼易', 'D0348', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '南莲', 'D0348', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '紫翠', 'D0348', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '雨寒', 'D0323', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '易烟', 'D0323', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '若南', 'D0323', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '寻真', 'D0323', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向珊', 'D0325', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '慕灵', 'D0325', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '寻雁', 'D0328', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '映易', 'D0328', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '雪柳', 'D0328', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王哲瀚', 'D0333', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '姚正德', 'D0333', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '蒋志学', 'D0333', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '姚正浩', 'D0333', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王哲茂', 'D0338', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王哲圣', 'D0338', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王哲彦', 'D0338', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '崔振国', 'D0338', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '崔正诚', 'D0340', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王正平', 'D0340', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '孙正奇', 'D0340', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '谢子墨', 'D0346', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '谢子平', 'D0346', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '孙正卿', 'D0346', '0', '信贷执行官', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '杨正雅', 'D0346', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '杨正阳', 'D0349', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '孙正信', 'D0349', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '杨正业', 'D0349', '0', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '杨正谊', 'D0349', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '黄正志', 'D0347', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '黄志诚', 'D0347', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '黄志新', 'D0347', '0', '对公项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '蒋志尚', 'D0350', '0', '个人项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '黄志勇', 'D0350', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '黄志国', 'D0350', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '蒋志专', 'D0350', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '蒋志文', 'D0352', '0', '对公项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '陈志泽', 'D0352', '0', '个人项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向致远', 'D0352', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向智明', 'D0352', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '陈志业', 'D0356', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '陈志义', 'D0356', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向智敏', 'D0356', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向子安', 'D0357', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '谢子民', 'D0357', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向智志', 'D0357', '0', '内控经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '向智渊', 'D0357', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '王文斌', 'D0358', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '谢子默', 'D0358', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '钱凡旋', 'D0358', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '孙以亦', 'D0358', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '周芷蕾', 'D0359', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '吴千兰', 'D0359', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '郑新波', 'D0359', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '冯新蕾', 'D0359', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '陈雁玉', 'D0359', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '卫紫山', 'D0361', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '蒋千琴', 'D0361', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '韩傲芙', 'D0361', '0', '对公项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '杨盼山', 'D0361', '0', '零售项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '秦冰兰', 'D0362', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '尤山柏', 'D0362', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '许翠萱', 'D0362', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '吕美丽', 'D0363', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '施从南', 'D0363', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '孔问筠', 'D0364', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '曹如霜', 'D0365', '0', '对公项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '严半芹', 'D0365', '0', '零售项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '金冰彤', 'D0365', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '魏亦寒', 'D0365', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '姜怜云', 'D0366', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '戚寻文', 'D0366', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '邹翠柔', 'D0366', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '喻谷山', 'D0366', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '柏之瑶', 'D0367', '0', '信贷执行官', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '窦尔珍', 'D0367', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '章谷雪', 'D0367', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '苏涵菡', 'D0368', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '潘宏远', 'D0368', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '奚英逸', 'D0369', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '范翔飞', 'D0370', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '彭英才', 'D0370', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '鲁志专', 'D0370', '0', '运营经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '韦弘方', 'D0373', '0', '客户管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '马风睿', 'D0373', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '苗振荣', 'D0381', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '花飞雨', 'D0378', '1', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '方天成', 'D0375', '1', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '俞天空', 'D0374', '1', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('', '袁明珠', 'D0378', '1', '金融市场部职员', '2021-10-10');
prompt Done.
4、
prompt Importing table ORG_TREE_MAPPING...
set feedback off
set define off
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0290', '上海黄浦外滩支行', '3', '0', 'S1002');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0291', '上海黄浦淮海中路支行', '3', '0', 'S1002');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0292', '上海黄浦豫园支行', '3', '0', 'S1002');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0293', '上海黄浦打浦桥支行', '3', '0', 'S1002');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0294', '北京通州马驹桥支行', '3', '0', 'S1003');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0295', '北京通州宋庄支行', '3', '0', 'S1003');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0326', '北京通州漷县支行', '3', '0', 'S1003');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0330', '深圳龙岗坂田支行', '3', '0', 'S1001');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0345', '深圳龙岗横岗营业部', '3', '0', 'S1001');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0348', '深圳龙岗龙城支行总经理办公室', '3', '0', 'S1001');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0323', '南京玄武昆仑支行', '3', '0', 'S1006');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0325', '南京玄武廖家巷支行', '3', '0', 'S1006');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0328', '南京玄武台城花园支行', '3', '0', 'S1006');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0333', '南京玄武高楼门支行', '3', '0', 'S1006');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0338', '南京玄武百子亭支行', '3', '0', 'S1006');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0340', '南京玄武百子亭支行', '3', '0', 'S1006');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0346', '杭州萧山义桥支行', '3', '0', 'S100N');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0349', '杭州萧山瓜沥支行', '3', '0', 'S100N');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0347', '杭州萧山戴村支行', '3', '0', 'S100N');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0350', '杭州萧山河上支行', '3', '0', 'S100N');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0352', '杭州萧山钱塘江支行', '3', '0', 'S100N');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0356', '无锡锡山厚桥营业部', '3', '0', 'S100C');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0357', '无锡锡山安镇街道营业部', '3', '0', 'S100C');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0358', '无锡锡山东亭街道办事处', '3', '0', 'S100C');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0359', '无锡锡山厚桥营业部', '3', '0', 'S100C');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0360', '金华金东罗店镇支行', '3', '0', 'S1008');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0361', '金华金东琅琊镇支行', '3', '0', 'S1008');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0362', '金华金东汤溪镇支行', '3', '0', 'S1008');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0363', '宁波鄞州分行行长办公室', '3', '0', 'S100S');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0364', '绍兴柯桥安昌镇支行', '3', '0', 'S100Q');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0365', '绍兴柯桥钱清镇支行', '3', '0', 'S100Q');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0366', '绍兴柯桥分行总经理办公室', '3', '0', 'S100Q');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0367', '嘉兴南湖凤桥支行', '3', '0', 'S100M');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0368', '嘉兴南湖余新镇支行', '3', '0', 'S100M');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0369', '嘉兴南湖洪合镇支行', '3', '0', 'S100M');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0370', '衢州开化苏庄镇支行', '3', '0', 'S1009');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0381', '衢州开化马金镇支行', '3', '0', 'S1009');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0382', '衢州开化桐村镇支行', '3', '0', 'S1009');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0387', '衢州开化马金镇支行', '3', '0', 'S1009');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0373', '苏州昆山巴城镇支行', '3', '0', 'S1007');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0374', '郑州新郑薛店镇支行', '3', '0', 'S012');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0375', '合肥蜀山五里墩支行', '3', '0', 'S013');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0375', '兰州城关庆阳路支行', '3', '0', 'S015');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0377', '长沙雨花侯家塘营业部', '3', '0', 'S018');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0377', '武汉东西湖办事处', '3', '0', 'S013');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('D0378', '石家庄裕华宋营支行', '3', '0', 'S017');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1002', '上海黄浦分行', '2', '0', '12');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1002', '上海黄浦分行', '2', '0', '12');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1002', '上海黄浦分行', '2', '0', '12');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1002', '上海黄浦分行', '2', '0', '12');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1003', '北京通州分行', '2', '0', '13');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1003', '北京通州分行', '2', '0', '13');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1003', '北京通州分行', '2', '0', '13');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1001', '深圳龙岗分行', '2', '0', '15');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1001', '深圳龙岗分行', '2', '0', '15');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1001', '深圳龙岗分行', '2', '0', '15');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1006', '南京玄武分行', '2', '0', '17');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1006', '南京玄武分行', '2', '0', '17');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1006', '南京玄武分行', '2', '0', '17');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1006', '南京玄武分行', '2', '0', '19');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1006', '南京玄武分行', '2', '0', '19');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1006', '南京玄武分行', '2', '0', '19');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100N', '杭州萧山分行', '2', '0', '21');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100N', '杭州萧山分行', '2', '0', '21');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100N', '杭州萧山分行', '2', '0', '21');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100N', '杭州萧山分行', '2', '0', '21');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100N', '杭州萧山分行', '2', '0', '21');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100C', '无锡锡山分行', '2', '0', '23');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100C', '无锡锡山分行', '2', '0', '23');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100C', '无锡锡山分行', '2', '0', '23');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100C', '无锡锡山分行', '2', '0', '23');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1008', '金华金东分行', '2', '0', '25');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1008', '金华金东分行', '2', '0', '25');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1008', '金华金东分行', '2', '0', '25');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100S', '宁波鄞州分行', '2', '0', '26');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100Q', '绍兴柯桥分行', '2', '0', '30');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100Q', '绍兴柯桥分行', '2', '0', '30');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100Q', '绍兴柯桥分行', '2', '0', '30');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100M', '嘉兴南湖分行', '2', '0', '33');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100M', '嘉兴南湖分行', '2', '0', '33');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S100M', '嘉兴南湖分行', '2', '0', '33');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1009', '衢州开化分行', '2', '0', '36');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1009', '衢州开化分行', '2', '0', '36');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1009', '衢州开化分行', '2', '0', '36');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1009', '衢州开化分行', '2', '0', '36');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S1007', '苏州昆山分行', '2', '0', '37');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S012', '郑州新郑分行', '2', '0', '39');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S013', '合肥蜀山分行', '2', '0', '45');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S015', '兰州城关分行', '2', '0', '47');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S018', '长沙雨花分行', '2', '0', '48');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S013', '武汉东西湖分行', '2', '0', '50');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('S017', '石家庄裕华分行', '2', '0', '49');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('12', '上海分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('13', '北京分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('15', '深圳分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('17', '南京分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('19', '广州分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('21', '杭州分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('23', '无锡分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('25', '金华分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('26', '宁波分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('30', '绍兴分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('33', '嘉兴分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('36', '衢州分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('37', '苏州分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('39', '郑州分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('45', '合肥分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('47', '兰州分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('48', '长沙分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('50', '武汉分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('49', '石家庄分行', '1', '0', '1');
insert into ORG_TREE_MAPPING (ORG_ID, ORG_NAME, ORG_LVL, ORG_STUS, ADMIN_ORG_ID)
values ('1', '全行汇总', null, null, null);
prompt Done.
以下是需要这些表的需求：
-----根据总行要求，目前员工拜访客户存在恶意拜访行为，现需要做一个员工访客表，同一个员工
--拜访同一客户，一周不能超过两次，超过两次算无效拜访，拜访人和陪访人员，
--必须是客户经理，或者是团队队长或者是直系管护人，否则属于无效拜访，
--现需要数据周一到周末员工的有效拜访次数，周四到到上周五
--的有效拜访次数，一月的有效拜访次数
---现根据要求，无效访客多少次，有效访客次数都显示出来
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请联系我们，一经查实，本站将立刻删除。
如需转载请保留出处：https://51itzy.com/kjqy/71137.html