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

Copyright © 2019, 2025, Oracle and/or its affiliates.