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.