Restrict employees to be eligible to more than one compensation plan
I would like to create a fast formula in order to exclude employees from other plans if they are eligible to a specific plan. More specifically, I want to restrict employees to be eligible to more than one compensation plan. I was suggested to use Fast Formula but I don't know in which table I'll be able to find the needed information. I'm using SQL Query Builder in OTBI to find the right table but i am not able to achieve my goal.
Has anyone ever created something similar before? Or someone knows where I can find the right table?