1. Tables and Views for Project Management
  2. PJS_RBS_D

PJS_RBS_D

Used to store RBS data for PJS.

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PJS_RBS_D_PK

RBS_ELEMENT_ID, OLAP_SELF_NODE_FLAG

Columns

Name Datatype Length Precision Not-null Comments Status
RBS_HEADER_ID NUMBER 18 Resource breakdown structure header ID Active
RBS_VERSION_ID NUMBER 18 Resource breakdown structure version ID Active
PARENT_ELEMENT_ID NUMBER 18 Resource breakdown structure parent element ID Active
RBS_ELEMENT_ID NUMBER 18 Yes Resource breakdown structure element ID Active
RESOURCE_NAME VARCHAR2 270 Resource breakdown structure element name Active
LEAF_NODE_FLAG VARCHAR2 1 Inernal flag Active
OLAP_SELF_NODE_FLAG VARCHAR2 1 Yes Inernal flag Active
CUBE_MEMBER VARCHAR2 21 The member as as it appears in Essbase Active
SOURCE_SYSTEM_ID NUMBER 18 Resource breakdown structure transaction system element ID Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ALIAS_NAME VARCHAR2 1024 Alternate name to identify a member of resource dimension in Smartview
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 80 Descriptive Flexfield: segment of the user descriptive flexfield.

Indexes

Index Uniqueness Tablespace Columns Status
PJS_RBS_D_N1 Non Unique FUSION_TS_TX_DATA RBS_VERSION_ID, RBS_ELEMENT_ID Active
PJS_RBS_D_N2 Non Unique FUSION_TS_TX_DATA PARENT_ELEMENT_ID, OLAP_SELF_NODE_FLAG
PJS_RBS_D_U1 Unique FUSION_TS_TX_DATA RBS_ELEMENT_ID, OLAP_SELF_NODE_FLAG