Share this page
RSC_RESOURCE_POOLS
This table stores all the resource pools in the system. Resource pools contains resources who can be allocated to projects as needed.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KRSC_ORG_UNITS_NLS |
ORG_UNIT_ID |
ORG_UNIT_ID |
|
RSC_RESOURCE_POOLS |
RESOURCE_POOL_ID |
PARENT_RESOURCE_POOL_ID |
|
KNTA_REGIONS_NLS |
REGION_ID |
REGION_ID |
|
ITG_SECURABLE_ENTITIES |
SECURABLE_ENTITY_ID |
SECURABLE_ENTITY_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
RESOURCE_POOL_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_NAME |
NOT NULL |
VARCHAR2(260) |
User entered name for the resource pool. |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(650) |
User entered description for this resource pool. |
|
USER_DATA1-20 |
NULLABLE |
VARCHAR2(255) |
User data segment |
|
VISIBLE_USER_DATA1-20 |
NULLABLE |
VARCHAR2(255) |
User data segment |
|
PARENT_RESOURCE_POOL_ID |
NULLABLE |
NUMBER |
Indicates the parent resource pool for this resource pool. Foreign key to the same table to a different record. |
|
REGION_ID |
NOT NULL |
NUMBER |
Indicates the region this resource pool is used for. This is a foreign key to the KNTA_REGIONS table. |
|
ORG_UNIT_ID |
NULLABLE |
NUMBER |
Indicates the organization unit this resource pool belongs to. This is a foreign key to KRSC_ORG_UNITS table. |
|
SECURABLE_ENTITY_ID |
NULLABLE |
NUMBER |
This is a foreign key to ITG_SECURABLE_ENTITIES table. |
|
SYSTEM_DEFAULT_FLAG |
NULLABLE |
VARCHAR2(1) |
Indicates whether this is the system default resource pool. |
|
INCLUDE_CHILD_LOAD_FLAG |
NULLABLE |
VARCHAR2(1) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
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 |
|
RESOURCE_POOL_SEQ |
NULLABLE |
NUMBER |
Used to order the resource pools as they are created for display purposes |
|
ENABLED_FLAG |
NULLABLE |
VARCHAR2(1) |
Flag that indicates if this resource pool is enabled or not. |
| RMO_CRITERIA_DATA | NULLABLE | VARCHAR2(500 CHAR) | Stores the criteria data for Resource Management Optimization |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
FK6AF578034F391F9A_I |
NONUNIQUE |
1 |
ORG_UNIT_ID |
|
FK6AF57803505BB933_I |
NONUNIQUE |
1 |
REGION_ID |
|
FK6AF57803760C2955_I |
NONUNIQUE |
1 |
PARENT_RESOURCE_POOL_ID |
|
FK6AF578038432A15_I |
NONUNIQUE |
1 |
SECURABLE_ENTITY_ID |
|
SYS_C005200398 |
UNIQUE |
1 |
RESOURCE_POOL_NAME |
|
SYS_C005201579 |
UNIQUE |
1 |
RESOURCE_POOL_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
RSC_RESOURCE_POOLS_S |
RESOURCE_POOL_ID |
