SDI_SUMMARY_LOGS

This table logs the errors and the information about tickets that are being processed.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

LOG_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

TICKET_ID

NOT NULL

VARCHAR2(40)

For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update

COMPONENT

NOT NULL

VARCHAR2(100)

For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update

ADAPTER_NAME

NULLABLE

VARCHAR2(100)

For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update

IN_PROCESS

NOT NULL

CHAR

For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update

MESSAGES

NOT NULL

CHAR

For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update

STATUS

NOT NULL

VARCHAR2(400)

For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update

Indexes

Index Name

Index Type

Sequence

Column Name

SDI_SUMMARY_LOGS_N1

NONUNIQUE

1

CREATED_BY

SDI_SUMMARY_LOGS_N2

NONUNIQUE

1

TICKET_ID

SDI_SUMMARY_LOGS_U1

UNIQUE

1

LOG_ID

Sequences

Sequence Name

Sequence Type

SDI_SUMMARY_LOGS_S

LOG_ID