DELETE FROM t_hrcs_msgpublisher WHERE FID = 1335553746759046144;
INSERT INTO t_hrcs_msgpublisher(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FPUBLISHBDID,FPUBERID,FCREATETIME,FOFFLINEDATE,FENABLE,FACTIONCLOUD,FISSUBSCRIBE,FPUBLISHDATE,FDISABLERID,FID,FMSGPROBOID,FDISABLEDATE,FSIMPLENAME,FSTATUS,FUSESTATUS,FMSGPUBNO,FNUMBER,FNAME,FINDEX,FACTIONID,FMSGTAG,FMODIFIERID,FMODIFYTIME,FACTIONTYPEID,FACTIONAPP,FCREATORID,FPUBSTATUS) VALUES ('1','1','确认入职消息',1335553746759046144,103010,1270951057564008448,{ts'2022-01-17  00:00:00'},NULL,'1','11FWSEDXBS99','2',{ts'2022-02-21  00:00:00'},0,1335553746759046144,0,NULL,' ','C','A','MP20220117000056','MP20220117000056','确认入职',0,101010,' ',1632644734646361088,{ts'2023-05-24  00:00:00'},101010,'1WXB5G9/BL46',1250694749896102912,'P');

DELETE FROM t_hrcs_msgpublisher_l WHERE FPKID = '3=V+M3G7AT1E';
DELETE FROM t_hrcs_msgpublisher_l WHERE FPKID = '260HG=MG+LLK';
INSERT INTO t_hrcs_msgpublisher_l(FID,FPKID,FLOCALEID,FMSGTAG,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1335553746759046144,'260HG=MG+LLK','zh_CN',' ',' ','确认入职消息','确认入职');

DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1493435294999918597;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1335553746759046144,104010,1493435294999918597);
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1493435294999918598;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1335553746759046144,104020,1493435294999918598);

DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227265;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227265,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_perserlen","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"employeeId"}]',' ','{"data":{"businessstatus":"java.lang.String","createtime":"java.util.Date","adjustworktime":"java.math.BigDecimal","adjustcomtime":"java.math.BigDecimal","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","comsercount":"java.math.BigDecimal","socialworkage":"java.math.BigDecimal","joinworktime":"java.util.Date","description":"java.lang.String","workyear":"java.math.BigDecimal","datastatus":"java.lang.String","firstjoincomdate":"java.util.Date","sourcevid":"java.lang.Long","iscurrentversion":"java.lang.Boolean","employee_id":"java.lang.Long","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long","joincomdate":"java.util.Date","id":"long","person_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-服务年限','API20220210000072',1352921235960390656,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',4,'listInfo',1150721201652407296,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227266;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227266,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_perprotitle","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"personId"}]',' ','{"data":{"firsttime":"java.util.Date","prolevel_id":"java.lang.Long","certiicateid":"java.lang.String","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","description":"java.lang.String","office":"java.lang.String","iscompany":"java.lang.Boolean","professional_id":"java.lang.Long","sourcevid":"java.lang.Long","secondtime":"java.util.Date","details":"java.lang.String","id":"long","person_id":"java.lang.Long","createtime":"java.util.Date","approvnum":"java.lang.String","datastatus":"java.lang.String","unit":"java.lang.String","issingle":"java.lang.Boolean","iscurrentversion":"java.lang.Boolean","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long","awardtime":"java.util.Date","ishigh":"java.lang.Boolean"},"resultType":"java.util.List"}','人事事务变动-职称信息','API20220210000073',1352935241186161664,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',5,'listInfo',1270951057564008448,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227267;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227267,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_pernontsprop","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"personId"}]',' ',' ','人事事务变动-非时序属性','API20220210000074',1352938855451472896,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',6,'listInfo',1270951057564008448,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1692164274018844672;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1692164274018844672,'P','IOnbrdService','0','[{"type":"java.lang.Long","key":"billId"}]','根据id查询入职单信息','{"data":{"dependencytype":"java.lang.Long","dependency":"java.lang.Long","empgroup":"java.lang.Long","viewtype":"java.lang.String"},"resultType":"java.util.Map"}','入职单查询','API20230522002045',1690683973308626944,'A','java.util.Map','11FWSEDXBS99','1WXB5G9/BL46',17,'getOnbrdBillById',0,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227268;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227268,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_pertsprop","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"personId"}]',' ','{"data":{"brfd":"java.util.Date","bsled":"java.util.Date","healthstatus_id":"java.lang.Long","brled":"java.util.Date","bred":"java.util.Date","createtime":"java.util.Date","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","marriagestatus_id":"java.lang.Long","description":"java.lang.String","procreatstatus_id":"java.lang.Long","datastatus":"java.lang.String","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","iscurrentversion":"java.lang.Boolean","childrennumber":"java.lang.Integer","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long","id":"long","bsed":"java.util.Date","person_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-时序属性','API20220210000075',1352940460947158016,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',7,'listInfo',1270951057564008448,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1341906381959166976;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1341906381959166976,'P','IHRCSMsgService','1',' ',' ',' ','人事事务变动-人员查询','API20220125000051',1341359774121351168,'A',' ','0PEIU203SX4Y','0QO140ANVBBZ',1,'getDataBySub',1150721201652407296,' ','1','{"person":"人员","cmpemp":"所属管理范围","boid":"业务id","employee":"企业人员"}');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1341906381959166977;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1341906381959166977,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_trialperiod","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"employeeId"}]',' ',' ','人事事务变动-试用信息','API20220126000065',1341892060726262784,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',2,'listInfo',1150721201652407296,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227264;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227264,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_empjobrel","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"employeeId"}]',' ',' ','人事事务变动-职级职等','API20220210000071',1352894602364871680,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',3,'listInfo',1150721201652407296,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127298;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127298,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_managingscope","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"cmpempId"}]',' ',' ','人事事务变动-管理范围记录','API20220214000080',1355825638925219840,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',10,'listInfo',1270951057564008448,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127302;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127302,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_person","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","default":"0L","key":"personId"}]','获取自然人基本信息',' ','人事事务变动-自然人基本信息','API20220214000076',1355771386509054976,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',14,'listInfo',1270951057564008448,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1574638903464471552;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1574638903464471552,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_laborrelrecord","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"employeeId"}]',' ','{"data":{"bsled":"java.util.Date","bred":"java.util.Date","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","description":"java.lang.String","number":"java.lang.String","lawentity":"java.lang.Long","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"long","bsed":"java.util.Date","person_id":"java.lang.Long","brfd":"java.util.Date","businessstatus":"java.lang.String","brled":"java.util.Date","createtime":"java.util.Date","sysenddate":"java.util.Date","org":"java.lang.Long","datastatus":"java.lang.String","iscurrentversion":"java.lang.Boolean","employee_id":"java.lang.Long","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-用工关系记录','API20221123002011',1560239394412049408,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',16,'listInfo',0,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1402233075810866176;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1402233075810866176,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_pereduexp","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"personId"}]',' ',' ','人事事务变动-教育经历','API20220417000120',1400967165800215552,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',15,'listInfo',0,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127296;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127296,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_empentrel","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"employeeId"}]',' ',' ','人事事务变动-职业信息','API20220214000082',1355843782897226752,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',8,'listInfo',1270951057564008448,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127297;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127297,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_empposorgrel","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","key":"depempId"}]',' ',' ','人事事务变动-任职经历','API20220214000081',1355835341138900992,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',9,'listInfo',1270951057564008448,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127299;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127299,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_cmpemp","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","default":"0L","key":"cmpempId"}]',' ','{"data":{"isprimaryscope":"java.lang.Boolean","bsled":"java.util.Date","bred":"java.util.Date","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","description":"java.lang.String","managingscope_id":"java.lang.Long","startdate":"java.util.Date","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"long","bsed":"java.util.Date","person_id":"java.lang.Long","brfd":"java.util.Date","lastworkdate":"java.util.Date","businessstatus":"java.lang.String","brled":"java.util.Date","createtime":"java.util.Date","sysenddate":"java.util.Date","company_id":"java.lang.Long","datastatus":"java.lang.String","enddate":"java.util.Date","iscurrentversion":"java.lang.Boolean","employee_id":"java.lang.Long","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-所属管理范围','API20220214000079',1355822002220487680,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',11,'listInfo',1270951057564008448,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127300;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127300,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_depemp","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","default":"0L","key":"depempId"}]',' ','{"data":{"bsled":"java.util.Date","adminorg_id":"java.lang.Long","bred":"java.util.Date","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","description":"java.lang.String","startdate":"java.util.Date","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"long","stdposition_id":"java.lang.Long","bsed":"java.util.Date","person_id":"java.lang.Long","brfd":"java.util.Date","lastworkdate":"java.util.Date","businessstatus":"java.lang.String","brled":"java.util.Date","createtime":"java.util.Date","sysenddate":"java.util.Date","cmpemp_id":"java.lang.Long","datastatus":"java.lang.String","isprimary":"java.lang.Boolean","enddate":"java.util.Date","iscurrentversion":"java.lang.Boolean","postype_id":"java.lang.Long","employee_id":"java.lang.Long","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long","position_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-组织人','API20220214000078',1355810811012109312,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',12,'listInfo',1270951057564008448,' ','2',' ');
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127301;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127301,'P','IHRPIPersonSyncService','1','[{"type":"java.lang.String","default":"hrpi_employee","key":"entityName"},{"type":"java.lang.Long","key":"id"},{"type":"java.lang.Long","key":"boId"},{"type":"java.lang.Long","default":"0L","key":"employeeId"}]',' ','{"data":{"bsled":"java.util.Date","bred":"java.util.Date","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","mid":"java.lang.Long","description":"java.lang.String","startdate":"java.util.Date","laborreltype_id":"java.lang.Long","candidate_id":"java.lang.Long","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"long","bsed":"java.util.Date","person_id":"java.lang.Long","brfd":"java.util.Date","lastworkdate":"java.util.Date","businessstatus":"java.lang.String","brled":"java.util.Date","laborrelstatus_id":"java.lang.Long","createtime":"java.util.Date","empnumber":"java.lang.String","sysenddate":"java.util.Date","enterprise_id":"java.lang.Long","datastatus":"java.lang.String","enddate":"java.util.Date","iscurrentversion":"java.lang.Boolean","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-企业人','API20220214000077',1355777059179385856,'A','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',13,'listInfo',1270951057564008448,' ','2',' ');

DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '3=V+M3G7AT1G';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1692164274018844672,'3=V+M3G7AT1G','zh_CN','根据id查询入职单信息','入职单查询');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '26TYEUUSOO7V';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1341906381959166976,'26TYEUUSOO7V','zh_CN',' ','人事事务变动-人员查询');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '26TYEUUSOO7W';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1341906381959166977,'26TYEUUSOO7W','zh_CN',' ','人事事务变动-试用信息');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UH8';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227264,'28906LKO6UH8','zh_CN',' ','人事事务变动-职级职等');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UH9';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227265,'28906LKO6UH9','zh_CN',' ','人事事务变动-服务年限');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UH=';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227266,'28906LKO6UH=','zh_CN',' ','人事事务变动-职称信息');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UHA';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227267,'28906LKO6UHA','zh_CN',' ','人事事务变动-非时序属性');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UHB';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227268,'28906LKO6UHB','zh_CN',' ','人事事务变动-时序属性');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3K';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127296,'28IX83OX4G3K','zh_CN',' ','人事事务变动-职业信息');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3L';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127297,'28IX83OX4G3L','zh_CN',' ','人事事务变动-任职经历');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3M';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127298,'28IX83OX4G3M','zh_CN',' ','人事事务变动-管理范围记录');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3N';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127299,'28IX83OX4G3N','zh_CN',' ','人事事务变动-所属管理范围');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3O';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127300,'28IX83OX4G3O','zh_CN',' ','人事事务变动-组织人');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3P';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127301,'28IX83OX4G3P','zh_CN',' ','人事事务变动-企业人');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3Q';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127302,'28IX83OX4G3Q','zh_CN','获取自然人基本信息','人事事务变动-自然人基本信息');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '2D7Z7EQEVHOX';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1402233075810866176,'2D7Z7EQEVHOX','zh_CN',' ','人事事务变动-教育经历');
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '2YDYHR5YPR/E';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1574638903464471552,'2YDYHR5YPR/E','zh_CN',' ','人事事务变动-用工关系记录');

DELETE FROM t_hrcs_apisource WHERE FID = 1690683973308626944;
INSERT INTO t_hrcs_apisource(FTYPE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FMASTERID,FPUBERID,FCREATETIME,FENABLE,FKEY,FPARAM,FDISABLERID,FID,FVERSION,FOUTPUTPARAMTYPE,FDISABLEDATE,FSIMPLENAME,FSTATUS,FOUTPUTPARAM,FMAINENTITY,FNUMBER,FNAME,FINDEX,FSERVICEID,FMETHODID,FMODIFIERID,FBIZAPPID,FMODIFYTIME,FBIZCLOUDID,FCREATORID) VALUES ('2','0','[{"type":"java.lang.Long","key":"billId"}]','根据id查询入职单信息',1690683973308626944,1632644734646361088,{ts'2023-05-22  00:00:00'},'1','IOnbrdBillQuery',' ',0,1690683973308626944,0,'java.util.Map',NULL,' ','C','{"data":{"dependencytype":"java.lang.Long","dependency":"java.lang.Long","empgroup":"java.lang.Long","viewtype":"java.lang.String"},"resultType":"java.util.Map"}',' ','API20230522002045','入职单查询',0,'IOnbrdService','getOnbrdBillById',1632644734646361088,'1WXB5G9/BL46',{ts'2023-05-24  00:00:00'},'11FWSEDXBS99',1632644734646361088);

DELETE FROM t_hrcs_apisource_a WHERE FID = 1690683973308626944;
INSERT INTO t_hrcs_apisource_a(FID,FAPIXML,FNUMBER) VALUES (1690683973308626944,' ',' ');

