Contains information about the tasks associated with projects.

Column

Data Type

Constraint

taskinfo_id

VARCHAR(40)

not null

(primary key)

The ID of this task information item

version

BIGINT

not null

The version of the task information item

process_id

VARCHAR(40)

not null

The ID of the process to which this item pertains

process_name

WVARCHAR(255)

not null

The name of the process whose task this item describes

segment_name

WVARCHAR(255)

not null

The name of the process segment whose task this item describes

task_element_id

VARCHAR(255)

not null

The element ID of the task this item describes

acl

VARCHAR(2048)

null

The Access Control List (ACL) assigned to the task at runtime

priority

BIGINT

null

The priority of the task

owner_name

VARCHAR(255)

null

The persona name of the owner of the task, or null if no owner is known.

last_actor_name

VARCHAR(255)

null

The persona name of the last known actor on the task.

last_action_date

TIMESTAMP

null

The date of the last known action on the task.

last_outcome_id

VARCHAR(255)

null

The element ID of the last applied outcome for the task.

 
loading table of contents...