Report to show when a spouse works for the same company

Summary

Benefits for spouses that work for the same company

Content

Hi All,

I  am hoping someone can help me out. We have a request to generate a report that shows when the spouse is also an employee of the company.

I have the start of a report that shows me the employee with their dependents but I need to show if that spouse is also an employee and I know that their person number is not the same for their employee and their contact record.

Besides trying to match on the name and date of birth - is there a method to show that the spouse is also an employee of the company.