-- 待入职启动
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277341092475328524;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277347887088424960,'1','1',' ',1277341092467030016,1277341092475328524,'effectdate',44,'0','入职日期与入职地点需同步录入',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277341092475418627;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277347887088424960,'1','1','name',1277341092467030016,1277341092475418627,'onbrdtype',26,'1','请根据场景填写“正式员工入职”或“实习生入职”','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277341092508882944;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277347887088424960,'1','1','number',1277341092467030016,1277341092508882944,'ajoblevel',48,'0',' ','number',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277341092508973057;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277347887088424960,'1','1','number',1277341092467030016,1277341092508973057,'ajobgrade',49,'0',' ','number',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1371028896270683136;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277347887088424960,'1','1','name',1277341092467030016,1371028896270683136,'contractlocation',22,'1','协议工作地所在城市，如"北京"','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1376840556121987076;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277347887088424960,'1','1','number',1277341092467030016,1376840556121987076,'handler',25,'1','跟进该名员工入职全流程的负责人','number',NULL);

-- 语言证书
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277481529525688324;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277483463879972864,'1','1','name',1277481529525778432,1277481529525688324,'educationid',11,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277481529525778437;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277483463879972864,'1','1','name',1277481529525778432,1277481529525778437,'degreeid',12,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277487245766449152;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277489129906526208,'1','1','number',1277487245758150656,1277487245766449152,'certificate',6,'1','如待入职员工的语言证书未在系统的基础资料维护，请在此录入其他，并在其他语言证书录入证书名称','number',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277487245766539266;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277489129906526208,'1','1',' ',1277487245758150656,1277487245766539266,'score',9,'1','根据具体证书，填写分数或者等级水平',' ',NULL);

-- 前工作经经历
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277489548967827458;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277490749084030976,'1','1',' ',1277489548967917568,1277489548967827458,'enddate',7,'1',' ',' ',NULL);

-- 家庭信息
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277486429974321155;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277487078505994240,'1','1',' ',1277486429974321152,1277486429974321155,'name',8,'1','家庭成员姓名',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1277486429974411268;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1277487078505994240,'1','1',' ',1277486429974321152,1277486429974411268,'mobilephone',9,'1','需填写电话的区位码，如"86-135xxxx8888"',' ',NULL);

-- 银行卡信息
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1378135393567896580;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1378137362986550272,'1','1','number',1378135393567884288,1378135393567896580,'socialrel',11,'0',' ','name',NULL);
