A Process Schema
The process instrumentation captures the state of the process at the beginning and end of each activity. This information is persisted into the process schema. For each activity there will be two records, one for before activity and the other for after activity.
| Table Name | Description |
|---|---|
|
BDI_PROCESS_DEFINITION |
This table stores all the process flow definitions. It is loaded at deployment time. |
|
BDI_PROCESS_EXEC_INSTANCE |
This table tracks all the process flow executions. There is a row for each process flow execution. |
|
BDI_ACTIVITY_EXEC_INSTANCE |
This table tracks all the activity executions. There are 2 rows for each activity execution. One to store the before context and one to store after context |
|
BDI_ACTIVITY_DYNAMIC_CONFIG |
This table stores the user runtime choices like SKIP, HOLD etc at activity level |
|
BDI_SYSTEM_OPTIONS |
This table has all the system level information like URLs, credential aliases etc. |
|
BDI_EMAIL_NOTIFICATION |
This table persists all the process email notifications. |
|
BDI_PROCESS_CALL_STACK |
This table stores call stack for processes. |
|
BDI_EXTERNAL_VARIABLE |
This table does temporary storage of variables during process execution. |
|
BDI_GROUP |
This table stores group names and its attributes |
|
BDI_GROUP_LOCK |
This table stores the lock id and group names |
|
BDI_GROUP_MEMBER |
This table stores all group member details |
BDI_PROCESS_DEFINITION
| Column | Type | Comments |
|---|---|---|
|
PROCESS_NAME |
VARCHAR2(255) |
Name of the process |
|
PROCESS_ENABLE_STATUS |
VARCHAR2(255) |
Enable or disable the process (true or false) |
|
PROCESS_CREATE_TIME |
TIMESTAMP |
Timestamp when the process was loaded to database |
|
PROCESS_DEF_CONTENT |
CLOB |
The Process Flow DSL |
BDI_ACTIVITY_EXEC_INSTANCE
| Column | Type | Comments |
|---|---|---|
|
ACTIVITY_EXEC_ID |
VARCHAR2(255) |
System generated id for activity instance |
|
ACTIVITY_BEGIN_OR_END |
VARCHAR2(255) |
"B" for Before Image, "A" for after image |
|
ACTIVITY_EVENT_TIME |
TIMESTAMP |
Time when he activity occurred |
|
ACTIVITY_NAME |
VARCHAR2(255) |
Name of the activity |
|
ACTIVITY_SEQ_NBR |
NUMBER |
Sequence number of the activity |
|
ACTIVITY_STATUS |
NUMBER |
Activity Status |
|
PROCESS_EXECUTION_ID |
VARCHAR2(255) |
Process Execution Id of the process instance that initiated the activity |
|
PROCESS_VARIABLES |
BLOB |
Serialized process variable map |
BDI_PROCESS_EXEC_INSTANCE
| Column | Type | Comments |
|---|---|---|
|
PROCESS_EXECUTION_ID |
VARCHAR2(255) |
Process Execution Id of the process instance that initiated the activity. |
|
PROCESS_NAME |
VARCHAR2(255) |
Name of the process |
|
PROCESS_EXEC_START_TIME |
TIMESTAMP |
Time when the process execution started |
|
PROCESS_EXEC_END_TIME |
TIMESTAMP |
Time when the process execution started |
|
PROCESS_FIRST_RUN_START_TIME |
TIMESTAMP |
Time when the process execution started, does not change when process is restarted. |
|
PROCESS_STATUS |
VARCHAR2(255) |
Process status |
BDI_ACTIVITY_DYNAMIC_CONFIG
| Column | Type | Comments |
|---|---|---|
|
PROCESS_NAME |
VARCHAR2(255) |
Name of the process |
|
ACTIVITY_NAME |
VARCHAR2(255) |
Name of the activity |
|
HOLD_FLAG |
VARCHAR2(255) |
To hold the activity |
|
SKIP_FLAG |
VARCHAR2(255) |
To skip the activity |
|
SKIP_OR_HOLD_EXPIRATION |
TIMESTAMP |
Time when skip or hold activity expires. |
|
COMMENTS |
VARCHAR2(255) |
Comments |
|
INVOKE_CALLBACK_SERVICE |
VARCHAR2(255) |
Invoke any callback service |
|
USER_NAME |
VARCHAR2(255) |
Username |
|
CALLBACK_SERVICE_URL_ALIAS |
VARCHAR2(255) |
Callback Service URL Alias |
|
CALLBACK_SERVICE_URL |
VARCHAR2(255) |
Callback Service URL |
BDI_EMAIL_NOTIFICATION
| Column | Type | Comments |
|---|---|---|
|
EMAIL_NOTIFICATION_ID |
NUMBER |
Process Execution Id of the process instance that initiated the activity
|
|
APP_NAME |
VARCHAR2(100) |
Name of the application |
|
EMAIL_NOTIFICATION_TO |
VARCHAR2(500) |
EMail Ids to whom notification will be sent |
|
EMAIL_NOTIFICATION_SUBJECT |
CLOB |
Notification subject |
|
EMAIL_NOTIFICATION_CONTENT |
CLOB |
Notification content |
|
EMAIL_NOTIFICATION_DATETIME |
TIMESTAMP |
At what time notification sent |
|
EMAIL_NOTIFICATION_TYPE |
VARCHAR2(255) |
Type of information |
|
ACTION_STATUS |
VARCHAR2(255) |
status (PENDING/COMPLETED) |
|
COMMENTS |
VARCHAR2(500) |
BDI_SYSTEM_OPTIONS
| Column | Type | Comments |
|---|---|---|
|
CREATE_TIME |
TIMESTAMP |
Time it was created |
|
UPDATE_TIME |
TIMESTAMP |
Time it was updated |
|
VARIABLE_NAME |
VARCHAR2(255) |
Name of system variable |
|
APP_TAG |
VARCHAR2(255) |
The application name |
|
VARIABLE_VALUE |
VARCHAR2(255) |
Value of the variable |