EVENT_PK

NUMBER

Sequential primary key. Constraint required.

SESSION_ID

VARCHAR2(128)

Session token. This will be the IS session token or a GUID if the token is missing from the message context.

SERVICE_NAME

VARCHAR2(256)

Virtual service name. Constraint required.

SERVICE_VERSION

VARCHAR2(256)

Version of a virtual service or an API. By default, for every version of a virtual service a system version number is generated. At the same time, user can also provide a version number which is set as a user version.

OPERATION_NAME

VARCHAR2(256)

Virtual service operation hosting the invocation. If this is a near real-time event, the VS operation name for the service invocation will be included in the event; however, if this is an aggregated event produced at the end of a policy's interval, no specific operation name is associated with the event. Constraint required.

NATIVE_ENDPOINT

VARCHAR2(4000)

Native service endpoint to which the request has been routed.

BINDING_NAME

VARCHAR2(256)

This column is currently not used.

TARGET_NAME

VARCHAR2(64)

The target name specified in the Integration Server Administrator's Solutions > Mediator > Administration > CentraSite Communication page.

CONSUMER_NAME

VARCHAR2(128)

Comma-separated consumer names identified based on the policy that triggered the event.

CONSUMER_IP

VARCHAR2(64)

Consumer IP.

CONSUMER_ID

VARCHAR2(256)

The system generated consumer application ID.

EVENT_CREATE_TS

TIMESTAMP(6)

Timestamp when the event was created by the virtual service runtime. This is not the time the database performed its insert (for example, this is calculated by the Mediator policy engine and not a database function).

EVENT_SOURCE

VARCHAR2(80)

The Mediator policy name that produced the event.

ALERT_SOURCE

VARCHAR2(256)

The Mediator policy name that produced the event. Currently it is same as EVENT_SOURCE.

ALERT_TYPE

VARCHAR2(128)

PolicyViolation.

ALERT_DESC

VARCHAR2(256)

The alert message defined in the runtime policy action.

EVENT_USERNAME

VARCHAR2(80)

The Integration Server user that executed the service. If the user cannot be determined for the service request, Integration Server will use a default unprivileged user. So this field must never be NULL for near real-time events. However, if this is an aggregated event produced at the end of a policy's interval, no specific user name is associated with the event.