The NOTIFICATION table contains the user notifications and their group header (for a group of notifications having the same type) in SAP
CC Cockpit user interface.
These notifications are visible in the Cockpit launchpad.
| Schema Version | 2023.0.2 | |
| Partitioned | No | |
The NOTIFICATION table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| ID | PK_NOTIFICATION |
|
The identifier of the notification or the group header. | |||
| CREATEDAT |
|
The date of the notification | ||||
| CREATEDATMS |
|
The date of the notification as a timestamp | ||||
| DEFAULTPRIORITYID |
|
The default level of priority for the notification. | ||||
| GROUPHEADERTEXT |
|
The text for a group header, null for a notification. | ||||
| GROUPHEADERTEXTDATA |
|
The group header of notifications, empty for a notification. | ||||
| ISGROUPHEADER |
|
Indicates if the record is a notification or a group header. | ||||
| ISNOTIFIED |
|
Indicates whether the notification was displayed. | ||||
| ISREAD |
|
Indicates whether the notification was read. | ||||
| PARENTID | NOTIFICATION (ID)
|
|
The identifier of the group header if the record is a notification, 0 if it is a group header. | |||
| PRIORITY |
|
The level of priority of the group header. | ||||
| PRIORITYID |
|
The code of the level of priority of the notification or the group header. | ||||
| SENSITIVETEXT |
|
The title for a notification, null for a group header. | ||||
| SENSITIVETEXTDATA |
|
Technical data on the title of a notification, empty for a group header. | ||||
| SESSIONID | SPRING_SESSION (SESSION_ID)
|
|
The identifier of the session | |||
| SETTINGID | NOTIFICATIONSETTING (ID)
|
|
The identifier of the setting related to the notification or to the group header | |||
| SUBTITLE |
|
The text for a notification, null for a group header. | ||||
| SUBTITLEDATA |
|
Technical data on the text of a notification, empty for a group header. | ||||
| NOTIFICATIONCOUNT |
|
The number of notifications in the group for a group header, 0 for a notification. |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The identifier of the notification or the group header. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_NOTIFICATION |
| Definition | The date of the notification |
| Type | NVARCHAR(255), NULL |
| Definition | The date of the notification as a timestamp |
| Type | DECIMAL(28), NULL |
| Definition | The default level of priority for the notification. |
| Type | DECIMAL(10), NULL |
| Definition | The text for a group header, null for a notification. |
| Type | NVARCHAR(255), NULL |
| Definition | The group header of notifications, empty for a notification. |
| Type | NVARCHAR(255), NULL |
| Definition | Indicates if the record is a notification or a group header. |
| Format |
The possible values are:
|
| Type | BOOLEAN, NULL |
| Definition | Indicates whether the notification was displayed. |
| Format |
The possible values are:
|
| Type | BOOLEAN, NULL |
| Definition | Indicates whether the notification was read. |
| Type | BOOLEAN, NULL |
| Definition | The identifier of the group header if the record is a notification, 0 if it is a group header. |
| Type | DECIMAL(28), NULL |
| Definition | The level of priority of the group header. |
| Format |
The possible values are:
|
| Type | NVARCHAR(255), NULL |
| Definition | The code of the level of priority of the notification or the group header. |
| Format |
The possible values are:
|
| Type | DECIMAL(10), NULL |
| Definition | The title for a notification, null for a group header. |
| Type | NVARCHAR(255), NULL |
| Definition | Technical data on the title of a notification, empty for a group header. |
| Type | NVARCHAR(255), NULL |
| Definition | The identifier of the session |
| Type | NVARCHAR(255), NULL |
| Definition | The identifier of the setting related to the notification or to the group header |
| Type | DECIMAL(28), NULL |
| Definition | The text for a notification, null for a group header. |
| Type | NVARCHAR(255), NULL |
| Definition | Technical data on the text of a notification, empty for a group header. |
| Type | NVARCHAR(255), NULL |
| Definition | The number of notifications in the group for a group header, 0 for a notification. |
| Type | DECIMAL(10), NOT NULL |
See the primary key information:
| Column(s) | ID |
| Tablespace | COCKPIT_INDX |
