niziming/rcs-sys
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
rcs-sys/loan-parent/db/20230905/执行脚本.txt

466 lines
34 KiB
Plaintext
Raw Permalink Normal View History

first commit
2025-03-07 16:23:56 +08:00
CREATE TABLE REC_LOAN_LAST."SYS_AREA" (
"ITEMNO" VARCHAR(64) NOT NULL,
"ITEMNAME" VARCHAR(12),
"BANKNO" VARCHAR(256),
"SORTNO" VARCHAR(80)
);
CREATE INDEX idx_SYS_AREA_SORTNO ON REC_LOAN_LAST."SYS_AREA" ("SORTNO");
CREATE TABLE REC_LOAN_LAST."SYS_AREA_CHANGE" (
"OLD_CODE" VARCHAR(64) ,
"NEW_CODE" VARCHAR(64)
);
CREATE INDEX idx_SYS_AREA_CHANGE_OLD_CODE ON REC_LOAN_LAST."SYS_AREA_CHANGE" ("OLD_CODE");
drop table REC_LOAN_LAST_M99."rec_msxf_cus_info_his" ;
drop table REC_LOAN_LAST_M99."rec_msxf_cus_info_tmp" ;
CREATE TABLE REC_LOAN_LAST_M99."rec_msxf_cus_info_his" (
id VARCHAR(64) ,
biz_date VARCHAR(64) ,
uuid VARCHAR(64) ,
apply_time VARCHAR(64) ,
seria_no VARCHAR(64) ,
cus_name VARCHAR(64) ,
gender VARCHAR(64) ,
birthday VARCHAR(64) ,
is_resident VARCHAR(64) ,
is_overseas VARCHAR(64) ,
nation VARCHAR(64) ,
ident_type VARCHAR(64) ,
ident_no VARCHAR(64) ,
mobile_no VARCHAR(64) ,
ident_area_code VARCHAR(64) ,
ident_valid_start VARCHAR(64) ,
ident_valid_end VARCHAR(64) ,
ocr_auth_nation VARCHAR(64) ,
ocr_auth_org VARCHAR(64) ,
ocr_auth_address VARCHAR(64) ,
address VARCHAR(64) ,
area_code VARCHAR(64) ,
industry_name VARCHAR(64) ,
industry_address VARCHAR(64) ,
industry_type VARCHAR(64) ,
industry_code VARCHAR(64) ,
month_income VARCHAR(64) ,
ocr_ethnic VARCHAR(64) ,
job VARCHAR(64) ,
profession VARCHAR(64) ,
education VARCHAR(64) ,
marital_status VARCHAR(64) ,
contact_name VARCHAR(64) ,
contact_relation VARCHAR(64) ,
contact_mobile VARCHAR(64) ,
loan_purpose VARCHAR(64) ,
bank_name VARCHAR(64) ,
name VARCHAR(64) ,
lpr_base_rate VARCHAR(64) ,
lpr_issue_time VARCHAR(64) ,
interestrate VARCHAR(64) ,
authorize_start_time VARCHAR(64) ,
month_interest VARCHAR(64) ,
contract_strat_time VARCHAR(64) ,
contract_end_time VARCHAR(64) ,
insure_amt VARCHAR(64) ,
deal_sts VARCHAR(128) DEFAULT '0',
data_date VARCHAR(64),
bank_code VARCHAR(32),
create_user VARCHAR(128),
create_date DATE,
create_time TIMESTAMP,
create_org VARCHAR(64),
update_user VARCHAR(128),
update_date DATE,
update_time TIMESTAMP,
update_org VARCHAR(64),
cur_vers INT DEFAULT 1 NOT NULL
);
CREATE INDEX idx_rec_msxf_cus_info_his_bizdate ON REC_LOAN_LAST_M99."rec_msxf_cus_info_his" ("biz_date");
CREATE TABLE REC_LOAN_LAST_M99."rec_msxf_cus_info_tmp" (
id VARCHAR(64) ,
biz_date VARCHAR(64) ,
uuid VARCHAR(64) ,
apply_time VARCHAR(64) ,
seria_no VARCHAR(64) ,
cus_name VARCHAR(64) ,
gender VARCHAR(64) ,
birthday VARCHAR(64) ,
is_resident VARCHAR(64) ,
is_overseas VARCHAR(64) ,
nation VARCHAR(64) ,
ident_type VARCHAR(64) ,
ident_no VARCHAR(64) ,
mobile_no VARCHAR(64) ,
ident_area_code VARCHAR(64) ,
ident_valid_start VARCHAR(64) ,
ident_valid_end VARCHAR(64) ,
ocr_auth_nation VARCHAR(64) ,
ocr_auth_org VARCHAR(64) ,
ocr_auth_address VARCHAR(64) ,
address VARCHAR(64) ,
area_code VARCHAR(64) ,
industry_name VARCHAR(64) ,
industry_address VARCHAR(64) ,
industry_type VARCHAR(64) ,
industry_code VARCHAR(64) ,
month_income VARCHAR(64) ,
ocr_ethnic VARCHAR(64) ,
job VARCHAR(64) ,
profession VARCHAR(64) ,
education VARCHAR(64) ,
marital_status VARCHAR(64) ,
contact_name VARCHAR(64) ,
contact_relation VARCHAR(64) ,
contact_mobile VARCHAR(64) ,
loan_purpose VARCHAR(64) ,
bank_name VARCHAR(64) ,
name VARCHAR(64) ,
lpr_base_rate VARCHAR(64) ,
lpr_issue_time VARCHAR(64) ,
interestrate VARCHAR(64) ,
authorize_start_time VARCHAR(64) ,
month_interest VARCHAR(64) ,
contract_strat_time VARCHAR(64) ,
contract_end_time VARCHAR(64) ,
insure_amt VARCHAR(64) ,
deal_sts VARCHAR(128) DEFAULT '0',
data_date VARCHAR(64),
bank_code VARCHAR(32),
create_user VARCHAR(128),
create_date DATE,
create_time TIMESTAMP,
create_org VARCHAR(64),
update_user VARCHAR(128),
update_date DATE,
update_time TIMESTAMP,
update_org VARCHAR(64),
cur_vers INT DEFAULT 1 NOT NULL
);
CREATE INDEX idx_rec_msxf_cus_info_tmp_bizdate ON REC_LOAN_LAST_M99."rec_msxf_cus_info_tmp" ("biz_date");
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.uuid is '客户编号';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.apply_time is '业务日期';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.seria_no is '贷款编号';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.cus_name is '客户名称';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.gender is '性别';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.birthday is '出生日期';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.is_resident is '居民标志';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.is_overseas is '境内境外标志';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.nation is '国籍';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.ident_type is '证件类型';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.ident_no is '证件号码';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.mobile_no is '手机号码/联系电话';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.ident_area_code is '户籍地行政区划代码';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.ident_valid_start is '证件签发日期';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.ident_valid_end is '失效日期';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.ocr_auth_nation is '发证机关国家';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.ocr_auth_org is '发证机关';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.ocr_auth_address is '证件登记地址';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.address is '联系地址';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.area_code is '居住地行政区划代码';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.industry_name is '工作单位';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.industry_address is '办公地址';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.industry_type is '行业类别';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.industry_code is '行业代码';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.month_income is '月收入';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.ocr_ethnic is '民族';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.job is '职务';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.profession is '职业';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.education is '学历';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.marital_status is '婚姻情况';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.contact_name is '联系人姓名';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.contact_relation is '联系人关系';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.contact_mobile is '联系人电话';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.loan_purpose is '借款用途';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.bank_name is '收款人账户银行';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.name is '收款人名称';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.lpr_base_rate is 'LPR基准值';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.lpr_issue_time is 'LPR发布时间';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.interestrate is 'LPR浮动值';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.authorize_start_time is '授权书开始时间';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.month_interest is '执行月利率';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.contract_strat_time is '借据合同起始日';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.contract_end_time is '借据合同截止日';
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_cus_info_tmp.insure_amt is '担保金额';
set identity_insert REC_LOAN_LAST.xxl_job_info ON;
INSERT INTO XXL_JOB.xxl_job_info (job_group,job_desc,add_time,update_time,author,alarm_email,schedule_type,schedule_conf,misfire_strategy,executor_route_strategy,executor_handler,executor_block_strategy,executor_timeout,executor_fail_retry_count,glue_type,glue_source,glue_remark,glue_updatetime,child_jobid,trigger_status,trigger_last_time,trigger_next_time,executor_fail_retry_interval,executor_param) VALUES (1,'马上消费：解析客户信息文件','2023-09-11 13:31:29.000','2023-09-11 13:32:41.000','CCHXBANK','','CRON','0 30 6 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-09-11 13:31:29.000','31',0,0,0,0,'{"path":"readerMsxfUCsFileTasket","batchNum":500,"tableField":"uuid,apply_time,seria_no,cus_name,gender,birthday,is_resident,is_overseas,nation,ident_type,ident_no,mobile_no,ident_area_code,ident_valid_start,ident_valid_end,ocr_auth_nation,ocr_auth_org,ocr_auth_address,address,area_code,industry_name,industry_address,industry_type,industry_code,month_income,ocr_ethnic,JOB,profession,education,marital_status,contact_name,contact_relation,contact_mobile,loan_purpose,bank_name,name,lpr_base_rate,lpr_issue_time,interestrate,authorize_start_time,month_interest,contract_strat_time,contract_end_time,insure_amt"}
');
-- 还需要设置xxl-job中马消的客户文件依赖关系
delete from REC_LOAN_LAST."SYS_AREA_CHANGE";
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '110118' , '110228');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '110119' , '110229');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '120117' , '120221');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '120118' , '120223');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '120119' , '120225');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130102' , '130103');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130284' , '130223');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130306' , '130323');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130407' , '130428');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130408' , '130429');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130402' , '130421');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130505' , '130526');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130506' , '130527');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130502' , '130521');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130606' , '130603');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130606' , '130604');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130607' , '130621');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130608' , '130622');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130609' , '130625');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130708' , '130729');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130709' , '130733');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130705' , '130721');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '130881' , '130823');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '131103' , '131181');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140213' , '140202');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140214' , '140203');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140214' , '140211');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140215' , '140227');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140403' , '140402');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140405' , '140424');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140406' , '140481');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140403' , '140411');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140404' , '140421');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140681' , '140624');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '140703' , '140726');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '210214' , '210282');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '220184' , '220381');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230113' , '230182');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230717' , '230702');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230726' , '230703');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230751' , '230705');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230718' , '230706');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230724' , '230707');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230717' , '230708');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230751' , '230709');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230724' , '230710');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230718' , '230711');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230723' , '230712');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230725' , '230713');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230723' , '230714');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230724' , '230715');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230719' , '230716');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230719' , '230704');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '230883' , '230833');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '231086' , '231024');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '231183' , '231121');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '232701' , '232723');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '310106' , '310108');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '310151' , '310230');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320213' , '320202');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320213' , '320203');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320213' , '320204');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320412' , '320405');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320413' , '320482');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320613' , '320611');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320613' , '320602');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320614' , '320684');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320685' , '320621');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320812' , '320802');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320812' , '320811');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320813' , '320829');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '320904' , '320982');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '330105' , '330103');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '330102' , '330104');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '330111' , '330183');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '330112' , '330185');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '330212' , '330204');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '330213' , '330283');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '331083' , '331021');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340209' , '340203');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340209' , '340208');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340210' , '340221');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340212' , '340222');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340705' , '340702');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340705' , '340703');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340706' , '340721');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340722' , '340823');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340882' , '340824');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340181' , '341402');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340124' , '341421');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340281' , '341422');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340522' , '341423');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340523' , '341424');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '340422' , '341521');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '341882' , '341822');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '350112' , '350182');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '350404' , '350402');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '350404' , '350403');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '350405' , '350427');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '350604' , '350681');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '350605' , '350625');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '350703' , '350784');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '350803' , '350822');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '360112' , '360105');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '360112' , '360122');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '360404' , '360421');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '360483' , '360427');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '360704' , '360721');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '360783' , '360727');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '361003' , '361029');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '361103' , '361122');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '361104' , '361121');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '370114' , '370181');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '370215' , '370282');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '370505' , '370521');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '370614' , '370684');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '370614' , '370634');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '371122' , '371201');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '370116' , '371202');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '370117' , '371203');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '371503' , '371523');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '371703' , '371727');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '410212' , '410224');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '410308' , '410306');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '410307' , '410381');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '410308' , '410322');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '410421' , '410481');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '410423' , '410421');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '410425' , '410423');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '410481' , '410425');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '410783' , '410728');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '411003' , '411023');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '411203' , '411222');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '411603' , '411626');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '420882' , '420821');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '421088' , '421023');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '430182' , '430124');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '430582' , '430521');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '431181' , '431121');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '310101' , '440116');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '441204' , '441283');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '441704' , '441723');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '450181' , '450127');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '450206' , '450221');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '450381' , '450331');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '451003' , '451021');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '451081' , '451025');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '451082' , '451023');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '451203' , '451281');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '451321' , '451324');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '451322' , '451321');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '451323' , '451322');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '451324' , '451323');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '460322' , '469038');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '460323' , '469039');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '460400' , '469003');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '500152' , '500223');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '500153' , '500226');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '500154' , '500234');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '500155' , '500228');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '500156' , '500232');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510107' , '510109');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510116' , '510122');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510117' , '510124');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510118' , '510132');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510185' , '512081');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510604' , '510626');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510705' , '510724');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510811' , '510813');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510811' , '510811');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '510981' , '510922');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '511083' , '511028');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '511403' , '511422');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '511504' , '511521');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '513201' , '513229');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '513301' , '513321');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '513402' , '513425');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '520204' , '520221');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '520281' , '520222');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '520403' , '520421');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '520581' , '520522');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '522302' , '522322');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '530115' , '530122');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '530303' , '530328');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '530304' , '530321');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '530403' , '530421');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '530481' , '530422');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '530581' , '530522');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '530681' , '530630');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '532302' , '532331');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '533401' , '533421');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540103' , '540125');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540104' , '540126');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540302' , '542121');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540321' , '542122');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540322' , '542123');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540323' , '542124');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540324' , '542125');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540325' , '542126');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540326' , '542127');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540327' , '542128');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540328' , '542129');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540329' , '542132');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540330' , '542133');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540402' , '542621');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540421' , '542622');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540422' , '542623');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540423' , '542624');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540424' , '542625');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540425' , '542626');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540426' , '542627');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540502' , '542221');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540521' , '542222');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540522' , '542223');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540523' , '542224');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540524' , '542225');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540525' , '542226');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540526' , '542227');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540527' , '542228');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540528' , '542229');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540529' , '542231');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540530' , '542232');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540531' , '542233');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540602' , '542421');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540621' , '542422');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540622' , '542423');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540623' , '542424');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540624' , '542425');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540625' , '542426');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540626' , '542427');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540627' , '542428');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540628' , '542429');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540629' , '542430');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '540630' , '542431');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610117' , '610126');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610118' , '610125');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610305' , '610322');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610482' , '610427');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610503' , '610521');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610603' , '610624');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610681' , '610623');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610703' , '610721');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610803' , '610823');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610881' , '610821');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '610981' , '610928');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '620881' , '620824');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '630106' , '630122');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '630203' , '630221');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '632301' , '632321');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '650402' , '652101');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '650421' , '652122');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '650422' , '652123');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '650502' , '652201');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '650521' , '652222');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '650522' , '652223');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '652902' , '652923');
insert into REC_LOAN_LAST."SYS_AREA_CHANGE" (new_code,old_code) values ( '654203' , '654223');
Reference in New Issue Copy Permalink