TaskReminder (ver24.9.0)
This table holds the task reminder configuration created from the My Tasks or Task Management pages or copied from the NotificationTaskDefinition table while created from a notification.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
DeliveryMethod | 24.9.0 | VARCHAR2(10 CHAR) | Delivery method of the reminder notification. Options are InApp, Email and InAppEmail. Required. |
Offset1 | 24.9.0 | NUMBER(3,0) | The number of days before the due date on which the reminder notification has to be sent. This is the first offset. Required. |
Offset2 | 24.9.0 | NUMBER(3,0) | The number of days before the due date on which the reminder notification has to be sent. This is the second offset. Optional. |
TaskInstanceID | 24.9.0 | NUMBER(19,0) | Foreign Key to TaskInstance table unique ID. Required. |
TaskReminderID | 24.9.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
WhenCreated | 24.9.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 24.9.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 24.9.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
WhoModifed | 24.9.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |