Try OpenEdge Now
skip to main content
Application Developer's Guide
Understanding the Business Process Server repository : Business Process Server event management : Schema for event tables : BizEvent table
 
BizEvent table
In the BizEvent table, EVENT_ID uniquely identifies an event and is generated by the database server in order to guarantee its uniqueness. The result set retrieved from BizEvent should be sorted on EVENT_ID because the event processing in BPM Process Store assumes the order of the event as the order of the event creation. The columns TYPE, VALUE, and CREATE_DATE store the corresponding values in a CommonEvent object. The column CONTEXT_OBJ stores event context in a serialized Java object format.

BizEvent table fields

The definition of the BizEvent table fields are as follows:
Field
Type
Description
EVENT_ID1
NUMBER NOT NULL
Unique event identifier
TYPE
VARCHAR2(30) NOT NULL
Event type
VALUE
VARCHAR2(20) NOT NULL
Value of the event
CREATE_DATE
NUMBER NOT NULL
Event creation time
CONTEXT_OBJ
LONG RAW
Stores event in Java serialized object format.
PROCESS_INSTANCE_ID
NUMBER
The process instance ID
PROCESS_TEMPLATE_ID
NUMBER
The process template ID
WORKSTEP_ID
NUMBER
The workstep ID
1 Table primary key