DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1447851561253470208;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FAPPLYSCOPE,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1447851561253470208,'1',1447851561253470208,'C','hom_cancontact_IMPT_S','IMPT','候选人紧急联系人',{ts'2022-06-21  00:00:00'},'0',1398398025684004864,'1',{ts'2022-07-01  00:00:00'},' ',1398398025684004864,'hom_cancontact');

DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1447850659511659520;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FAPPLYSCOPE,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1447850659511659520,'1',1447850659511659520,'C','hom_canfamily_IMPT_S','IMPT','候选人家庭信息',{ts'2022-06-21  00:00:00'},'0',1398398025684004864,'1',{ts'2022-07-01  00:00:00'},' ',1398398025684004864,'hom_canfamily');


DELETE FROM t_bas_importtemplate_l WHERE FPKID = '2IUHUJK2L9HW';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1447851561253470208,'2IUHUJK2L9HW','zh_CN','候选人映射模板','候选人紧急联系人');

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '2IUHO+=FJMV+';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1447850659511659520,'2IUHO+=FJMV+','zh_CN','候选人映射模板','候选人家庭信息');


DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112498925568;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','0',' ',0,1447850112498925568,'hom_canfamily',1,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112549252096;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','0',' ',1447850112498925568,1447850112549252096,'billhead',2,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112557645824;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','1',' ',1447850112549252096,1447850112557645824,'id',3,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112566029312;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','1',' ',1447850112549252096,1447850112566029312,'initbatch',4,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112574423040;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','1',' ',1447850112549252096,1447850112574423040,'changedescription',5,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112582806528;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','1',' ',1447850112549252096,1447850112582806528,'description',6,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112591200256;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'1','1','number',1447850112549252096,1447850112591200256,'candidate',7,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112591195136;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','1',' ',1447850112549252096,1447850112591195136,'issingle',8,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112599588864;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'1','1','name',1447850112549252096,1447850112599588864,'familymembship',9,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112607972352;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'1','1',' ',1447850112549252096,1447850112607972352,'name',10,'1','家庭成员姓名',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112666697728;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'1','1',' ',1447850112549252096,1447850112666697728,'locationcode',11,'1','需填写电话的区位码，如中国大陆填写"86"',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112616366080;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'1','1',' ',1447850112549252096,1447850112616366080,'mobilephone',12,'1','需填写具体的联系电话，如"135xxxx8888"',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112624749568;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'1','1',' ',1447850112549252096,1447850112624749568,'contactaddr',13,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112649920512;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'1','1',' ',1447850112549252096,1447850112649920512,'workunit',14,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112658304000;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','1','number',1447850112549252096,1447850112658304000,'country',15,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112675081216;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','1',' ',1447850112549252096,1447850112675081216,'datastatus',16,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850112683474944;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447850659511659520,'0','1',' ',1447850112549252096,1447850112683474944,'sourcevid',17,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867515583488;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','0',' ',0,1447850867515583488,'hom_cancontact',1,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867557531648;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','0',' ',1447850867515583488,1447850867557531648,'billhead',2,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867574303744;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','1',' ',1447850867557531648,1447850867574303744,'id',3,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867574308864;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','1',' ',1447850867557531648,1447850867574308864,'initbatch',4,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867582692352;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','1',' ',1447850867557531648,1447850867582692352,'changedescription',5,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867591086080;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','1',' ',1447850867557531648,1447850867591086080,'description',6,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867599469568;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'1','1','number',1447850867557531648,1447850867599469568,'candidate',7,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867607863296;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','1',' ',1447850867557531648,1447850867607863296,'issingle',8,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867607858176;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'1','1',' ',1447850867557531648,1447850867607858176,'emrgname',9,'1','紧急联系人姓名',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867616251904;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'1','1','name',1447850867557531648,1447850867616251904,'emrgrelation',10,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867658194944;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'1','1',' ',1447850867557531648,1447850867658194944,'locationcode',11,'1','需填写电话的区位码，如中国大陆填写"86"',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867624635392;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'1','1',' ',1447850867557531648,1447850867624635392,'emrgphone',12,'1','需填写具体的联系电话，如"135xxxx8888"',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867633029120;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','1','number',1447850867557531648,1447850867633029120,'country',13,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867641412608;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','1',' ',1447850867557531648,1447850867641412608,'emrgaddress',14,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867658189824;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','1',' ',1447850867557531648,1447850867658189824,'datastatus',15,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1447850867666583552;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1447851561253470208,'0','1',' ',1447850867557531648,1447850867666583552,'sourcevid',16,'0',' ',' ',NULL);
