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.