Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: