执行此sql:

select relation.fpersonid from t_hr_emporgrelation relation inner join T_HR_EmpLaborRelationHis emplabor on emplabor.fhistoryrelateid = relation.FlaborRelationID and relation.Feffdt >= emplabor.feffdt and relation.feffdt < emplabor.fleffdt inner join t_hr_bdemployeetype emptype on emplabor.FLaborRelationStateID = emptype.fid where relation.FEFFDT <= to_date('2021-03-08') and relation.FLEFFDT >= to_date('2021-03-08') and relation.fpositionid = '职位ID' and emptype.FIsInCount =1 and relation.FASSIGNTYPE =1 and relation.FIsLatestInAday = 1

这个sql是禁用职位查询生效员工的,可以看到关联了变动记录和用工关系历史,如果该职位已经无员工任职,那么只可能是用工关系历史数据问题,查询出校验到的员工,然后处理异常数据即可。