NotificationTaskDefinition (ver24.6.0)
This table stores the task related information associated with the notification definition.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Description | 24.6.0 | VARCHAR2(2000 CHAR) | Description of the task. Optional. |
DueDateOffset | 24.6.0 | NUMBER(3,0) | The number of days from the event, task due date should be set. Default 0. Required. |
Name | 24.6.0 | VARCHAR2(100 CHAR) | Name of the task. Required. |
NotificationDefinitionID | 24.6.0 | NUMBER(19,0) | Foreign Key to NotificationDefinition table unique ID. Required. |
NotificationTaskDefinitionID | 24.6.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
WhenCreated | 24.6.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 24.6.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 24.6.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
WhoModifed | 24.6.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |