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');