KNTA_USER_SESSIONS

When the WEB_SESSION_TRACKING parameter is set to true in the server.conf file, this table stores information about user sessions when errors or exceptions are thrown during user logon, user access to portlets and Scenario Comparison pages.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

USER_SESSION_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

RESOURCE_NAME

NOT NULL

VARCHAR2(200)

Identifier of the Resource the user was trying to access

TIME_TO_LOAD

NOT NULL

NUMBER

Determines the loading time for the Resource to be rendered.

ACCESS_DATE

NOT NULL

DATE

Determines the Date of access for the resource.

ERROR

NULLABLE

VARCHAR2(2000)

Determines whether there were any errors in rendering a resource

APP_SERVER

NULLABLE

VARCHAR2(80)

Indicates the server name

BROWSER

NULLABLE

VARCHAR2(256)

Indicates the browser and version

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_USER_SESSIONS_N1

NONUNIQUE

1

CREATED_BY

KNTA_USER_SESSIONS_U1

UNIQUE

1

USER_SESSION_ID

Sequences

Sequence Name

Sequence Type

KNTA_USER_SESSIONS_S

USER_SESSION_ID