-- 业务类型与应用
DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fnumber in('1220_S','1230_S','1240_S','1250_S','1260_S','1270_S','1280_S','1290_S','1300_S','1310_S','1320_S','1330_S');
DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1330;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1330,'1330_S','C',1,{ts'2022-05-11 18:38:20'},1,{ts'2022-05-11 18:38:20'},'1',1330,0,null,0,'1','19KOKMMSZFZJ',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1220;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1220,'1220_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-10-08 15:15:57'},'1',1220,0,null,0,'1','2MRET//UCEBW',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1450;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1450,'1450_S','C',1,{ts'2022-05-11 18:38:47'},1,{ts'2022-05-11 18:39:14'},'1',1450,0,null,0,'1','2AXKDRPJUQ77',107050,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1260;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1260,'1260_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-05-11 00:00:00'},'1',1260,0,null,0,'1','15R5/4TCA97N',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1270;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1270,'1270_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-05-11 00:00:00'},'1',1270,0,null,0,'1','1C8H4/N38LCY',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1230;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1230,'1230_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-10-08 15:16:25'},'1',1230,0,null,0,'1','1O9FSW4YM0ZO',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1240;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1240,'1240_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-10-08 15:16:48'},'1',1240,0,null,0,'1','15=TGRTUNG1B',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1250;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1250,'1250_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-10-08 15:17:10'},'1',1250,0,null,0,'1','15R4TU4TF8YZ',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1280;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1280,'1280_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-05-11 00:00:00'},'1',1280,0,null,0,'1','2MUA/1KC/DUS',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1290;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1290,'1290_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-06-29 00:00:00'},'1',1290,0,null,0,'1','2MRJ2X=2VZX9',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1300;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1300,'1300_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-05-11 00:00:00'},'1',1300,0,null,0,'1','1Q=BI7RA+PXM',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1310;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1310,'1310_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-05-11 00:00:00'},'1',1310,0,null,0,'1','2MKKI+46MWNZ',104010,' ',' ','  ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1320;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1320,'1320_S','C',1,{ts'2022-05-11 00:00:00'},1,{ts'2022-05-11 00:00:00'},'1',1320,0,null,0,'1','1O9FOLRY18YW',104010,' ',' ','  ');



 -- 职能类型
 DELETE FROM T_HBSS_HRBUCA WHERE fid=26;
 INSERT INTO T_HBSS_HRBUCA(fid,fnumber,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fstatus,fdisablerid,fdisabledate,findex,fmasterid,fissyspreset,fhrbubaid,fdybutton,fhrbucafuncid,ffinalparentid,fparentid,fsyncstrategy,fname,fsimplename,fdescription)
 VALUES(26,'26',1,{ts'2020-05-15 17:01:58'},1,{ts'2022-10-10 11:03:20'},'1','C',0,null,0,26,'1',0,' ',0,0,11,'0','考勤业务视图默认方案',' ','考勤业务视图是反应全部考勤组织上下层级关系的树状结构。');
 DELETE FROM T_HBSS_HRBUCA_L WHERE FPKID='16489YU7AYGL';
 INSERT INTO T_HBSS_HRBUCA_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('16489YU7AYGL',26,'zh_CN','考勤业务视图默认方案',' ','考勤业务视图是反应全部考勤组织上下层级关系的树状结构。');













 