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     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, 2023, Oracle and/or its affiliates.