Identify persons active both as Employee and Contingent Worker
I have a requirement to identify employee records that have a User Person Type "Employee" AND a User Person Type "Contingent Worker" where Assignment Status Type is "Active" on both. For example, Jane Doe has two records in Workforce Management - Worker Assignment Real Time and they both are showing active. One record is their Employee record and one record is their Contingent Worker record and both of these records have an Assignment Status Type of "Active". This is for a bi-weekly audit report finding active Contingent Worker records that need to be ended. Thank you for your suggestions.