Retrieving user selective access in module
I have an issue in my Workforce Planning model I can't quite get my head around. The scenario is the following:
I have an organisational hierarchy with Cost Centers and then Individuals as childs. I have selective access enabled to my cost center list and only certain users have access to certain cost centers (and therefore individuals).
I want the end users to be able to move employees between different cost centers. This is done by setting a termination date on the employee, and then creating a new one in the new cost center with the start date the day after the termination date for the original employee. The functionality has to work this way since it is required by the business.
Now to the issue: Since I have selective access on cost center level, the users cannot create an employee in a cost center they do not have access to, since they don't have write access.
My solution to this is to add a staging list and module (flat numbered list) inbetween without the organisation hierachy with the selective access, where you need to approve the transfers coming to your cost center.
However, I cannot think of a way to limit the users to not be able approve any transfer, that is, transfers that is not within their cost center. This, since the staging list/module is without any list with selective access (flat). I would like to add DCA to the boolean you tick to confirm the transfer before you run the process, but since I cannot access the selective access rights from the users list, I would have to maintain that access in a module, which is something I would prefer not to do.
When you tick the box for an employee that is not in your cost center, the import fails and the error message doen't really make sense for an end user.
Any suggestions, solutions or ideas? Any help is highly appreciated - Thanks!