StudentNotification (ver23.11.0)
This table acts as the distribution table that holds student notification data displayed in the student 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. |
DefaultMessageContent | 23.11.0 | VARCHAR2(4000 CHAR) | Default message content that will be displayed to the user. |
IsImportant | 23.11.0 | NUMBER(1,0) | Flag indicating if the message is important. |
IsRead | 23.11.0 | NUMBER(1,0) | Flag indicating if the message is read. |
StudentNotificationId | 23.11.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
StudentsDcid | 23.11.0 | NUMBER(19,0) | Student’s 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. |