StaffNotification (ver23.11.0)
This table acts as the distribution table that holds staff notification data displayed in the admin and teacher portal. A process that runs in task master will copy data from NotificationEventMetaData table if it matches with any active definition.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AltLanguageIsoCode | 23.11.0 | VARCHAR2(2 CHAR) | Alternate language ISO code. |
AltLanguageMessageContent | 23.11.0 | VARCHAR2(4000 CHAR) | Message content in alternate language. |
ClickAction | 23.11.0 | VARCHAR2(200 CHAR) | Click action script. |
ClickActionTitle | 24.2.0 | VARCHAR2(255 CHAR) | Title to use when displaying a hyperlink in a notification |
ContextIdentifier | 24.5.0 | VARCHAR2(2000 CHAR) | A formatted string used internally to resolve dynamic notification message content and security rules. |
DefaultMessageContent | 23.11.0 | VARCHAR2(4000 CHAR) | Default message content that will be displayed to the user. |
DefaultMessageSubject | 23.12.0 | VARCHAR2(100 CHAR) | Stores the notification subject to be displayed for the default locale/language. |
IsImportant | 23.11.0 | NUMBER(1,0) | Flag indicating if the message is important. |
IsNew | 24.2.0 | NUMBER(1,0) | Flag indicating if the message has not been seen yet. Defaults to true. |
IsMarkedForDelete | 24.2.0 | NUMBER(1,0) | Flag indicating if the notification is marked for delete. |
IsRead | 23.11.0 | NUMBER(1,0) | Flag indicating if the message is read. |
IsTeacher | 23.12.0 | NUMBER(1,0) | Indicates if this message is to be displayed to a user having the teacher persona |
StaffNotificationId | 23.11.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
UsersDcid | 23.11.0 | NUMBER(19,0) | User’s Dcid. FK constraint present to Users table Dcid. |
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. |