RPT_DIM_RM_ROLES

This is a materialized view over PPM's RSC_ROLES table. It is a simple table with role's details.

Foreign Keys

This table does not have any foreign keys.

Column Name	Null?	Data Type	Description
ROLE_ID	NOT NULL	NUMBER	ROLE_ID derived from PPM's RSC_ROLES table
ROLE_NAME	NOT NULL	VARCHAR2(260)	Name of this role
DESCRIPTION	NULLABLE	VARCHAR2(650)	Description of this role
ENABLED_FLAG	NULLABLE	VARCHAR2(1)	Flag to indicate if this role is enabled or disabled

Index Name	Index Type	Sequence	Column Name
PKC_RSC_ROLES_NLS1	UNIQUE	1	ROLE_ID
RPT_DIM_RM_ROLES_N14	NONUNIQUE	1	ROLE_NAME

This table uses no sequences.