RPT_DIM_RM_RESOURCEPOOLS

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

RPT_DIM_RM_RESOURCEPOOLS_N8

NONUNIQUE

1

RESOURCE_POOL_ID

RPT_DIM_RM_RESOURCEPOOLS_N9

NONUNIQUE

1

RESOURCE_POOL_NAME