ACTIVITY table

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 activitie.
Character (5)

RESULT_DETAIL Detailed results information for the activity. Long Character

SHORT_DETAIL¹ Short detailed results information for the activity. Character (4000)

^* Indicates the column is required and not null.
¹ Indicates the column or the value is added in release 5.0.
Parent topic: Workflow tables

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 activitie.	Character (5)
RESULT_DETAIL	Detailed results information for the activity.	Long Character
SHORT_DETAIL¹	Short detailed results information for the activity.	Character (4000)