CMFTASKGRP

Holds the Task Group information for Workspaces.

Column Descriptions:

NameTypeDescription
CMFTASKGRP_IDBIGINT NOT NULLThe unique ID of this task group.
IDENTIFIERVARCHAR (254)Unique, language-independent name used to identify the task group.
STATUSINTEGER NOT NULL DEFAULT 0Indicates 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 in progress.
  • 12=published.
  • 13=publish failed.
APPROVEDATETIMESTAMPIndicates the date the task group was approved for promotion.
DUEDATETIMESTAMPDue date of the task group.
PROMOTIONDATETIMESTAMPDate on which the task group promotion is scheduled.
PERSISTENTYPEINTEGER NOT NULL DEFAULT 0Indicates whether or not this is a persistent task group.
  • 1=persistent
  • 0=not persistent
TEMPLATETYPEINTEGER NOT NULL DEFAULT 0Indicates whether or not this is a template task group.
  • 1=Template
  • 0=Instance
QUICKPUBLISHTYPEINTEGER NOT NULL DEFAULT 0Indicates whether or not this is a quick publish task group.
  • 1=Yes
  • 0=No
COMMITDATETIMESTAMPIndicates the date that the task group content was committed to the base content.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CMFTASKGRP_IDPrimary Key
I0000882IDENTIFIERUnique Index
I0000883STATUSNon-Unique Index
I0000884TEMPLATETYPENon-Unique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1125CMFTASKGRP_IDCMFTGDSCCMFTASKGRP_IDCascade
F_1129CMFTASKGRP_IDCMFTGCMTCMFTASKGRP_IDCascade
F_1135CMFTASKGRP_IDCMFWSTGRELCMFTASKGRP_IDCascade
F_1136CMFTASKGRP_IDCMFTGTSKRELCMFTASKGRP_IDCascade