Share this page

# PPM_FM_PLAN_VALUE

This table stores the plan value data related to the staffing profile. The data in this table is displayed in the chart in "Resource Forecast Cost" sub-tab of the Cost tab of the project overview page.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PLAN_VALUE_ID | NOT NULL | NUMBER | System-generated identifier
ENTITY_ID | NOT NULL | NUMBER | Resource ID or position ID
ENTITY_NAME | NOT NULL | VARCHAR2 | Resource name or position name
FISCAL_PERIOD_ID | NOT NULL | NUMBER | Refer to FISCAL_PERIOD_ID in PPM_ FISCAL_PERIODS_NLS table
PLAN_VALUE_BSE | NOT NULL | NUMBER | Base plan value
PLAN_VALUE_LCL | NOT NULL | NUMBER | Local plan value
PLAN_VALUE_CUR_LCL | NOT NULL | VARCHAR2 | Local currency code of plan value
POSITION_ID | NOT NULL | NUMBER | If entity is position, then POSITION_ID=0; If entity is resource, then POSITION_ID indicates the resource belongs to.
ENTITY_TYPE | NOT NULL | VARCHAR2 | ‘position’ or ‘resource’
STAFFING_PROFILE_ID | NOT NULL | NUMBER | Refer to STAFFING_PROFILE_ID in RSC_STAFFING_PROFILES table
CREATED_ BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_ DATE | NOT NULL | DATE | Date record was created
LAST_ UPDATED_ BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_ DATE | NOT NULL | DATE | Date record was last updated

## Indexes

This table has no indexes.

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: