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.