FFS_MESSAGE_QUEUE
Used to store queue of Outbound API messages that still don't have a final status.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_MESSAGE_QUEUE_PK |
MESSAGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MESSAGE_ID | NUMBER | 10 | Yes | Unique identifier for the message in the system. | |
| ACTIVITY_ID | NUMBER | 10 | Yes | 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 | Yes | 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 | Yes | Link to the related user ID - FFS_USER->USER_ID. | |
| FLOW_ID | NUMBER | 10 | Yes | Link to the unique identifier of the notification scenario (ffs_message_flow->flow_id). | |
| STEP_ID | NUMBER | 10 | Yes | 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 | Trigger Label. Example: 'day_before'. | ||
| 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 | Yes | Time Zone Difference. Value in Minutes. | |
| STATUS | VARCHAR2 | 11 | Notification Status. Values: 'new', 'sending', 'failed', 'sent', 'delivered', 'falsemethod', 'obsolete'. | ||
| 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 | Notification message Sent Time. | |||
| 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 value. | ||
| CREATED | TIMESTAMP | Notification Message Creation Date and 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. | ||
| PREV_STATUS | VARCHAR2 | 11 | Previous message's notification status. | ||
| PREV_DESC | VARCHAR2 | 1020 | Previous message's extended notification status description. | ||
| PREV_DATA | VARCHAR2 | 1020 | Previous message's information delivered from external system(customer wants to change phone to #). | ||
| PREV_SUBJECT | VARCHAR2 | 4000 | Previous message's information delivered from external system(customer wants to change phone to #). | ||
| PREV_BODY | CLOB | Previous message's information delivered from external system(customer wants to change phone to #). | |||
| PREV_STOPPED | NUMBER | 3 | Previous Notification Message's Option(s). | ||
| 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_QUEUE_PK | Unique | DATA | MESSAGE_ID |