COGIPF_POWERPLAY Table

The COGIPF_POWERPLAY table contains the following columns.
Table 1. Columns in the COGIPF_POWERPLAY table

Column name

Description and data type

COGIPF_HOST_ IPADDR

The host IP address where the log message is generated

VARCHAR2 (15)

COGIPF_HOST_ PORT

The host port number

NUMBER

COGIPF_PROC_ID

The process ID assigned by the operating system

NUMBER

COGIPF_LOCAL TIMESTAMP

The local date and time when the log message was generated

While the report is executing, this is the time that the report execution started. After the report execution is complete, this is the end time of report execution.

To calculate the execution start time for a report that has already completed execution, subtract COGIPF_RUNTIME from COGIPF_LOCALTIMESTAMP.

DATE

COGIPF_TIMEZONE_ OFFSET

The time zone, offset from GMT

NUMBER

COGIPF_SESSIONID

The identification number of the session

VARCHAR2 (255)

COGIPF_ REQUESTID

The identification number of the request

VARCHAR2 (255) UNIQUE NOT NULL

COGIPF_STEPID

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

VARCHAR2 (255)

COGIPF_ SUBREQUESTID

The identification number of the component subrequest

VARCHAR2 (255)

COGIPF_THREADID

The identification number of the thread where the request is run

VARCHAR2 (255)

COGIPF_ COMPONENTID

The name of the component that generates the indication

VARCHAR2 (4)

COGIPF_ BUILDNUMBER

The major build number for the component that generates the indication

NUMBER

COGIPF_ LOG_LEVEL

The level of the indication

NUMBER

COGIPF_ TARGET_TYPE

The object on which the operation is run

VARCHAR2 (255)

COGIPF_ REPORTPATH

The report path

VARCHAR2 (512)

COGIPF_STATUS

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

VARCHAR2 (255)

COGIPF_ RUNTIME

The number of milliseconds required to execute the report

NUMBER

COGIPF_REPORTNAME

The name of the report

VARCHAR2 (255)

COGIPF_PACKAGE

The package that the report is associated with

VARCHAR2 (512)

COGIPF_DATASOURCE

The data source that the report is associated with

VARCHAR2 (512)

COGIPF_DATASOURCE_CONNECTION

The data source connection that the report is associated with

VARCHAR2 (512)

COGIPF_CUBEPATH

The path to the local PowerCube that the report is associated with

VARCHAR2 (512)

COGIPF_OPERATION

The action performed on the object

VARCHAR2 (128)

COGIPF_MESSAGE

Error details

VARCHAR2 (2000)

COGIPF_REQUEST_TYPE

NUMBER

COGIPF_SUB_COMPONENTID

VARCHAR2 (64)