DBA Data[Home] [Help] [Dependency Information]

TABLE: PJI.PJI_XBS_DENORM_DELTA_T

Object Details
Object Name: PJI_XBS_DENORM_DELTA_T
Object Type: TABLE
Owner: PJI
Subobject Name:
Status: VALID

Used during PJP summarization, this table stores the difference between PA_XBS_DENORM and PJI_XBS_DENORM.

Temporary Table Details

PJI.PJI_XBS_DENORM_DELTA_T is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15) Yes Partitioning column.
STRUCT_TYPE VARCHAR2 (30) Yes Indicates the type of XBS represented WBS = Work Breakdown Structure within a ProjectPRG = Program Hierarchy
PRG_GROUP NUMBER (15)
Not null for STRUCT_TYPE = PRG this identifies the connected sub-graph of project hierarchies to which a project belongs.
STRUCT_VERSION_ID NUMBER (15)
Identifier for the structure version
SUP_PROJECT_ID NUMBER (15) Yes SUP_ID is a structure version for this project id.
SUP_ID NUMBER (15) Yes Parent XBS version identifier
SUP_EMT_ID NUMBER (15) Yes Parent XBS element identifier
SUBRO_ID NUMBER (15)
Immediate Child Identifier
SUB_ID NUMBER (15) Yes Child WBS version identifier
SUB_EMT_ID NUMBER (15) Yes Child WBS element identifier
SUP_LEVEL NUMBER (15) Yes Parent Element Level
SUB_LEVEL NUMBER (15) Yes Child Element Level
SUB_ROLLUP_ID NUMBER (15)
Identifier of the element into which a sub structure rolls up.
SUB_LEAF_FLAG VARCHAR2 (1) Yes Indicates whether the current parent has any children who are leaf nodes.
SIGN NUMBER (15) Yes Used to determine the source of the rows.
EVENT_ID NUMBER (15)
Identifier for the event
STRUCT_EMT_ID NUMBER (15)
RELATIONSHIP_TYPE VARCHAR2 (2)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WORKER_ID
,      STRUCT_TYPE
,      PRG_GROUP
,      STRUCT_VERSION_ID
,      SUP_PROJECT_ID
,      SUP_ID
,      SUP_EMT_ID
,      SUBRO_ID
,      SUB_ID
,      SUB_EMT_ID
,      SUP_LEVEL
,      SUB_LEVEL
,      SUB_ROLLUP_ID
,      SUB_LEAF_FLAG
,      SIGN
,      EVENT_ID
,      STRUCT_EMT_ID
,      RELATIONSHIP_TYPE
FROM PJI.PJI_XBS_DENORM_DELTA_T;

Dependencies

[top of page]

PJI.PJI_XBS_DENORM_DELTA_T does not reference any database object

PJI.PJI_XBS_DENORM_DELTA_T is referenced by following:

SchemaAPPS
SynonymPJI_XBS_DENORM_DELTA_T