--hmp
-- 注册 组织人与薪资档案关联关系查询 接口
-- 主表
DELETE FROM t_hrcs_apisource WHERE FID = 1504977659711516672;
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','1','[{"type":"long","key":"depEmpId"},{"type":"java.util.Date","key":"effectTime"}]',' ',1504977659711516672,949756199442610176,{ts'2022-09-08  00:00:00'},'1','matchSalaryFile',' ',0,1504977659711516672,0,'java.util.Map',NULL,' ','C','{"data":{"isSalaryExist":"boolean"},"resultType":"java.util.Map"}',' ','API20220908001004','组织人与薪资档案关联关系查询',0,'ISalaryFileService','matchSalaryFile',949756199442610176,'/UHMBBGZQ65X',{ts'2022-09-08  00:00:00'},'/U+QDTL900//',949756199442610176); 

DELETE FROM t_hrcs_apisource_l WHERE FPKID = '2PV6LFU8V4PC';
INSERT INTO t_hrcs_apisource_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1504977659711516672,'2PV6LFU8V4PC','zh_CN',' ',' ','组织人与薪资档案关联关系查询'); 
DELETE FROM t_hrcs_apisource_l WHERE FPKID = '2PV6LFU8V4PD';
--INSERT INTO t_hrcs_apisource_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1504977659711516672,'2PV6LFU8V4PD','zh_TW',' ',' ','組織人與薪資檔案關聯關係查詢'); 
-- 入参分录表
DELETE FROM t_hrcs_apiinput WHERE FENTRYID = 1504977659912843265;
INSERT INTO t_hrcs_apiinput(FID,FINPUTFIELDNAME,FINPUTFIELDTYPE,FINPUTFIELDDEFAULT,FENTRYID,FSEQ,FINPUTFIELDDESC,FINPUTFIELDKEY) VALUES (1504977659711516672,'组织人ID','long',' ',1504977659912843265,1,'组织人ID','depEmpId'); 
DELETE FROM t_hrcs_apiinput WHERE FENTRYID = 1504977659912843264;
INSERT INTO t_hrcs_apiinput(FID,FINPUTFIELDNAME,FINPUTFIELDTYPE,FINPUTFIELDDEFAULT,FENTRYID,FSEQ,FINPUTFIELDDESC,FINPUTFIELDKEY) VALUES (1504977659711516672,'生效日期','java.util.Date',' ',1504977659912843264,2,'生效日期','effectTime'); 

DELETE FROM t_hrcs_apiinput_l WHERE FPKID = '2PV6LFU8V4PG';
INSERT INTO t_hrcs_apiinput_l(FPKID,FLOCALEID,FINPUTFIELDNAME,FENTRYID,FINPUTFIELDDESC) VALUES ('2PV6LFU8V4PG','zh_CN','组织人ID',1504977659912843265,'组织人ID'); 
DELETE FROM t_hrcs_apiinput_l WHERE FPKID = '2PV6LFU8V4PH';
--INSERT INTO t_hrcs_apiinput_l(FPKID,FLOCALEID,FINPUTFIELDNAME,FENTRYID,FINPUTFIELDDESC) VALUES ('2PV6LFU8V4PH','zh_TW','組織人ID',1504977659912843265,'組織人ID'); 
DELETE FROM t_hrcs_apiinput_l WHERE FPKID = '2PV6LFU8V4PE';
INSERT INTO t_hrcs_apiinput_l(FPKID,FLOCALEID,FINPUTFIELDNAME,FENTRYID,FINPUTFIELDDESC) VALUES ('2PV6LFU8V4PE','zh_CN','生效日期',1504977659912843264,'生效日期'); 
DELETE FROM t_hrcs_apiinput_l WHERE FPKID = '2PV6LFU8V4PF';
--INSERT INTO t_hrcs_apiinput_l(FPKID,FLOCALEID,FINPUTFIELDNAME,FENTRYID,FINPUTFIELDDESC) VALUES ('2PV6LFU8V4PF','zh_TW','生效日期',1504977659912843264,'生效日期'); 

--出参分录表
DELETE FROM t_hrcs_apioutput WHERE FENTRYID = 1504977659912843266;
INSERT INTO t_hrcs_apioutput(FID,FENTRYID,FSEQ,FOUTPUTFIELDTYPE,FOUTPUTFIELDDESC,FOUTPUTFIELDKEY,FOUTPUTFIELDNAME,FBASEDATAFIELD) VALUES (1504977659711516672,1504977659912843266,1,'boolean','是否存在档案','isSalaryExist','是否存在档案',' '); 

DELETE FROM t_hrcs_apioutput_l WHERE FPKID = '2PV6LFU8V4PI';
INSERT INTO t_hrcs_apioutput_l(FPKID,FLOCALEID,FENTRYID,FOUTPUTFIELDDESC,FOUTPUTFIELDNAME) VALUES ('2PV6LFU8V4PI','zh_CN',1504977659912843266,'是否存在档案','是否存在档案'); 
DELETE FROM t_hrcs_apioutput_l WHERE FPKID = '2PV6LFU8V4PJ';
--INSERT INTO t_hrcs_apioutput_l(FPKID,FLOCALEID,FENTRYID,FOUTPUTFIELDDESC,FOUTPUTFIELDNAME) VALUES ('2PV6LFU8V4PJ','zh_TW',1504977659912843266,'是否存在檔案','是否存在檔案'); 


--扩展表
DELETE FROM t_hrcs_apisource_a WHERE FID = 1504977659711516672;
INSERT INTO t_hrcs_apisource_a(FID,FAPIXML,FNUMBER) VALUES (1504977659711516672,' ','API20220908001004'); 
