ARM_WORKFLOW_ACTIONS

This table stores the workflow actions (submit and approve) for a profile instance. Does not store rejection actions.

Details

Object type: TABLE

Primary Key

Name	Columns
ARM_WORKFLOW_ACTIONS_PK	ACTION_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
ACTION_ID	NUMBER		18	0	No	Unique ID
OBJECT_ID	NUMBER		18	0	No	The object (profile instance) of this action.
ACTION_TYPE	VARCHAR2	1			No	The action type: S=submit, A=approve
ACTION_DATE	DATE				No	When the action took place
ACTION_LEVEL	NUMBER		9	0	Yes	Approval only. The approval level of this approval. Matches access order_seq column.
ACTION_BY_USER_ID	VARCHAR2	255			No	Which user performed this action
ACTION_BY_RULE_ID	NUMBER		18	0	Yes	The rule ID that performed the action if auto run by a rule.
OBJECT_VERSION_NUMBER	NUMBER		9	0	No	Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_LOGIN	NUMBER				Yes	Who column. Stores the login/session ID of the user who last updated this row.
LAST_UPDATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who last updated this row.
LAST_UPDATE_DATE	DATE				No	Who column. Stores the date when this row was last updated.
CREATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who created this row.
CREATION_DATE	DATE				No	Who column. Stores the date when this row was created in the database.

Indexes

Index	Uniqueness	Columns
ARM_WORKFLOW_ACTIONS_N1	NONUNIQUE	OBJECT_ID, ACTION_LEVEL
ARM_WORKFLOW_ACTIONS_PK	UNIQUE	ACTION_ID