PPM_INT_EVENTS

This table stores the events of the integration. These events will be notified to system administrators through email by the backend service if the notification is enabled.

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

EVENT_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

VERSION

NOT NULL

NUMBER

System field for persistent layer, this field has nothing to do with the business

SOLUTION_ID

NOT NULL

NUMBER

ID of the solution
PPM_REQUEST_ID NULLABLE NUMBER ID of the request created in PPM Center
SYC_PARTNER_ID NULLABLE NUMBER ID of the ALM entity that is synchronized with PPM Center request

CONFIGURATION_KEY

NULLABLE

VARCHAR2(400)

Configuration specific identity for filter event

EVENT_TIME

NOT NULL

DATE

Time the event occurs

EVENT_SUBJECT

NULLABLE

VARCHAR2(512)

Subject of the event

EVENT

NULLABLE

VARCHAR2(4000)

Detail of the event. In case of error, it should contain the entity which has the error and the possible causes

ERROR_FLAG

NOT NULL

VARCHAR2(1)

This flag field distinguishes between error events and normal events

NOTIFICATION_STATUS

NOT NULL

VARCHAR2(32)

Status of the notification. This field may have values such as SENT, READY
MAPPING_KEY NULLABLE VARCHAR2(200) The request type mapping this event is for. It is retrieved from the FIELDS_MAPPING_CONFIGURATION column in the table PPM_INT_CONFIGURATION.

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005201898

UNIQUE

1

EVENT_ID

Sequences

Sequence Name

Sequence Type

PPM_INT_EVENTS_S

EVENT_ID