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     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