SQL query fetching Duplicate rows for terminated employees with pending worker records — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL query fetching Duplicate rows for terminated employees with pending worker records

edited Jun 19, 2019 8:15PM in Reporting and Analytics for HCM 18 comments

Summary

SQL query fetching Duplicate rows for terminated employees with pending worker records

Content

I created a SQL BI Publisher report to fetch all active employees and terminated employees along with their Manager person numbers in the system. While I am getting the results as expected, there are five terminated records who have duplicate rows due to different managers assigned to the pending worker record and employee record. 

I am unable to exclude the duplicate records of the pending workers. I tried all the primary flags, system person types, Max Row, R count but nothing seems to be working. 

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!