CMFTASK

Holds the Task information for Workspaces

Column Descriptions:

NameTypeDescription
CMFTASK_IDBIGINT NOT NULLPrimary key
IDENTIFIERVARCHAR (254)Unique external name that is used to identify the Task.
USAGEINTEGERReserved for HCL internal use.
DUEDATETIMESTAMPIndicates the due date for the task.
COMPLETEDATETIMESTAMPIndicates the date the task was marked complete.
STATUSINTEGER NOT NULL DEFAULT 0Indicates the status of the task:
  • 0=Inactive
  • 1=Working
  • 2=Complete
TEMPLATETYPEINTEGER NOT NULL DEFAULT 0Indicates if this is a template task:
  • 0=Instance
  • 1=Template
TYPEINTEGER NOT NULL DEFAULT 1Indicates the type of task:
  • 1=Content Contributor
  • 2=Approver
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>CMFTASK_IDPrimary Key
I0000885IDENTIFIERUnique Index
I0000886STATUSNon-Unique Index
I0000887TYPENon-Unique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1131CMFTASK_IDCMFTASKDSCCMFTASK_IDCascade
F_1133CMFTASK_IDCMFTSKMBRELCMFTASK_IDCascade
F_1137CMFTASK_IDCMFTGTSKRELCMFTASK_IDCascade