PJF_RBS_ELEM_MSG_INT
Interface table to register messages generated while processing the resources entered in the PJF_RBS_ELEMENTS_INT table.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJF_RBS_ELEM_MSG_INT_PK |
RBS_ELEM_MSG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CURRENT_RUN_ID | NUMBER | 18 | Yes | The identifier of the current run of the process that processes this record. | |
| RBS_ELEM_MSG_ID | NUMBER | 18 | Yes | The unique identifier of the message record corresponding to the resource identified by the temp_rbs_element_id column. | |
| TEMP_RBS_ELEMENT_ID | NUMBER | 18 | Yes | The unique identifier of the record that is to be converted into an actual resource inside a planning resource breakdown structure. | |
| MESSAGE_TYPE | VARCHAR2 | 30 | Yes | Represents the type of the message. Valid values are 'ERROR', 'WARNING', 'INFORMATION', 'STRING'. | |
| FULL_MESSAGE_TEXT | CLOB | Yes | The complete translated and token substituted message. | ||
| MESSAGE_NAME | VARCHAR2 | 30 | Yes | The name of the application message. | |
| MSG_TOKEN_NAME1 | VARCHAR2 | 30 | The name of the first message token. | ||
| MSG_TOKEN_TYPE1 | VARCHAR2 | 30 | The data type of the first message token. | ||
| MSG_TOKEN_VALUE_1 | VARCHAR2 | 1000 | The value of the first message token. | ||
| MSG_TOKEN_NAME2 | VARCHAR2 | 30 | The name of the second message token. | ||
| MSG_TOKEN_TYPE2 | VARCHAR2 | 30 | The data type of the second message token. | ||
| MSG_TOKEN_VALUE_2 | VARCHAR2 | 1000 | The value of the second message token. | ||
| MSG_TOKEN_NAME3 | VARCHAR2 | 30 | The name of the third message token. | ||
| MSG_TOKEN_TYPE3 | VARCHAR2 | 30 | The data type of the third message token. | ||
| MSG_TOKEN_VALUE_3 | VARCHAR2 | 1000 | The value of the third message token. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJF_RBS_ELEM_MSG_INT | pjf_rbs_elements_int | TEMP_RBS_ELEMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_RBS_ELEM_MSG_INT_N1 | Non Unique | Default | CURRENT_RUN_ID, MESSAGE_TYPE, MESSAGE_NAME, TEMP_RBS_ELEMENT_ID |
| PJF_RBS_ELEM_MSG_INT_N2 | Non Unique | Default | TEMP_RBS_ELEMENT_ID, CURRENT_RUN_ID |
| PJF_RBS_ELEM_MSG_INT_N3 | Non Unique | Default | CREATION_DATE |
| PJF_RBS_ELEM_MSG_INT_U1 | Unique | Default | RBS_ELEM_MSG_ID |