ApplicationEventCondition (ver23.11.0)
Stores user defined condition on the selected application event to decide the notification content.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ApplicationEventConditionID | 23.11.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
ApplicationEventDetailID | 23.11.0 | NUMBER(19,0) | Foreign key to DataChangeEventDetail table PK. |
CompareValue | 23.11.0 | VARCHAR2(256 CHAR) | Value to which the table column value is compared against. |
EventFieldName | 24.1.0 | VARCHAR2(257 CHAR) | The name of the event data field to use when evaluating a condition. |
GroupLevel | 23.11.0 | NUMBER(1,0) | Boolean value indicating the condition groups combined (AND/OR) with other conditions. |
GroupNumber | 23.11.0 | NUMBER(1,0) | Boolean value indicating the group number. |
IgnoreCase | 23.11.0 | NUMBER(1,0) | Boolean value indicating if the comparevalue is case insensitive. |
IsOrGroup | 23.11.0 | NUMBER(1,0) | Boolean value indicating if the condition group should be combined with an OR condition. |
WhenCreated | 23.11.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 23.11.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 23.11.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
WhoModifed | 23.11.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |