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,' ',1244200157814308864,{ts'2022-04-12  00:00:00'},101010,'1WXB5G9/BL46',1250694749896102912,'P'); 

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 = 1397100321758518272;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1335553746759046144,102010,1397100321758518272); 
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518273;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1335553746759046144,103010,1397100321758518273); 
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518274;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1335553746759046144,107010,1397100321758518274); 
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518275;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1335553746759046144,107020,1397100321758518275); 
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518276;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1335553746759046144,106010,1397100321758518276); 


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','0',' ',' ',' ','人事事务变动-人员查询','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','0','[{"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 = 1353615310569227267;
INSERT INTO t_hrcs_msgpublishapi(fid, fpubapiid, fseq, fissyspreset, fenable, fapipubstatus, fapipuberid, fapino, fapisourceid, fname, fdescription, fapipubservice, fapipubmethod, fapitype, fnumber, fapipubcloudid, fapipubappid, fparams, foutputtype, foutputparam, finputparam)
VALUES(1335553746759046144, 1353615310569227267, 6, '0', 'A', 'P', 1270951057564008448, ' ', 1352938855451472896, '人事事务变动-非时序属性', ' ', 'IHRPIPersonSyncService', 'listInfo', '2', 'API20220210000074', '0PEIU203SX4Y', '0QO140ANVBBZ', ' ', 'java.util.List', '{"data":{"ns_title":"java.lang.String","hisversion":"java.lang.String","boid":"java.lang.Long","ns_firstname":"java.lang.String","deathdate":"java.util.Date","ns_customfield1":"java.lang.String","bloodtype":"java.lang.String","ns_customfield2":"java.lang.String","ns_customfield3":"java.lang.String","ns_customfield4":"java.lang.String","lunarcalendarbirthday":"java.util.Date","ns_middlename":"java.lang.String","id":"long","headsculpture":"java.lang.String","height":"java.lang.Integer","person_id":"java.lang.Long","datastatus":"java.lang.String","enname":"java.lang.String","entservicelen":"java.math.BigDecimal","iscurrentversion":"java.lang.Boolean","name":"java.lang.String","creator_id":"java.lang.Long","birthday":"java.util.Date","modifytime":"java.util.Date","nationality_id":"java.lang.Long","description":"java.lang.String","nativelngname":"java.lang.String","nameen":"java.lang.String","title":"java.lang.String","ns_country_id":"java.lang.Long","ns_namestyle_id":"java.lang.Long","sourcevid":"java.lang.Long","beginservicedate":"java.util.Date","julianbirthday":"java.util.Date","symbolicanimals_id":"java.lang.Long","createtime":"java.util.Date","birthdaytype":"java.lang.String","ns_posttitle":"java.lang.String","gender_id":"java.lang.Long","ns_lastname":"java.lang.String","marriageregistdate":"java.util.Date","constellation_id":"java.lang.Long","servicelen":"java.math.BigDecimal","formername":"java.lang.String","ns_nickname":"java.lang.String","displayname":"java.lang.String","ismodify":"java.lang.String","ns_abbr":"java.lang.String","modifier_id":"java.lang.Long","folk_id":"java.lang.Long","age":"java.lang.Integer"},"resultType":"java.util.List"}', '[{"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"}]');

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','0','[{"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 = 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','0','[{"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 = 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','0','[{"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 = 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','0','[{"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 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','0','[{"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 = 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','0','[{"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','0','[{"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 = 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','0','[{"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','0','[{"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 = 1355884770483127296;
INSERT INTO t_hrcs_msgpublishapi(fid, fpubapiid, fseq, fissyspreset, fenable, fapipubstatus, fapipuberid, fapino, fapisourceid, fname, fdescription, fapipubservice, fapipubmethod, fapitype, fnumber, fapipubcloudid, fapipubappid, fparams, foutputtype, foutputparam, finputparam)
VALUES(1335553746759046144, 1355884770483127296, 8, '0', 'A', 'P', 1270951057564008448, ' ', 1355843782897226752, '人事事务变动-职业信息', ' ', 'IHRPIPersonSyncService', 'listInfo', '2', 'API20220214000082', '0PEIU203SX4Y', '0QO140ANVBBZ', ' ', 'java.util.List', '{"data":{"bsled":"java.util.Date","bred":"java.util.Date","laborsubcate_id":"java.lang.Long","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","description":"java.lang.String","isprobation":"java.lang.Boolean","startdate":"java.util.Date","laborreltype_id":"java.lang.Long","number":"java.lang.String","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"long","labrelstatusprd_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","onboardsource_id":"java.lang.Long","brled":"java.util.Date","laborrelstatus_id":"java.lang.Long","createtime":"java.util.Date","empnumber":"java.lang.String","sysenddate":"java.util.Date","adjustlength":"java.math.BigDecimal","enterprise_id":"java.lang.Long","datastatus":"java.lang.String","oldempnumber":"java.lang.String","issingle":"java.lang.Boolean","enddate":"java.util.Date","iscurrentversion":"java.lang.Boolean","servicelength":"java.math.BigDecimal","firststartdate":"java.util.Date","employee_id":"java.lang.Long","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long","preemployee_id":"java.lang.Long"},"resultType":"java.util.List"}', '[{"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"}]');

DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127297;
INSERT INTO t_hrcs_msgpublishapi(fid, fpubapiid, fseq, fissyspreset, fenable, fapipubstatus, fapipuberid, fapino, fapisourceid, fname, fdescription, fapipubservice, fapipubmethod, fapitype, fnumber, fapipubcloudid, fapipubappid, fparams, foutputtype, foutputparam, finputparam)
VALUES(1335553746759046144, 1355884770483127297, 9, '0', 'A', 'P', 1270951057564008448, ' ', 1355835341138900992, '人事事务变动-任职经历', ' ', 'IHRPIPersonSyncService', 'listInfo', '2', 'API20220214000081', '0PEIU203SX4Y', '0QO140ANVBBZ', ' ', 'java.util.List', '{"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","variationtype_id":"java.lang.Long","description":"java.lang.String","startdate":"java.util.Date","posstatus_id":"java.lang.Long","isexistprobation":"java.lang.Boolean","number":"java.lang.String","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","endprobation":"java.util.Date","depemp_id":"java.lang.Long","id":"long","darkposition_id":"java.lang.Long","stdposition_id":"java.lang.Long","bsed":"java.util.Date","startprobation":"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","cmpemp_id":"java.lang.Long","datastatus":"java.lang.String","isprimary":"java.lang.String","issingle":"java.lang.Boolean","enddate":"java.util.Date","iscurrentversion":"java.lang.Boolean","islatestrecord":"java.lang.Boolean","job_id":"java.lang.Long","servicelength":"java.lang.Integer","employee_id":"java.lang.Long","postype_id":"java.lang.Long","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long","isinsystem":"java.lang.Boolean","workplace_id":"java.lang.Long","position_id":"java.lang.Long"},"resultType":"java.util.List"}', '[{"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"}]');

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','0','[{"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_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',' ','人事事务变动-教育经历'); 


