NotificationEventMetadata (ver23.11.0)
This is a staging table used to store the notification content read from the audit tables or high level application events. The data will be deleted once it is written to the portal based notification distribution tables.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
EventMetadata | 23.11.0 | CLOB | Notification message content in JSON format. |
EventType | 23.11.0 | VARCHAR2(10 CHAR) | Notification event type. |
NotificationEventMetadataID | 23.11.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
SourceIPAddress | 23.11.0 | VARCHAR2(100 CHAR) | Source IP address. |
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. |