The mpi_evttype table is used to define event types.

Expanded name
Event Types
Table category
Defines valid event types. If a database interaction request is event-oriented, and the identifying interaction type is not listed in this table, the operational server rejects any further processing of this request.
Audit records from mpi_grpxixn can be associated with events.
Table 1. mpi_evttype Attribute Descriptions
Attribute Description
caudrecno Creation of this particular record, from mpi_audhead
maudrecno Last time the record value was modified, from mpi_audhead
recstat Record status; A(ctive) or I(nactive)
evttypeno Unique identifier for events
evttypelabel Event type label (used by reports)
evttypecat Event type category (used by reports)

mpi_evttype SQL:

CREATE TABLE mpi_evttype
caudrecno     bigint		NOT NULL,
maudrecno     bigint		NOT NULL,
recstat       nchar(1)		NOT NULL,
evttypeno     smallint		NOT NULL,
evttype       nvarchar(32)	NOT NULL,
evttypelabel  nvarchar(32)	NOT NULL,
evttypecat    nvarchar(32)	NOT NULL
CREATE UNIQUE INDEX mpi_evttype0 ON mpi_evttype (evttypeno)
CREATE UNIQUE INDEX mpi_evttype1 ON mpi_evttype (evttype)