DW_RBS_ELEMENT_D

This table stores the element information and the parent-child relationship for all elements in a resource breakdown structure.

Details

Module: Project Control

Key Columns

RBS_ELEMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RBS_ELEMENT_ID NUMBER 38 0 True System generated number that uniquely identifies the RBS element.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System generated Unique Identifier.
RBS_ELEMENT_NAME_ID NUMBER 38 0 Foreign key to the denormalized name table.
RBS_VERSION_ID NUMBER 38 0 Identifier of the RBS version to which the element belongs.
RESOURCE_FORMAT_ID NUMBER 38 0
OUTLINE_NUMBER VARCHAR2 256 Indicates where in the hierarchy the element belongs.
RBS_SHORT_NAME VARCHAR2 256 User defined short name for the RBS element.
ENABLED_FLAG VARCHAR2 16 Indicates whether the resource is enabled for use or not.
RESOURCE_CLASS_CODE VARCHAR2 32 Code to identify the resource class.
UOM_CODE VARCHAR2 32 Unit of measure of the RBS element.
PARENT_ELEMENT_ID NUMBER 38 0 The parent element of the RBS element null for the top node.
RBS_LEVEL NUMBER 38 0 Indicates the level of the RBS.
LEAF_NODE_FLAG VARCHAR2 16 Indicates whether the element is the lowest level node in the RBS.
RESOURCE_TYPE_ID NUMBER 38 0 The resource type of the element.
RESOURCE_TYPE_CODE VARCHAR2 32 Holds the code used to identify the resource type.
SPREAD_CURVE_ID NUMBER 38 0 Identifier of spread curve
SPREAD_CURVE_CODE VARCHAR2 32 To be used internally for Oracle Projects