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 Help required - pulling manager for rehires

edited Jun 19, 2020 9:11PM in Reporting and Analytics for HCM 5 comments

Summary

Query was built to pull in Areas of responsibility - Manager details but for rehires, it seems to be picking up their previous record

Content

I have been trying to fix a SQL so that it pulls in the max effective_sequence value so that it picks up the newest information but I can't seem to get it to do what I expect

The users want to see the manager details even if the worker is terminated

I think I have tracked the issue to a sub query

When I pull data from per_all_assignments_m, I am getting 4 records returned (2 from the previous work and 2 from the current)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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