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