PJO_WBS_HEADERS

This table tracks associations between projects and Work Breakdown Structures.

Details

  • Schema: FUSION

  • Object owner: PJO

  • Object type: TABLE

  • Tablespace: FUSION_TS_SEED

Primary Key

Name Columns

PJO_WBS_HEADERS_PK

PLAN_VERSION_ID

Columns

Name Datatype Length Precision Not-null Comments
PROJECT_ID NUMBER 18 Yes Identifier of the Project *****
PROJECT_UNIT_ID NUMBER 18 PROJECT_UNIT_ID *****
PLAN_VERSION_ID NUMBER 18 Yes Identifier of the Plan Version *****
STRUCT_VERSION_ID NUMBER 18 Yes WBS structure version associated with the project and plan version *****
CB_FLAG VARCHAR2 1 Indicates if plan version is current baselined or not *****
CO_FLAG VARCHAR2 1 Indicates if plan version is current original or not *****
LOCK_FLAG VARCHAR2 1 Used to arbitrate parallel processing of project data. *****
PLAN_TYPE_ID NUMBER 18 Identifier of the Plan Type, for actuals the value is -1 *****
PLAN_TYPE_CODE VARCHAR2 1 This indicates the type of plan version. Valid values are C-Cost Only , R-Revenue Only ,A-Cost and Revenue same/Actuals *****
CALENDAR_TYPE VARCHAR2 1 CALENDAR_TYPE *****
MIN_TXN_DATE DATE Minimum transaction start date from which transaction exists for the plan version *****
MAX_TXN_DATE DATE Maximum transaction end date to which transaction exists for the plan version *****
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.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CW_FLAG VARCHAR2 1 CW_FLAG *****
RBS_VERSION_ID NUMBER 18 Yes RBS_VERSION_ID *****

Foreign Keys

Table Foreign Table Foreign Key Column
PJO_WBS_HEADERS pjo_plan_versions_b PLAN_VERSION_ID
pjo_xbs_accum_f pjo_wbs_headers PLAN_VERSION_ID

Indexes

Index Uniqueness Tablespace Columns
PJO_PJP_WBS_HEADER_N1 Non Unique FUSION_TS_TX_DATA PROJECT_ID, PLAN_VERSION_ID
PJO_WBS_HEADERS_N2 Non Unique Default STRUCT_VERSION_ID
PJO_WBS_HEADERS_U1 Unique Default PLAN_VERSION_ID