Column Descriptions
| Column Name
| Column Type
| Description
|
| CMFTASK_ID
| BIGINT NOT NULL
| Primary key
|
| IDENTIFIER
| VARCHAR(254)
| Unique external name that is used to identify the Task.
|
| USAGE
| INTEGER
| Reserved for IBM internal use.
|
| DUEDATE
| TIMESTAMP
| Indicates the due date for the task.
|
| COMPLETEDATE
| TIMESTAMP
| Indicates the date the task was marked complete.
|
| STATUS
| INTEGER NOT NULL DEFAULT 0
| Indicates the status of the task; 0=Inactive 1=Working 2=Complete
|
| TEMPLATETYPE
| INTEGER NOT NULL DEFAULT 0
| Indicates if this is a template task; 1=Template 0=Instance
|
| TYPE
| INTEGER NOT NULL DEFAULT 1
| Indicates the type of task; 1=Content Contributor; 2=Approver
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|