EVENT_PK

NUMBER

Sequential primary key. This column will not contain a NULL value.

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. This column will not contain a NULL value.

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 (for example, "invoke" for virtual service connector) hosting the invocation. This column will not contain a NULL value.

BINDING_NAME

VARCHAR2(256)

This column is currently not used.

NATIVE_ENDPOINT

VARCHAR2(4000)

Native service endpoint to which the request has been routed.

TARGET_NAME

VARCHAR2(32)

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.

STATUS

VARCHAR2(128)

Formatted status based on resource message ID's.

where '{0}' is the fault reason.

RESPONSE

BLOB

BLOB with response data.

REQUEST

BLOB

BLOB with request data.

TOTAL_TIME

NUMBER

Time interval in milliseconds from when a request is received by the virtual service runtime until the response is returned to the caller. This field includes the overhead incurred while the message is passing through the Mediator runtime.

PROVIDER_TIME

NUMBER

Time interval in milliseconds from when Mediator forwards a request to the native provider until it receives the provider's response. This field includes the time it takes a provider to process the request plus any network latency to/from the provider. This field is a better indicator of the time it takes for a provider to process a request and return a response. Subtracting total time from provider time must give a rough indicator of the Mediator overhead.

INSERTTIMESTAMP

TIMESTAMP(6)

Timestamp when the event is persisted to table.

AUDITTIMESTAMP

TIMESTAMP(6)

Timestamp when the event was created by the virtual service runtime.

ROOTCONTEXTID

CHAR(36)

This column is not used by EDA.

PARENTCONTEXTID

CHAR(36)

This column is not used by EDA.

CONTEXTID

CHAR(36)

This column is not used by EDA.

MSGID

CHAR(36)

This column is not used by EDA.

PARTNER_ID

VARCHAR2(256)

This column is not used by EDA.

SERVERID

VARCHAR2(450)

This column is not used by EDA.

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_USERNAME

VARCHAR2(256)

Integration Server always provides a value, even if anonymous. 80 is the size of user in IS_USER_TASKS table. This column will not contain a NULL value.

EVENT_SOURCE

VARCHAR2(256)

Policy name that produced the event.

TOTAL_DATA_SIZE

NUMBER

Combined request and response payload sizes.