RPT_DIM_RM_RESOURCEPOOLMGRS

This is an association table to establish the many-to-many relationship between the RPT_DIM_RM_RESOURCES and RPT_DIM_RM_RESOURCEPOOLS tables.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

RESOURCE_POOL_ID

NOT NULL

NUMBER

System-generated identifier and points to the RPT_DIM_RM_RESOURCE_POOLS.RESOURCE_POOL_ID

RESOURCEPOOL_MGR_USR_ID

NOT NULL

NUMBER

System-generated identifier and points to the RPT_DIM_RM_RESOURCES.RESOURCE_ID

RESOURCE_POOL_NAME

NULLABLE

VARCHAR2(260)

The resource pool name same as in RPT_DIM_RM_RESOURCE_POOLS.RESOURCE_POOL_NAME. The data in this column has been denormalized for reports/universe as many to many relationship is not supported in the universe.

RESOURCEPOOL_MANAGER_NAME

NULLABLE

VARCHAR2(200)

The resource pool manager name (resource name) same as in RPT_DIM_RM_RESOURCES.RESOURCE_NAME. The data in this column has been denormalized for reports/universe as many to many relationship is not supported in the universe.

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.