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.