Previous Topic: target_time_tpl TableNext Topic: Task_Type Table


Task_Status Table

Workflow task states. Possible states include: Wait, pending, approve, reject, and so on.

Field

Data Type

Reference

Remarks

allow_
accumulate

INTEGER

 

Identifies the Allow Accumulate flag, as follows:
0—Do not accumulate
1—Accumulate

allow_task
_update

INTEGER

 

Specifies the Allow Task Update flag, as follows:
0—Cannot update
1—Can update

code

nvarchar(12)

 

Primary key of this table.

del

INTEGER

Active_Boolean_ Table::enum

Specifies the Deleted flag, as follows:
0—Active
1—Inactive/marked as deleted

description

nvarchar(500)

 

Provides a text description of the status.

do_next_task

INTEGER

 

Sets the Do Next Task flag, as follows:
0—No
1—Yes

hold

INTEGER

 

Sets the Hold flag, as follows:
0—Start events
1—Stop events

id

INTEGER

 

Specifies the unique (to the table) numeric ID.

is_internal

INTEGER

 

Specifies the Internal flag, as follows:
0—No
1—Yes (do not display in most status selections).

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Identifies the timestamp of when this record was last modified.

no_update_msg

nvarchar(500)

 

Sets the No Update Message flag to No.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

sym

nvarchar(30)

 

Identifies the Task Status name.

task_complete

INTEGER

 

Sets the Task Complete, as follows:
0—No
1—Yes