考勤组织和行政组织不一致
[适用版本]8.2 sp2
[操作步骤]
解决方案有3种:
1.未进行过考勤档案变更的员工请在员工考勤档案界面上点击组织更新或职位更新进行组织职位同步。
2.在后台事务“自动生成假期档案”中修改参数“组织职位变动自动更新假勤档案”为1,然后保存发布后台事务
3.此外,还可以根据以下sql语句进行修复:
--备份考勤档案数据
select * into t_hr_ats_attendancefile0528 from t_hr_ats_attendancefile;
select * into t_hr_ats_attendancefilehis0528 from t_hr_ats_attendancefilehis;
--备份职业信息数据
select * into t_hr_personposition70831 from t_hr_personposition;
select * into t_hr_personpositionhis70831 from t_hr_personpositionhis;
--更新职业信息组织职位和企业任职经历组织职位
update t_hr_personposition a set FPERSONDEP = (select FADMINORGID from T_hr_emporgrelation where FLEFFDT = {ts '2199-12-31'} and FASSIGNTYPE = 1 AND FISINNER = 1 and FPERSONID = a.fpersonid)
update t_hr_personposition a set FPRIMARYPOSITIONID = (select fpositionid from T_hr_emporgrelation where FLEFFDT = {ts '2199-12-31'} and FASSIGNTYPE = 1 AND FISINNER = 1 and FPERSONID = a.fpersonid)
------批量更新考勤档案表和历史表使组织及职位和职业信息一致
update t_hr_ats_attendancefile set FADMINORGUNITID=(select FPERSONDEP from t_hr_personposition where fpersonid=fproposerid)
update t_hr_ats_attendancefilehis set FADMINORGUNITID=(select FPERSONDEP from t_hr_personposition where fpersonid=fproposerid) where FLEFFDT ={ts '2099-12-31'} --FPOSITIONID <>fprimarypositionid )
update t_hr_ats_attendancefile set FPOSITIONID=(select fprimarypositionid from t_hr_personposition where fpersonid=fproposerid)
update t_hr_ats_attendancefilehis set FPOSITIONID=(select fprimarypositionid from t_hr_personposition where fpersonid=fproposerid) where FLEFFDT ={ts '2099-12-31'}
考勤组织和行政组织不一致
本文2024-09-22 21:47:30发表“s-hr cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-shr-122358.html