FCM_ALERT_ASSOCIATIONS

This table stores information about associations of alerts with one or more objects.

Details

Object type: TABLE

Primary Key

Name	Columns
FCM_ALERT_ASSOCIATIONS_PK	ASSOCIATION_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
ASSOCIATION_ID	NUMBER		18	0	No	Unique association ID, primary key.
ALERT_ID	NUMBER		18	0	No	Unique ID of the alert related to this association.
OBJECT_ID	NUMBER		18	0	No	Unique ID of the object with which the alert is associated.
OBJECT_TYPE	VARCHAR2	15			No	Type of object with which the alert is associated.
ASSOCIATION_DATE	DATE				Yes	Date the association between the alert and object was created.
OBJECT_VERSION_NUMBER	NUMBER		9	0	No 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	VARCHAR2	255			Yes	Who column. Stores the login/session 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.
LAST_UPDATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who last updated this row.
CREATION_DATE	DATE				No	Who column. Stores the date when this row was created in the database.
CREATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who created this row.
RESTRICTION	VARCHAR2	1			Yes	Default restriction of the alert. Possible values are: W = Prevent Workflow, C = Prevent Close.