查询转正生效后员工状态没有变为目标状态的数据

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

SELECT c.fname_l2,c.fnumber,a.FBIZDATE,d.fnumber,a.FEMPTYPEID,e.FLABORRELATIONSTATEID

FROM T_HR_EMPHIREBIZBILLentry a

left join T_HR_EMPORGRELATION b on a.fid=b.FFlowInAffairID

left join T_HR_EMPLABORRELATIONhis e on e.feffdt=b.feffdt and e.fpersonid=b.fpersonid

left join T_BD_PERSON c on a.fpersonid=c.fid

left join T_HR_EMPHIREBIZBILL d on d.fid=a.fbillid

where a.FBIZDATE

and d.FBILLSTATE =3

and a.FEMPTYPEID <>e.FLABORRELATIONSTATEID

本文2024-09-22 20:45:38发表“s-hr cloud知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-shr-115696.html

阅读排行