This table contains basic information for project plans and financial plan versions.
Module: Project Control
PLAN_VERSION_ID
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, 2024, Oracle and/or its affiliates.