Copyright © Cloud Software Group, Inc. All rights reserved.

TABLE system_event (

type_id number(5) NOT NULL,

user_name varchar(255) NOT NULL,

audit_date date NOT NULL,

audit_usecs number(6) NOT NULL,

details varchar(512) NOT NULL,

Column	Description
type_id	IID of an audit event. It is defined in the SWDIR\etc\language.lng\sysevents.cfg file.
user_name	Name of the user who performed the audit event, as defined in the user_names table.
audit_date	Date and time when the event occurred. Note: The audit_usecs column can be combined with this column to provide resolution to a microsecond.
audit_usecs	Number of microseconds since the start of the seconds value specified in the audit_date column.
details	Extra details of the event.

Primary Key

None.

Foreign Keys

None.

Indexes

The following index is defined for this table.

Index Name	Column(s) Indexed
idx_sys_event_fk	type_id user_name audit_date

Table Activity

The system_event table contains one row for each system event that is audited.

Rows are added and deleted in the following situations:

A row is...	When...
added	a new system event is audited.
deleted	using the swadm delete_system_event command to delete system event information or clean system event information that is earlier than a specified period. See TIBCO iProcess Engine Administrator’s Guide for more information about the swadm delete_system_event command.

Copyright © Cloud Software Group, Inc. All rights reserved.