---离职误操作后，如何将人员恢复为在职人员？---根据姓名、公司主键确认员工的人员类别及归属范围selectpd.pk_psndoc,pd.pk_psnbasdoc,pd.psncode,pd.psnname,pk_psncl,psnclscopefrombd_psndocpdwherepd.pk_corp='1001'andpd.psnname='员工008'10001121000000000023C0001121000000000023BHI001008员工008000112100000000002282--查询员工离职记录select(selectt.psnclassnamefrombd_psncltwheret.pk_psncl=di.psnclbefore)psnclbeforename,(selectt.psnclassnamefrombd_psncltwheret.pk_psncl=di.psnclafter)psnclaftername,di.pk_psndoc_sub,di.pk_corpfromhi_psndoc_dimissiondiwheredi.pk_psnbasdoc='0001121000000000023B'anddi.pk_psndoc='0001121000000000023C'1集团在职人员集团解聘人员1001111000000000670G1001--删除员工离职记录deletefromhi_psndoc_dimissiondiwheredi.pk_psndoc_sub='1001111000000000670G'anddi.pk_corp='1001'anddi.pk_psnbasdoc='0001121000000000023B'anddi.pk_psndoc='0001121000000000023C'--确认员工的最新任职记录，结束标志、结束日期selectdi.pk_psncl,(selectt.psnclassnamefrombd_psncltwheret.pk_psncl=di.pk_psncl)psnclaftername,di.pk_psndoc_sub,di.bendflag,di.enddate,di.pk_corpfromhi_psndoc_deptchgdiwheredi.pk_psnbasdoc='0001121000000000023B'anddi.pk_psndoc='0001121000000000023C'anddi.lastflag='Y'anddi.recordnum=0100011210000000000227集团在职人员100112100000000000FTN1001--修改最新任职记录的结束标志、清空结束日期updatehi_psndoc_deptchgsetbendflag='N',enddate=nullwherepk_psndoc_sub='100112100000000000FT';--修改工作信息中的人员类别及归属范围，清空离职日期updatebd_psndocsetpk_psncl='00011210000000000227',psnclscope=0,outdutydate=nullwherepk_psnbasdoc='0001121000000000023B'andpk_psndoc='0001121000000000023C'--以上修改之后人员在人员信息维护的在职人员中可以看到了，然后在人员变动-->调配记录节点修改人员类别。
