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 '上级机构';
以上是建表语句，以下是插入内容：
1、
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 ('02FA1D11B2504274AFABF9D464D6E278', '0000151007', '光邦有限责任公司', '131407', '潘石屹', '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 ('32827FD357964E6EA1DD98D41E8C8071', '0000151008', '吉凡有限责任公司', '131408', '王石', '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', '0000151009', '达识有限责任公司', '131409', '蒋锡培', '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', '0000151010', '梦本有限责任公司', '131410', '向文波', '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 ('AF3FC975760240ADB461407C1227E7BF', '0000151011', '博京有限责任公司', '131411', '牛根生', '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 ('76D6077C82E04DD2815E933539D8990D', '0000151012', '百纽有限责任公司', '131412', '熊晓鸽', '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', '0000151013', '赛事有限责任公司', '131413', '王冉', '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 ('6D948FE4A3F942149EF3F559B9D9E2A4', '0000151014', '网丝有限责任公司', '131414', '于清教', '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 ('C2E0FBE6F6B84CA5A447246B9939F33F', '0000151015', '达尚有限责任公司', '131415', '谢清海', '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', '0000151016', '明成有限责任公司', '131416', '刘旗辉', '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 ('8A49438F25214106A9B29C1EB8BFFA07', '0000151017', '易惠有限责任公司', '131417', '刘步尘', '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 ('0FC22EB537184E199F85B6C87AAB583F', '0000151018', '坚鑫有限责任公司', '131418', '陈达夫', '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 ('39ADDB4350364214B1FDE445F3E7BE30', '0000151019', '顿开有限责任公司', '131419', '船长', '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 ('E6627462AD54478A9EA4FE75CC912BCE', '0000151020', '奥惠有限责任公司', '131420', '叶茂中', '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 ('0A49E5AE59284975ABDDDAE98AB4F588', '0000151021', '新具有限责任公司', '131421', '李士福', '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 ('913262563DB34995A7798B44395764FC', '0000151022', '宇立有限责任公司', '131422', '王进生', '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 ('01E058DB2D324111826D59093986EFCC', '0000151023', '太鑫有限责任公司', '131423', '任志强', '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 ('1883D197F29343B5B444043E468CE8A3', '0000151024', '莱风有限责任公司', '131424', '付伟', '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 ('3D5963E10C334D379565ED6331CEBC94', '0000151025', '相智有限责任公司', '131425', '孙虹钢', '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 ('62351A54FA404193AC7B0BFFA835FD85', '0000151026', '金系有限责任公司', '131426', '宋新宇', '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 ('6A963C5979FB4FF2BE57BD553445CCB3', '0000151027', '京亿有限责任公司', '131427', '王微', '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 ('30257D3150744519817C9E71EAE2BBB2', '0000151028', '力智有限责任公司', '131428', '翁向东', '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', '0000151029', '涛建有限责任公司', '131429', '周济谱', '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 ('63C9FF6BC142424491162C3B1B20E7D1', '0000151030', '庆铁有限责任公司', '131430', '袁岳', '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 ('CA95D5A2913B4E4499899956DEA67EBD', '0000151031', '辉诺有限责任公司', '131431', '成君忆', '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 ('60E86053A4C54480BAF26E0C37746679', '0000151032', '览相有限责任公司', '131432', '艾学蛟', '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 ('749614735BA448848D200128A2C85962', '0000151033', '凡诺有限责任公司', '131433', '雷永军', '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 ('029399569A6F4C2FBC1A98FF4B7DEFF5', '0000151034', '频亚有限责任公司', '131434', '刘秋华', '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 ('184F1426EACB484497061E84EAE8B811', '0000151035', '尼迪有限责任公司', '131435', '宋炜', '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', '0000151036', '清爱有限责任公司', '131436', '刘东华', '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', '0000151037', '天复有限责任公司', '131437', '科特勒', '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 ('C3C02D0FC19147539BBFEE1A9A548CC0', '0000151038', '成特有限责任公司', '131438', '陈志列', '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 ('BC3BE94987404E958D156F2DDA97A8C7', '0000151039', '和优有限责任公司', '131439', '张巨峰', '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 ('E0C611481D5D44F990EF3402EC20CB24', '0000151040', '玉营有限责任公司', '131440', '姚日来', '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', '0000151041', '派佳有限责任公司', '131441', '李朝曙', '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 ('AE7739A546E24E669534D14F36A82272', '0000151042', '仕正有限责任公司', '131442', '刘兴亮', '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', '0000151043', '正妙有限责任公司', '131443', '梦琪', '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 ('E74935F28CCF4DAA8F5D4F6118178A79', '0000151044', '富旭有限责任公司', '131444', '忆柳', '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', '0000151045', '木先有限责任公司', '131445', '之桃', '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 ('1EC86D3119024063813AEFE79069001E', '0000151046', '茂友有限责任公司', '131446', '慕青', '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 ('812721C3F2504B9D8ED76C117FBD6CDE', '0000151047', '领码有限责任公司', '131447', '问兰', '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 ('5B824DCD50CA4AC2A4749881EF2C1533', '0000151048', '速腾有限责任公司', '131448', '尔岚', '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 ('B67EB3001C534665AECCFC7590D8D5B0', '0000151049', '春鸿有限责任公司', '131449', '元 香', '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', '0000151050', '联相有限责任公司', '131450', '初夏', '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', '0000151051', '木圆有限责任公司', '131451', '沛菡', '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', '0000151052', '尚具发展有限公司', '131452', '傲珊', '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 ('B260B5ACE59543069521FA3DF4B35675', '0000151053', '高赛有限责任公司', '131453', '曼文', '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 ('C1F71676475547C681C73A9E30B00D72', '0000151054', '长蓝有限责任公司', '131454', '乐菱', '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 ('E0EB0E9E485D4E5DA4CF232541F73005', '0000151055', '览驰有限责任公司', '131455', '痴珊', '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 ('415690E34EB24006A06C92D8E4614B2C', '0000151056', '码庆发展有限公司', '131456', '恨玉', '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 ('9B580882F2C34F33BD2638C4504F46FB', '0000151057', '百川有限责任公司', '131457', '惜文', '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 ('3BF8B7B145704B5BA11804C489E65C63', '0000151058', '顺大有限责任公司', '131458', '香寒', '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', '0000151059', '诗亿发展有限公司', '131459', '新柔', '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 ('CA4E59CCC1EC4BBD87CD7E845234558A', '0000151060', '翔百有限责任公司', '131460', '语蓉', '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', '0000151061', '实川有限责任公司', '131461', '海安', '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', '0000151062', '裕实有限责任公司', '131462', '夜蓉', '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 ('60C8281128024A718FFBC2559FC87AF6', '0000151063', '仕日发展有限公司', '131463', '涵柏', '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', '0000151064', '电娇有限责任公司', '131464', '水桃', '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 ('823901D742604DB484073F27F09993FB', '0000151065', '飞尼有限责任公司', '131465', '醉蓝', '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 ('19A80BEB0E5744DD8A3B47162755F7AD', '0000151066', '惠集有限责任公司', '131466', '春儿', '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', '0000151067', '爱贵发展有限公司', '131467', '语琴', '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 ('C379742302194F57AC45D2EC2E171197', '0000151068', '优盛有限责任公司', '131468', '从彤', '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', '0000151069', '欣基有限责任公司', '131469', '傲晴', '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 ('9E0DD1A7B6DE4BE492138D3010BF3237', '0000151070', '爱森发展有限公司', '131470', '语兰', '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', '0000151071', '晶旺有限责任公司', '131471', '又菱', '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 ('AD50771834434292BAEF07C3A55CD129', '0000151200', '玉志发展有限公司', '131600', '凤嘉慕', '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', '0000151072', '欧冠有限责任公司', '131472', '碧彤', '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', '0000151073', '双成有限责任公司', '131473', '元霜', '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 ('FC81CC59E38141568BFCB54C1F6A71B7', '0000151074', '皇健发展有限公司', '131474', '怜梦', '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 ('038F94C078E946398362E26B4B602516', '0000151075', '典和有限责任公司', '131475', '紫寒', '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 ('0D3A5F801500452D9A9858A43FC18B61', '0000151076', '迪庆有限责任公司', '131476', '妙彤', '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 ('8D8C449185BA46D1B96E7F9C6A096343', '0000151077', '益驰发展有限公司', '131477', '曼易', '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 ('D723848AAFE3421A97E05095200F0C39', '0000151078', '汉爱有限责任公司', '131478', '南莲', '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 ('5CC17766BC2247669FB59F3D808E8967', '0000151079', '和盈有限责任公司', '131479', '紫翠', '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 ('36262F8A1938411EBC07F29E2A031FF7', '0000151080', '雅力有限责任公司', '131480', '雨寒', '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 ('CCC12690A78D49A699AA1B2D0879004F', '0000151081', '实斯发展有限公司', '131481', '易烟', '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', '0000151082', '财营有限责任公司', '131482', '如萱', '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 ('04AA606ECAC64C1DBE40C7E4C226236C', '0000151083', '子佩有限责任公司', '131483', '若南', '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 ('6B923CDFCEB64C38AF1E8518D295099F', '0000151084', '真百发展有限公司', '131484', '寻真', '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 ('A042E099166A4970808D8153A7668539', '0000151085', '具硕有限责任公司', '131485', '晓亦', '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', '0000151086', '维原有限责任公司', '131486', '向珊', '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 ('05883543AFA641F6BBD1F29D210DF7EF', '0000151087', '海真有限责任公司', '131487', '慕灵', '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 ('4E86953A27044272ADA3154A7887EA66', '0000151088', '豪妙发展有限公司', '131488', '以蕊', '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', '0000151089', '时新有限责任公司', '131489', '寻雁', '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 ('1011E15B923049CFBC74D0A7D776E32C', '0000151090', '倍妙有限责任公司', '131490', '映易', '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', '0000151091', '驰缘发展有限公司', '131491', '雪柳', '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 ('E1C968815A1840929FF56AFC9EB505EE', '0000151092', '士坚有限责任公司', '131492', '王展鹏', '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 ('C4524FE2133A4EB89588007F58E8C918', '0000151093', '和元有限责任公司', '131493', '王哲瀚', '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 ('7C191117CAA149579D97BFBC86EA828D', '0000151094', '旋和有限责任公司', '131494', '姚正德', '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', '0000151095', '瑞浩发展有限公司', '131495', '蒋志行', '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', '0000151096', '明翔有限责任公司', '131496', '蒋志学', '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 ('81D1F8C933594228A8B82A99AA09EA95', '0000151097', '美名有限责任公司', '131497', '姚正浩', '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', '0000151098', '吉码发展有限公司', '131498', '姚正豪', '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', '0000151099', '优斯有限责任公司', '131499', '王哲茂', '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 ('884D3B864D234A77811E24653840BE37', '0000151100', '洁飞有限责任公司', '131500', '王哲圣', '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 ('967B4AEA9688411486AC3BA341FDAFC5', '0000151101', '东彩有限责任公司', '131501', '王哲彦', '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', '0000151102', '志语发展有限公司', '131502', '崔振海', '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', '0000151103', '纳实有限责任公司', '131503', '崔振国', '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', '0000151104', '吉圆有限责任公司', '131504', '崔正诚', '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', '0000151105', '月霆有限责任公司', '131505', '崔正初', '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 ('9B9934412BDD48379F64BBCA26E485F0', '0000151106', '爱用发展有限公司', '131506', '王正平', '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 ('5BC9156545FE4F31A8302E09084C54EB', '0000151107', '环太有限责任公司', '131507', '孙正奇', '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 ('B7295890A9BA4DA8BBF495E9E54FA88D', '0000151108', '福卓有限责任公司', '131508', '孙正青', '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 ('969E52E127974DE6804DC70461CA6FE7', '0000151109', '和邦发展有限公司', '131509', '谢子墨', '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', '0000151110', '系环有限责任公司', '131510', '谢子平', '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 ('E372B7EF703046A396F622AFB6F3094B', '0000151111', '旋展有限责任公司', '131511', '孙正卿', '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 ('AE2011E5C22444918482D9CFA4790552', '0000151112', '磊邦有限责任公司', '131512', '孙正文', '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', '0000151113', '火赛发展有限公司', '131513', '杨正雅', '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', '0000151114', '好雷有限责任公司', '131514', '杨正阳', '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 ('02D850719C9F4140A6D0CE62E55FC068', '0000151115', '磊频有限责任公司', '131515', '孙正祥', '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 ('AD19D0C7D44340598CB46A2BA5403403', '0000151116', '财雅发展有限公司', '131516', '孙正信', '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', '0000151117', '隆宇有限责任公司', '131517', '杨正业', '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', '0000151118', '速雅有限责任公司', '131518', '杨正谊', '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 ('59EA947D0D954286B6B7341590067A63', '0000151119', '佩佳有限责任公司', '131519', '杨正真', '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 ('F6B1020C5B114561A4AB67CB67F82FD1', '0000151120', '安百发展有限公司', '131520', '黄正志', '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', '0000151121', '巨远有限责任公司', '131521', '黄志诚', '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 ('52798A62CCC1443282A277CF85264E3D', '0000151122', '宏智有限责任公司', '131522', '黄志新', '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', '0000151123', '恒智发展有限公司', '131603', '俞天空', '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 ('84EB1283E50B49E7923E297465900F0D', '0000151124', '方诚有限责任公司', '131524', '蒋志尚', '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 ('5A4C41464D1148EB9F602E3127897DA1', '0000151125', '凤太有限责任公司', '131525', '黄志勇', '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 ('61A4585E66C44FEB9127324FC65EEBE1', '0000151126', '尔智有限责任公司', '131526', '黄志明', '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', '0000151127', '凌长发展有限公司', '131527', '黄志国', '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', '0000151128', '远信有限责任公司', '131528', '蒋志专', '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', '0000151129', '运翔有限责任公司', '131529', '蒋志文', '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 ('4EF7131289A64AB9BF8101643A641127', '0000151130', '营和发展有限公司', '131530', '陈志用', '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', '0000151131', '成白有限责任公司', '131531', '陈志泽', '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', '0000151132', '月通有限责任公司', '131532', '向致远', '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', '0000151133', '泰讯有限责任公司', '131533', '向智明', '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 ('5201117A798642C1A97A7E400422AD4F', '0000151134', '优复发展有限公司', '131534', '向智鑫', '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', '0000151135', '相彩有限责任公司', '131535', '陈志业', '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', '0000151136', '宝嘉有限责任公司', '131536', '陈志义', '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 ('9AF1BD8065144C3EAB1D7C87A18FE49D', '0000151137', '裕来发展有限公司', '131537', '向智勇', '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', '0000151138', '光亿有限责任公司', '131538', '向智敏', '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 ('8A60D267238C4EFEB3F10A2A18667765', '0000151139', '腾赛有限责任公司', '131539', '向子安', '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', '0000151140', '佳诗发展有限公司', '131540', '谢子晋', '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', '0000151141', '辉星发展有限公司', '131541', '谢子民', '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', '0000151142', '尔元发展有限公司', '131542', '向智志', '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', '0000151143', '铁领发展有限公司', '131543', '向智渊', '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 ('7BA8252508604DFA870AFC4D17D6A0AD', '0000151144', '博典发展有限公司', '131544', '谢子明', '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 ('14AF18E7D49647BE9E7E6EC3C9751679', '0000151145', '铭驰发展有限公司', '131545', '王文斌', '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 ('E4DDEED1B7114888A5ACFA8F996E70C2', '0000151146', '风事发展有限公司', '131546', '谢子默', '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', '0000151147', '坚建发展有限公司', '131547', '赵静曼', '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 ('C1090145F56E4E30A51373945F7494F7', '0000151148', '旭开发展有限公司', '131548', '钱凡旋', '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 ('C4878621F0404A0A9F4A56897B7857E2', '0000151149', '嘉达发展有限公司', '131549', '孙以亦', '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 ('428A9BD879A648878DC876C65629E60C', '0000151150', '讯坚发展有限公司', '131550', '李念露', '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 ('46A857BEB880488BBEFA48D2004A3231', '0000151151', '旺啸发展有限公司', '131551', '周芷蕾', '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', '0000151152', '吉典发展有限公司', '131552', '吴千兰', '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 ('7CEE0A45B5BA477A9927AD612C255905', '0000151153', '码冠发展有限公司', '131553', '郑新波', '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', '0000151154', '大德发展有限公司', '131554', '王代真', '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 ('B87F2BDF3814450B9E4989874DF59210', '0000151155', '洲旭发展有限公司', '131555', '冯新蕾', '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 ('6438517F374F4F7E88F789A15B5B930B', '0000151156', '益盛发展有限公司', '131556', '陈雁玉', '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', '0000151157', '帝隆发展有限公司', '131557', '褚冷卉', '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', '0000151158', '力月发展有限公司', '131558', '卫紫山', '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', '0000151159', '涛江发展有限公司', '131559', '蒋千琴', '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', '0000151160', '联奥发展有限公司', '131560', '沈恨天', '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 ('D2BFC98C21804F68B4F0FDCA417548FC', '0000151161', '盈讯发展有限公司', '131561', '韩傲芙', '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', '0000151162', '好金发展有限公司', '131562', '杨盼山', '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 ('FB6F0A22FCC342938B64A22777319F0B', '0000151163', '亿霆发展有限公司', '131563', '朱怀蝶', '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', '0000151164', '湖润发展有限公司', '131564', '秦冰兰', '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', '0000151165', '宝跃发展有限公司', '131565', '尤山柏', '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', '0000151166', '维拓发展有限公司', '131566', '许翠萱', '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 ('FA52270C783B450CAA3E9DF541113DC7', '0000151167', '开火发展有限公司', '131567', '何恨松', '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 ('937BBFC1C422495FA93CED376C7F6C4D', '0000151168', '金茂发展有限公司', '131568', '吕美丽', '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', '0000151169', '宜亿发展有限公司', '131569', '施从南', '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', '0000151170', '营本发展有限公司', '131570', '张白易', '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', '0000151171', '曼拓发展有限公司', '131571', '孔问筠', '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 ('E1DB8BCEB820422D86FFED5DCBDAD58A', '0000151172', '铭联发展有限公司', '131572', '曹如霜', '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 ('3518E920DAAF4D2896E64ADC370494A1', '0000151173', '林涛发展有限公司', '131573', '严半芹', '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 ('1445DE6A66FE40DB87C193A951787B16', '0000151174', '安拓发展有限公司', '131574', '华丹珍', '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 ('C2D1D350888248B1AB9F61EA79E5D66E', '0000151175', '展啸发展有限公司', '131575', '金冰彤', '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 ('8AB547CF3A9E475386FD8F98ABB058DB', '0000151176', '汇友发展有限公司', '131576', '魏亦寒', '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 ('1C9E0397D420476F967BD3ABD18A3F1E', '0000151177', '发诚发展有限公司', '131577', '陶落花', '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 ('B38E038DC5DA4BDEBA3354592DA8D2C8', '0000151178', '德真发展有限公司', '131578', '姜怜云', '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 ('58E3272659014634A661651857D3EA6E', '0000151179', '火用发展有限公司', '131579', '戚寻文', '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 ('86E4F2E278EF49638809C743D8E48935', '0000151180', '盈佩发展有限公司', '131580', '谢乐丹', '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 ('1E93616EFE044A6EB9DF991D00362086', '0000151181', '仕木发展有限公司', '131581', '邹翠柔', '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', '0000151182', '倍旺发展有限公司', '131582', '喻谷山', '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 ('2B0A772EE2984C078E7B36C863817E56', '0000151183', '频信发展有限公司', '131583', '柏之瑶', '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 ('1C8BAB3241FA4239964D2F2DA1405BF6', '0000151184', '缘聚发展有限公司', '131584', '水冰露', '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', '0000151185', '贸圆发展有限公司', '131585', '窦尔珍', '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 ('370D627366BD4159909D292E5F4C74F0', '0000151186', '帝冠发展有限公司', '131586', '章谷雪', '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', '0000151187', '同西发展有限公司', '131587', '云乐萱', '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', '0000151188', '瑞扬发展有限公司', '131588', '苏涵菡', '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 ('375F45E72E3845228076EE6B93A4D7AB', '0000151189', '顺宇发展有限公司', '131589', '潘宏远', '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', '0000151190', '铁清发展有限公司', '131590', '葛子瑜', '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', '0000151191', '克罗发展有限公司', '131591', '奚英逸', '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 ('4BE48484506049BC9BFD545F4EE938AF', '0000151192', '欣航发展有限公司', '131592', '范翔飞', '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', '0000151193', '基超发展有限公司', '131593', '彭英才', '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', '0000151194', '梦华发展有限公司', '131594', '郎鸿博', '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', '0000151195', '志远发展有限公司', '131595', '鲁志专', '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 ('75D0CB34AFBD4CDABD2B8C84F0252364', '0000151196', '诚木发展有限公司', '131596', '韦弘方', '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 ('76CC4E4C08D746B2A6906005E88D13EB', '0000151197', '涛宏发展有限公司', '131597', '昌志尚', '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 ('8EC0C8D539444A05BB2AD0EE9C7895B9', '0000151198', '优坚发展有限公司', '131598', '马风睿', '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 ('F073B28174584A82ADE709DBDD3F525B', '0000151199', '德天发展有限公司', '131599', '苗振荣', '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 ('131572', '131590,131591,131592', '0000151073', '双成有限责任公司', '易收宝微信认证,国际业务', '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 ('131573', '131593', '0000151075', '典和有限责任公司', '模拟利润,贷款', '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 ('131574', '131604', '0000151078', '汉爱有限责任公司', '好生意,国际业务', '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 ('131575', '131606,131578,131579', '0000151079', '和盈有限责任公司', '客户维护,财资大管家', '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 ('131576', '131580', '0000151082', '财营有限责任公司', '财资大管家', '2021-05-28', '2021-10-10', 'ADEB645811E84065A1511C15E1EF6102');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131551', '131486,131487,131488,131489,131490', '0000151083', '子佩有限责任公司', '国际业务,好生意收款', '2021-05-28', '2021-10-10', '0986604B24104E61AC6AD432DAD18CAF');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131552', '131491', '0000151085', '具硕有限责任公司', '托管业务', '2021-05-28', '2021-10-10', 'C08FC70D112247A380C55EF60A2A5B53');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131553', '131492', '0000151087', '海真有限责任公司', '代发工资', '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 ('131554', '131493,131494', '0000151089', '时新有限责任公司', '模拟利润', '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 ('131555', '13149,131496,131497', '0000151112', '磊邦有限责任公司', '中间业务', '2021-05-29', '2021-10-10', '9E01737F408746AE86C4152BC4CE0DA7');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131556', '131480,131481', '0000151115', '磊频有限责任公司', '票据业务', '2021-05-29', '2021-10-10', '8D97601A14AF404988B2BF5C2C17D5C4');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131557', '131479', '0000151117', '隆宇有限责任公司', '办理易收宝,易收宝开通', '2021-05-29', '2021-10-10', 'C3082FA59C6E4434B700CF2FEA632696');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131558', '131477', '0000151118', '速雅有限责任公司', '好生意,模拟利润', '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 ('131559', '131475', '0000151121', '巨远有限责任公司', '贷款,存款', '2021-05-29', '2021-10-10', '36C37806CD4F41089D18BE600577C00A');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131560', '131476', '0000151122', '宏智有限责任公司', '易收宝开通,国际业务', '2021-05-30', '2021-10-10', '8A5BBEDAA92140988183852F80410530');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131561', '131424', '0000151092', '士坚有限责任公司', '客户维护', '2021-05-30', '2021-10-10', '1D248CE613144EE6A4DBD6F2D2D9995E');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131562', '131410,131408', '0000151093', '和元有限责任公司', '易收宝微信认证,国际业务', '2021-05-30', '2021-10-10', '49274071E1DC41AAB33CE302635665C5');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131563', '131418,131419,131420', '0000151094', '旋和有限责任公司', '模拟利润,贷款', '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 ('131567', '131486,131487,131419,131420', '0000151097', '美名有限责任公司', '国际业务,贷款', '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 ('131568', '131477,131476,131424', '0000151099', '优斯有限责任公司', '财资大管家,贷款', '2021-05-31', '2021-10-10', '11E0BA934F9B412CBC650028552C8948');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131569', '131436,131437', '0000151101', '东彩有限责任公司', '老客户维护,财资大管家', '2021-05-31', '2021-10-10', '6DBF14C5E1BB4983B3CAF568B1913403');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131570', '131438', '0000151103', '纳实有限责任公司', '托管业务,财资大管家', '2021-05-31', '2021-10-10', 'DDCD7EE2C67542579945A996B2765E13');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131571', '131439', '0000151104', '吉圆有限责任公司', '中间业务,老客户维护', '2021-05-31', '2021-10-10', '54C625798A96492FAED6331941943C02');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131572', '131442,131443,131444,131445', '0000151107', '环太有限责任公司', '开通票据提醒,中间业务', '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 ('131573', '131447', '0000151108', '福卓有限责任公司', '贷款,开通票据提醒', '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 ('131574', '131418,131419,131420', '0000151111', '旋展有限责任公司', '国际业务', '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 ('131479', '131590,131591,131592', '0000151079', '和盈有限责任公司', '托管业务', '2021-06-01', '2021-10-10', '8939005E595E49ABBE07E2BE382A9730');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131482', '131410,131408', '0000151082', '财营有限责任公司', '代发工资', '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 ('131483', '131590,131591,131592', '0000151083', '子佩有限责任公司', '模拟利润', '2021-06-01', '2021-10-10', '1044E43F6E9C451F8ED588669F6E4FDA');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131487', '131409', '0000151087', '海真有限责任公司', '票据业务', '2021-06-02', '2021-10-10', '7D697053E2B44730BEF9DA5A52874146');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131489', '131411', '0000151089', '时新有限责任公司', '办理易收宝,易收宝开通', '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 ('131492', '131414', '0000151092', '士坚有限责任公司', '好生意,模拟利润', '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 ('131493', '131578,131579', '0000151093', '和元有限责任公司', '贷款,存款', '2021-06-02', '2021-10-10', '570D4C3339994426B83547D2C3B19BFB');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131494', '131580', '0000151094', '旋和有限责任公司', '易收宝开通,国际业务', '2021-06-02', '2021-10-10', 'D8216CF976764B66B28F1C4230B8FF47');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131499', null, '0000151099', '优斯有限责任公司', '易收宝微信认证,国际业务', '2021-06-02', '2021-10-10', '6B4071B1B224475293284C7565C6ED2C');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131558', '131442,131443,131444,131445', '0000151158', '力月发展有限公司', '模拟利润,贷款', '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 ('131560', '131447', '0000151160', '联奥发展有限公司', '国际业务,贷款', '2021-06-02', '2021-10-10', '870B978464B2429CBAEEBF39EDD87328');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131530', '131459', '0000151130', '营和发展有限公司', '易收宝微信认证', '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 ('131534', '131460', '0000151134', '优复发展有限公司', '国际业务,好生意收款', '2021-06-03', '2021-10-10', '6FE4635AE752415CAC3C1E6B9F6E7631');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131537', '131461', '0000151137', '裕来发展有限公司', '托管业务', '2021-06-03', '2021-10-10', 'F0BAA5A4BFE945239F8D02D139A44A38');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131545', '131463', '0000151145', '铭驰发展有限公司', '模拟利润', '2021-06-03', '2021-10-10', '9234E6879AB246928D7978828230156C');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131548', '131464', '0000151148', '旭开发展有限公司', '新客户维护', '2021-06-03', '2021-10-10', 'D9588288E09A46B0A28F9674C55AF345');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131552', '131465', '0000151152', '吉典发展有限公司', '开通票据提醒', '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 ('131555', '131466', '0000151155', '洲旭发展有限公司', '新客户维护', '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 ('131559', '131467,131583', '0000151159', '涛江发展有限公司', '国际业务,好生意收款,托管业务', '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 ('131566', '131469,131445', '0000151166', '维拓发展有限公司', '代发工资,模拟利润', '2021-06-04', '2021-10-10', 'AD864867AF134B42BA6BC3E5DF7E66F2');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131569', '131409', '0000151169', '宜亿发展有限公司', '存款', '2021-06-04', '2021-10-10', 'C75A0A11E84E407CAB658829D90EDDE1');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131407', '131415', '0000151018', '坚鑫有限责任公司', '维护客户', '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 ('131573', '131495', '0000151173', '林涛发展有限公司', '易收宝开通,国际业务,好生意收款', '2021-06-04', '2021-10-10', '2307105821224508840D277D451F3A9A');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131576', '131496', '0000151176', '汇友发展有限公司', '贷款', '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 ('131580', '131497', '0000151180', '盈佩发展有限公司', '模拟利润', '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 ('131584', '131498', '0000151184', '缘聚发展有限公司', '开通票据提醒', '2021-06-05', '2021-10-10', '41D1EE2EDF72479591C6EF9031F504A5');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131587', '131499', '0000151187', '同西发展有限公司', '办理易收宝,易收宝开通', '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 ('131591', '131500', '0000151191', '克罗发展有限公司', '好生意,模拟利润', '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 ('131594', '131501', '0000151194', '梦华发展有限公司', '贷款,存款', '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 ('131598', '131502', '0000151198', '优坚发展有限公司', '易收宝开通,国际业务', '2021-06-05', '2021-10-10', '619370769BEB43ABA4F75B20415A770B');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131485', '131410', '0000151085', '具硕有限责任公司', '中间业务', '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 ('131497', '131582,131583', '0000151097', '美名有限责任公司', '客户维护', '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 ('131541', '131462', '0000151141', '辉星发展有限公司', '代发工资', '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 ('131562', '131468', '0000151162', '好金发展有限公司', '托管业务,好生意收款', '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 ('131407', '134574,131419,', '0000151015', '达尚有限责任公司', '维护客户', '2021-05-02', '2021-10-10', 'CB54274EE846450C94B8E7A2662F31DD');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131407', '134574,131420,', '0000151015', '达尚有限责任公司', '维护客户', '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 ('131407', '131420,131415', '0000151018', '坚鑫有限责任公司', '维护客户', '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 ('131420', '131407,131415', '0000151018', '坚鑫有限责任公司', '维护客户', '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 ('131407', '131418,131419,131420', '0000151008', '吉凡有限责任公司', '易收宝', '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 ('131408', '131421,131422', '0000151009', '达识有限责任公司', '好生意', '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 ('131409', '131423', '0000151011', '博京有限责任公司', '易收宝开通', '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 ('131410', '131424', '0000151012', '百纽有限责任公司', '易收宝微信认证', '2021-05-03', '2021-10-10', '1801C86986384B69A19DD73E52B37C38');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131411', '131425', '0000151013', '赛事有限责任公司', '国际业务,好生意收款', '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 ('131412', '131407,131410', '0000151015', '达尚有限责任公司', '托管业务', '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 ('131413', '131410', '0000151016', '明成有限责任公司', '代发工资', '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 ('131414', '131409', '0000151018', '坚鑫有限责任公司', '模拟利润', '2021-05-07', '2021-10-10', '1FC87DC293FD43CEB179148F1B9EDDA6');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131415', '131411', '0000151019', '顿开有限责任公司', '中间业务', '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 ('131416', '131414', '0000151020', '奥惠有限责任公司', '票据业务', '2021-05-09', '2021-10-10', '40AB26A14C644C148466C7733F0864F0');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131417', '131413', '0000151022', '宇立有限责任公司', '理财', '2021-05-10', '2021-10-10', '2881AA496E514687ADF5C978BB5FBE5E');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131418', '131416,131418,131419,131420', '0000151023', '太鑫有限责任公司', '存款', '2021-05-11', '2021-10-10', '64D3DE7E1676418D9296E1DACE460599');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131419', '131414', '0000151025', '相智有限责任公司', '办理易收宝', '2021-05-12', '2021-10-10', '8BAF08DBD1C742318B6BA4172A9C72C4');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131420', '131410', '0000151026', '金系有限责任公司', '贷款，国际贷款', '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 ('131421', '131407,131410', '0000151027', '京亿有限责任公司', '上市理财', '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 ('131422', '131409', '0000151029', '涛建有限责任公司', '开通票据提醒', '2021-05-15', '2021-10-10', 'D7FD3389AA3C49BB93602116FE2F1925');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131423', '131413,131410', '0000151030', '庆铁有限责任公司', '反洗钱提醒', '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 ('131424', '131416,131412', '0000151032', '览相有限责任公司', '老客户维护', '2021-05-17', '2021-10-10', '0A197493E167407994F30EB2C57081C5');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131425', '131429,131428', '0000151033', '凡诺有限责任公司', '新客户维护', '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 ('131426', '131410,131408', '0000151034', '频亚有限责任公司', '存款', '2021-05-19', '2021-10-10', '712D0BBFBC6640058573446E5229CA88');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131427', null, '0000151036', '清爱有限责任公司', '存款', '2021-05-20', '2021-10-10', 'C9CE286218BE4CE99296DDC009E86D54');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131430', '131410,131408', '0000151037', '天复有限责任公司', '易收宝', '2021-05-21', '2021-10-10', '01494677594E4BF38933C8DBED00402E');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131431', '131425', '0000151039', '和优有限责任公司', '好生意', '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 ('131432', '131420', '0000151040', '玉营有限责任公司', '易收宝开通', '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 ('131433', '131417', '0000151042', '仕正有限责任公司', '易收宝微信认证', '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 ('131434', '131415', '0000151054', '长蓝有限责任公司', '国际业务,好生意收款', '2021-05-21', '2021-10-10', '328B9F18CB334A449547C2F1FC96E33A');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131435', '131413', '0000151055', '览驰有限责任公司', '托管业务', '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 ('131436', null, '0000151058', '顺大有限责任公司', '代发工资', '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 ('131437', null, '0000151060', '翔百有限责任公司', '模拟利润', '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 ('131438', null, '0000151039', '和优有限责任公司', '新客户维护', '2021-05-23', '2021-10-10', '61221C8A5692416E943E79DEE9EAFE1D');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131439', null, '0000151040', '玉营有限责任公司', '开通票据提醒', '2021-05-23', '2021-10-10', 'D2A0B21537694361935FBA9C78AC74CC');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131440', null, '0000151042', '仕正有限责任公司', '新客户维护', '2021-05-24', '2021-10-10', 'F4A71AE920DE4BAAB21A6146911D2B71');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131441', '131601', '0000151043', '正妙有限责任公司', '国际业务,好生意收款,托管业务', '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 ('131442', '131590,131591,131592', '0000151044', '富旭有限责任公司', '托管业务,好生意收款', '2021-05-24', '2021-10-10', '2F373AB72FBB4F77B2E5260482F12FA6');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131443', '131593', '0000151046', '茂友有限责任公司', '代发工资,模拟利润', '2021-05-24', '2021-10-10', 'A4D6996BCE82492DBE81888DC9867639');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131444', '131604', '0000151047', '领码有限责任公司', '存款', '2021-05-24', '2021-10-10', '62F743464D13478A9E5A829707ADBD7A');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131445', '131594,131595,131596', '0000151049', '春鸿有限责任公司', '易收宝开通,国际业务,好生意收款', '2021-05-25', '2021-10-10', '61F5A32FBB604492B49A5B2F896BE715');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131446', '131606', '0000151050', '联相有限责任公司', '贷款', '2021-05-25', '2021-10-10', 'B759A53BF314404281F8100975267E60');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131447', '131578,131579', '0000151051', '木圆有限责任公司', '模拟利润', '2021-05-25', '2021-10-10', '421E831BAE514647B018E3EC88A45BB8');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131448', '131580', '0000151061', '实川有限责任公司', '开通票据提醒', '2021-05-25', '2021-10-10', '6D640E6A4E4B4C639217CEBF876F6CFC');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131449', '131582,131583', '0000151064', '电娇有限责任公司', '办理易收宝,易收宝开通', '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 ('131568', '131416,131418,131419,131420', '0000151065', '飞尼有限责任公司', '好生意,模拟利润', '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 ('131569', '131413,131410', '0000151068', '优盛有限责任公司', '贷款,存款', '2021-05-26', '2021-10-10', 'DC04DFE9524C48058B720ED3346571F1');
insert into CC_STAT_VISITOR_SIGN (EMP_ID, ACCP_EMP_ID, CUST_ID, CUST_NAME, VISITOR_PURPOSE, SIGN_DT, DATA_DT, PK_ID)
values ('131570', '131416,131412', '0000151069', '欣基有限责任公司', '易收宝开通,国际业务', '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 ('131571', '131410,131408', '0000151072', '欧冠有限责任公司', '客户维护', '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 ('131606', '柳长逸', 'D0377', '1', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131606', '柳长逸', 'D0377', '1', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131600', '凤嘉慕', 'D0382', '0', '项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131601', '花飞雨', 'D0378', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131602', '方天成', 'D0375', '1', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131603', '俞天空', 'D0374', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131604', '任开霁', 'D0377', '1', '票据业务经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131605', '袁明珠', 'D0378', '1', '支行行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131482', '如萱', 'D0323', '0', '信贷执行官', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131485', '晓亦', 'D0325', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131488', '以蕊', 'D0325', '0', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131492', '王展鹏', 'D0328', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131495', '蒋志行', 'D0333', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131498', '姚正豪', 'D0333', '0', '信贷执行官', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131502', '崔振海', 'D0338', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131505', '崔正初', 'D0340', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131508', '孙正青', 'D0346', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131512', '孙正文', 'D0346', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131515', '孙正祥', 'D0349', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131519', '杨正真', 'D0347', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131523', '蒋志强', 'D0350', '0', '零售项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131526', '黄志明', 'D0350', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131530', '陈志用', 'D0352', '0', '零售项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131534', '向智鑫', 'D0356', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131537', '向智勇', 'D0356', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131540', '谢子晋', 'D0357', '0', '理财经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131544', '谢子明', 'D0357', '0', '助理经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131547', '赵静曼', 'D0358', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131550', '李念露', 'D0359', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131554', '王代真', 'D0359', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131557', '褚冷卉', 'D0360', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131560', '沈恨天', 'D0361', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131563', '朱怀蝶', 'D0362', '0', '个人项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131567', '何恨松', 'D0363', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131570', '张白易', 'D0364', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131574', '华丹珍', 'D0365', '0', '个人项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131577', '陶落花', 'D0365', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131580', '谢乐丹', 'D0366', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131584', '水冰露', 'D0367', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131587', '云乐萱', 'D0368', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131590', '葛子瑜', 'D0369', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131594', '郎鸿博', 'D0370', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131597', '昌志尚', 'D0373', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131600', '凤嘉慕', 'D0382', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131604', '任开霁', 'D0377', '1', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131407', '潘石屹', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131408', '王石', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131409', '蒋锡培', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131410', '向文波', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131411', '牛根生', 'D0290', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131412', '熊晓鸽', 'D0290', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131413', '王冉', 'D0290', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131414', '于清教', 'D0290', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131415', '谢清海', 'D0291', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131416', '刘旗辉', 'D0291', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131417', '刘步尘', 'D0291', '0', '理财经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131418', '陈达夫', 'D0291', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131419', '船长', 'D0291', '0', '内控经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131420', '叶茂中', 'D0291', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131421', '李士福', 'D0291', '0', '助理经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131422', '王进生', 'D0291', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131423', '任志强', 'D0291', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131424', '付伟', 'D0291', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131425', '孙虹钢', 'D0292', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131426', '宋新宇', 'D0292', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131427', '王微', 'D0292', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131428', '翁向东', 'D0292', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131429', '周济谱', 'D0292', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131430', '袁岳', 'D0292', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131431', '成君忆', 'D0292', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131432', '艾学蛟', 'D0293', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131433', '雷永军', 'D0293', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131434', '刘秋华', 'D0293', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131435', '宋炜', 'D0293', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131436', '刘东华', 'D0293', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131437', '科特勒', 'D0293', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131438', '陈志列', 'D0293', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131439', '张巨峰', 'D0294', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131440', '姚日来', 'D0294', '0', '信息科技部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131441', '李朝曙', 'D0294', '0', '财信部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131442', '刘兴亮', 'D0294', '0', '零售营销管理部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131443', '梦琪', 'D0294', '0', '资产托管部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131444', '忆柳', 'D0294', '0', '信贷科长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131445', '之桃', 'D0294', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131446', '慕青', 'D0295', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131447', '问兰', 'D0295', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131448', '尔岚', 'D0295', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131449', '元 香', 'D0295', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131450', '初夏', 'D0295', '0', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131451', '沛菡', 'D0295', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131452', '傲珊', 'D0326', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131453', '曼文', 'D0326', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131454', '乐菱', 'D0326', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131455', '痴珊', 'D0326', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131456', '恨玉', 'D0326', '0', '运营经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131457', '惜文', 'D0326', '0', '客户管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131458', '香寒', 'D0326', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131459', '新柔', 'D0330', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131460', '语蓉', 'D0330', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131461', '海安', 'D0330', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131462', '夜蓉', 'D0330', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131463', '涵柏', 'D0330', '0', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131464', '水桃', 'D0330', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131465', '醉蓝', 'D0330', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131466', '春儿', 'D0345', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131467', '语琴', 'D0345', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131468', '从彤', 'D0345', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131469', '傲晴', 'D0345', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131470', '语兰', 'D0345', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131471', '又菱', 'D0345', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131472', '碧彤', 'D0345', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131473', '元霜', 'D0345', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131474', '怜梦', 'D0348', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131475', '紫寒', 'D0348', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131476', '妙彤', 'D0348', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131477', '曼易', 'D0348', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131478', '南莲', 'D0348', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131479', '紫翠', 'D0348', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131480', '雨寒', 'D0323', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131481', '易烟', 'D0323', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131483', '若南', 'D0323', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131484', '寻真', 'D0323', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131486', '向珊', 'D0325', '0', '票据业务管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131487', '慕灵', 'D0325', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131489', '寻雁', 'D0328', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131490', '映易', 'D0328', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131491', '雪柳', 'D0328', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131493', '王哲瀚', 'D0333', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131494', '姚正德', 'D0333', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131496', '蒋志学', 'D0333', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131497', '姚正浩', 'D0333', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131499', '王哲茂', 'D0338', '0', '贸易融资部长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131500', '王哲圣', 'D0338', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131501', '王哲彦', 'D0338', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131503', '崔振国', 'D0338', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131504', '崔正诚', 'D0340', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131506', '王正平', 'D0340', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131507', '孙正奇', 'D0340', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131509', '谢子墨', 'D0346', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131510', '谢子平', 'D0346', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131511', '孙正卿', 'D0346', '0', '信贷执行官', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131513', '杨正雅', 'D0346', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131514', '杨正阳', 'D0349', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131516', '孙正信', 'D0349', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131517', '杨正业', 'D0349', '0', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131518', '杨正谊', 'D0349', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131520', '黄正志', 'D0347', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131521', '黄志诚', 'D0347', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131522', '黄志新', 'D0347', '0', '对公项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131524', '蒋志尚', 'D0350', '0', '个人项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131525', '黄志勇', 'D0350', '0', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131527', '黄志国', 'D0350', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131528', '蒋志专', 'D0350', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131529', '蒋志文', 'D0352', '0', '对公项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131531', '陈志泽', 'D0352', '0', '个人项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131532', '向致远', 'D0352', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131533', '向智明', 'D0352', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131535', '陈志业', 'D0356', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131536', '陈志义', 'D0356', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131538', '向智敏', 'D0356', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131539', '向子安', 'D0357', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131541', '谢子民', 'D0357', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131542', '向智志', 'D0357', '0', '内控经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131543', '向智渊', 'D0357', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131545', '王文斌', 'D0358', '0', '部室主任', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131546', '谢子默', 'D0358', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131548', '钱凡旋', 'D0358', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131549', '孙以亦', 'D0358', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131551', '周芷蕾', 'D0359', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131552', '吴千兰', 'D0359', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131553', '郑新波', 'D0359', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131555', '冯新蕾', 'D0359', '0', '对公经办', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131556', '陈雁玉', 'D0359', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131558', '卫紫山', 'D0361', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131559', '蒋千琴', 'D0361', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131561', '韩傲芙', 'D0361', '0', '对公项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131562', '杨盼山', 'D0361', '0', '零售项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131564', '秦冰兰', 'D0362', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131565', '尤山柏', 'D0362', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131566', '许翠萱', 'D0362', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131568', '吕美丽', 'D0363', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131569', '施从南', 'D0363', '0', '支行副行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131571', '孔问筠', 'D0364', '0', '部室经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131572', '曹如霜', 'D0365', '0', '对公项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131573', '严半芹', 'D0365', '0', '零售项目经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131575', '金冰彤', 'D0365', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131576', '魏亦寒', 'D0365', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131578', '姜怜云', 'D0366', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131579', '戚寻文', 'D0366', '0', '团队队长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131581', '邹翠柔', 'D0366', '0', '行政助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131582', '喻谷山', 'D0366', '0', '零售信贷职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131583', '柏之瑶', 'D0367', '0', '信贷执行官', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131585', '窦尔珍', 'D0367', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131586', '章谷雪', 'D0367', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131588', '苏涵菡', 'D0368', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131589', '潘宏远', 'D0368', '0', '客户经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131591', '奚英逸', 'D0369', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131592', '范翔飞', 'D0370', '0', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131593', '彭英才', 'D0370', '0', '行长助理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131595', '鲁志专', 'D0370', '0', '运营经理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131596', '韦弘方', 'D0373', '0', '客户管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131598', '马风睿', 'D0373', '0', '副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131599', '苗振荣', 'D0381', '0', '产品管理', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131601', '花飞雨', 'D0378', '1', '支行行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131602', '方天成', 'D0375', '1', '金融市场部职员', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131603', '俞天空', 'D0374', '1', '支行副行长', '2021-10-10');
insert into CC_SYS_EMPLOYEES (EMP_NO, EMP_NAME, ORG_ID, STUS, JOB_ID, DATA_DT)
values ('131605', '袁明珠', '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.
以下是需要这些表的需求：
-----根据总行要求，目前员工拜访客户存在恶意拜访行为，现需要做一个员工访客表，同一个员工
--拜访同一客户，一周不能超过两次，超过两次算无效拜访，拜访人和陪访人员，
--必须是客户经理，或者是团队队长或者是直系管护人，否则属于无效拜访，
--现需要数据周一到周末员工的有效拜访次数，周四到到上周五
--的有效拜访次数，一月的有效拜访次数
---现根据要求，无效访客多少次，有效访客次数都显示出来
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
