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 |
