获取直接上级为空问题的数据修复语句

栏目：s-hr cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-22浏览：1

获取直接上级为空问题的数据修复语句

解决方案：

【适用版本】

8.5sp1,8.6,8.6sp1

【分析处理】

--备份数据

select * into positionmember1014 from t_org_positionmember

--修复数据

insert into t_org_positionmember(fid,fpositionid,fpersonid,fisprimary,FCREATORID,FCREATETIME,FLASTUPDATEUSERID,FLASTUPDATETIME,FHRORGUNITID,FCONTROLUNITID, FCHECKLEN, FISCHECK,FCHECKSTATE)

select newbosid('0127BD68') fid,fpositionid,fpersonid,FASSIGNTYPE fisprimary,FCREATORID,FCREATETIME,FLASTUPDATEUSERID,FLASTUPDATETIME,FHRORGUNITID,FCONTROLUNITID,0 FCHECKLEN,0 FISCHECK,1 FCHECKSTATE

from t_hr_emporgrelation where FPERSONID ='EaEAAABjCVeA733t' and FLEFFDT ={ts '2199-12-31'}