Database Schema Reference
Table | WFHSessionRole |
|
|
Name | Index Null? | Type | Description |
|
|
|
|
SESSIONID | NOT | NUMBER(38) | Unique identifier for the client session. |
| NULL |
| Joins to WFHSESSION.ID. |
ROLENAME | ● | VARCHAR2(64) | A role held by the session. |
|
|
|
|
Table
Name | Index | Null? | Type | Description |
|
|
|
|
|
COMBINEDID | ✔ | NOT | VARCHAR2(158) | Internal use only. |
|
| NULL |
|
|
PROCESSID |
|
| NUMBER(38) | Unique identifier for a process instance |
|
|
|
| in the engine. |
ACTIVITYID |
|
| NUMBER(38) | Identifier for an activity instance within |
|
|
|
| the process instance designated by |
|
|
|
| PROCESSID. |
ENVIRONMENT |
|
| VARCHAR2(64) | The name of the environment the engine |
|
|
|
| is running in. |
ENGINE |
|
| VARCHAR2(64) | The name of the engine. |
COLDSEQID |
|
| NUMBER(38) | Internal use only. |
COMPLETIONCODE |
|
| NUMBER(38) | Indicates the completion state of the |
|
|
|
| process: |
|
|
|
| 440 – Aborted |
|
|
|
| 430 – Completed |
USERNAME |
|
| VARCHAR2(64) | The user name for the user that started |
|
|
|
| the process. |
OTHERINFO |
|
| VARCHAR2(64) | The otherInfo attribute associated with a |
|
|
|
| user profile. |
|
|
|
|
|
