员工发起加班单,所属部门显示与实际任职不符

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

[适用版本]:V8.2 SP2

[解决方案]: 数据问题,根本解决,请打当前版本的最新假勤补丁,数据修复请按顺序执行以下语句:

select * into t_hr_personposition70831 from t_hr_personposition;

select * into t_hr_personpositionhis70831 from t_hr_personpositionhis;

update t_hr_personposition set fpersondep=(select fadminorgid from t_hr_emporgrelation where fpersonid=t_hr_personposition.fpersonid and fisinner=1 and fassigntype=1 and fleffdt={ts '2199-12-31'}) where fpersonid = '???';

update t_hr_personposition set fprimarypositionid=(select fpositionid from t_hr_emporgrelation where fpersonid=t_hr_personposition.fpersonid and fisinner=1 and fassigntype=1 and fleffdt={ts '2199-12-31'}) where fpersonid = '???';

update t_hr_personpositionhis set fpersondep=(select fadminorgid from t_hr_emporgrelation where fpersonid=t_hr_personpositionhis.fpersonid and fisinner=1 and fassigntype=1 and fleffdt={ts '2199-12-31'}) where fleffdt={ts '2199-12-31'} and fpersonid = '???';

update t_hr_personpositionhis set fprimarypositionid=(select fpositionid from t_hr_emporgrelation where fpersonid=t_hr_personpositionhis.fpersonid and fisinner=1 and fassigntype=1 and fleffdt={ts '2199-12-31'}) where fleffdt={ts '2199-12-31'} and fpersonid = '???';