This table stores the planning options of plan types and plan versions.
Module: Project Control
PLANNING_OPTION_ID
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 | 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, 2023, Oracle and/or its affiliates.