DELETE FROM t_hrcs_apisource WHERE FID = 1392786704389111808;
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"}]',' ',1392786704389111808,1204935858868818944,{ts'2022-04-06  00:00:00'},'1','IRegBillService',' ',0,1392786704389111808,0,'java.util.Map',NULL,' ','C','{"data":{"effectdate":"java.util.Date","regbilltype":"java.lang.String","regcategory":"java.lang.String"},"resultType":"java.util.Map"}',' ','API20220406000108','转正单查询',0,'IRegBillService','getRegBillById',1204935858868818944,'1WX49GDDDZ0V',{ts'2022-04-06  00:00:00'},'11FWSEDXBS99',1204935858868818944); 


 DELETE FROM T_HRCS_APISOURCE_A WHERE fid=1392786704389111808;
 INSERT INTO T_HRCS_APISOURCE_A(fid,fapixml,fnumber)
 VALUES(1392786704389111808,'<?xml version="1.0" encoding="UTF-8"?>

<APIMetadata>
	<BizCloudId>11FWSEDXBS99</BizCloudId>
	<BizAppId>1WX49GDDDZ0V</BizAppId>
	<Id>1392786704389111808</Id>
	<Version>1649242871571</Version>
	<Number>API20220406000108</Number>
	<Key>IRegBillService</Key>
	<Name>转正单查询</Name>
	<Description></Description>
	<ApiType>2</ApiType>
	<Service>IRegBillService</Service>
	<Method>getRegBillById</Method>
	<InputParam>[{"type":"java.lang.Long","key":"billId"}]</InputParam>
	<OutputParam>{"data":{"effectdate":"java.util.Date","regbilltype":"java.lang.String","regcategory":"java.lang.String"},"resultType":"java.util.Map"}</OutputParam>
	<Param>[{"type":"java.lang.Long","key":"billId"}]</Param>
	<Enable>1</Enable>
	<APIInputDataXml>
		<APIEntity>
			<APIFields>
				<APIField>
					<Key>billId</Key>
					<Name>转正单据ID</Name>
					<Type>java.lang.Long</Type>
				</APIField>
			</APIFields>
		</APIEntity>
	</APIInputDataXml>
	<APIDataXml>
		<APIEntity>
			<APIFields>
				<APIField>
					<Key>effectdate</Key>
					<Name>实际转正日期</Name>
					<Type>java.util.Date</Type>
				</APIField>
				<APIField>
					<Key>regbilltype</Key>
					<Name>转正单类型</Name>
					<Type>java.lang.String</Type>
				</APIField>
				<APIField>
					<Key>regcategory</Key>
					<Name>转正分类</Name>
					<Type>java.lang.String</Type>
				</APIField>
			</APIFields>
		</APIEntity>
	</APIDataXml>
</APIMetadata>',' ');
 DELETE FROM T_HRCS_MSGPUBLISHER WHERE fid=1393289364846411776;
 INSERT INTO T_HRCS_MSGPUBLISHER(fid,fnumber,fname,fstatus,fcreatorid,fmodifierid,fenable,fcreatetime,fmodifytime,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fsimplename,fdescription,fpublishbdid,factiontypeid,fpublishdate,fofflinedate,fsubstatus,fissubscribe,fpuberid,fpubstatus,fusestatus,fmsgpubno,factioncloud,factionapp,fmsgtag,factionid,fmsgproboid)
 VALUES(1393289364846411776,'MP20220407000106','转正生效协同','A',1,1,'1',{ts'2022-04-07 08:54:07'},{ts'2022-04-07 09:58:37'},1393289364846411776,0,null,0,'1',' ','转正生效后发送消息至中台',103010,101090,{ts'2022-04-07 08:57:15'},null,'0','2',1204935858868818944,'P',' ','MP20220407000106','11FWSEDXBS99','1WX49GDDDZ0V',' ',101090,0);
 
DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1393289364997406720;
 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(1393289364846411776,1393289364997406720,1,'1','A','P',0,' ',1392786704389111808,'转正单查询',' ','IRegBillService','getRegBillById','2','API20220406000108','11FWSEDXBS99','1WX49GDDDZ0V',' ','java.util.Map','{"data":{"effectdate":"java.util.Date","regbilltype":"java.lang.String","regcategory":"java.lang.String"},"resultType":"java.util.Map"}','[{"type":"java.lang.Long","key":"billId"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130816;
 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(1393289364846411776,1394022137060130816,2,'1','A','P',0,' ',1355825638925219840,'人事事务变动-管理范围记录',' ','IHRPIPersonSyncService','listInfo','2','API20220214000080','0PEIU203SX4Y','0QO140ANVBBZ',' ','java.util.List','{"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","variationtype_id":"java.lang.Long","description":"java.lang.String","managingscope_id":"java.lang.Long","startdate":"java.util.Date","number":"java.lang.String","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","cmpemp_id":"java.lang.Long","datastatus":"java.lang.String","issingle":"java.lang.Boolean","enddate":"java.util.Date","iscurrentversion":"java.lang.Boolean","islatestrecord":"java.lang.Boolean","employee_id":"java.lang.Long","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long","workplace_id":"java.lang.Long"},"resultType":"java.util.List"}','[{"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"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130817;
 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(1393289364846411776,1394022137060130817,3,'1','A','P',0,' ',1355822002220487680,'人事事务变动-所属管理范围',' ','IHRPIPersonSyncService','listInfo','2','API20220214000079','0PEIU203SX4Y','0QO140ANVBBZ',' ','java.util.List','{"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"}','[{"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"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130818;
 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(1393289364846411776,1394022137060130818,4,'1','A','P',0,' ',1355810811012109312,'人事事务变动-组织人',' ','IHRPIPersonSyncService','listInfo','2','API20220214000078','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","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"}','[{"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"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130819;
 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(1393289364846411776,1394022137060130819,5,'1','A','P',0,' ',1355777059179385856,'人事事务变动-企业人',' ','IHRPIPersonSyncService','listInfo','2','API20220214000077','0PEIU203SX4Y','0QO140ANVBBZ',' ','java.util.List','{"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"}','[{"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"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130820;
 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(1393289364846411776,1394022137060130820,6,'1','A','P',0,' ',1355771386509054976,'人事事务变动-自然人基本信息','获取自然人基本信息','IHRPIPersonSyncService','listInfo','2','API20220214000076','0PEIU203SX4Y','0QO140ANVBBZ',' ','java.util.List','{"data":{"ns_title":"java.lang.String","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","description":"java.lang.String","ns_firstname":"java.lang.String","ns_country_id":"java.lang.Long","ns_namestyle_id":"java.lang.Long","number":"java.lang.String","ns_customfield1":"java.lang.String","sourcevid":"java.lang.Long","ns_customfield2":"java.lang.String","ns_customfield3":"java.lang.String","ns_customfield4":"java.lang.String","ns_middlename":"java.lang.String","id":"long","headsculpture":"java.lang.String","createtime":"java.util.Date","ns_posttitle":"java.lang.String","index":"java.lang.Integer","datastatus":"java.lang.String","ns_lastname":"java.lang.String","ishrcreate":"java.lang.Boolean","iscurrentversion":"java.lang.Boolean","ns_nickname":"java.lang.String","ismodify":"java.lang.String","ns_abbr":"java.lang.String","name":"java.lang.String","personindexid":"java.lang.Long","modifier_id":"java.lang.Long","creator_id":"java.lang.Long"},"resultType":"java.util.List"}','[{"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"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130821;
 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(1393289364846411776,1394022137060130821,7,'1','A','P',0,' ',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=1394022137060130822;
 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(1393289364846411776,1394022137060130822,8,'1','A','P',0,' ',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=1394022137060130823;
 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(1393289364846411776,1394022137060130823,9,'1','A','P',0,' ',1352940460947158016,'人事事务变动-时序属性',' ','IHRPIPersonSyncService','listInfo','2','API20220210000075','0PEIU203SX4Y','0QO140ANVBBZ',' ','java.util.List','{"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"}','[{"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"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130824;
 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(1393289364846411776,1394022137060130824,10,'1','A','P',0,' ',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=1394022137060130825;
 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(1393289364846411776,1394022137060130825,11,'1','A','P',0,' ',1352935241186161664,'人事事务变动-职称信息',' ','IHRPIPersonSyncService','listInfo','2','API20220210000073','0PEIU203SX4Y','0QO140ANVBBZ',' ','java.util.List','{"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"}','[{"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"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130826;
 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(1393289364846411776,1394022137060130826,12,'1','A','P',0,' ',1352921235960390656,'人事事务变动-服务年限',' ','IHRPIPersonSyncService','listInfo','2','API20220210000072','0PEIU203SX4Y','0QO140ANVBBZ',' ','java.util.List','{"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"}','[{"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"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130827;
 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(1393289364846411776,1394022137060130827,13,'1','A','P',0,' ',1352894602364871680,'人事事务变动-职级职等',' ','IHRPIPersonSyncService','listInfo','2','API20220210000071','0PEIU203SX4Y','0QO140ANVBBZ',' ','java.util.List','{"data":{"bsled":"java.util.Date","adminorg_id":"java.lang.Long","bred":"java.util.Date","jobscm_id":"java.lang.Long","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","variationtype_id":"java.lang.Long","description":"java.lang.String","joblength":"java.lang.Integer","startdate":"java.util.Date","hrbu_id":"java.lang.Long","jobgrade_id":"java.lang.Long","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"long","joblevel_id":"java.lang.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","jobseq_id":"java.lang.Long","company_id":"java.lang.Long","datastatus":"java.lang.String","jobfamily_id":"java.lang.Long","issingle":"java.lang.Boolean","enddate":"java.util.Date","iscurrentversion":"java.lang.Boolean","job_id":"java.lang.Long","employee_id":"java.lang.Long","ismodify":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long","jobclass_id":"java.lang.Long","position_id":"java.lang.Long"},"resultType":"java.util.List"}','[{"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"}]');
 DELETE FROM T_HRCS_MSGPUBLISHAPI WHERE fpubapiid=1394022137060130828;
 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(1393289364846411776,1394022137060130828,14,'1','A','P',0,' ',1341892060726262784,'人事事务变动-试用信息',' ','IHRPIPersonSyncService','listInfo','2','API20220126000065','0PEIU203SX4Y','0QO140ANVBBZ',' ','java.util.List','{"data":{"realregulardate":"java.util.Date","bsled":"java.util.Date","bred":"java.util.Date","hisversion":"java.lang.String","modifytime":"java.util.Date","boid":"java.lang.Long","trialperiodrst_id":"java.lang.Long","description":"java.lang.String","startdate":"java.util.Date","probationunit":"java.lang.String","regcategory":"java.lang.String","preregulardate":"java.util.Date","number":"java.lang.String","probation":"java.lang.Integer","sourcevid":"java.lang.Long","entrydate":"java.util.Date","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"long","bsed":"java.util.Date","examscore":"java.math.BigDecimal","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","examstatus":"java.lang.String","datastatus":"java.lang.String","issingle":"java.lang.Boolean","enddate":"java.util.Date","iscurrentversion":"java.lang.Boolean","askstatus":"java.lang.String","employee_id":"java.lang.Long","ismodify":"java.lang.String","regcomment":"java.lang.String","modifier_id":"java.lang.Long","creator_id":"java.lang.Long","regstatus":"java.lang.String"},"resultType":"java.util.List"}','[{"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"}]');
 
 
 
 DELETE FROM T_HRCS_APISOURCE_L WHERE FPKID='2C1P6WFXVML6';
 INSERT INTO T_HRCS_APISOURCE_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('2C1P6WFXVML6',1392786704389111808,'zh_CN','转正单查询',' ',' ');
 DELETE FROM T_HRCS_APIINPUT_L WHERE FPKID='2C1P6WFXVML8';
 INSERT INTO T_HRCS_APIINPUT_L(fpkid,fentryid,flocaleid,finputfieldname,finputfielddesc)
 VALUES('2C1P6WFXVML8',1392786704623992832,'zh_CN','转正单据ID',' ');
 DELETE FROM T_HRCS_APIOUTPUT_L WHERE FPKID='2C1P6WFXVML=';
 INSERT INTO T_HRCS_APIOUTPUT_L(fpkid,fentryid,flocaleid,foutputfieldname,foutputfielddesc)
 VALUES('2C1P6WFXVML=',1392786704623992833,'zh_CN','实际转正日期',' ');
 DELETE FROM T_HRCS_APIOUTPUT_L WHERE FPKID='2C22HC9B=4X7';
 INSERT INTO T_HRCS_APIOUTPUT_L(fpkid,fentryid,flocaleid,foutputfieldname,foutputfielddesc)
 VALUES('2C22HC9B=4X7',1392868560476308480,'zh_CN','转正单类型',' ');
 DELETE FROM T_HRCS_APIOUTPUT_L WHERE FPKID='2C22HC9B=4X9';
 INSERT INTO T_HRCS_APIOUTPUT_L(fpkid,fentryid,flocaleid,foutputfieldname,foutputfielddesc)
 VALUES('2C22HC9B=4X9',1392868560476308481,'zh_CN','转正分类',' ');
 DELETE FROM T_HRCS_MSGPUBLISHER_L WHERE FPKID='2C433ROO6V47';
 INSERT INTO T_HRCS_MSGPUBLISHER_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription,fmsgtag)
 VALUES('2C433ROO6V47',1393289364846411776,'zh_CN','转正生效协同',' ','转正生效后发送消息至中台',' ');
 DELETE FROM T_HRCS_MSGPUBLISHAPI_L WHERE FPKID='2C433ROO6V49';
 INSERT INTO T_HRCS_MSGPUBLISHAPI_L(fpkid,fpubapiid,flocaleid,fname,fdescription)
 VALUES('2C433ROO6V49',1393289364997406720,'zh_CN','转正单查询',' ');
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281792;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281792,1393289364846411776,103010);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281793;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281793,1393289364846411776,107010);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281794;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281794,1393289364846411776,107020);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281795;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281795,1393289364846411776,101010);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281796;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281796,1393289364846411776,101020);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281797;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281797,1393289364846411776,102010);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281798;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281798,1393289364846411776,104010);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281799;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281799,1393289364846411776,104020);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281800;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281800,1393289364846411776,105010);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281801;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281801,1393289364846411776,106010);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281802;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281802,1393289364846411776,107030);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281803;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281803,1393289364846411776,107040);
 DELETE FROM T_HRCS_SUBBSIFIELD WHERE fpkid=1393320253605281804;
 INSERT INTO T_HRCS_SUBBSIFIELD(fpkid,fid,fbasedataid)
 VALUES(1393320253605281804,1393289364846411776,108010);
 
 DELETE FROM T_HRCS_APIINPUT WHERE fentryid=1392786704623992832;
 INSERT INTO T_HRCS_APIINPUT(fid,fentryid,fseq,finputfieldkey,finputfieldname,finputfieldtype,finputfielddesc,finputfielddefault)
 VALUES(1392786704389111808,1392786704623992832,1,'billId','转正单据ID','java.lang.Long',' ',' ');
 DELETE FROM T_HRCS_APIOUTPUT WHERE fentryid=1392786704623992833;
 INSERT INTO T_HRCS_APIOUTPUT(fid,fentryid,fseq,foutputfieldkey,foutputfieldname,foutputfieldtype,foutputfielddesc)
 VALUES(1392786704389111808,1392786704623992833,1,'effectdate','实际转正日期','java.util.Date',' ');
 DELETE FROM T_HRCS_APIOUTPUT WHERE fentryid=1392868560476308480;
 INSERT INTO T_HRCS_APIOUTPUT(fid,fentryid,fseq,foutputfieldkey,foutputfieldname,foutputfieldtype,foutputfielddesc)
 VALUES(1392786704389111808,1392868560476308480,2,'regbilltype','转正单类型','java.lang.String',' ');
 DELETE FROM T_HRCS_APIOUTPUT WHERE fentryid=1392868560476308481;
 INSERT INTO T_HRCS_APIOUTPUT(fid,fentryid,fseq,foutputfieldkey,foutputfieldname,foutputfieldtype,foutputfielddesc)
 VALUES(1392786704389111808,1392868560476308481,3,'regcategory','转正分类','java.lang.String',' ');
