| Oracle® Retail Bulk Data Integration Implementation Guide Release 16.0 E81413-01 |
|
 Previous |
 Next |
| Oracle® Retail Bulk Data Integration Implementation Guide Release 16.0 E81413-01 |
|
Previous |
Next |
BDI_PROCESS_DEFINITION
| Column | Type | Comments |
|---|---|---|
| PROCESS_NAME | VARCHAR2(255) | Name of the process |
| PROCESS_CREATE_TIME | TIMESTAMP | Timestamp when the process was loaded to database |
| PROCESS_DEF_CONTENT | CLOB | The Process Flow DSL |
BDI_PROCESS_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_SYSTEM_OPTIONS
| Column | Type | Comments |
|---|---|---|
| VARIABLE_NAME | VARCHAR2(255) | Name of system variable |
| APP_TAG | VARCHAR2(255) | The application name |
| VARIABLE_VALUE | VARCHAR2(255) | Value of the variable |
