COGIPF_HUMANTASKSERVICE_DETAIL Table

Stores additional details about Human Task service operations (not necessarily required for every audit entry, for example, notification details and human role details).

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