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. If this is a near real-time event, the session ID 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 single service invocation is associated with the event, so no session is included.

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 virtual service 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 is not a database function).

EVENT_SOURCE

VARCHAR2(80)

This column is not currently used.

ALERT_SOURCE

VARCHAR2(256)

The name of the policy that contains the "Monitor Service Performance" or "Monitor Service Level Agreement" action that produced the event.

ALERT_TYPE

VARCHAR2(128)

The value "Monitor" means the event was produced by the "Monitor Service Performance" action. The value "Sla" means the event was produced by the "Monitor Service Level Agreement" action or the "Throttling Traffic Optimization" action.

ALERT_DESC

VARCHAR2(256)

The alert message defined in the run-time policy action.

MONITOR_ATTR

VARCHAR2(256)

The expression rule that was breached in the run-time policy. If multiple conditions are specified for the policy, only the first expression is included here.

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.