FFS_MESSAGE_LOG
Used to store Outbound API message modification history.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_MESSAGE_LOG_PK |
LOG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOG_ID | NUMBER | 19 | Yes | Unique identifier of the Message Log record. | |
| MESSAGE_ID | NUMBER | 10 | Link to the record in FFS_MESSAGE_QUEUE->MESSAGE_ID. | ||
| ACTIVITY_ID | NUMBER | 10 | Identifier of the activity the message is related to. | ||
| VISIT_ID | NUMBER | 10 | Link to FFS_VISIT record related to the message. | ||
| INVENTORY_ID | NUMBER | 10 | Reference to the related inventory ID - FFS_INVENTORY->INVENTORY_ID. | ||
| ROUTE_ID | NUMBER | 10 | Reference to the unique route ID -> FFS_ROUTE -> ROUTE_ID. | ||
| RESOURCE_ID | NUMBER | 8 | Link to the related resource ID - FFS_RESOURCE->RESOURCE_ID. | ||
| SERVICE_REQUEST_ID | NUMBER | 10 | ID of the related support request. Reference to the FFS_SERVICE_REQUEST -> SERVICE_REQUEST_ID. | ||
| USER_ID | NUMBER | 18 | Link to the record in FFS_USER->USER_ID. | ||
| FLOW_ID | NUMBER | 10 | Link to the unique identifier of the notification scenario (ffs_message_flow->flow_id). | ||
| STEP_ID | NUMBER | 10 | Link to the record in FFS_MESSAGE_STEP->STEP_ID. | ||
| PREV_MESSAGE_ID | NUMBER | 10 | Yes | Link to the record in FFS_MESSAGE_QUEUE->MESSAGE_ID. | |
| MESSAGE_TRIGGER | VARCHAR2 | 24 | Identifier of the launch condition that triggered the scenario which created the message. | ||
| METHOD | VARCHAR2 | 15 | Identifier of message method which is used to process the message.. | ||
| SUBMETHOD | VARCHAR2 | 40 | Additional identifier for message method 'external_system'. | ||
| SEND_FROM | TIMESTAMP | Specifies starting time of the message time range for sending the message. | |||
| SEND_TO | TIMESTAMP | Specifies ending time of the message time range for sending the message. | |||
| GMT_SHIFT | NUMBER | 10 | Time Zone Difference. Value in minutes starting from the Midnight. Example: 120, -240. | ||
| STATUS | VARCHAR2 | 11 | Notification Status. Values: 'obsolete', 'falsemethod', 'delivered', 'sent', 'failed'. | ||
| DESCRIPTION | VARCHAR2 | 1020 | Extended notification status description. | ||
| DATA | VARCHAR2 | 1020 | Information delivered from external system(customer wants to change phone to #). | ||
| EXTERNAL_ID | VARCHAR2 | 160 | Sent message external system identifier. | ||
| FAULT_RETRIES | NUMBER | 10 | Yes | Total attempts quantity on notification sent failure. | |
| FAULT_ATTEMPT | NUMBER | 10 | Yes | Rest of attempts quantity on notification sent failure. | |
| FAULT_INTERVAL | NUMBER | 10 | Yes | Interval before next notification attempt on notification sent failure. | |
| SENT_ATTEMPT | NUMBER | 10 | Yes | Rest of attempts quantity on notification sent. | |
| SENT_INTERVAL | NUMBER | 10 | Yes | Interval before next notification attempt on notification sent. | |
| SENT | TIMESTAMP | Specifies time of sending the message. | |||
| TIME_DELIVERED_START | NUMBER | 5 | Specifies the activity communicated window time start. | ||
| TIME_DELIVERED_END | NUMBER | 5 | Specifies the activity communicated window time end. | ||
| DURATION | NUMBER | 10 | Step Duration Time. Calculated field. | ||
| CREATED | TIMESTAMP | Notification Message Creation Time. | |||
| UPDATED | TIMESTAMP | Notification Message Last Update Time. | |||
| STOPPED | NUMBER | 3 | It's a bitmap mask which identifies message's further steps. | ||
| SURVEY_ID | NUMBER | 8 | This field is not used and can be removed. | ||
| ADDRESS | VARCHAR2 | 4000 | Notification Address which was used for the action. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_MESSAGE_LOG_N1 | Non Unique | DATA | MESSAGE_ID |
| FFS_MESSAGE_LOG_N2 | Non Unique | DATA | UPDATED |
| FFS_MESSAGE_LOG_N3 | Non Unique | DATA | ACTIVITY_ID |
| FFS_MESSAGE_LOG_N4 | Non Unique | DATA | RESOURCE_ID, SEND_FROM |
| FFS_MESSAGE_LOG_N5 | Non Unique | DATA | SERVICE_REQUEST_ID |
| FFS_MESSAGE_LOG_N6 | Non Unique | DATA | VISIT_ID |
| FFS_MESSAGE_LOG_PK | Unique | DATA | LOG_ID |