Share this page

# RSC_SP_NOTIFICATION_SETUPS

This table stores all the staffing profile's notification setup data. Only one record represents the default setup that will be inherited by all the newly created staffing profiles. Individual staffing profile notification setup can be altered once the staffing profile is created. There is one-to-one mapping between staffing profile and this 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_STAFFING_PROFILES | STAFFING_PROFILE_ID | STAFFING_PROFILE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
SP_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.
STAFFING_PROFILE_ID | NULLABLE | NUMBER | Foreign key to RSC_STAFFING_PROFILES table.
SYSTEM_FLAG | NOT NULL | VARCHAR2(1) | This flag represents if this record is a system level setup.
RSCRQ_FWD_TO_SPMGR | NOT NULL | VARCHAR2(1) | Flag to represent if staffing profile managers should be notified if a resource request is forwarded to a different resource pool.
RSCRQ_REJ_TO_SPMGR | NOT NULL | VARCHAR2(1) | Flag to represent if staffing profile managers should be notified if a resource request is rejected.
CMT_ALLOC_CHG_TO_SPMGR | NOT NULL | VARCHAR2(1) | Flag to represent if staffing profile managers should be notified if a committed allocation status changed to something else.
SFTBK_ALLOC_CHG_TO_SPMGR | NOT NULL | VARCHAR2(1) | Flag to represent if staffing profile managers should be notified if a softbooked allocation is changed to something else.
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
PREVENT_ALL_FLAG | NULLABLE | VARCHAR2(1) | Indicates if all the notifications related to the specified Staffing Profile should disabled or not

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FK5DCC41253F9006BA_I | NONUNIQUE | 1 | STAFFING_PROFILE_ID
SYS_C005201941 | UNIQUE | 1 | SP_NOTIFICATION_SETUP_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
RSC_SP_NOTIFICATION_SETUPS_S | SP_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: