I got into this interesting situation, where the organization wants to simplify the roles in rate matrix.
Currently we are over 5000+ roles in rate matrix, the idea was to simplify the number of roles in the organization to close 100+ roles.
Eventually when this happens, we are ought to update the existing records in wip table.
My uncertainty drills down to this point:
Can we update role_code with new role id to those existing records in PPA_WIP through a SQL update statement?, will there be any discrepency in any other tables?
or do we have any other tables apart from ppa_Wip which would hold role_code for actual's records?