COGIPF_VIEWREPORT Table

Stores information about report view requests.
Table 1. COGIPF_VIEWREPORT 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

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 check if execution is complete, see COGIPF_STATUS. A blank entry means an incomplete execution. A filled entry means execution completed.

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

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

VARCHAR2 (255)

NOT NULL

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 component subrequest

VARCHAR (255)

COGIPF_THREADID

The alphanumeric identification of the thread where the request is run

VARCHAR (255)

COGIPF_COMPONENTID

The name of the component that generates the indication

VARCHAR (64)

COGIPF_BUILDNUMBER

The major build number for the component that generates the indication

INTEGER

COGIPF_LOG_LEVEL

The level of the indication

INTEGER

COGIPF_TARGET_TYPE

The object on which the operation is run

VARCHAR (255)

COGIPF_REPORTPATH

The report path

VARCHAR (1024)

COGIPF_STATUS

The status of the operation: blank, success, warning, or failure

VARCHAR (255)

COGIPF_ERRORDETAILS

Error details

VARCHAR (2000)

COGIPF_REPORTNAME

The name of the report that was viewed

VARCHAR (512)

COGIPF_PACKAGE

The package with which the report is associated

VARCHAR (1024)

COGIPF_REPORTFORMAT

The format of the report. For more information, see Report formats

VARCHAR (255)

COGIPF_MODEL

The model that the report is associated with

VARCHAR (512)