NotificationTaskReminderDefinition (ver24.9.0)
This table holds the task reminder configuration on the notification definition page.
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. |
NotificationTaskDefinitionID | 24.9.0 | NUMBER(19,0) | Foreign Key to NotificationTaskDefinition table unique ID. Required. |
NotificationTaskReminderDefinitionID | 24.9.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. 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. |
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. |