DW_PROJECT_PLAN_OPTION_D

This table stores the planning options of plan types and plan versions.

Details

Module: Project Control

Key Columns

PLANNING_OPTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLANNING_OPTION_ID NUMBER 38 0 True PLANNING_OPTION_ID
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System generated Unique Identifier.
APPROVED_COST_PLAN_TYPE_FLAG VARCHAR2 16 Indicates whether this plan type is used as an approved cost budget
APPROVED_REV_PLAN_TYPE_FLAG VARCHAR2 16 This flag indicates whether this plan type is used as an approved revenue budget
BUDGET_CREATION_METHOD VARCHAR2 32 BUDGET_CREATION_METHOD
CURRENT_PLANNING_PERIOD VARCHAR2 16 CURRENT_PLANNING_PERIOD
PLAN_LEVEL_CODE VARCHAR2 32 PLAN_LEVEL_CODE
PLAN_VERSION_ID NUMBER 38 0 PLAN_VERSION_ID
PRIMARY_COST_FORECAST_FLAG VARCHAR2 16 Indicates if the plan type is a primary cost forecast.
PRIMARY_REV_FORECAST_FLAG VARCHAR2 16 Indicates if the plan type is a primary revenue forecast.
TIME_PHASED_CODE VARCHAR2 32 TIME_PHASED_CODE
ETC_METHOD_CODE VARCHAR2 32 This column will be used to store the Generation Override ETC method code.