FCM_ALERTS
This table stores information about the alerts created.
Details
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
FCM_ALERTS_PK |
ALERT_ID |
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
ALERT_ID |
NUMBER |
18 |
0 |
No |
Unique ID of the alert, primary key for the alert record. |
|
|
CLOSED_DATE |
DATE |
Yes |
Date on which alert was closed. |
|||
|
OWNER_ID |
VARCHAR2 |
255 |
Yes |
User ID of the alter owner. |
||
|
ALERT_TYPE_ID |
NUMBER |
18 | 0 |
Yes |
ID of the alert type. This is a foreign key into the FCM_ALERT_TYPES
table.
|
|
|
PRIORITY |
NUMBER |
1 | 0 |
No |
Priority assigned to the alert. Possible values are: 1=Low, 2=Medium, and 3=High. | |
|
ALERT_NAME |
VARCHAR2 |
240 |
No |
Name of the alert. | ||
|
ALERT_DESCRIPTION |
VARCHAR2 |
4000 |
No |
Description of the alert. | ||
|
STATUS_ID |
NUMBER |
2 | 0 |
No |
The status of the alert. Possible values are: 24 = With Owner, 6 = With Assignee, 10 = With Approver, and 1 = Closed. | |
|
ASSIGNEE_ID |
VARCHAR2 |
255 |
Yes |
ID of the user to who the alert is assigned. | ||
|
APPROVER_ID |
VARCHAR2 |
255 |
Yes |
ID of the user who is designated as the Approver for this alert. | ||
|
APP_ID |
NUMBER |
1 |
0 |
No |
The Application ID | |
|
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 |
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 |
1 |
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. | ||
|
START_DATE |
DATE |
Yes |
Start date of the alert | |||
|
END_DATE |
DATE |
Yes |
End date of the alert. | |||
|
YEAR_ID |
NUMBER |
18 | 0 |
Yes |
Year ID associated with this alert | |
|
PERIOD_ID |
NUMBER |
18 | 0 |
Yes |
Period ID associated with this alert. | |
|
RESPONSIBILITY_LEVEL |
NUMBER |
0 | 0 |
Yes |
The current level of the alert. | |
|
INSTRUCTIONS |
CLOB |
Yes |
The instructions provided in the alert definition. | |||
|
ALERT_SECONDARY_ID |
NUMBER |
18 | 0 |
Yes |
Secondary ID, used for attachments. | |
|
OBJECT_TYPE |
VARCHAR2 |
15 |
Yes |
The object type associated with the alert. | ||
|
RESTRICTION |
VARCHAR2 |
1 |
Yes |
Default restriction of the alert. Possible values are: W = Prevent Workflow, C = Prevent Close. | ||
|
OWNER_SUBMISSION_DATE |
DATE |
Yes |
Date this alert was submitted by the alert owner. | |||
|
UUID |
VARCHAR2 |
40 |
Yes |
Unique ID, used for LCM. | ||
|
REMOVE_ASSOCIATIONS |
VARCHAR2 |
1 |
Yes |
Whether this alert can be removed from an object. Possible values are: Y = Yes or N = No. |