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 |