mpi_evttype

The mpi_evttype table is used to define event types.

Expanded name
Event Types
Table category
Audit
Purpose
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.
Cross-reference
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)