Share this page
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.
