AnsweredAssumed Answered

DB Table for Roles

Question asked by dmukherji on Jun 10, 2016
Latest reply on Jun 10, 2016 by sridhar_bandaru

When I use the 'NBI_CURRENT_RESOURCE_FACTS' table for info on the resources, I see a column for Role Name and Role ID for the corresponding resource. I'm looking for the table that has the identifier for the role.


For example, I have a user1 with a Role Name of 'Marketing Director'. However, the identifier for that role is 'mkt_dir' (which is what's used in the Rate Matrix tables (PPA_MATRIX and PPA_MATRIX_VALUES). I need to join 'Marketing Director' to 'mkt_dir' and am not sure which table has the definitions for the roles.