Workflow Process Instance

OptimaJet Team Updated 2026-10-12 3 min read 405 words

The WORKFLOWPROCESSINSTANCE table is part of the Oracle database schema used by Workflow Engine. The WORKFLOWPROCESSINSTANCE table stores the current state and execution metadata for process instances. This page lists the table columns in database order together with types, nullability, primary keys, defaults, and indexes.

Table columns

The WORKFLOWPROCESSINSTANCE table contains 19 columns in database order. Data types and default expressions use the syntax defined by Oracle.

WORKFLOWPROCESSINSTANCE columns
Position	Column	Database type	Nullable	Primary key	Default
1	`ID`	`RAW(16)`	No	Yes	-
2	`STATENAME`	`NVARCHAR2(1024)`	Yes	No	-
3	`ACTIVITYNAME`	`NVARCHAR2(1024)`	No	No	-
4	`SCHEMEID`	`RAW(16)`	Yes	No	-
5	`PREVIOUSSTATE`	`NVARCHAR2(1024)`	Yes	No	-
6	`PREVIOUSSTATEFORDIRECT`	`NVARCHAR2(1024)`	Yes	No	-
7	`PREVIOUSSTATEFORREVERSE`	`NVARCHAR2(1024)`	Yes	No	-
8	`PREVIOUSACTIVITY`	`NVARCHAR2(1024)`	Yes	No	-
9	`PREVIOUSACTIVITYFORDIRECT`	`NVARCHAR2(1024)`	Yes	No	-
10	`PREVIOUSACTIVITYFORREVERSE`	`NVARCHAR2(1024)`	Yes	No	-
11	`ISDETERMININGPARAMETERSCHANGED`	`CHAR(1)`	Yes	No	`0`
12	`PARENTPROCESSID`	`RAW(16)`	Yes	No	-
13	`ROOTPROCESSID`	`RAW(16)`	No	No	-
14	`TENANTID`	`NVARCHAR2(128)`	Yes	No	-
15	`STARTINGTRANSITION`	`CLOB`	Yes	No	-
16	`SUBPROCESSNAME`	`CLOB`	Yes	No	-
17	`CREATIONDATE`	`TIMESTAMP(6)`	No	No	`CURRENT_TIMESTAMP`
18	`LASTTRANSITIONDATE`	`TIMESTAMP(6)`	Yes	No	-
19	`CALENDARNAME`	`NVARCHAR2(1024)`	Yes	No	-

Database indexes

The WORKFLOWPROCESSINSTANCE table defines 3 database indexes. Definitions retain the column or field order and sort direction used by the database.

WORKFLOWPROCESSINSTANCE indexes
Index	Unique	Definition
`IDX_CALENDARNAME`	No	`CALENDARNAME`
`IDX_WORKFLOWPROCESSINSTANCE_ROOT`	No	`ROOTPROCESSID`
`PK_WORKFLOWPROCESSINSTANCE`	Yes	`ID`

Previous Workflow Inbox Next Workflow Process Instance Persistence