解决方案：

问题：假期额度部分员工的假期额度之假期类型为空

【适用版本】

8.5

【分析处理】

删除了假期额度所关联假期制度引起，如确定额度记录不需要，可参考以下语句修复 

--查询异常数据 

select * from t_hr_ats_holidaylimitdetail where FHOLIDAYLIMITID  in (select fid from t_hr_ats_holidaylimit  where FHOLIDAYPOLICYID not in(select fid from T_HR_ATS_HolidayPolicy)) select* from t_hr_ats_holidaylimit  where FHOLIDAYPOLICYID not in(select fid from T_HR_ATS_HolidayPolicy) 

--备份数据  

select * into holidaylimit0417 from t_hr_ats_holidaylimit select * into holidaylimitdetail0417 from t_hr_ats_holidaylimitdetail 

--清除数据 

delete from t_hr_ats_holidaylimitdetail where FHOLIDAYLIMITID  in (select fid from t_hr_ats_holidaylimit  where FHOLIDAYPOLICYID not in(select fid from T_HR_ATS_HolidayPolicy)) delete from t_hr_ats_holidaylimit  where FHOLIDAYPOLICYID not in(select fid from T_HR_ATS_HolidayPolicy)