RPT_FCT_RM_RES_DISTRIBUTION
This table stores the current percentage distribution of resources in the resource pools.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
RESOURCE_ID |
NOT NULL |
NUMBER |
ID derived from the PPM RSC_RESOURCE_POOLS table |
RESOURCE_POOL_ID |
NOT NULL |
NUMBER |
ID derived from the PPM RSC_RESOURCE_POOLS table |
DISTRIBUTION_DATE |
NOT NULL |
DATE |
Date on which this resource pool distribution was last determined |
DISTRIBUTION_PERCENT |
NOT NULL |
NUMBER |
The percentage that effort is distributed to this resource in the resource pool |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.