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

Copyright © 2019, 2025, Oracle and/or its affiliates.