FFS_MESSAGE_STEP
Contains configured steps for notification scenarios.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FFS_MESSAGE_STEP_PK |
STEP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STEP_ID | NUMBER | 10 | Yes | Link to the record in FFS_MESSAGE_STEP->STEP_ID. | |
| TYPE | VARCHAR2 | 5 | Step type. (start - top step, inner - related step). | ||
| FLOW_ID | NUMBER | 10 | Yes | Link to the unique identifier of the notification scenario (ffs_message_flow->flow_id). | |
| NAME | VARCHAR2 | 256 | Message Step Name. Unique text value. | ||
| METHOD | VARCHAR2 | 15 | Identifier of message method which is used to process the message.. | ||
| SUBMETHOD | VARCHAR2 | 40 | Additional identifier for message method 'external_system'. | ||
| FAULT_RETRIES | NUMBER | 10 | Rest of attempts quantity on notification sent failure. | ||
| FAULT_INTERVAL | NUMBER | 10 | Interval before next notification attempt on notification sent failure. | ||
| SENT_RETRIES | NUMBER | 10 | Rest of attempts quantity on notification sent. | ||
| SENT_INTERVAL | NUMBER | 10 | Interval before next notification attempt on notification sent. | ||
| DELAY | NUMBER | 10 | Delay the message by specified minutes. | ||
| RECIPIENT | VARCHAR2 | 10 | Recipient. Values: 'customer', 'provider', 'dispatcher', 'static'. | ||
| TIME_IN_MSG | VARCHAR2 | 21 | Defines what time to use in message. | ||
| ADDRESS | VARCHAR2 | 8 | Notification Address which was used for the action. | ||
| ADDRESS_PROPERTY_ID | NUMBER | 5 | Reference to the unique property ID -> FFS_PROPERTY_DESC -> PROPERTY_ID. | ||
| STATIC_ADDRESS | VARCHAR2 | 1020 | Recipient Address. Used to send the message to specific users, user groups, and helpdesks. | ||
| STATIC_TIME_ZONE_ID | NUMBER | 3 | Unique identifier for the time zone created in the system. | ||
| STATIC_LANGUAGE_ID | NUMBER | 3 | F.k. language. language for static address. | ||
| REPLY_TO | VARCHAR2 | 1020 | The value for the 'reply to' email parameter, which is used as a senders address in an email notification. | ||
| SKIP_HOLIDAYS | NUMBER | 3 | Indicates whether the message sending should be postponed during a configured holiday date.`. | ||
| MAX_DAYS_TO_SHIFT | NUMBER | 3 | The number of days to shift proactive customer messages back in the calendar if messages are assigned for a day of the week for which a block is set or if they are assigned to fall on a company holiday when holidays are blocked. | ||
| SKIP_WEEKDAYS | NUMBER | 3 | Yes | The days of the week on which proactive customer messages should not be sent. | |
| SEND_AT | VARCHAR2 | 13 | The notification interval starts directly from the message creation. | ||
| SEND_DAY_SHIFT | NUMBER | 10 | It defines a number of days to add to the date determined using the 'method'. | ||
| SEND_FROM | NUMBER | 5 | Specifies starting time of the message time range for sending the message. | ||
| SEND_WITHIN | NUMBER | 10 | It is a length of the notification interval in hours/minutes. (end time = start time + length). | ||
| SURVEY_ID | NUMBER | 8 | This field is not used and can be removed. | ||
| FEATURES | NUMBER | 10 | Yes | It is a set of boolean flags that define behavior of this message step. | |
| 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. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| DELETED_FLAG | VARCHAR2 | 1 | Indicates whether the record is logically deleted (Y - soft deleted, N or NULL - active). |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_MESSAGE_STEP_N1 | Non Unique | Default | TYPE, FLOW_ID |
| FFS_MESSAGE_STEP_PK | Unique | Default | STEP_ID, ORA_SEED_SET1 |
| FFS_MESSAGE_STEP_PK1 | Unique | Default | STEP_ID, ORA_SEED_SET2 |