This table stores the element information and the parent-child relationship for all elements in a resource breakdown structure.
Module: Project Control
RBS_ELEMENT_ID
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 |