COGIPF_HUMANTASKSERVICE_DETAIL Table

The COGIPF_HUMANTASKSERVICE_DETAIL table contains the following columns.

For more information, see System Performance Metrics.

Table 1. COGIPF_HUMANTASKSERVICE_DETAIL 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_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 of the step, empty if none

VARCHAR (255)

COGIPF_SUBREQUESTID

The alphanumeric identification of the SUBrequest.

VARCHAR (255)

COGIPF_TASKID

The alphanumeric identification of the task

VARCHAR (50)

COGIPF_LOGENTRYID

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

VARCHAR (50)

NOT NULL

COGIPF_NOTIFICATION_DETAILS

Details about notification emails sent about the task

NTEXT

COGIPF_HUMANROLE_USER

The userid of the user who performs a role for a task

Combines with COGIPF_HUMANROLE to define the role of the user for the task

VARCHAR (255)

COGIPF_HUMANROLE_ROLE

The role of the user

Combines with COGIPF_HUMAN_USER to define the role of the user for the task

VARCHAR (50)

COGIPF_SUBSCRIPTION_OPERATION

The subscription operation, for example, SUBSCRIBE or UNSUBSCRIBE

VARCHAR (50)

COGIPF_SUBSCRIPTION_EVENT

The task event for which the user is subscribing or unsubscribing

SMALLINT

COGIPF_SUBSCRIPTION_USER

The user who is subscribing or unsubscribing for a task event

VARCHAR (255)

COGIPF_TASK_MESSAGE

The task message

NTEXT

COGIPF_TASK_MESSAGE_TYPE

The type of message stored in COGIPF_TASK_MESSAGE

Values can be INPUT, OUTPUT, or FAULT

VARCHAR (20)

COGIPF_DETAIL_ID

The sequence number of the detail record

VARCHAR (50)

NOT NULL