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 2048     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.