员工发起加班单，所属部门显示与实际任职不符
解决方案：
【适用版本】：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 = '???';
员工发起加班单，所属部门显示与实际任职不符
本文2024-09-22 22:01:22发表“s-hr cloud知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-shr-123884.html
