TM_ALERT_RULE
This table stores information about the alert rules in Transaction Matching.
Details
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
| TM_ALERT_RULE_PK | ALERT_RULE_ID |
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
MATCH_TYPE_ID |
NUMBER |
18 |
0 |
No |
The Match Type ID reference for this alert rule |
|
|
MATCH_PROC_ID |
NUMBER |
18 |
0 |
No |
Foreign Key to TM_MATCH_PROC |
|
|
ALERT_RULE_ID |
18 |
0 |
No |
Primary key |
||
|
TEXT_ID |
VARCHAR2 |
100 |
No |
Text ID of the alert rule |
||
|
NAME |
VARCHAR2 |
100 |
No |
Name of the alert rule |
||
|
DESCRIPTION |
VARCHAR2 |
2000 |
Yes |
Description of the alert rule |
||
|
ACTIVE |
NUMBER |
1 |
0 |
Yes |
Indicates if the alert rule is active or not. 1=ACTIVE, 0=INACTIVE |
|
|
RULE_ORDER |
NUMBER |
4 |
0 |
No |
Order in which this rule is run. |
|
|
ALERT_NAME |
VARCHAR2 |
100 |
No |
Name of the alert | ||
|
ALERT_TYPE |
NUMBER |
10 |
0 |
No |
Reference of the alert type associated with this rule |
|
|
ALERT_PRIORITY |
NUMBER |
18 |
0 |
No |
Priority of this alert rule |
|
|
ALERT_NOTIFICATION_ASSIGNEE |
VARCHAR2 |
100 |
Yes |
Details of Notification Assignee |
||
|
ALERT_ASSIGNEE_TYPE |
NUMBER |
2 |
0 |
No |
Assignee type ENUM. Values are: 0 = PREPARER, 1 = CURRENT_WORKFLOW, 2 = ALERT_TYPE, 3 = SPECIFY, 4 = NONE |
|
|
ALERT_ASSIGNEE |
VARCHAR2 |
100 |
Yes |
The user ID of the assignee |
||
|
ALERT_AS_USER_TYPE |
NUMBER |
2 |
0 |
Yes |
Assignee user type ENUM. Options are: 0 = U, 1 = G, 2 = T |
|
|
ALERT_APPROVER_TYPE |
NUMBER |
2 |
0 |
No |
The approver type ENUM. Values are: 0 = PREPARER, 1 = CURRENT_WORKFLOW, 2 = ALERT_TYPE, 3 = SPECIFY, 4 = NONE; | |
| ALERT_APPROVER |
VARCHAR2 |
100 |
Yes |
User ID of the approver |
||
| ALERT_AP_USER_TYPE |
NUMBER |
2 |
0 |
Yes |
The approver user type ENUM. Values are: 0 = U, 1 = G, 2 = T |
|
| ALERT_END_DATE_DURATION |
NUMBER |
4 |
0 |
No |
End date duration of the alert rule |
|
| ALERT_DESCRIPTION |
VARCHAR2 |
2000 |
No |
Description of the alert |
||
| FROM_FILTER |
NUMBER |
18 |
0 |
Yes |
Filter ID of the source system |
|
| TO_FILTER |
NUMBER |
18 |
0 |
Yes |
Filter ID of the subsystem |
|
| ALERT_GROUP_BY |
NUMBER |
4 |
0 |
Yes |
The group by ENUM, Values are NULL, 0 = SINGLE_ALERT_PER_TRANSACTIO, 1 = SINGLE_ALERT_PER_GROUP |
|
| MAX_TRANS_PER_ALERT |
NUMBER |
18 |
0 |
Yes |
Maximum transaction allowed per alert. Default value is 1000. |
|
| MAX_ALERT |
NUMBER |
18 |
0 |
Yes |
Maximum number of alerts per execution. Default value is 500. |
|
| CREATED_BY |
VARCHAR2 |
300 |
Yes |
ID of the user who created the alert rule |
||
| UPDATED_BY |
VARCHAR2 |
300 |
Yes |
ID of the user who updated the alert rule |
||
| CREATE_DATE |
TIMESTAMP(6) |
No |
Alert rule creation date |
|||
| UPDATE_DATE |
TIMESTAMP(6) |
No |
Alert rule updted date |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
|
TM_ALERT_RULE_PK |
UNIQUE |
ALERT_RULE_ID |