# DW_PROJECT_PLAN_VERSION_D

This table contains basic information for project plans and financial plan versions.

## Details

Module: Project Control

## Key Columns

PLAN_VERSION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PLAN_VERSION_ID | NUMBER | 38 | 0 | True | PLAN_VERSION_ID |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
BASELINED_BY_PERSON_ID | VARCHAR2 | 128 |  |  | The identifier of the person who baselined the budget |  |
BASELINED_DATE | DATE |  |  |  | The baselined date of the budget version |  |
CURRENT_PLAN_STATUS_FLAG | VARCHAR2 | 16 |  |  | CURRENT_PLAN_STATUS_FLAG |  |
OBJECT_ID1 | NUMBER | 38 | 0 |  | OBJECT_ID1 |  |
ORIGINAL_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates whether the budget version was an original budget at any time |  |
PLAN_CLASS_CODE | VARCHAR2 | 32 |  |  | PLAN_CLASS_CODE |  |
PLAN_STATUS_CODE | VARCHAR2 | 32 |  |  | PLAN_STATUS_CODE |  |
PLAN_TYPE_ID | NUMBER | 38 | 0 |  | PLAN_TYPE_ID |  |
PLANNED_FOR_CODE | VARCHAR2 | 32 |  |  | PLANNED_FOR_CODE |  |
PROJECT_ID | NUMBER | 38 | 0 |  | The identifier of the project for which the budget is entered |  |
SUBMITTED_BY | VARCHAR2 | 128 |  |  | SUBMITTED_BY |  |
SUBMITTED_DATE | TIMESTAMP |  |  |  | SUBMITTED_DATE |  |
VERSION_NUMBER | NUMBER | 38 | 0 |  | The version number of the budget. For draft budget, the version number is always 1, for baselined budget this number is increased sequentially |  |
ETC_START_DATE | DATE |  |  |  | This column stores the Estimate To Complete start date. |  |
DERIVED_PLAN_STATUS_CODE | VARCHAR2 | 32 |  |  | Derived Plan Status Code. |  |

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