ARM_ACTION_PLAN

This table stores the Action Plans.

Details

Object type: TABLE

Primary Key

Name	Columns
ARM_ACTION_PLAN_PK	ACTION_PLAN_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
ACTION_PLAN_ID	NUMBER		18	0	No	Unique ID, Primary Key
OBJECT_ID	NUMBER		18	0	Yes	The object this access is being associated with
ACTION_PLAN_NAME	VARCHAR2	4000			Yes	Action Plan Details
CLOSE_DATE	DATE				Yes	Action Plan Close Date
CLOSED	VARCHAR2	1			Yes	Whether action plan is closed or open
OBJECT_VERSION_NUMBER	NUMBER				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.
PRIOR_ACTION_PLAN_ID	NUMBER		18	0	Yes	ID of prior action plan, for copied-forward transactions

Indexes

Index	Uniqueness	Columns
ARM_ACTION_PLAN_PK	UNIQUE	ACTION_PLAN_ID
ARM_ACTION_PLAN_U1	UNIQUE	OBJECT_ID