Holds the task group information for workspaces.
Column Descriptions
| Column Name
| Column Type
| Description |
| CMFTASKGRP_ID
| BIGINT NOT NULL
| The unique ID of this task group.
|
| IDENTIFIER
| VARCHAR(254)
| Unique, language-independent name used to identify the task group.
|
| STATUS
| INTEGER NOT NULL DEFAULT 0
| Indicates the status of the Task Group. The possible values are: 0=inactive. 1=working. 2=ready for approval. 3=approved. 4=ready to commit. 5=complete. 6=cancelled. 7=commit failed. 8=commit in progress. 9=committed. 10=ready to publish. 11=publish. 12=publish in progress. 13=publish failed.
|
| APPROVEDATE
| TIMESTAMP
| Indicates the date the task group was approved for promotion.
|
| DUEDATE
| TIMESTAMP
| Due date of the task group.
|
| PROMOTIONDATE
| TIMESTAMP
| Date on which the task group promotion is scheduled.
|
| PERSISTENTYPE
| INTEGER NOT NULL DEFAULT 0
| Indicates whether or not this is a persistent task group. 1=persistent, 0=not persistent
|
| TEMPLATETYPE
| INTEGER NOT NULL DEFAULT 0
| Indicates whether or not this is a template task group. 1=Template 0=Instance
|
| QUICKPUBLISHTYPE
| INTEGER NOT NULL DEFAULT 0
| Indicates whether or not this is a quick publish task group. 1=Yes 0=No
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
| COMMITDATE
| TIMESTAMP
| Indicates the date that the task group content was committed to the base content.
|