Security Profile - Custom Criteria — 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

Security Profile - Custom Criteria

edited Apr 19, 2019 3:44PM in Human Capital Management 4 comments

Summary

SQL not working correctly

Content

I have the following script for some employees to only see certain people in reporting.... The issue I am having is if someone was in a prior role, left the company in that role and is now in a new role, they show.  For example. we have an employee who is now in HR.  She was an intern in a different BU, and left the company then rejoined.  When I add the script which is for HR folks to not see anyone in HR, she still shows.  Any idea what I need to do to the SQL to correct that? 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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