/****** HR Management Report SQL ******/
DELETE FROM T_HRPTMC_REPORTMANAGE WHERE FID = 1950192668692955136;
INSERT INTO T_HRPTMC_REPORTMANAGE(FID,FISSYSPRESET,FPUBLISHSTATUS,FANOBJID,FCREATEORGID,FDISABLEDATE,FDESCRIPTION,FSTATUS,FNAME,FNUMBER,FCLOUDID,FCREATETIME,FENABLE,FMODIFIERID,FROW,FDATAFILTER,FMODIFYTIME,FCOLUMN,FCREATORID,FDISABLERID) VALUES (1950192668692955136,'1','B',1945039541882619904,100000,NULL,' ','C','部门编制明细表(月度)','kdhr_staff_orgreport_mth','0MUWQ6HSY5JA',{ts'2024-05-14  00:00:00'},'1',13466739,' ',' ',{ts'2024-06-14  00:00:00'},'[]',13466739,0); 

DELETE FROM T_HRPTMC_REPORTMANAGE_L WHERE FPKID = '43J63M0MA3EZ';
INSERT INTO T_HRPTMC_REPORTMANAGE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1950192668692955136,'43J63M0MA3EZ','zh_CN',' ','部门编制明细表(月度)'); 

DELETE FROM T_HRPTMC_WORKREPORT WHERE FRPTMANAGEID IN (1950192668692955136);
DELETE FROM T_HRPTMC_WORKREPORT WHERE FID = 1950190024033288192;
INSERT INTO T_HRPTMC_WORKREPORT(FID,FINDEX,FROW,FCOLUMN,FKEY,FRPTMANAGEID) VALUES (1950190024033288192,0,' ','[]',1,1950192668692955136); 

DELETE FROM T_HRPTMC_REPORTCONFIG WHERE FID = 1950192669523427328;
INSERT INTO T_HRPTMC_REPORTCONFIG(FID,FTYPE,FCATEGORYUNIT,FLEGEND,FVALUENAME,FSUBTOTAL,FCOLADVANCESORT,FTOTAL,FROWCOLTRANSPOSITION,FFREE,FCATEGORYNAME,FPAGE,FSHOWSEQ,FRPTMANAGEID,FWORKRPTID,FROWADVANCESORT,FSUBTOTALNAME,FHEADSTYLE,FVALUEUNIT,FTOTALNAME,FMERGECELL,FSHOWDATALABEL,FDRILLINGDRL,FHEADERMERGE) VALUES (1950192669523427328,'1',' ',' ',' ','0',' ','0',' ',-1,' ','0','0',1950192668692955136,1950190024033288192,' ',' ',' ',' ','总计','0','0',' ',' '); 

DELETE FROM T_HRPTMC_REPORTCONFIG_L WHERE FPKID = '43J63M99MJ4A';
INSERT INTO T_HRPTMC_REPORTCONFIG_L(FID,FCATEGORYUNIT,FVALUENAME,FPKID,FLOCALEID,FSUBTOTALNAME,FVALUEUNIT,FTOTALNAME,FCATEGORYNAME) VALUES (1950192669523427328,' ',' ','43J63M99MJ4A','zh_CN',' ',' ','总计',' '); 

DELETE FROM T_HRPTMC_PUBLISHMENU WHERE FREPORTMANAGEID IN (1950192668692955136);




DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914624;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914624,'1','none','行政组织名称',1945039542302156804,1950192668692955136,0,0,0,1950190024033288192,0,'curdate',' ',' ','adminorg.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914625;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914625,'1','none','行政组织编码',1945039542302156803,1950192668692955136,0,0,1,1950190024033288192,0,'curdate',' ',' ','adminorg.number','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914626;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914626,'1','none','所属公司',1945039542302156807,1950192668692955136,0,0,2,1950190024033288192,0,'curdate',' ',' ','adminorg.company.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914627;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914627,'2','none','直属编制人数',1945039542302156808,1950192668692955136,0,0,3,1950190024033288192,0,'curdate',' ',' ','staffcount','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914628;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914628,'2','none','含下级编制人数',1945039542302156809,1950192668692955136,0,0,4,1950190024033288192,0,'curdate',' ',' ','staffcountwithsub','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914629;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914629,'2','none','直属占编人数',0,1950192668692955136,1949225294393000960,0,5,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_hold','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914630;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914630,'2','none','直属空余编制',0,1950192668692955136,1949227869183951872,0,6,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_remain','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914631;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914631,'0',' ','直属在途占编',0,1950192668692955136,0,0,7,1950190024033288192,0,'curdate',' ','1','直属在途占编','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045667843;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045667843,'2','none','入职',0,1950192668692955136,1949229801550136320,1972539059045914631,7,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_entryin','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045667842;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045667842,'2','none','调入',0,1950192668692955136,1949228689136829440,1972539059045914631,7,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_transferin','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045667841;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045667841,'2','none','调出',0,1950192668692955136,1949230042588398592,1972539059045914631,7,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_transferout','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045667840;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045667840,'2','none','离职',0,1950192668692955136,1949230285438600192,1972539059045914631,7,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_departin','0','tile'); 

DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VS0';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914624,'46=8FCUY=VS0','zh_CN','行政组织名称'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VS3';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914625,'46=8FCUY=VS3','zh_CN','行政组织编码'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VS6';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914626,'46=8FCUY=VS6','zh_CN','所属公司'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VS9';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914627,'46=8FCUY=VS9','zh_CN','直属编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSB';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914628,'46=8FCUY=VSB','zh_CN','含下级编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSD';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914629,'46=8FCUY=VSD','zh_CN','直属占编人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSF';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914630,'46=8FCUY=VSF','zh_CN','直属空余编制'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSG';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914631,'46=8FCUY=VSG','zh_CN','直属在途占编'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSI';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045667843,'46=8FCUY=VSI','zh_CN','入职'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSK';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045667842,'46=8FCUY=VSK','zh_CN','调入'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSM';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045667841,'46=8FCUY=VSM','zh_CN','调出'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSO';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045667840,'46=8FCUY=VSO','zh_CN','离职'); 




DELETE FROM T_HRPTMC_DATAFORMAT WHERE FID IN (SELECT FID FROM T_HRPTMC_ROWFIELD WHERE FRPTMANAGEID IN (1950192668692955136));

DELETE FROM T_HRPTMC_FILTER WHERE FRPTMANAGEID IN (1950192668692955136);
DELETE FROM T_HRPTMC_FILTER WHERE FID = 1972535441416771584;
INSERT INTO T_HRPTMC_FILTER(FISMUST,FISSYSPRESET,FTEXTDEFAULTVALUE,FGROUPDATE,FSUBORG,FANOBJFIELDID,FBDDEFAULTVALUE,FHISDATE,FHISSCOPE,FORGLEVEL,FISGROUPFIELD,FCREATETIME,FENABLE,FFILTERTYPE,FTEXTFILTERRANGE,FDATEFILTERTEXT,FFILTERENDDATE,FFILTERSTARTDATE,FID,FDATEFILTERTYPE,FDATETYPE,FDATESCOPE,FRPTMANAGEID,FBASEDATAISMUL,FGROUPFIELDID,FOPT,FNAME,FQUICKSCOPE,FINDEX,FBEGINDATE,FMODIFIERID,FBDFILTERRANGE,FMODIFYTIME,FENDDATE,FCREATORID,FSPLITDATEID) VALUES ('1','0',' ','0','1',1945039542302156801,' ','0','1','0','0',{ts'2024-06-14  00:00:00'},'1','date',' ',' ',NULL,NULL,1972535441416771584,' ','0',',month,',1950192668692955136,'1',0,'==','查询期间',' ',0,0,13466739,' ',{ts'2024-06-14  00:00:00'},0,0,0); 
DELETE FROM T_HRPTMC_FILTER WHERE FID = 1972535441416771585;
INSERT INTO T_HRPTMC_FILTER(FISMUST,FISSYSPRESET,FTEXTDEFAULTVALUE,FGROUPDATE,FSUBORG,FANOBJFIELDID,FBDDEFAULTVALUE,FHISDATE,FHISSCOPE,FORGLEVEL,FISGROUPFIELD,FCREATETIME,FENABLE,FFILTERTYPE,FTEXTFILTERRANGE,FDATEFILTERTEXT,FFILTERENDDATE,FFILTERSTARTDATE,FID,FDATEFILTERTYPE,FDATETYPE,FDATESCOPE,FRPTMANAGEID,FBASEDATAISMUL,FGROUPFIELDID,FOPT,FNAME,FQUICKSCOPE,FINDEX,FBEGINDATE,FMODIFIERID,FBDFILTERRANGE,FMODIFYTIME,FENDDATE,FCREATORID,FSPLITDATEID) VALUES ('1','0',' ','0','1',1945039542302156804,' ','0','1','0','0',{ts'2024-06-14  00:00:00'},'1','adminorg',' ',' ',NULL,NULL,1972535441416771585,' ','1',',,',1950192668692955136,'1',0,'==','行政组织',' ',1,0,13466739,' ',{ts'2024-06-14  00:00:00'},0,0,0); 

DELETE FROM T_HRPTMC_FILTER_L  WHERE FID IN (SELECT FID FROM T_HRPTMC_FILTER WHERE FRPTMANAGEID IN (1950192668692955136)) AND FLOCALEID='zh_CN';
DELETE FROM T_HRPTMC_FILTER_L WHERE FPKID = '46=7S/R3L9GN';
INSERT INTO T_HRPTMC_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1972535441416771584,'46=7S/R3L9GN','zh_CN','查询期间'); 
DELETE FROM T_HRPTMC_FILTER_L WHERE FPKID = '46=7S/R3L9GQ';
INSERT INTO T_HRPTMC_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1972535441416771585,'46=7S/R3L9GQ','zh_CN','行政组织'); 




DELETE FROM T_HRPTMC_REPORTMARK WHERE FID = 1972539060161599488;
INSERT INTO T_HRPTMC_REPORTMARK(FID,FSHOW,FRPTMANAGEID) VALUES (1972539060161599488,'1',1950192668692955136); 

DELETE FROM T_HRPTMC_RPTMARKCONTENT WHERE FID = 1972539060194907136;
INSERT INTO T_HRPTMC_RPTMARKCONTENT(FID,FRPTMARKID,FLOCALE,FMARKCONTENT) VALUES (1972539060194907136,1972539060161599488,'zh_CN',' '); 





DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950192668692955136));
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972539059633117184;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950192669523427328,'0','[]',NULL,1972539059633117184,0); 
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972539059633117185;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950192669523427328,'1','[]',NULL,1972539059633117185,0); 
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972539059633117186;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950192669523427328,'2','["rgba(251, 35, 35, 1)"]',NULL,1972539059633117186,0); 
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972539059633117187;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950192669523427328,'3','["rgba(255, 255, 255, 1)"]',NULL,1972539059633117187,0); 



DELETE FROM T_HRPTMC_ALGORITHMCOL WHERE FRPTCONFIGID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950192668692955136));

DELETE FROM T_HRPTMC_ALGORITHMCOL_L WHERE FID IN (SELECT FID FROM T_HRPTMC_ALGORITHMCOL WHERE FRPTCONFIGID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950192668692955136))) AND FLOCALEID='zh_CN';

DELETE FROM T_HRPTMC_COLALGORITHMTYPE WHERE FID IN (SELECT FID FROM T_HRPTMC_ALGORITHMCOL WHERE FRPTCONFIGID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950192668692955136)));

DELETE FROM T_HRPTMC_ROWALGORITHM WHERE FID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950192668692955136));






DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914624;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914624,'1','none','行政组织名称',1945039542302156804,1950192668692955136,0,0,0,1950190024033288192,0,'curdate',' ',' ','adminorg.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914625;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914625,'1','none','行政组织编码',1945039542302156803,1950192668692955136,0,0,1,1950190024033288192,0,'curdate',' ',' ','adminorg.number','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914626;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914626,'1','none','所属公司',1945039542302156807,1950192668692955136,0,0,2,1950190024033288192,0,'curdate',' ',' ','adminorg.company.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914627;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914627,'2','none','直属编制人数',1945039542302156808,1950192668692955136,0,0,3,1950190024033288192,0,'curdate',' ',' ','staffcount','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914628;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914628,'2','none','含下级编制人数',1945039542302156809,1950192668692955136,0,0,4,1950190024033288192,0,'curdate',' ',' ','staffcountwithsub','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914629;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914629,'2','none','直属占编人数',0,1950192668692955136,1949225294393000960,0,5,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_hold','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914630;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914630,'2','none','直属空余编制',0,1950192668692955136,1949227869183951872,0,6,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_remain','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045914631;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045914631,'0',' ','直属在途占编',0,1950192668692955136,0,0,7,1950190024033288192,0,'curdate',' ','1','直属在途占编','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045667843;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045667843,'2','none','入职',0,1950192668692955136,1949229801550136320,1972539059045914631,7,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_entryin','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045667842;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045667842,'2','none','调入',0,1950192668692955136,1949228689136829440,1972539059045914631,7,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_transferin','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045667841;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045667841,'2','none','调出',0,1950192668692955136,1949230042588398592,1972539059045914631,7,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_transferout','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972539059045667840;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972539059045667840,'2','none','离职',0,1950192668692955136,1949230285438600192,1972539059045914631,7,1950190024033288192,0,'curdate',' ',' ','kdhr_staff_presetindex_departin','0','tile'); 

DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VS0';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914624,'46=8FCUY=VS0','zh_CN','行政组织名称'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VS3';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914625,'46=8FCUY=VS3','zh_CN','行政组织编码'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VS6';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914626,'46=8FCUY=VS6','zh_CN','所属公司'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VS9';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914627,'46=8FCUY=VS9','zh_CN','直属编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSB';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914628,'46=8FCUY=VSB','zh_CN','含下级编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSD';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914629,'46=8FCUY=VSD','zh_CN','直属占编人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSF';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914630,'46=8FCUY=VSF','zh_CN','直属空余编制'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSG';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045914631,'46=8FCUY=VSG','zh_CN','直属在途占编'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSI';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045667843,'46=8FCUY=VSI','zh_CN','入职'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSK';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045667842,'46=8FCUY=VSK','zh_CN','调入'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSM';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045667841,'46=8FCUY=VSM','zh_CN','调出'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=8FCUY=VSO';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972539059045667840,'46=8FCUY=VSO','zh_CN','离职'); 




DELETE FROM T_HRPTMC_DIMMAP WHERE FREPORTID IN (1950192668692955136);
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972539059280548864;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972539059280548864,'kdhr_staff_presetindex_hold',1949225294393000960,1950192668692955136,1950190024033288192); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972539059280548865;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972539059280548865,'kdhr_staff_presetindex_remain',1949227869183951872,1950192668692955136,1950190024033288192); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972539059280548866;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972539059280548866,'kdhr_staff_presetindex_entryin',1949229801550136320,1950192668692955136,1950190024033288192); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972539059280548867;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972539059280548867,'kdhr_staff_presetindex_transferin',1949228689136829440,1950192668692955136,1950190024033288192); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972539059280548868;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972539059280548868,'kdhr_staff_presetindex_transferout',1949230042588398592,1950192668692955136,1950190024033288192); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972539059280548869;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972539059280548869,'kdhr_staff_presetindex_departin',1949230285438600192,1950192668692955136,1950190024033288192); 

DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FID IN (SELECT FID FROM T_HRPTMC_DIMMAP WHERE FREPORTID IN (1950192668692955136));
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795648;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548864,'行政组织名称','-','adminorgname','10',1972539059280795648,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795649;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548864,'行政组织编码','-','adminorgnumber','10',1972539059280795649,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795650;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548864,'所属公司','-','company','10',1972539059280795650,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795651;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548864,'查询期间','20','querydate','20',1972539059280795651,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795652;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548865,'行政组织名称','-','adminorgname','10',1972539059280795652,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795653;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548865,'行政组织编码','-','adminorgnumber','10',1972539059280795653,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795654;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548865,'所属公司','-','company','10',1972539059280795654,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795655;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548865,'查询期间','20','querydate','20',1972539059280795655,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795656;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548866,'行政组织名称','-','adminorgname','10',1972539059280795656,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795657;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548866,'行政组织编码','-','adminorgnumber','10',1972539059280795657,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795658;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548866,'所属公司','-','company','10',1972539059280795658,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795659;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548866,'查询期间','20','querydate','20',1972539059280795659,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795660;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548867,'行政组织名称','-','adminorgname','10',1972539059280795660,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795661;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548867,'行政组织编码','-','adminorgnumber','10',1972539059280795661,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795662;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548867,'所属公司','-','company','10',1972539059280795662,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795663;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548867,'查询期间','20','querydate','20',1972539059280795663,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795664;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548868,'行政组织名称','-','adminorgname','10',1972539059280795664,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795665;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548868,'行政组织编码','-','adminorgnumber','10',1972539059280795665,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795666;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548868,'所属公司','-','company','10',1972539059280795666,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795667;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548868,'查询期间','20','querydate','20',1972539059280795667,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795668;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548869,'行政组织名称','-','adminorgname','10',1972539059280795668,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795669;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548869,'行政组织编码','-','adminorgnumber','10',1972539059280795669,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795670;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548869,'所属公司','-','company','10',1972539059280795670,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972539059280795671;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972539059280548869,'查询期间','20','querydate','20',1972539059280795671,0,'month','30','datetime'); 

DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FENTRYID IN (SELECT FENTRYID FROM T_HRPTMC_DIMMAPENTRY WHERE FID IN (SELECT FID FROM T_HRPTMC_DIMMAP WHERE FREPORTID IN (1950192668692955136)));
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAY1';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=8FCXIQAY1','zh_CN',1972539059280795656); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAXQ';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=8FCXIQAXQ','zh_CN',1972539059280795651); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAZ+';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('所属公司','46=8FCXIQAZ+','zh_CN',1972539059280795670); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAY8';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=8FCXIQAY8','zh_CN',1972539059280795659); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAXT';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=8FCXIQAXT','zh_CN',1972539059280795652); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYA';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=8FCXIQAYA','zh_CN',1972539059280795660); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAXP';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('所属公司','46=8FCXIQAXP','zh_CN',1972539059280795650); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYQ';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('所属公司','46=8FCXIQAYQ','zh_CN',1972539059280795666); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYR';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=8FCXIQAYR','zh_CN',1972539059280795667); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAXZ';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('所属公司','46=8FCXIQAXZ','zh_CN',1972539059280795654); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAY4';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=8FCXIQAY4','zh_CN',1972539059280795657); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYG';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('所属公司','46=8FCXIQAYG','zh_CN',1972539059280795662); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYX';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=8FCXIQAYX','zh_CN',1972539059280795669); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYK';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=8FCXIQAYK','zh_CN',1972539059280795664); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAXW';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=8FCXIQAXW','zh_CN',1972539059280795653); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYN';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=8FCXIQAYN','zh_CN',1972539059280795665); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAXJ';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=8FCXIQAXJ','zh_CN',1972539059280795648); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAY7';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('所属公司','46=8FCXIQAY7','zh_CN',1972539059280795658); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAXM';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=8FCXIQAXM','zh_CN',1972539059280795649); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYD';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=8FCXIQAYD','zh_CN',1972539059280795661); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYH';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=8FCXIQAYH','zh_CN',1972539059280795663); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAY+';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=8FCXIQAY+','zh_CN',1972539059280795655); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAYU';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=8FCXIQAYU','zh_CN',1972539059280795668); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8FCXIQAZ/';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=8FCXIQAZ/','zh_CN',1972539059280795671); 

DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FREPORTID IN (1950192668692955136);
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972539060111021056;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972539060111021056,1949225294393000960,1950192668692955136); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972539060111021057;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972539060111021057,1949227869183951872,1950192668692955136); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972539060111021058;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972539060111021058,1949229801550136320,1950192668692955136); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972539060111021059;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972539060111021059,1949228689136829440,1950192668692955136); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972539060111021060;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972539060111021060,1949230042588398592,1950192668692955136); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972539060111021061;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972539060111021061,1949230285438600192,1950192668692955136); 



