Share this page

# RSC_RESOURCE_ROLES

This is the association table between the RSC_RESOURCES and RSC_ROLES tables.

Since the application is not supporting multiple roles per user currently, a resource has only one record in this table.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
RSC_RESOURCES | RESOURCE_ID | RESOURCE_ID
RSC_ROLES_NLS | ROLE_ID | ROLE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
RESOURCE_ID | NOT NULL | NUMBER | This is the foreign key to RSC_RESOURCES table.
ROLE_ID | NOT NULL | NUMBER | This is the foreign key to RSC_ROLES table.
RESOURCE_ROLE_SEQ | NOT NULL | NUMBER | This column value is currently 0 as there is only one role for a resource in the system. If the system supports multiple roles per resource in the future, this seq will be used to order the roles as they are created.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FK6B119AE926AE1775_I | NONUNIQUE | 1 | ROLE_ID
SYS_C005201581 | UNIQUE | 1 | RESOURCE_ID
SYS_C005201581 | UNIQUE | 2 | RESOURCE_ROLE_SEQ

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: