TaskInstance (ver24.3.0)
This table stores the instances of a task. It can be a stand alone manual task instance or automated run instances of a workflow task.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CurrentStatusCode | 24.6.0 | NUMBER(19,0) | Current status of the task instance. Refers the codeset.codesetid. Required. |
Description | 24.3.0 | VARCHAR2(2000 CHAR) | Description of the task instance. |
DueDateTimestamp | 24.6.0 | TIMESTAMP(6) | Due date of the assigned task instance. |
IsArchived | 24.7.0 | NUMBER(1) | Indicate if the record is archived. Default 0. |
Name | 24.5.0 | VARCHAR2(100 CHAR) | Name of the task instance. |
SharedUserCount | 24.6.0 | NUMBER(5) | Number of users the task is shared with. This will be a fixed count on creation of the task based on the number of users in the selected user role the current user has access to. |
SourceEventMetadata | 24.7.0 | CLOB | A JSON representation of the source event metadata. The context identifier is also included. This is required to identify the user access to the task assignment at the time of display. |
TaskInstanceId | 24.3.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
TaskType | 24.3.0 | VARCHAR2(100 CHAR) | Task type. Required. |
WhenArchived | 24.7.0 | TIMESTAMP(6) | The date and time the record was archived. |
WhenCompleted | 24.7.0 | TIMESTAMP(6) | The date and time the record was marked with a completed status. |
WhenCreated | 24.3.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 24.3.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 24.3.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
WhoModifed | 24.3.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |