/****** HR Management Report SQL ******/
DELETE FROM T_HRPTMC_REPORTMANAGE WHERE FID = 1950200869882448896;
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 (1950200869882448896,'1','B',1945039853569738752,100000,NULL,' ','C','岗位编制明细表(月度)','kdhr_staff_posreport_mth','0MUWQ6HSY5JA',{ts'2024-05-14  00:00:00'},'1',13466739,' ','{"conditionList":[{"index":0,"name":"T01","displayParam":"编制维度编码","param":"haos_dimstaffreport.haos_dimstaffreport.staffdimension.number","paramType":"dynamicObject","target":false,"operators":"==","valueType":"2","displayValue":"岗位","value":"1010","valueDataType":"number","objectId":"","objectNumber":""}],"conditionExpressType":"0","conditionExpressList":[{"name":"T01"}],"conditionExpressStr":"T01"}',{ts'2024-06-14  00:00:00'},'[]',13466739,0); 

DELETE FROM T_HRPTMC_REPORTMANAGE_L WHERE FPKID = '43J7NCREO/K6';
INSERT INTO T_HRPTMC_REPORTMANAGE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1950200869882448896,'43J7NCREO/K6','zh_CN',' ','岗位编制明细表(月度)'); 

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

DELETE FROM T_HRPTMC_REPORTCONFIG WHERE FID = 1950200870553537536;
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 (1950200870553537536,'1',' ',' ',' ','0',' ','0',' ',-1,' ','0','0',1950200869882448896,1950197424370764800,' ',' ',' ',' ','总计','0','0',' ',' '); 

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

DELETE FROM T_HRPTMC_PUBLISHMENU WHERE FREPORTMANAGEID IN (1950200869882448896);




DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179456;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179456,'1','none','行政组织名称',1945039853737617412,1950200869882448896,0,0,0,1950197424370764800,0,'curdate',' ',' ','adminorg.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179457;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179457,'1','none','行政组织编码',1945039853737617411,1950200869882448896,0,0,1,1950197424370764800,0,'curdate',' ',' ','adminorg.number','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179458;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179458,'1','none','所属公司',1945039853737617415,1950200869882448896,0,0,2,1950197424370764800,0,'curdate',' ',' ','adminorg.company.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179459;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179459,'1','none','岗位',1945039853737617420,1950200869882448896,0,0,3,1950197424370764800,0,'curdate',' ',' ','dutyworkrole.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179460;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179460,'2','none','编制人数',1945039853737617416,1950200869882448896,0,0,4,1950197424370764800,0,'curdate',' ',' ','staffcount','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179461;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179461,'2','none','占编人数',0,1950200869882448896,1949225294393000960,0,5,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_hold','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179462;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179462,'2','none','空余编制',0,1950200869882448896,1949227869183951872,0,6,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_remain','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179463;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179463,'0',' ','在途占编',0,1950200869882448896,0,0,7,1950197424370764800,0,'curdate',' ','1','在途占编','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636426243;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636426243,'2','none','入职',0,1950200869882448896,1949229801550136320,1972546272636179463,7,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_entryin','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636426242;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636426242,'2','none','调入',0,1950200869882448896,1949228689136829440,1972546272636179463,7,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_transferin','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636426241;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636426241,'2','none','调出',0,1950200869882448896,1949230042588398592,1972546272636179463,7,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_transferout','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636426240;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636426240,'2','none','离职',0,1950200869882448896,1949230285438600192,1972546272636179463,7,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_departin','0','tile'); 

DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH6ZS';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179456,'46=9SYWVH6ZS','zh_CN','行政组织名称'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH6ZW';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179457,'46=9SYWVH6ZW','zh_CN','行政组织编码'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7++';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179458,'46=9SYWVH7++','zh_CN','所属公司'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+1';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179459,'46=9SYWVH7+1','zh_CN','岗位'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+5';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179460,'46=9SYWVH7+5','zh_CN','编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+7';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179461,'46=9SYWVH7+7','zh_CN','占编人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+9';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179462,'46=9SYWVH7+9','zh_CN','空余编制'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+=';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179463,'46=9SYWVH7+=','zh_CN','在途占编'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+B';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636426243,'46=9SYWVH7+B','zh_CN','入职'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+D';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636426242,'46=9SYWVH7+D','zh_CN','调入'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+F';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636426241,'46=9SYWVH7+F','zh_CN','调出'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+H';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636426240,'46=9SYWVH7+H','zh_CN','离职'); 




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

