DataChangeEventCondition (ver23.11.0)
Stores user defined condition on the selected table and field to decide the notification.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Comparator | 23.11.0 | VARCHAR2(10 CHAR) | Comparator for the condition item. |
CompareValue | 23.11.0 | VARCHAR2(256 CHAR) | Value to which the table column value is compared against. |
DataChangeEventConditionID | 23.11.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
DataChangeEventDetailID | 23.11.0 | NUMBER(19,0) | Foreign key to DataChangeEventDetail table PK. |
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. |
IsOldVal | 24.1.0 | NUMBER(1,0) | Boolean value indicating if the condition should be checked against the data change event old value. |
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. |