KNTA_OPENAPI_TXN_AUDIT

This table stores web service calls made through the ITG 6.0 web services. The information in this table is sent by the web- service client along with every web service request. It is not used by the newer web services released in PPM 7.1.

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

OPENAPI_TXN_AUDIT_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

CALLER_NAME

NOT NULL

VARCHAR2(50)

Name of the client machine that initiated the web service call

TRANSACTION_NAME

NOT NULL

VARCHAR2(50)

A transaction name provided by the client machine. This is usually a globally unique sting used for tracking purposes.

AUDIT_NOTE

NULLABLE

VARCHAR2(1000)

A note for the web service call

OPERATION_NAME

NOT NULL

VARCHAR2(25)

Name of the web service operation that was invoked by the client

WS_VERSION

NULLABLE

VARCHAR2(50)

Version of the web service operation that was invoked by the client

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_OPENAPI_TXN_AUDIT_U1

UNIQUE

1

OPENAPI_TXN_AUDIT_ID

KNTA_OPENAPI_TXN_AUDIT_U2

UNIQUE

1

CALLER_NAME

KNTA_OPENAPI_TXN_AUDIT_U2

UNIQUE

2

TRANSACTION_NAME

Sequences

Sequence Name

Sequence Type

KNTA_OPENAPI_TXN_AUDIT_S

OPENAPI_TXN_AUDIT_ID