Share this page

# RSC_RP_NOTIFICATION_SETUPS

This table stores all the resource pools notification setup data. Only one record represents the default setup that will be inherited by all the newly created resource pools. Individual resource pool notification setup can be altered once the resource pool is created. This table has a one-to-one mapping to resource pool table.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
RSC_RESOURCE_POOLS | RESOURCE_POOL_ID | RESOURCE_POOL_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
RP_NOTIFICATION_SETUP_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually.
RESOURCE_POOL_ID | NULLABLE | NUMBER | Foreign key to RSC_RESOURCE_POOLS table
SYSTEM_FLAG | NOT NULL | VARCHAR2(1) | Flag to indicate if this record represents the system level settings for the resource pool notifications
RSCRQ_SEND_FWD_TO_RPMGR | NOT NULL | VARCHAR2(1) | Flag to represent if the resource pool manager should be notified if a resource request is sent to that resource pool
CMT_ALLOC_CHG_TO_RSC | NOT NULL | VARCHAR2(1) | Flag to represent if the allocated resource should be notified if the committed allocation status changes to something else.
SFTBK_ALLOC_CHG_TO_RSC | NOT NULL | VARCHAR2(1) | Flag to represent if the allocated resource should be notified if the soft booked allocation status changes to something else.
FRCST_DMND_CHG_TO_RPMGR | NOT NULL | VARCHAR2(1) | Flag to indicate if system should send notification to resource pool manager when the start date, end date, or FTEs of a position is adjusted.
PSTN_DLT_TO_RPMGR | NOT NULL | VARCHAR2(1) | Flag to indicate if system should send notification to resource pool manager when a position is deleted.
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date record was created
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
RSCRQ_SEND_WITHDRAW_TO_RPMGR | NOT NULL | VARCHAR2(1) | Flag to represent if the resource pool manager should be notified if a resource request is withdrawn from that resource pool

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FKD7468686A85CA660_I | NONUNIQUE | 1 | RESOURCE_POOL_ID
SYS_C005201942 | UNIQUE | 1 | RP_NOTIFICATION_SETUP_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
RSC_RP_NOTIFICATION_SETUPS_S | RP_NOTIFICATION_SETUP_ID

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: