RPT_DIM_RM_RESOURCEPOOLS

This is a materialized view on top of PPM's RSC_RESOURCE_POOLS table with additional logic to build the resource pool hierarchy.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

RANK

NULLABLE

NUMBER

Specifies what is the level of this resource pool in the hierarchy. The rank starts with number 1. 1 being the root.

RESOURCE_POOL_ID

NULLABLE

NUMBER

ID derived from the PPM RSC_RESOURCE_POOLS table.

RESOURCE_POOL_NAME

NULLABLE

VARCHAR2(260)

Name of this resource pool derived from the under lying RSC_RESOURCE_POOLS table.

ORG_UNIT_ID

NULLABLE

NUMBER

ID of the org unit this resource pool is tied to. In the original PPM table, this represents a foreign key to the KRSC_ORG_UNIT table.

REGION_ID

NULLABLE

NUMBER

ID of the region this resource pool is tied to. In the original PPM table, this represents a foreign key to the KNTA_REGIONS table.

DIRECT_PARENT_RES_POOL_ID

NULLABLE

NUMBER

ID of the immediate parent resource pool

DIRECT_PARENT_RES_POOL_NAME

NULLABLE

VARCHAR2(4000)

Name of the immediate parent resource pool

PARENT_RESOURCE_POOL_ID1

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 1 or rank 1

PARENT_RESOURCE_POOL_NAME1

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 1 or rank 1

PARENT_RESOURCE_POOL_ID2

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 2 or rank 2

PARENT_RESOURCE_POOL_NAME2

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 2 or rank 2

PARENT_RESOURCE_POOL_ID3

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 3 or rank 3

PARENT_RESOURCE_POOL_NAME3

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 3 or rank 3.

PARENT_RESOURCE_POOL_ID4

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 4 or rank 4.

PARENT_RESOURCE_POOL_NAME4

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 4 or rank 4.

PARENT_RESOURCE_POOL_ID5

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 5 or rank 5.

PARENT_RESOURCE_POOL_NAME5

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 5 or rank 5.

PARENT_RESOURCE_POOL_ID6

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 6 or rank 6.

PARENT_RESOURCE_POOL_NAME6

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 6 or rank 6.

PARENT_RESOURCE_POOL_ID7

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 7 or rank 7.

PARENT_RESOURCE_POOL_NAME7

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 7 or rank 7.

PARENT_RESOURCE_POOL_ID8

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 8 or rank 8.

PARENT_RESOURCE_POOL_NAME8

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 8 or rank 8.

PARENT_RESOURCE_POOL_ID9

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 9 or rank 9.

PARENT_RESOURCE_POOL_NAME9

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 9 or rank 9.

PARENT_RESOURCE_POOL_ID10

NULLABLE

VARCHAR2(4000)

ID of the root resource pool in the hierarchy, level 10 or rank 10.

PARENT_RESOURCE_POOL_NAME10

NULLABLE

VARCHAR2(4000)

Name of the root resource pool in the hierarchy, level 10 or rank 10.

USER_DATA1-20

NULLABLE

VARCHAR2(255)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(255)

User data segment

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_DIM_RM_RESOURCEPOOLS_N8

NONUNIQUE

1

RESOURCE_POOL_ID

RPT_DIM_RM_RESOURCEPOOLS_N9

NONUNIQUE

1

RESOURCE_POOL_NAME

Sequences

This table uses no sequences.