COGIPF_USERLOGON Table

Stores user logon and logoff information.
Table 1. COGIPF_USERLOGON table columns, descriptions, and data types

Column name

Description

Data type

COGIPF_CAMID

The user's CAMID

VARCHAR(512)

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) 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_STATUS

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

VARCHAR (255)

COGIPF_ERRORDETAILS

Error details

VARCHAR (2000)

COGIPF_LOGON_OPERATION

Logon, logoff, or logon expired

VARCHAR (255)

COGIPF_USERNAME

The display name of the user

VARCHAR2 (255)

COGIPF_USERID

The username of the user

VARCHAR (255)

COGIPF_NAMESPACE

The namespace ID

VARCHAR (255)

COGIPF_REMOTE_IPADDR

The IP address of the user

VARCHAR (128)

COGIPF_TENANTID

The tenant ID

VARCHAR(255)