DELETE FROM t_hrcs_apisource_l WHERE FPKID = '3=NX06JM4909';
INSERT INTO t_hrcs_apisource_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1690683973308626944,'3=NX06JM4909','zh_CN',' ','根据id查询入职单信息','入职单查询');

DELETE FROM t_hrcs_apiinput WHERE FENTRYID = 1690683974013270016;
INSERT INTO t_hrcs_apiinput(FID,FINPUTFIELDNAME,FINPUTFIELDTYPE,FINPUTFIELDDEFAULT,FENTRYID,FSEQ,FINPUTFIELDDESC,FINPUTFIELDKEY) VALUES (1690683973308626944,'入职单id','java.lang.Long',' ',1690683974013270016,1,'入职单id','billId');
DELETE FROM t_hrcs_apiinput_l WHERE FPKID = '3=NX06JM490A';
INSERT INTO t_hrcs_apiinput_l(FPKID,FLOCALEID,FINPUTFIELDNAME,FENTRYID,FINPUTFIELDDESC) VALUES ('3=NX06JM490A','zh_CN','入职单id',1690683974013270016,'入职单id');

DELETE FROM t_hrcs_apioutput WHERE FENTRYID = 1692157316045997056;
INSERT INTO t_hrcs_apioutput(FID,FENTRYID,FSEQ,FOUTPUTFIELDTYPE,FOUTPUTFIELDDESC,FOUTPUTFIELDKEY,FOUTPUTFIELDNAME) VALUES (1690683973308626944,1692157316045997056,1,'java.lang.String','1-首次入职 2-再入职','viewtype','入职场景');
DELETE FROM t_hrcs_apioutput WHERE FENTRYID = 1692157316045997057;
INSERT INTO t_hrcs_apioutput(FID,FENTRYID,FSEQ,FOUTPUTFIELDTYPE,FOUTPUTFIELDDESC,FOUTPUTFIELDKEY,FOUTPUTFIELDNAME) VALUES (1690683973308626944,1692157316045997057,2,'java.lang.Long',' ','dependency','人事管理属地');
DELETE FROM t_hrcs_apioutput WHERE FENTRYID = 1692157316045997058;
INSERT INTO t_hrcs_apioutput(FID,FENTRYID,FSEQ,FOUTPUTFIELDTYPE,FOUTPUTFIELDDESC,FOUTPUTFIELDKEY,FOUTPUTFIELDNAME) VALUES (1690683973308626944,1692157316045997058,3,'java.lang.Long',' ','dependencytype','属地员工类别');
DELETE FROM t_hrcs_apioutput WHERE FENTRYID = 1692157316045997059;
INSERT INTO t_hrcs_apioutput(FID,FENTRYID,FSEQ,FOUTPUTFIELDTYPE,FOUTPUTFIELDDESC,FOUTPUTFIELDKEY,FOUTPUTFIELDNAME) VALUES (1690683973308626944,1692157316045997059,4,'java.lang.Long',' ','empgroup','人事人员组');

DELETE FROM t_hrcs_apioutput_l WHERE FPKID = '3=UZAE1I1J4M';
INSERT INTO t_hrcs_apioutput_l(FPKID,FLOCALEID,FENTRYID,FOUTPUTFIELDDESC,FOUTPUTFIELDNAME) VALUES ('3=UZAE1I1J4M','zh_CN',1692157316045997056,'1-首次入职 2-再入职','入职场景');
DELETE FROM t_hrcs_apioutput_l WHERE FPKID = '3=UZAE1I1J4O';
INSERT INTO t_hrcs_apioutput_l(FPKID,FLOCALEID,FENTRYID,FOUTPUTFIELDDESC,FOUTPUTFIELDNAME) VALUES ('3=UZAE1I1J4O','zh_CN',1692157316045997057,' ','人事管理属地');
DELETE FROM t_hrcs_apioutput_l WHERE FPKID = '3=UZAE1I1J4Q';
INSERT INTO t_hrcs_apioutput_l(FPKID,FLOCALEID,FENTRYID,FOUTPUTFIELDDESC,FOUTPUTFIELDNAME) VALUES ('3=UZAE1I1J4Q','zh_CN',1692157316045997058,' ','属地员工类别');
DELETE FROM t_hrcs_apioutput_l WHERE FPKID = '3=UZAE1I1J4S';
INSERT INTO t_hrcs_apioutput_l(FPKID,FLOCALEID,FENTRYID,FOUTPUTFIELDDESC,FOUTPUTFIELDNAME) VALUES ('3=UZAE1I1J4S','zh_CN',1692157316045997059,' ','人事人员组');
