PJF_RBS_ELEMENTS_INT
Interface table for entering details of resources to be created in a given planning resource breakdown structure.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJF_RBS_ELEMENTS_INT_PK |
TEMP_RBS_ELEMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CURRENT_RUN_ID | NUMBER | 18 | Yes | Identifier of the current run of the process that processes this record. | |
| TEMP_RBS_ELEMENT_ID | NUMBER | 18 | Yes | Unique identifier of the record that is to be converted into an actual resource inside a planning resource breakdown structure. | |
| ELEMENT_TYPE | VARCHAR2 | 30 | Yes | Represents if the record has been created as an input to the process or internally created by the process. Valid values are INPUT and INTERNAL. | |
| RES_FORMAT_NAME | VARCHAR2 | 240 | Full name of the resource format. | ||
| LEVEL1_RES_NAME | VARCHAR2 | 300 | Name of the first level resource. | ||
| LEVEL2_RES_NAME | VARCHAR2 | 300 | Name of the second level resource. | ||
| LEVEL3_RES_NAME | VARCHAR2 | 300 | Name of the third level resource. | ||
| ALIAS | VARCHAR2 | 240 | User defined short name for the resource. | ||
| RESOURCE_CLASS_NAME | VARCHAR2 | 240 | Resource class of the resource. | ||
| SPREAD_CURVE_NAME | VARCHAR2 | 240 | Spread curve associated with the resource. | ||
| STATUS | VARCHAR2 | 30 | Yes | Internal status of the record during various stages of its lifecycle. Valid values are: NOT_PROCESSED, PROCESSING, VALIDATED, CREATED, EXISTING, REJECTED. | |
| RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the actual resource in the planning resource breakdown structure. It could have been either created by the process or existing from before. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Indicates if the resource is enabled or disabled when the resource already exists in the planning resource breakdown structure. | ||
| RES_FORMAT_ID | NUMBER | 18 | Identifier of the format of the resource element. | ||
| PARENT_RES_FORMAT_ID | NUMBER | 18 | Identifier of the parent of the format of the resource element. | ||
| FORMAT_LEVEL | NUMBER | 18 | Level of the resource format, for example, 1, 2, and 3. | ||
| RES_TYPE_ID | NUMBER | 18 | Resource type identifier of the lowest level resource in resource format. | ||
| RES_TYPE_ID_LEVEL1 | NUMBER | 18 | Resource type identifier of the first resource type in resource format. | ||
| RES_TYPE_ID_LEVEL2 | NUMBER | 18 | Resource type identifier of the second resource type in resource format. | ||
| RES_TYPE_ID_LEVEL3 | NUMBER | 18 | Resource type identifier of the third resource type in resource format. | ||
| PEOPLE_CLASS_FLAG | VARCHAR2 | 1 | Indicates if the resource format allows the People resource class to be assigned to the resource. | ||
| EQUIPMENT_CLASS_FLAG | VARCHAR2 | 1 | Indicates if the resource format allows the Equipment resource class to be assigned to the resource. | ||
| MATERIAL_ITEM_CLASS_FLAG | VARCHAR2 | 1 | Indicates if the resource format allows the Material Items resource class to be assigned to the resource. | ||
| FINANCIAL_ELEM_CLASS_FLAG | VARCHAR2 | 1 | Indicates if the resource format allows the Financial Resources resource class to be assigned to the resource. | ||
| RBS_ELEMENT_NAME_ID | NUMBER | 18 | Unique identifier of the display name of the lowest level resource. | ||
| RESOURCE_SOURCE_ID | NUMBER | 18 | Identifier of the lowest level resource in the resource format. | ||
| LEVEL1_RES_SRC_ID | NUMBER | 18 | Identifier of the first resource in the resource format. | ||
| LEVEL2_RES_SRC_ID | NUMBER | 18 | Identifier of the second resource in the resource format. | ||
| LEVEL3_RES_SRC_ID | NUMBER | 18 | Identifier of the third resource in the resource format. | ||
| PERSON_ID | NUMBER | 18 | Identifier of the person when it is part of the resource element. | ||
| PERSON_FULL_NAME | VARCHAR2 | 1000 | Full name of the person when it is part of the resource element. | ||
| EVENT_TYPE_ID | NUMBER | 18 | Identifier of the event type when it is part of the resource element. | ||
| EXPENDITURE_CATEGORY_ID | NUMBER | 18 | Identifier of the expenditure category when part of the resource element. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the expenditure type when it is part of the resource element. | ||
| ITEM_CATEGORY_ID | NUMBER | 18 | Identifier of the item category when it is part of the resource element. | ||
| ITEM_CATEGORY_NAME | VARCHAR2 | 250 | Name of the item category when it is part of the resource element. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the inventory item when it is part of the resource element. | ||
| JOB_ID | NUMBER | 18 | Identifier of the job when it is part of the resource element. | ||
| JOB_NAME | VARCHAR2 | 240 | Name of the job when it is part of the resource element. | ||
| JOB_SET_ID | NUMBER | 18 | Identifier of the set to which the job belong when the job is part of the resource element. | ||
| ORGANIZATION_ID | NUMBER | 18 | Identifier of the organization when it is part of the resource element. | ||
| PERSON_TYPE_ID | NUMBER | 18 | Identifier of the person type when it is part of the resource element. | ||
| PERSON_TYPE_CODE | VARCHAR2 | 30 | Lookup code for the person type when it is part of the resource element. | ||
| NON_LABOR_RESOURCE_ID | VARCHAR2 | 20 | Identifier of the nonlabor resource when it is part of the resource element. | ||
| RESOURCE_CLASS_ID | NUMBER | 18 | Identifier of the resource class of the resource element. | ||
| REVENUE_CATEGORY_ID | NUMBER | 18 | Identifier of the revenue category when it is part of the resource element. | ||
| REVENUE_CATEGORY_CODE | VARCHAR2 | 30 | Lookup code for the revenue category when it is part of the resource element. | ||
| VENDOR_ID | NUMBER | 18 | Identifier of the supplier when it is part of the resource element. | ||
| VENDOR_NAME | VARCHAR2 | 360 | Name of the supplier when it is part of the resource element. | ||
| RESOURCE_CLASS_CODE | VARCHAR2 | 30 | Code that identifies the resource class of the resource element. | ||
| SPREAD_CURVE_ID | NUMBER | 18 | Identifier of the spread curve. | ||
| UNIT_OF_MEASURE | VARCHAR2 | 30 | Unit of measure of the resource element | ||
| PARENT_IDENTIFIED_FLAG | VARCHAR2 | 1 | Yes | Indicates if the parent element for this resource element has been located either in the planning resource breakdown structure or in this interface table. | |
| PARENT_RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the parent of this resource element in the planning resource breakdown structure. | ||
| PARENT_TEMP_RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the parent of this resource element in this interface table. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| RBS_HEADER_NAME | VARCHAR2 | 240 | Name of the resource breakdown structure. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Identifier of the enterprise service scheduler process that loaded the record into the interface table. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | Number that uniquely identifies the project with which the resource breakdown structure is associated. | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project with which the resource breakdown structure is associated. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | Identifier of the project role which is part of the resource element. | ||
| PROJECT_ROLE_NAME | VARCHAR2 | 240 | Name of the project role which is part of the resource element. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJF_RBS_ELEMENTS_INT | pjf_rbs_elements | RBS_ELEMENT_ID |
| pjf_rbs_elem_msg_int | pjf_rbs_elements_int | TEMP_RBS_ELEMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_RBS_ELEMENTS_INT_N1 | Non Unique | Default | CURRENT_RUN_ID, ELEMENT_TYPE, STATUS |
| PJF_RBS_ELEMENTS_INT_N2 | Non Unique | Default | CREATION_DATE |
| PJF_RBS_ELEMENTS_INT_N3 | Non Unique | Default | RBS_ELEMENT_ID, CURRENT_RUN_ID |
| PJF_RBS_ELEMENTS_INT_N4 | Non Unique | Default | REQUEST_ID, STATUS |
| PJF_RBS_ELEMENTS_INT_N5 | Non Unique | Default | REQUEST_ID, RBS_HEADER_NAME |
| PJF_RBS_ELEMENTS_INT_U1 | Unique | Default | TEMP_RBS_ELEMENT_ID |