DELETE FROM T_HRPTMC_FILTER WHERE FRPTMANAGEID IN (1950200869882448896);
DELETE FROM T_HRPTMC_FILTER WHERE FID = 1972545919089906688;
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',1945039853737617409,' ','0','1','0','0',{ts'2024-06-14  00:00:00'},'1','date',' ',' ',NULL,NULL,1972545919089906688,' ','0',',month,',1950200869882448896,'1',0,'==','查询期间',' ',0,0,13466739,' ',{ts'2024-06-14  00:00:00'},0,0,0); 
DELETE FROM T_HRPTMC_FILTER WHERE FID = 1972545919089906689;
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',1945039853737617412,' ','0','1','0','0',{ts'2024-06-14  00:00:00'},'1','adminorg',' ',' ',NULL,NULL,1972545919089906689,' ','1',',,',1950200869882448896,'1',0,'==','行政组织',' ',1,0,13466739,' ',{ts'2024-06-14  00:00:00'},0,0,0); 
DELETE FROM T_HRPTMC_FILTER WHERE FID = 1972545919089906690;
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 ('0','0',' ','0','1',1945039853737617420,' ','0','0','0','0',{ts'2024-06-14  00:00:00'},'1','hisbasedata',' ',' ',NULL,NULL,1972545919089906690,' ','1',',,',1950200869882448896,'1',0,'==','岗位',' ',2,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 (1950200869882448896)) AND FLOCALEID='zh_CN';
DELETE FROM T_HRPTMC_FILTER_L WHERE FPKID = '46=9QCEI5BR9';
INSERT INTO T_HRPTMC_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1972545919089906688,'46=9QCEI5BR9','zh_CN','查询期间'); 
DELETE FROM T_HRPTMC_FILTER_L WHERE FPKID = '46=9QCEI5BRC';
INSERT INTO T_HRPTMC_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1972545919089906689,'46=9QCEI5BRC','zh_CN','行政组织'); 
DELETE FROM T_HRPTMC_FILTER_L WHERE FPKID = '46=9QCEI5BRF';
INSERT INTO T_HRPTMC_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1972545919089906690,'46=9QCEI5BRF','zh_CN','岗位'); 




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

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





DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950200869882448896));
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972546273324045312;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950200870553537536,'0','[]',NULL,1972546273324045312,0); 
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972546273324045313;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950200870553537536,'1','[]',NULL,1972546273324045313,0); 
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972546273324045314;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950200870553537536,'2','["rgba(251, 35, 35, 1)"]',NULL,1972546273324045314,0); 
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972546273324045315;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950200870553537536,'3','["rgba(255, 255, 255, 1)"]',NULL,1972546273324045315,0); 



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

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 (1950200869882448896))) 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 (1950200869882448896)));

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






DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179456;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179456,'1','none','行政组织名称',1945039853737617412,1950200869882448896,0,0,0,1950197424370764800,0,'curdate',' ',' ','adminorg.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179457;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179457,'1','none','行政组织编码',1945039853737617411,1950200869882448896,0,0,1,1950197424370764800,0,'curdate',' ',' ','adminorg.number','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179458;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179458,'1','none','所属公司',1945039853737617415,1950200869882448896,0,0,2,1950197424370764800,0,'curdate',' ',' ','adminorg.company.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179459;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179459,'1','none','岗位',1945039853737617420,1950200869882448896,0,0,3,1950197424370764800,0,'curdate',' ',' ','dutyworkrole.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179460;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179460,'2','none','编制人数',1945039853737617416,1950200869882448896,0,0,4,1950197424370764800,0,'curdate',' ',' ','staffcount','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179461;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179461,'2','none','占编人数',0,1950200869882448896,1949225294393000960,0,5,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_hold','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179462;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179462,'2','none','空余编制',0,1950200869882448896,1949227869183951872,0,6,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_remain','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636179463;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636179463,'0',' ','在途占编',0,1950200869882448896,0,0,7,1950197424370764800,0,'curdate',' ','1','在途占编','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636426243;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636426243,'2','none','入职',0,1950200869882448896,1949229801550136320,1972546272636179463,7,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_entryin','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636426242;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636426242,'2','none','调入',0,1950200869882448896,1949228689136829440,1972546272636179463,7,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_transferin','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636426241;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636426241,'2','none','调出',0,1950200869882448896,1949230042588398592,1972546272636179463,7,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_transferout','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972546272636426240;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972546272636426240,'2','none','离职',0,1950200869882448896,1949230285438600192,1972546272636179463,7,1950197424370764800,0,'curdate',' ',' ','kdhr_staff_presetindex_departin','0','tile'); 

DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH6ZS';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179456,'46=9SYWVH6ZS','zh_CN','行政组织名称'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH6ZW';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179457,'46=9SYWVH6ZW','zh_CN','行政组织编码'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7++';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179458,'46=9SYWVH7++','zh_CN','所属公司'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+1';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179459,'46=9SYWVH7+1','zh_CN','岗位'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+5';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179460,'46=9SYWVH7+5','zh_CN','编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+7';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179461,'46=9SYWVH7+7','zh_CN','占编人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+9';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179462,'46=9SYWVH7+9','zh_CN','空余编制'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+=';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636179463,'46=9SYWVH7+=','zh_CN','在途占编'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+B';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636426243,'46=9SYWVH7+B','zh_CN','入职'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+D';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636426242,'46=9SYWVH7+D','zh_CN','调入'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+F';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636426241,'46=9SYWVH7+F','zh_CN','调出'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=9SYWVH7+H';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972546272636426240,'46=9SYWVH7+H','zh_CN','离职'); 




DELETE FROM T_HRPTMC_DIMMAP WHERE FREPORTID IN (1950200869882448896);
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972546272879695872;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972546272879695872,'kdhr_staff_presetindex_hold',1949225294393000960,1950200869882448896,1950197424370764800); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972546272879695873;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972546272879695873,'kdhr_staff_presetindex_remain',1949227869183951872,1950200869882448896,1950197424370764800); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972546272879695874;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972546272879695874,'kdhr_staff_presetindex_entryin',1949229801550136320,1950200869882448896,1950197424370764800); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972546272879695875;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972546272879695875,'kdhr_staff_presetindex_transferin',1949228689136829440,1950200869882448896,1950197424370764800); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972546272879695876;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972546272879695876,'kdhr_staff_presetindex_transferout',1949230042588398592,1950200869882448896,1950197424370764800); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972546272879695877;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972546272879695877,'kdhr_staff_presetindex_departin',1949230285438600192,1950200869882448896,1950197424370764800); 

DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FID IN (SELECT FID FROM T_HRPTMC_DIMMAP WHERE FREPORTID IN (1950200869882448896));
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837696;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695872,'行政组织名称','-','adminorgname','10',1972546272887837696,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837697;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695872,'行政组织编码','-','adminorgnumber','10',1972546272887837697,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837698;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695872,'行政组织所属公司行政组织名称','-','company','10',1972546272887837698,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837699;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695872,'岗位名称','-','dutyworkrole','10',1972546272887837699,0,'dutyworkrole.name','10','hisbasedata'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837700;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695872,'查询期间','20','querydate','20',1972546272887837700,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837701;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695873,'行政组织名称','-','adminorgname','10',1972546272887837701,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837702;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695873,'行政组织编码','-','adminorgnumber','10',1972546272887837702,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837703;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695873,'行政组织所属公司行政组织名称','-','company','10',1972546272887837703,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837704;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695873,'岗位名称','-','dutyworkrole','10',1972546272887837704,0,'dutyworkrole.name','10','hisbasedata'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837705;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695873,'查询期间','20','querydate','20',1972546272887837705,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837706;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695874,'行政组织名称','-','adminorgname','10',1972546272887837706,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837707;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695874,'行政组织编码','-','adminorgnumber','10',1972546272887837707,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837708;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695874,'行政组织所属公司行政组织名称','-','company','10',1972546272887837708,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837709;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695874,'岗位名称','-','dutyworkrole','10',1972546272887837709,0,'dutyworkrole.name','10','hisbasedata'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837710;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695874,'查询期间','20','querydate','20',1972546272887837710,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837711;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695875,'行政组织名称','-','adminorgname','10',1972546272887837711,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837712;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695875,'行政组织编码','-','adminorgnumber','10',1972546272887837712,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837713;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695875,'行政组织所属公司行政组织名称','-','company','10',1972546272887837713,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837714;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695875,'岗位名称','-','dutyworkrole','10',1972546272887837714,0,'dutyworkrole.name','10','hisbasedata'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837715;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695875,'查询期间','20','querydate','20',1972546272887837715,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837716;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695876,'行政组织名称','-','adminorgname','10',1972546272887837716,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837717;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695876,'行政组织编码','-','adminorgnumber','10',1972546272887837717,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837718;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695876,'行政组织所属公司行政组织名称','-','company','10',1972546272887837718,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837719;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695876,'岗位名称','-','dutyworkrole','10',1972546272887837719,0,'dutyworkrole.name','10','hisbasedata'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837720;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695876,'查询期间','20','querydate','20',1972546272887837720,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837721;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695877,'行政组织名称','-','adminorgname','10',1972546272887837721,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837722;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695877,'行政组织编码','-','adminorgnumber','10',1972546272887837722,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837723;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695877,'行政组织所属公司行政组织名称','-','company','10',1972546272887837723,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837724;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695877,'岗位名称','-','dutyworkrole','10',1972546272887837724,0,'dutyworkrole.name','10','hisbasedata'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972546272887837725;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972546272879695877,'查询期间','20','querydate','20',1972546272887837725,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 (1950200869882448896)));
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDTV';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=9SYZJRDTV','zh_CN',1972546272887837701); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDVT';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=9SYZJRDVT','zh_CN',1972546272887837725); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDUJ';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('岗位名称','46=9SYZJRDUJ','zh_CN',1972546272887837709); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDVP';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织所属公司行政组织名称','46=9SYZJRDVP','zh_CN',1972546272887837723); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDU4';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('岗位名称','46=9SYZJRDU4','zh_CN',1972546272887837704); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDVD';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=9SYZJRDVD','zh_CN',1972546272887837720); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDVH';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=9SYZJRDVH','zh_CN',1972546272887837721); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDU9';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=9SYZJRDU9','zh_CN',1972546272887837706); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDTN';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织所属公司行政组织名称','46=9SYZJRDTN','zh_CN',1972546272887837698); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDU5';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=9SYZJRDU5','zh_CN',1972546272887837705); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDUO';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=9SYZJRDUO','zh_CN',1972546272887837711); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDTR';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=9SYZJRDTR','zh_CN',1972546272887837700); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDV2';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=9SYZJRDV2','zh_CN',1972546272887837716); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDTJ';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=9SYZJRDTJ','zh_CN',1972546272887837697); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDTQ';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('岗位名称','46=9SYZJRDTQ','zh_CN',1972546272887837699); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDTF';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=9SYZJRDTF','zh_CN',1972546272887837696); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDUS';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=9SYZJRDUS','zh_CN',1972546272887837712); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDU1';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织所属公司行政组织名称','46=9SYZJRDU1','zh_CN',1972546272887837703); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDTZ';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=9SYZJRDTZ','zh_CN',1972546272887837702); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDUG';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织所属公司行政组织名称','46=9SYZJRDUG','zh_CN',1972546272887837708); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDV6';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=9SYZJRDV6','zh_CN',1972546272887837717); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDVS';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('岗位名称','46=9SYZJRDVS','zh_CN',1972546272887837724); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDUW';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织所属公司行政组织名称','46=9SYZJRDUW','zh_CN',1972546272887837713); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDUZ';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('岗位名称','46=9SYZJRDUZ','zh_CN',1972546272887837714); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDUC';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=9SYZJRDUC','zh_CN',1972546272887837707); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDVC';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('岗位名称','46=9SYZJRDVC','zh_CN',1972546272887837719); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDUK';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=9SYZJRDUK','zh_CN',1972546272887837710); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDVL';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=9SYZJRDVL','zh_CN',1972546272887837722); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDV+';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=9SYZJRDV+','zh_CN',1972546272887837715); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=9SYZJRDV=';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织所属公司行政组织名称','46=9SYZJRDV=','zh_CN',1972546272887837718); 

DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FREPORTID IN (1950200869882448896);
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972546273861163008;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972546273861163008,1949225294393000960,1950200869882448896); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972546273861163009;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972546273861163009,1949227869183951872,1950200869882448896); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972546273861163010;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972546273861163010,1949229801550136320,1950200869882448896); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972546273861163011;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972546273861163011,1949228689136829440,1950200869882448896); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972546273861163012;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972546273861163012,1949230042588398592,1950200869882448896); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972546273861163013;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972546273861163013,1949230285438600192,1950200869882448896); 



