ITG_AUDIT_EVENTS

This table stores audit information for events associated with PPM Center entities.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

AUDIT_EVENT_ID

NOT NULL

NUMBER

System-generated identifier

EVENT_TYPE_CODE

NULLABLE

NUMBER

Identifies type of the audit event: CREATE = 1;ISSUE_PRIORITY = 2;DELETE = 3;FIELD_CHANGE = 4;MESSAGE = 5;AUDIT_ADD_PREDECESSOR = 6;AUDIT_REMOVE_PREDECESSOR = 7;RESOURCE_MESSAGE = 8;WORKPLAN_TEMPLATE = 9;SCHEDULE_WORKPLAN = 10;

USER_ID

NULLABLE

NUMBER

Identifies user who caused the audit to trigger. FK to KNTA_USERS

EVENT_DATE

NULLABLE

DATE

Indicates date on which this event occurred

MESSAGE

NULLABLE

VARCHAR2(4000)

Provides message for this audit event

NEW_VALUE

NULLABLE

VARCHAR2(4000)

Provides new value set on the entity

OLD_VALUE

NULLABLE

VARCHAR2(4000)

Provides old value for the entity

FIELD_ID

NULLABLE

VARCHAR2(100)

ID of the field which was changed

CONTAINER0_TYPE

NULLABLE

NUMBER

Type of the container entity

CONTAINER0_ID

NULLABLE

NUMBER

ID of the container entity

CONTAINER0_NAME

NULLABLE

VARCHAR2(650)

Name of the container entity

CONTAINER1_TYPE

NULLABLE

NUMBER

Type of the container entity

CONTAINER1_ID

NULLABLE

NUMBER

ID of the container entity

CONTAINER1_NAME

NULLABLE

VARCHAR2(650)

Name of the container entity

CONTAINER2_TYPE

NULLABLE

NUMBER

Type of the container entity

CONTAINER2_ID

NULLABLE

NUMBER

ID of the container entity

CONTAINER2_NAME

NULLABLE

VARCHAR2(650)

Name of the container entity

ENTITY_TYPE

NULLABLE

NUMBER

Type of the entity

ENTITY_ID

NULLABLE

NUMBER

ID of the entity

ENTITY_NAME

NULLABLE

VARCHAR2(650)

Name of the entity

RELATED_ENTITY_TYPE

NULLABLE

NUMBER

Type of the related entity

RELATED_ENTITY_ID

NULLABLE

NUMBER

ID of the related entity

RELATED_ENTITY_NAME

NULLABLE

VARCHAR2(650)

Name of the related entity

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

Indexes

Index Name

Index Type

Sequence

Column Name

ITG_AUDIT_EVENTS_N1

NONUNIQUE

1

ENTITY_ID

SYS_C005201534

UNIQUE

1

AUDIT_EVENT_ID
ITG_AUDIT_EVENTS_N2

NONUNIQUE

1

 ENTITY_ID
ITG_AUDIT_EVENTS_N2

NONUNIQUE

2

 ENTITY_TYPE
ITG_AUDIT_EVENTS_N3

NONUNIQUE

1

 CONTAINER0_ID
ITG_AUDIT_EVENTS_N3

NONUNIQUE

2

 CONTAINER0_TYPE
ITG_AUDIT_EVENTS_N4

NONUNIQUE

1

 CONTAINER1_ID
ITG_AUDIT_EVENTS_N4

NONUNIQUE

2

 CONTAINER1_TYPE
ITG_AUDIT_EVENTS_N5

NONUNIQUE

1

 CONTAINER2_ID
ITG_AUDIT_EVENTS_N5

NONUNIQUE

2

 CONTAINER2_TYPE

Sequences

Sequence Name

Sequence Type

ITG_AUDIT_EVENTS_S

AUDIT_EVENT_ID