ACTIVITY table
The ACTIVITY table contains records of
each workflow process implementation flow.
| Column Name | Description | Data type |
|---|---|---|
ID* |
Activity ID number. Primary key. | Numeric |
PROCESS_ID* |
Activity process ID number. Reference PROCESS
(ID). |
Numeric |
DEFINITION_ID* |
Activity definition identifier. | Character (100) |
ACTIVITY_INDEX |
Activity index (only if the activity is inside of a loop). | Numeric |
LOOP_COUNT |
Specific to loop activity. Number of iterations that occurred in the loop. |
Numeric |
LOOP_RUNCOUNT |
Specific to asynchronous loop activity. Number of remaining iterations in the loop. |
Numeric |
RETRY_COUNT |
Number of attempts to complete the activity. | Numeric |
LOCK_COUNT |
Number of pending tasks on the activity. | Numeric |
SUBPROCESS_ID |
ID of the subprocess associated with the activity. | Numeric |
NAME |
Activity name. Maximum of 100 characters. | Character (100) |
DESCRIPTION |
Description of the activity. Maximum of 300 characters. | Character (300) |
TYPE |
Activity type. Values include: Application (A) Subprocess (S) Loop (L) Route (R) Manual (M) Operation (O) |
Character (1) |
SUBTYPE |
Activity subtype. Values for manual activity
type include: Approval/Reject (AP) Provide Information (RI) Work Order (WO) Other activity types do not have subtype values. |
Character (2) |
PRIORITY |
Priority of the activity (NOT SUPPORTED). | Numeric |
STARTED |
Time that the activity is started. | Character (50) |
COMPLETED |
Time that the activity is completed. | Character (50) |
LASTMODIFIED |
Time that the activity was last modified. | Character (50) |
STATE |
Current state
of the activity. Values include: Running (R) Not Started (I) Terminated (T) Canceled (A) Suspended (S) Completed (C) Bypassed (B) |
Character (1) |
RESULT_SUMMARY |
Activity result summary code. Values include: Approved (AA) Rejected (AR) Submitted (RS) Success (SS) Timeout (ST) Failed (SF) Warning (SW) Pending (PE) Participant Resolution Failed (PF) Escalated (ES) Skipped (SK) Custom – custom values added for Approval and Reject codes in Enhanced Approval activities |
Character (5) |
RESULT_DETAIL |
Detailed results information for the activity. | Long Character |
SHORT_DETAIL1 |
Short detailed results information for the activity. | Character (4000) |
* Indicates the column is required and not null.
1 Indicates the column or the value is added in release 5.0.