COGIPF_HUMANTASKSERVICE Table

The COGIPF_HUMANTASKSERVICE table contains the following columns.

For more information, see System Performance Metrics.

Table 1. COGIPF_HUMANTASKSERVICE table columns, descriptions, and data types

Column name

Description

Data type

COGIPF_HOST_IPADDR

The host IP address where the log message is generated

VARCHAR (128)

COGIPF_HOST_PORT

The host port number

INTEGER

COGIPF_PROC_ID

The process ID assigned by the operating system

INTEGER

COGIPF_LOCALTIMESTAMP

The local date and time when the log message was generated

TIMESTAMP

COGIPF_TIMEZONE_OFFSET

The time zone, offset from GMT

INTEGER

COGIPF_SESSIONID

The alphanumeric identification of the user session

VARCHAR (255)

COGIPF_REQUESTID

The alphanumeric identification of the request.

VARCHAR (255)

COGIPF_STEPID

The alphanumeric identification for the step within a job run (empty if there is none)

VARCHAR (255)

COGIPF_SUBREQUESTID

The alphanumeric identification of the subrequest.

VARCHAR (255)

COGIPF_THREADID

The alphanumeric identification of the thread where the request is run

VARCHAR (255)

COGIPF_BUILDNUMBER

The major build number for the component that generates the indication

INTEGER

COGIPF_OPERATION

The action performed on the object, for example, ADD, UPDATE

VARCHAR (128)

COGIPF_TARGET_TYPE

The target type

VARCHAR (255)

COGIPF_TARGET_PATH

The object path

VARCHAR (1024)

COGIPF_STATUS

The status of the operation: blank if execution has not completed, success, warning, or failure

VARCHAR (50)

COGIPF_LOGENTRYID

The primary key used to link the tables COGIPF_HUMANTASKSERVICE and COGIPF_HUMANTASKSERVICE _DETAIL

VARCHAR (50)

NOT NULL

COGIPF_TASKID

The task identification

VARCHAR (50)

COGIPF_TRANSACTION_TYPE

The operation that is performed, specific to the Human Task service, for example, claim, setPriority, getTaskInfo, changeSubscription.

VARCHAR (255)

COGIPF_USER

The user who performed the transaction in COGIPF_TRANSACTION_TYPE.

VARCHAR (255)

COGIPF_TASK_PRIORITY

The priority of the task:

  • 1 = high
  • 3 = medium
  • 5 = low

INTEGER

COGIPF_TASK_STATUS

The status of the task: blank if execution has not completed, success, warning, or failure

VARCHAR (255)

COGIPF_TASK_ACTIVATION_TIME

The time that the task was activated.

A date/time value which is stored in the database in long numeric form.

BIGINT

COGIPF_TASK_EXPIRATION_TIME

The date and time when the task expired

BIGINT

COGIPF_TASK_NAME

The name of the task

NTEXT

COGIPF_TASK_SUBJECT

The subject of the task

NTEXT

COGIPF_TASK_DESCRIPTION

The description of the task

NTEXT

COGIPF_TASK_TIMEZONEID

The time zone id of the task

VARCHAR (50)

COGIPF_TASK_ACTUAL_OWNER

The owner of the task

VARCHAR (255)

COGIPF_TASK_INITIATOR

The initiator (creator) of the task

VARCHAR (255)

COGIPF_TASK_CLASS_NAME

The name of the task class which the task is an instance of

VARCHAR (255)

COGIPF_TASK_CLASS_OPERATION

The action performed on the object

VARCHAR (255)

COGIPF_TASK_COMMENT

Comments that are related to the task

VARCHAR (2048)