DataChangeEventDetail (ver23.11.0)
This table stores the details related to datachange event type of the notification definition.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
ColumnName | 23.11.0 | VARCHAR2(128 CHAR) | Name of the source table column on which the changes are monitored. Required. |
DataChangeEventDetailID | 23.11.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
NotificationDefinitionID | 23.11.0 | NUMBER(19,0) | Foreign Key to NotificationDefinition table. Required. |
Operations | 23.11.0 | NUMBER(1,0) | Multi selectable field with INSERT, UPDATE and DELETE as options. Stores the encoded value of the binary (IUD-> 001 (1) to 111 (7)). Required. |
TableName | 23.11.0 | VARCHAR2(128 CHAR) | Name of the source table on which the changes are monitored. Required. |
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. |