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

TABLE: PJI.PJI_FP_AGGR_RBS_T

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

This table is used to build the RBS normalized table

Temporary Table Details

PJI.PJI_FP_AGGR_RBS_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
Indexes
Index Type Uniqueness Tablespace Column
PJI_FP_AGGR_RBS_T_N1 NORMAL NONUNIQUE Tablespace ColumnWORKER_ID
ColumnSUP_ID
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15) Yes Partitioning Column
STRUCT_VERSION_ID NUMBER (15) Yes Identifier for the RBS structure version
SUP_ID NUMBER (15) Yes Parent RBS element identifier
SUBRO_ID NUMBER (15)
Immediate Child Identifier
SUB_ID NUMBER (15) Yes Child RBS element identifier
SUP_LEVEL NUMBER (15) Yes Parent Level
SUB_LEVEL NUMBER (15) Yes Child Level
SUB_LEAF_FLAG VARCHAR2 (1) Yes Indicates whether the current parent has any children who are leaf nodes
SUB_LEAF_FLAG_ID NUMBER (15)
Identifier for the sub leaf flag
STATUS_ID VARCHAR2 (255)
Identifier for the status used in summarization
Query Text

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


SELECT WORKER_ID
,      STRUCT_VERSION_ID
,      SUP_ID
,      SUBRO_ID
,      SUB_ID
,      SUP_LEVEL
,      SUB_LEVEL
,      SUB_LEAF_FLAG
,      SUB_LEAF_FLAG_ID
,      STATUS_ID
FROM PJI.PJI_FP_AGGR_RBS_T;

Dependencies

[top of page]

PJI.PJI_FP_AGGR_RBS_T does not reference any database object

PJI.PJI_FP_AGGR_RBS_T is referenced by following:

SchemaAPPS
SynonymPJI_FP_AGGR_RBS_T