NotificationDefinition (ver23.11.0)
This table stores the notification definition data for the custom notification feature.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ActionType | 23.11.0 | VARCHAR2(10 CHAR) | Name of the action type. Copied from the selected action type. Required. |
ActionTypeDetail | 23.11.0 | VARCHAR2(50 CHAR) | User entered action detail data |
AltLanguageISOCode | 23.11.0 | VARCHAR2(2 CHAR) | ISO code for the alt language. |
AltLanguageMessageContent | 23.11.0 | CLOB | Message content for an alternate language. May include unresolved PSHTML. |
ChannelType | 23.11.0 | VARCHAR2(10 CHAR) | Name of the selected channel type. Required. |
DefaultMessageContent | 23.11.0 | CLOB | Message content for the default language. May include unresolved PSHTML. |
DefaultMessageSubject | 23.12.0 | Varchar2(100 CHAR) | Stores the notification subject to be displayed for the default locale/language. |
Description | 23.11.0 | VARCHAR2(100 CHAR) | Description of the definition. Optional. |
EventType | 23.11.0 | VARCHAR2(10 CHAR) | Name of the event type. Copied from selected event type. Options are ‘DataChange' and 'Application’. Required. |
IsActive | 23.11.0 | NUMBER(1,0) | Checkbox to indicate if the definition is active. Valid values: 1=Active (checked), 0=Inactive (unchecked). Default 0 (unchecked). |
IsTeacher | 23.12.0 | Number(1,0) | Indicates if this message is to be displayed to a user having the teacher persona |
MessageCodeSetID | 23.11.0 | NUMBER(19,0) | FK to selected code set item to use for the message. |
Name | 23.11.0 | VARCHAR2(100 CHAR) | Name of the definition. Required. |
NotificationDefinitionID | 23.11.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
RecipientMetadata | 23.12.0 | CLOB | JSON formatted data containing information about which groups and/or users should receive notifications. |
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. |