Custom Security profile does not bring up some records in HR
We have a custom responsibility called HR User – XXX, for which the security profile HR: Security Profile is set to a custom Security Profile that has the following Custom Security:
Restrict the people visible to this profile:
ASSIGNMENT.PEOPLE_GROUP_ID IN (SELECT PG.people_group_id FROM pay_people_groups PG WHERE pg.segment1 NOT in ('EXEC') )
By using this responsibility, we cannot see people who have the first segment in People Group NULL or EXEC.
So, we should be able to see all the other people.
Restrict the people visible to this profile:
ASSIGNMENT.PEOPLE_GROUP_ID IN (SELECT PG.people_group_id FROM pay_people_groups PG WHERE pg.segment1 NOT in ('EXEC') )
By using this responsibility, we cannot see people who have the first segment in People Group NULL or EXEC.
So, we should be able to see all the other people.
Now, I try to see a certain person using this responsibility. I am able to see this person which right now has type Applicant. Ex-employee
0