DELETE FROM t_cr_coderule WHERE FID = '21CYCX=B7=F9';
INSERT INTO t_cr_coderule(FFILTERCONDITION,FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID,FCONDITIONDESC) VALUES ('{"filterRow":[{"id":"2YATQ5+OEX0B","leftBracket":"","compareType":"105","fieldName":"viewtype","rightBracket":"","logic":"0","value":[{"id":"2YATQ5+OEXPL","value":"2"}],"baseDataIds":[]}],"forList":false}',' ','2','1','0','21CYCX=B7=F9','0',NULL,'0',{ts'2021-11-26  00:00:00'},'hom_onbrdbillbase','1','0','0','1',NULL,'0','21CYCX=B7=F9','-','1',NULL,'0','C','21CXWA0QTGUA',' ','1',1238922419582804992,'1',{ts'2022-12-12  00:00:00'},0,'视图类型等于再入职');
DELETE FROM t_cr_coderule WHERE FID = '235GSY+20IR2';
INSERT INTO t_cr_coderule(FFILTERCONDITION,FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID,FCONDITIONDESC) VALUES ('{"filterRow":[{"id":"2YATL=8SNGS7","leftBracket":"","compareType":"105","fieldName":"viewtype","rightBracket":"","logic":"0","value":[{"id":"2YATL=8SNG2Z","value":"1"}],"baseDataIds":[]}],"forList":false}',' ','2','1','0','235GSY+20IR2','0',NULL,'0',{ts'2021-12-16  00:00:00'},'hom_onbrdbillbase','1','0','0','1',NULL,'0','235GSY+20IR2','-','1',NULL,'0','C','235GNWH57II6',' ','1',1238922419582804992,'1',{ts'2022-12-12  00:00:00'},0,'视图类型等于常规入职');


DELETE FROM t_cr_coderule_l WHERE FPKID = '235GSY+20JEB';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('235GSY+20IR2','235GSY+20JEB','zh_CN','常规入职');
DELETE FROM t_cr_coderule_l WHERE FPKID = '21CYCX=B7BG0';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('21CYCX=B7=F9','21CYCX=B7BG0','zh_CN','再入职');


DELETE FROM t_cr_coderuleentry WHERE fid in ('21CYCX=B7=F9','235GSY+20IR2');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '2XS7E=AH0ANO';
INSERT INTO t_cr_coderuleentry(fentryid,fid,fseq,fattributetype,fattusingmode,fvalueatribute,fformat,fsettingvalue,flength,finitial,fstep,faddchar,fissplitsign,faddstyle,fcutstyle,fissortitem,fsplitsign,fisvisable) VALUES ('2XS7E=AH0ANO','235GSY+20IR2',0,'1',' ',' ','OBD',' ',8,1,1,' ','0','1','1','0',' ','1');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '2XS7E=AH0ANP';
INSERT INTO t_cr_coderuleentry(fentryid,fid,fseq,fattributetype,fattusingmode,fvalueatribute,fformat,fsettingvalue,flength,finitial,fstep,faddchar,fissplitsign,faddstyle,fcutstyle,fissortitem,fsplitsign,fisvisable) VALUES ('2XS7E=AH0ANP','235GSY+20IR2',1,'9',' ',' ','yyyyMMdd',' ',8,1,1,' ','1','1','1','1','-','1');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '2XS7E=AH0ANQ';
INSERT INTO t_cr_coderuleentry(fentryid,fid,fseq,fattributetype,fattusingmode,fvalueatribute,fformat,fsettingvalue,flength,finitial,fstep,faddchar,fissplitsign,faddstyle,fcutstyle,fissortitem,fsplitsign,fisvisable) VALUES ('2XS7E=AH0ANQ','235GSY+20IR2',2,'16',' ',' ',' ',' ',5,1,1,' ','1','1','1','0','-','1');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '2XS7G1HBK1D6';
INSERT INTO t_cr_coderuleentry(fentryid,fid,fseq,fattributetype,fattusingmode,fvalueatribute,fformat,fsettingvalue,flength,finitial,fstep,faddchar,fissplitsign,faddstyle,fcutstyle,fissortitem,fsplitsign,fisvisable) VALUES ('2XS7G1HBK1D6','21CYCX=B7=F9',0,'1',' ',' ','RHR',' ',8,1,1,' ','0','1','1','0',' ','1');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '2XS7G1HBK1D7';
INSERT INTO t_cr_coderuleentry(fentryid,fid,fseq,fattributetype,fattusingmode,fvalueatribute,fformat,fsettingvalue,flength,finitial,fstep,faddchar,fissplitsign,faddstyle,fcutstyle,fissortitem,fsplitsign,fisvisable) VALUES ('2XS7G1HBK1D7','21CYCX=B7=F9',1,'9',' ',' ','yyyyMMdd',' ',8,1,1,' ','1','1','1','1','-','1');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '2XS7G1HBK1D8';
INSERT INTO t_cr_coderuleentry(fentryid,fid,fseq,fattributetype,fattusingmode,fvalueatribute,fformat,fsettingvalue,flength,finitial,fstep,faddchar,fissplitsign,faddstyle,fcutstyle,fissortitem,fsplitsign,fisvisable) VALUES ('2XS7G1HBK1D8','21CYCX=B7=F9',2,'16',' ',' ',' ',' ',5,1,1,' ','1','1','1','0','-','1');
