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 |