PJF_RBS_ELEMENTS_GT
This is a temporary table for RBS elements processing to hold elements data.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| RBS_ELEMENT_ID | NUMBER | 18 | Unique identifier of the RBS element. | |
| ORDER_ID | NUMBER | 9 | Indicates the order of element in the RBS version. | |
| RESOURCE_CLASS_FLAG | VARCHAR2 | 1 | Flag to indicate if the element is a resource class. | |
| RESOURCE_CLASS_CODE | VARCHAR2 | 30 | Code to identify resource class of the element. | |
| RESOURCE_CLASS_ID | NUMBER | 18 | Identifier of resource class of the element. | |
| RES_TYPE_CODE | VARCHAR2 | 30 | Code to identify resource type of the element. | |
| PERSON_ID | NUMBER | 18 | The person ID of the element, if RBS element is a person. | |
| JOB_ID | NUMBER | 18 | The job ID of the element, if RBS element is a job. | |
| PERSON_TYPE_ID | NUMBER | 18 | The person type ID, if RBS element is a person type. | |
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | The Non-labor resource ID of the element, if RBS element is a Project Non-Labor resource. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | The item ID of the element, if RBS element is an item. | |
| ITEM_CATEGORY_ID | NUMBER | 18 | The item category ID of the element, if RBS element is an item category. | |
| PROJECT_ROLE_ID | NUMBER | 18 | The role ID of the element, if RBS element is a role. | |
| ORGANIZATION_ID | NUMBER | 18 | The organization ID of the element, if RBS element is an organization. | |
| FC_RES_TYPE_CODE | VARCHAR2 | 30 | This column is obsolete. | |
| EXPENDITURE_TYPE_ID | NUMBER | 18 | The expenditure type ID, if RBS element is an expenditure type. | |
| EXPENDITURE_CATEGORY_ID | NUMBER | 18 | The expenditure category ID, if RBS element is an expenditure category. | |
| EVENT_TYPE_ID | NUMBER | 18 | The event type ID, if RBS element is an event type. | |
| REVENUE_CATEGORY_ID | NUMBER | 18 | The revenue category ID, if RBS element is an revenue category. | |
| VENDOR_ID | NUMBER | 18 | The supplier ID, if RBS element is a supplier. | |
| SPREAD_CURVE_ID | NUMBER | 18 | Identifier of the spread curve. | |
| MFC_COST_TYPE_ID | NUMBER | 18 | Identifier of the manufacturing cost type. | |
| UNIT_OF_MEASURE | VARCHAR2 | 30 | Unit of measure of the RBS element. | |
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | |
| RATE_BASED_FLAG | VARCHAR2 | 1 | Indicates if the resource is rate based. | |
| RATE_EXPENDITURE_TYPE_ID | NUMBER | 18 | The expenditure type ID associated with the resource. | |
| RATE_FUNC_CURR_CODE | VARCHAR2 | 30 | Functional currency code associated with the expenditure type. | |
| RATE_INCURRED_BY_ORG_ID | NUMBER | 18 | This column is obsolete. | |
| TRANSACTION_DATE | DATE | The plan line details start date, which is then used to determine the date-effective related entities such as person, job, and department. |