场景说明:通过HR同步工具同步组织架构,出现重复人员信息,人员无法正常登录
场景类型:常规
涉及版本:E-cology9
解决方案:
--setup 1、查询重复数据,大于1即为重复数据
select outkey,lastname,count(1) from hrmresource
where status<5
group by outkey,lastname
--setup 2、通过outkey查询重复数据信息
select id,lastname,loginid,status,outkey,createdate from hrmresource where outkey in (3790,3885,3778,3786,3884,3944,3979,3886,3989,3881,3986,3982,3780)
order by lastname
--setup 3、明确需要更新人员信息,重复数据ID连续,只需要处理ID较大的 1740 、1741 ,处理1741即可
select id,lastname,loginid,status,outkey,createdate from hrmresource where id in (1840,1740,1626,1742,1844,1641,1849,1738,1854,1803,1636,1623,1734)
order by lastname
--setup 4、取消重复数据的关联关系和人员状态 清除登录ID、状态为离职、outkey置空
--update hrmresource set loginid='',status=5,outkey='' where id in (1623) and lastname =''