PJS_PLAN_VERSION_D
This table contains persistent plan version dimension data.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJS_PLAN_VERSION_D_PK |
PLAN_VERSION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PROJECT_ID | NUMBER | 18 | Contains the PROJECT_ID, not the Project Number (SEGMENT1) | |||
| PARENT_PLAN_VERSION_ID | NUMBER | 18 | Parent plan version ID | Active | ||
| PLAN_VERSION_NAME | VARCHAR2 | 225 | Plan version name | |||
| PLAN_VERSION_ID | NUMBER | 18 | Yes | Plan Version ID | ||
| PLAN_TYPE_ID | NUMBER | 18 | Plan type ID | |||
| PLAN_CLASS_CODE | VARCHAR2 | 1 | Indicates whether the plan is a budget or forecast plan | |||
| PLANNED_FOR_CODE | VARCHAR2 | 30 | Stores the planned for code value of the plan version. | |||
| TIME_PHASED_TYPE_CODE | VARCHAR2 | 30 | Indicates whether a plan should be prorated the beginning or end of a period, or evenly | |||
| CURRENT_BUDGET_FLAG | VARCHAR2 | 1 | Inernal flag | |||
| ORIGINAL_BUDGET_FLAG | VARCHAR2 | 1 | Inernal flag | |||
| CURRENT_FORECAST_FLAG | VARCHAR2 | 1 | Inernal flag | |||
| PRIOR_FORECAST_FLAG | VARCHAR2 | 1 | Inernal flag | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_PLAN_VERSION_D_N1 | Non Unique | FUSION_TS_TX_DATA | PROJECT_ID, PLAN_VERSION_ID |