单业务组织,权限都有,考勤员代做请假单时选不到某个职员,其假期档案职位是空的

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

[适用版本]通用

[解决方案]

造成原因是:假期档案职位字段数据异常;

方案:需后台修复数据,可参考语句;

--备份假期档案及档案历史

select * into T_HR_ATS_AtsHolidayFile08 from T_HR_ATS_AtsHolidayFile;

select * into T_HR_ATS_AtsHolidayFileHis08 from T_HR_ATS_AtsHolidayFileHis;

--查询备份数据是否备份成功,有数据的话证明已经备份成功

select * from T_HR_ATS_AtsHolidayFile08;

select * from T_HR_ATS_AtsHolidayFileHis08;

--修改假期档案和档案历史上的职位

update T_HR_ATS_AtsHolidayFile set FPOSITIONID=(select fprimarypositionid from t_hr_personposition where fpersonid=fproposerid) where FPROPOSERID = (SELECT fid FROM T_BD_Person WHERE fname_l2='' and FNUMBER ='员工编码')

update T_HR_ATS_AtsHolidayFileHis set FPOSITIONID=(select fprimarypositionid from t_hr_personposition where fpersonid=fproposerid) where FLEFFDT ={ts '2099-12-31'} where FPROPOSERID = (SELECT fid FROM T_BD_Person WHERE fname_l2='' and FNUMBER ='员工编码')

--可选择执行方言