Skip to Content
Former Member
May 31, 2012 at 07:22 PM

Extract all the Duplicate pernrs for the same employee


Hi All,

I have an issue where an employee has multiple pernrs. E.g. employee is terminated and the same employee comes back as an consultant or Non-employee. therefor has 2 pernrs now.

Example : Pat McGrath has 2 pernrs, but different first name and common last names(Pat vs. Patricia).

I need to get all the duplicate pernrs in the system. I need to know logic I need to use in SE16 PA0002 or query to extract all the duplicate pernrs. Pls advise.

Thanks in advance,